|
|
Data Analysis of Admissions
Josífek, Jan ; Luhan, Jan (referee) ; Kříž, Jiří (advisor)
This thesis deals with data analysis of admissions and report creation. The thesis is divided into three parts. The first part is the theoretical background that serves as a basis for the remaining parts. The second part analyses current state, where are defined questions for data analysis and ETL phase is performer. In the third part, custom report solutions are developed to answer the set questions.
|
|
|
Business Intelligence Implementation
Procházková, Vendula ; Koch, Miloš (referee) ; Novák, Lukáš (advisor)
This thesis deals with the implementation of Business Intelligence (BI) in the Bio G company environment. The aim of the implementation is to improve the efficiency of the service department's decision making and processes through better use of data and analysis obtained by BI tools. A strategic analysis of the company revealed the key factors for the successful implementation of BI into the service department processes. The thesis focuses on data cleansing and transformation, which is essential to provide quality inputs for analysis and reporting using Power BI. The results show significant improvements in reporting and data analysis, which has enabled better strategic decision making and the identification of new trends. Thus, the implementation of BI has brought about process improvements and created a foundation for future expansion within the company.
|
|
|
OLAP Data Storage Methods
Dittrich, Petr ; Kroulík, Jan (referee) ; Hruška, Tomáš (advisor)
The topic of the bachelor work is the OLAP core implementation for the data storage space. All theoretical facts about the data storage space are discussed at the start. The form of metadata elements storage and the OLAP cubes creating are described in the following part. And finally, in the last chapter, it is precisely shown how to create a cube in this system.
|
|
|
E-commerce System Database Migration
Zkoumalová, Barbora ; Weirich, Pavel (referee) ; Luhan, Jan (advisor)
The object of master‘s thesis is design and creation of e-commerce system database migration tool from the ZenCart platform to the PrestaShop platform. Both system databases will be described and analysed and based on gained information the migration tool will be created according customers‘ requirements and then final data migration from original to the new database will be executed.
|
|
| |
|
| |
|
|
Design of Data Warehouse in SaaS Company
Zetocha, Adam ; Šimek, Dominik (referee) ; Kříž, Jiří (advisor)
The diploma thesis consists of design and steps leading to build of data warehouse in startup developing SaaS product. Theoretical information about data warehouses and business intelligence are projected into design and following process of data warehouse development mainly for marketing data. Importing process of data into a data warehouse and reporting are fully automated.
|
|
|
Data Cube Visualization
Dittrich, Petr ; Kupčík, Jan (referee) ; Hruška, Tomáš (advisor)
The topic of the master's thesis is a concept and implementation of the prototype application TOPZ demostrating the data warehouse. All theoretical facts about the data storage space are discussed at first. It is also specified the areas of possible improvements of the data warehouse. The specification of requirements and concept of the demonstration application are described in the following part. Testing the performace of the data warehouse is discussed in last chapter.
|
|
|
Implementation of OLAP Analysis for BUT Libraries
Mahdalíček, Josef ; Ruttkay, Ladislav (referee) ; Šárfy, Martin (advisor)
The aim of this project is to create tool for OLAP analysis over operational data of BUT libraries. This OLAP tool answers ie. query how long were users having loaned books. These queries could be specified by time period (year, month), library (ie. FIT library) and other dimensions. Only some, for this application interesting, tables from source database are used. Tables were exported into text files in csv format. According to project specification, system for OLAP analysis should be open source. Tool Mondrian accomplishes this requirement and was used in this work. Data warehouse is represented by relational database MySQL. ETL tool feeds data warehouse by data from exported files. User interface is used from internet browser and is implemented by component JPivot. Query results are displayed in tables and graphs.
|
|
| |
guest ::
