The main goal of master thesis is to analyze and propose possible low cost Business Intelligence solution with open source technologies and comparison of available tools for implementation in middle size company. We compare Pentaho and Jaspersoft tools implemented on local hardware and cloud environment with Microsoft Azure services. The theoretical part focuses mainly on understanding the business intelligence and its architecture, because architecture is an important part of the work. Actual tools are designed as stand alone modules for specific activities in the business intelligence lifecycle. Low cost tools are often connected with open source technologies and cloud computing. This part of the work contains explanation of these terms and their advantages and disadvantages for our chosen target group of companies. The analytical part includes defined parameters by which it is conducted analysis of tools and their comparison. Business Intelligence solutions are divided according to arcitectural layers. The evaluation criteria are divided into financial, technical and user category. In conclusion, chosen tools are compared and evaluated. The main contribution of this thesis is comparison of open source business intelligence tools for implementation in middle size company. According to the EU directive, middle size company does not exceed 250 employees or profit is less than 50 million euros. The reader can compare the different solutions and their pitfalls or shortcomings that could be critical for the implementation.

The master thesis deals with the issue of evaluation of efficiency and data collection of lines in production, using the APROL program from B\&R automation. The aim of this work is to create a program completed requirement, which is going to be compared with already implemented projects of the company and will serve to create a company standard. The first part is devoted to the description of the theory of this issue and used software. The second part describes the solution of the line simulator and the whole concept of collection and evaluation.

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.

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 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.