Diploma thesis focuses on open source business intelligence platforms. The main aim of this thesis is to compare open source BI platforms Pentaho BI Suite and Jaspersoft BI Suite using a set of criteria on the example of the solution for a fictive company. In order to achieve this goal, the research for criteria in already existing comparisons is made firstly and on the basis of this own comparative criteria and their weights are defined. Then important features of platforms under the BI solution primary layers are characterized. In the conclusion both platforms are evaluated and compared according to the result values of all criteria. The thesis is divided into two parts. The theoretical part deals with the analysis and definition of criteria and the BI platform introduction. Used criteria are analyzed in the Gartner research, in the book about business intelligence and in two diploma theses. Own defined criteria are divided into following groups: Installation, ETL, OLAP, Reporting and Documentation. The introduction includes description of components, licence politics and available editions. In the practical part the platform functionality is tested, the project created in both of them is specified and then platforms are evaluated and compared. The functionality testing is made progressively from installation, through ETL and OLAP to reporting. The main aim of this thesis is completed in the last chapter of the practical part, where both platforms are evaluated according to the set of defined criteria, first of all under the BI solution primary layers and then also from general point of view. Here is used the weighted sum method from the multi-criteria decision analysis. The contribution of this thesis is in the transparent confrontation of two open source BI platforms, in the definition of the comparative criteria set and also in the presentation of all tools strengths and weaknesses including screenshots.

The goal of this diploma thesis is to develop a tool for monitoring electricity grid state in real-time. The theoretical part of the thesis covers real-time power grid monitoring and reporting knowledge, solutions and standards currently existing on the market and answers questions about what, how and why it should be monitored. This thesis describes TSCNET as electricity grid coordinator in Central Europe and Unicorn Systems and its current solutions for this industry. Also, modern approaches for development of the real-time BI are mentioned. Customised solution for the customer is presented. Chapter Material and methods introduces multiple tools used for the development of such a tool – Pentaho, JMS, MOM, AMICA, RIS, Vue etc. BPMN is used for ETL process modelling. Results describe the tool implementation based on the application integration principles, available solutions mentioned in methods part of this thesis and feasibility study. In the next part, physical model is created, communication interface is set, ETL diagrams are provided and all is implemented to generate CSV file output with grid state data. In addition, presentation layer is developed using Vue, NodeJS and client-server sockets. This layer visualises real-time tables containing grid state contingency and load-flow analysis results and also allows managers to regulate the newly implemented tool. Even though this tool presented in this thesis is deeply customised and developed for business processes of a specific company, it still can be the clue for further research of the real-time solutions and tools.

Diploma thesis is focused on the implementation of customer relationship management and Business Intelligence solutions in the small business company using open source technologies. Main objective of the thesis is implementation of CRM and Business Intelligence and evaluation of usability of these solutions. Thesis describes basic elements of these solutions. For the setting up metrics is using Balanced Scorecard. In the next part of this thesis is designed the whole Business Intelligence including the creating of data model and OLAP cubes using open source technologies. Theoretical background is described in the first part of thesis. There are defined basic terms from scope of strategic management using Balanced Scorecard, CRM and Business Intelligence. Thesis demonstrates using and creation of the whole Business Intelligence solution. There are also evaluated difficulties in implementation of these products. In thesis is designed data warehouse and the whole solution including reports.

The objective of this thesis is a complete implementation of the Financial and Property Analysis of Municipalities (FAMA) methodology using open-source Business Intelligence (BI) tools. The FAMA methodology was developed at the Institute of Public Administration and Regional Development at University of Economics in Prague and monitors wide range of aspects of management of municipalities. The main objective of this work is to create an application that would allow users to clearly analyze the management of municipalities with indicators of this methodology, using open source BI tools. The first, theoretical part, consists of two parts. The first half of the theoretical part of this thesis is devoted to the analysis of municipal finances and describes the FAMA methodology itself. Furthermore, methods used by the Ministry of Finance to evaluate municipalities are described. The second half of the theoretical part introduces readers to principles and components used in BI, some of which are used in the actual implementation. The second, practical part, initially deals with selection of suitable open-source BI tools and these tools are subsequently used to create an application that is used to analyze the management of municipalities. The implementation itself is divided into several parts. Firstly an initial study is performed, which is based on analysis of source data and user requirements. Based on the initial analysis, data warehouse is designed. Subsequently, an ETL project is created to process financial reports of municipalities and store them in the data warehouse. After filling the data warehouse, several OLAP cubes are created, which are used for multidimensional data analysis and finally, the presentation layer of the application is introduced and suitable graphical outputs for data presentation are designed. The main contribution of this thesis is the actual implementation of the FAMA methodology using the selected tools. The solution includes all indicators of the methodology and covers financial data of all municipalities of the Czech Republic in the years 2001 to 2012. Due to the scope of this work, a complete solution was made, that is ready for use.

Diploma thesis deals with comparison of commercial and Open Source Business Intelligence (BI) reporting tools. The main aim of the thesis is to provide a list of BI reporting tools and their further comparison. Evaluation is based on a set of criteria. Every criterium has its assigned value that represents the importance of the criterium in a given group. The same procedure is applied on the groups. The final evaluation is based on defined values of these groups. The output of the thesis is a table structured into five parts according to defined groups of criteria. The second part of the thesis walks the reader through the practical showcase of implementation one of the selected tools that is SAP Business Objects Enterprise 4.0. At the beginning, there is a description of report proposal that contains graphical design and functionality requirements. Next part shows the whole process in detail.

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.