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.

The thesis deals with analysing and designing an effective dashboard. By way of introduction the topics of Business Intelligence, data storages and data quality are described. Then, an overview of analytical outputs is given and the process of their formation is outlined. The basic principles of an effective design of management reports are described, with emphasis laid on the end user. The thesis focuses on important factors of efficiency, such as applicability of transferred information and the form of their transfer. The practical part concentrates on the improvement of the efficiency of a particular dashboard. Besides the rules of a correct design, knowledge of cognitive psychology is also used for this purpose. Upon an analysis of deficiencies of an existing dashboard, proposed changes are incorporated. Changes resulting in more effective transfer of information via a dashboard are based on a theoretical basis of the previous section.

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.

This thesis covers the process analysis in sales controlling department of an energy company from the point of view of effectiveness of information system support. Based on this analysis is provided evaluation of the system implementation. According to the importance of the practical part of the thesis, it is not divided from the theoretical part, but it penetrates the theory withint the whole thesis. the main scope of controlling and information system is first introduced in the beginning of the thesis, followed by the process description and its analysis. Conclusion includes all essential findings and evaluation of premilinary hypotesis.

The main objective of this thesis is to describe working with spatial data and their use in reports. The author focuses mainly on the MS SQL Server 2008 R2 platform. The first part deals with theoretical foundations. Defines the concept of Location Intelligence and describes its history to the present. It also addresses the benefits of Location Intelligence in various sectors and the relationship with Business Intelligence. Further theoretical part goes on to describe both spatial data at a general level and at the level of MS SQL Server 2008 R2. In addition, it described the use of ESRI Shapefile files and work with these files. From the description of spatial data author goes on to use reporting tools in Microsoft - SQL Server Reporting Services and Report Builder. Possible forms of map visualization and a detailed description of the settings are at the end of the theoretical part. The second part is focused on solving practical problems. Tools that are described in the theoretical part, are used to create report examples that the author at the beginning of this section set out to create.

Thesis deals with systems for customer relationship management (CRM) and possibility of their expansion and extension using technologies of Business Intelligence (BI). The work focuses on a specific part of CRM - the so-called "analytical CRM" (aCRM). aCRM is examined comprehensively, i.e. in the whole range - from its history and reasons for use, through the problematic relations to other areas of business intelligence. Specification and realization of example aCRM using BI technology is included.

This thesis focuses on the data warehouse of an extensive bank intitution from its operational management point of view (for the main part). To grasp the fast overview of the data warehouse the thesis includes the description of its data architecture, transformation processes and the way of presenting data to its users. Besides that the description of systems used for both the business data and for the metadata purposses is also included in this thesis. The thesis also covers operational activities including the identification of weak areas and their improvements. Another part of the thesis is represented by the project of optimization of a scheduling mechanism (Master Workflow) for running transformation processes, that helps to minimalize the metadata load of the Teradata database system. The main goal of this thesis is to describe the environment of the data warehouse in an understandable way. It's critical to understand the environment for both, the operational management personnel and for developers, that can supply the warehouse with higher quality solutions and ease the deployment of new deliveries into the production environment. This goal is achieved by the description of the data warehouse (mainly the description of its data architecture, transformation processes, operational activities and tools used to deploy changes into the production environment). Another goal is to give a feedback on the operational activities from the operational personnel point of view. This helps identify weak spots and can lead to its elimination. The last goal is to improve the scheduling mechanism that controls and runs all transformation processes. This goal is achieved by a project. The thesis describes the starting state, implemented changes, final state and the consideration whether the project was successful or not. The thesis brings several contributions: easier understanding of the data warehouse and the way of managing ETL processes -- for the operational management personnel and developers, which can bring the improvement of new solutions. The possibility of elimination of weak areas in the operational activities. And thanks to the project described there are two changes -- standardization and the metadata load of Teradata decreased. My own contribution to this issue is, besides the useful introduction to the data warehouse, the identification of the weak areas, suggested improvements and also the project of optimization Master Workflow which took about 17 MD. The thesis is devided into chapters based on the topics described: introductory information, theoretical base, characteristics of the main systems, the description of the data warehouse, the description of operational activities including the identification of weak areas, and at the end there is the project of optimization of Master Workflow. In the last chapter there is the final conclusion of the entire thesis.

This diploma thesis focuses on options of Competitive Intelligence solutions in small and medium enterprises. Applied part is conducted in a medium sized manufacturing company. Theoretical part of this thesis introduces areas of Competitive Intelligence and Business Intelligence, basic technological overview and illustrates Competitive Intelligence cycle description. In Czech republic, majority of companies are in a form of a small or medium enterprise, therefore theoretical definition is provided. In applied part of the thesis are introduced relevant information sources for small and medium enterprise, selected Business Intelligence tools under the Open-source license or provided as a Service. In following chapters is described possible utilization of this analytical software for a Competitive Intelligence. In final part of the thesis is a chosen solution applied in a HF Czechforge s.r.o., which consists of Business Intelligence and Competitive Intelligence. Main contribution of this thesis is a implementation suggestion of a user friendly Business Intelligence and Competitive Intelligence, which can be helpful for the company in gaining better overview of itself and its environment at acceptable costs.

This thesis is focused on the possibility of using Business Intelligence tools in a non-profit organization. These tools should be used to create regular and special data analyses and to replace current, no longer satisfactory method of data processing. The main objective was to create a proposal of implementation of Business Intelligence solution for the Children's Safety Line (Sdružení Linka bezpečí). In order to fulfil the main objective, secondary objectives were identified, specifically the discovery of a suitable adjustment of the Balanced Scorecard methodology for non-profit organizations and its application on the Children's Safety Line. The main objective of this thesis was achieved by creating a proposal; the proposed solution was implemented in the Safety Line environment. The thesis is devided into a theoretical and practical part. The theoretical part uses Business Intelligence tools, Balanced Scorecard methodology (adjusted for non-profit sector) and contains the Commentated research. The practical part is devoted to a general description of the Safety Line, application of BSC methodology, and a proposal of Business Intelligence implementation in the Safety Line.

This thesis focuses on the information design in business intelligence. It combines cognitive psychology, graphic design and information design to equip the reader with information and skills to create effective reports and dashboards. The paper presents not only theory but also explains their principles. In the practical part of the theoretical knowledge is applied in practice on a sample dashboard that corrects the current solution imaginary company Alfa Kampeny. Although the work is primarily focused developer BI reports and dashboards, ideas contained therein apply to all those who have businesses are graphs and tables.