|
|
Application for Displaying OLAP Data Cubes
Kiss, Tomáš ; Burget, Radek (referee) ; Bartík, Vladimír (advisor)
The main aim of this thesis is to provide information about the basic issues of data warehouses, data cubes and OLAP analysis. Furthermore, in the theoretical part is introduced the stage of data preprocessing and its elementary parts performed before their insertion in to data warehouses. Additionally, there are listed the basic types of OLAP operations and the possible ways of displaying data cubes. Acquired information is used to create application for displaying OLAP data cubes in suitable format.
|
|
|
Using the Tools of Business Intelligence in Customer Care Center
Mencner, Jacek ; Luhan, Jan (referee) ; Kříž, Jiří (advisor)
This master's thesis deals with proposal of Business Intelligence solution. The main task is analysis of Customer Care processes, based on which the Business Intelligence solution has been designed. Thanks to obtained knowledge changes has been made to get more effective contact process. The first part of the thesis describes the theoretical foundations of Business Intelligence. In the second part is analysis of the current situation and solution proposal.
|
|
| |
|
|
Integration, Visualization, and Mining from Data of World Countries
Dušek, Vladimír ; Rychlý, Marek (referee) ; Bartík, Vladimír (advisor)
This thesis explores the utilization of open data about countries around the world, particularly data in the areas of progress and quality of life. The goal was to design and implement a web application to present this data and further use the data for data mining. The integration and processing of data from open data sources were accomplished using the Apache Airflow platform. The Python framework FastAPI was used to create the API and the JavaScript library ReactJS was used to implement the web application. In the application, the indicators are categorized. Each of them can be displayed for different groups of countries, for different time periods, and in several visualizations. From the domain of data mining, clustering of countries based on a group of indicators and prediction of future development of selected indicators using regression analysis was performed. The final application is available at jakjsmenatom.cz.
|
|
|
Information System for Management of Company Employees
Sklenář, Pavel ; Křivka, Zbyněk (referee) ; Bartík, Vladimír (advisor)
Purpose of this thesis is to help companies in terms of managing their own employees including analysis of employees shifts using OLAP, thanks to OLAP analysis companies can find out for example total delays on employees shifts. Information system is created as a web application implemented in PHP using the Laravel framework with MySQL database. Information system functionalities are: employees management, including management of employees attendances, Google Drive management, generating various files in PDF format, viewing various statistics, employees ratings, shifts management, vacations management, diseases management, employees languages management, reports management, injuries management.
|
|
|
Proposal Solution of Business Intelligence
Drdla, Tomáš ; Menčík, Tomáš (referee) ; Kříž, Jiří (advisor)
The aim of this thesis is to propose Business Intelligence solutions and consider its impact on decision-making, implementation costs, the overall contribution to the company and make a proposal that will help to change in the present conditiontion unsatisfactory situation of data management in enterprise JáNěkdo.CZ s.r.o.
|
|
|
Agile Data Warehouse
Smetana, Martin ; Luhan, Jan (referee) ; Kříž, Jiří (advisor)
Bachelor thesis is focused on design and automatization filling to datawarehouse on the platform of the Microsoft SQL server. This datawarehouse is designed for historization data, possibility to connect other different external sources and adding specific implemention of customer demand in the future.
|
|
|
Knowledge Discovery over Data Warehouses
Pumprla, Ondřej ; Chmelař, Petr (referee) ; Stryka, Lukáš (advisor)
This Master's thesis deals with the principles of the data mining process, especially with the mining of association rules. The theoretical apparatus of general description and principles of the data warehouse creation is set. On the basis of this theoretical knowledge, the application for the association rules mining is implemented. The application requires the data in the transactional form or the multidimensional data organized in the Star schema. The implemented algorithms for finding of the frequent patterns are Apriori and FP-tree. The system allows the variant setting of parameters for mining process. Also, the validation tests and efficiency proofs were accomplished. From the point of view of the association rules searching support, the resultant application is more applicable and robust than the existing compared systems SAS Miner and Oracle Data Miner.
|
|
|
Use of Agile Methodologies in the Data Warehouse Design
Janečka, Pavel ; Kreslíková, Jitka (referee) ; Bartík, Vladimír (advisor)
Scope of this master’s thesis contains agile data warehouse design. It begins with a brief demonstration of data warehouse issues, shows the architectures dimensional data warehouse, corporate information factory and data vault. Furthermore, the thesis introduces agile methodologies suitable for data warehouses. Main part of this thesis focuses on the data warehouse design and development in Kentico Software s.r.o. using the modelstorming, shows implementation of universal ETL process for loading dimensional data warehouse, designs ETL processes, data warehouse storage and presentation layer. In the end, the thesis discusses future extensions to the data warehouse such as knowledge discovery module or large-scale data expansion.
|
|
|
Replacement of the Reporting Solution in Sales Department at Pharmaceutical Company
Smetana, Martin ; Luhan, Jan (referee) ; Kříž, Jiří (advisor)
The aim of the thesis is to automate the process of loading data from particular distributors, make data quality management more transparent - consolidate data from particular distributors - mainly in the area of products and points of sale (pharmacies), process existing reports in modern reporting tool, which enables the creation of new reports, including graphically processed territorial data (map reports), with the possibility of interactive viewing of detailed data.
|
guest ::
