|
|
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.
|
|
| |
|
|
Global Meteorological Data Analysis
Gerych, Petr ; Chmelař, Petr (referee) ; Hlosta, Martin (advisor)
The thesis generally describes matters of data warehouses and knowledge discovery in databases. Then it focuses on the meteorological databases and their problems. The practical part of thesis describes design methods for data mining project, NOAA Global Surface Summary of the Day (GSOD), which is then implemented in two different ways using the Pentaho tools. Finally, an evaluation and comparison of these two approaches.
|
|
| |
|
|
BI Open Source tools selection for small company
Sukdol, Lukáš ; Šedivá, Zuzana (advisor) ; Pour, Jan (referee)
The master thesis deals with a theme of Open Source Business Intelligence tools from the point of view of a small company. The theoretical part describes the historical background of Open Source software and Business Intelligence theory. The practical part summarizes possibilities and properties of particular selected tools, based on implementation of partial activities with fi?ctional company data. Based on a multicriterial analysis, a variant proposal of BI solution for a specifi?c small company is created at the end of the thesis.
|
|
|
Global Meteorological Data Analysis
Gerych, Petr ; Chmelař, Petr (referee) ; Hlosta, Martin (advisor)
The thesis generally describes matters of data warehouses and knowledge discovery in databases. Then it focuses on the meteorological databases and their problems. The practical part of thesis describes design methods for data mining project, NOAA Global Surface Summary of the Day (GSOD), which is then implemented in two different ways using the Pentaho tools. Finally, an evaluation and comparison of these two approaches.
|
|
| |
|
|
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.
|
|
|
Implementation of BI in the field of geolocation data
Rosenberger, Tomáš ; Novotný, Ota (advisor) ; Pour, Jan (referee)
The thesis deals with the theoretical and practical aspects of implementation of Business Intelligence in a field of geo-location data with emphasis on the design and implementation of data architecture and the development of dynamic dashboards. The whole issue is described on the development of a tool for the analysis of geo-location data, on which the author participated with other members of the Competence Center Retail Analytics - Ondrej Funiok, Vilem Kalus and Martin Matejka. The first part of the thesis describes the theoretical bases of Business and Location Intelligence, which is followed by a description of the basic tasks of working with geo-location data - data storage in relational database management systems, data processing by map servers and data presentation. Individual tasks are described with practical examples and use software tools to support these tasks. The next section presents the project of development tool for the analysis of geo-location data that is created in the Retail Analytics Competence Center at the University of Economics, Prague. The second part of the thesis describes the design and implementation of the data architecture of developed tool, which is followed by a description of the frontend portion of the tool consisting of the implementation of a library for creating dynamic Dashboards to present geo-location data.
|
|
|
Implementation of Open Source BI in Healthcare
Vencovský, Josef ; Novotný, Ota (advisor) ; Pour, Jan (referee)
This diploma thesis deals with implementation of open source Business Intelligence solution Pentaho Community Edition 5.0 (Pentaho CE) in particular healthcare institution and it tries to prove its usability in full operation. In theoretic part there are defined concept and principles of Business Intelligence and specifics BI solution implementation in healthcare. In practical part there are detailed analysis of Pentaho CE and demonstration of usage in healthcare presented by implementation into specific healthcare institution. The main benefit of this thesis is description of implementation Pentaho CE using author's practical experience in healthcare area and advanced knowledge of Pentaho CE. The main goal, the verification of usability in production, is fulfilled in both theoretical and practical parts of this diploma thesis. There are also calculated costs and approximate suggested schedule of main activities. Functionality of Pentaho CE is attested in detailed analysis which is possible to use as guide on its own describing general architecture of Business Intelligence solution Pentaho CE.
|
guest ::
