This Diploma thesis deals with the analysis and proposal of the pilot BI solution for the company Svoboda & Partner CZ s.r.o., engaged in the automechanic expertise. Fundamental objectives of this work focus particularly on the above mentioned pilot BI solutions and partial objectives deal with an analysis of the company and its needs, arising from business strategy and market analysis applications available to support the visualization of transaction reporting. These objectives have been achieved by analyzing the company's business model in chapter seven, further analysis of needs and problems within the company in chapter eight. Before the analysis, the diploma thesis deals with a survey of available applications that offer functionality of dynamically generated graphs to aid visualization of transaction reporting in chapter six and finally a major analysis and preparation of pilot BI and transaction reporting for this business which you can find from chapter 9 to chapter eleven. Contribution of this work for the company will be a complete analysis and delivery of all necessary documents in order to decide whether the above BI solutions to the company implement or not. In the case of a positive decision of the company, it is expected that thanks to BI solutions the ways of looking at corporate data can be more expanded, more precise and more operational management of the company, achieving better performance, higher profits and more efficient decision-making based on better data for decision making.

In this diploma thesis I concentrate on analysing the possibilities of standardization of financial Business Intelligence solution. The objective is firstly to assess whether it is useful to create a so-called standard model, i.e. a solution model, which could be used repeatedly in independent BI project implementations. The objective is to analyse whether there are similarities among the implemented BI projects in terms of content requirements (measures and dimensions), or what are the differences. The objective is then to design a standard solution model (design relational and dimensional model for data structures). Another objective is to create a functional prototype solution based on the designed model, i.e. to create the actual data structures and fill them with data. A part of this prototype solution should be a set of demonstrative reports. The objectives will be achieved first of all by analysing the theoretical foundations, which provides the literature, and by analysing available real project documentation. Considered BI projects have been implemented within several non-financial commercial institutions. That means that the outputs of this thesis are applicable primarily in non-financial enterprises environments. In the next step, the dimensional modelling techniques will be used to create the schema. Then, leveraging the knowledge of BI solution development techniques on Microsoft SQL Server platform, the prototype solution will be deployed. Reports will be developed using the Microsoft Excel client tool. The benefit of this thesis consists in the model added value, which can be used as the core of newly developed financial BI solutions. The implementation process should by this spare some time. Another benefit of the thesis is the possible use of the prototype solution as a tool for customized demonstration of the financial BI capabilities to potential customers.

Extract, Transformation, and Load (ETL) system is responsible for the extraction of data from several sources, their cleansing, conforming and insertion into a data warehouse. The thesis is focused on building ETL methodology to better understanding of ETL process and its application in the real environment. I've worked on project "BI Cookbook" with Clever Decision, a software consulting company that specializes in Business Intelligence. The aim was to create ETL part of the BI methodology. This methodology has been designed to provide ease of use, flexible and extensible material for the purpose of building ETL solution. The main goal of this work is to introduce created ETL methodology, all of its components and the way in which it could be used. Following goal is to discuss options of its implementation and modification for the wide range of use. The main contribution of this work is to provide ideas of creating and implementing ETL methodology or ideas for creating methodology in general. The thesis is divided into three parts. The first theoretical part deals with basic definition, architecture and implementing of ETL system. The second part presents the proposed methodology. The last part contains of the possible options for implementation a modification of the methodology.

The dissertation describes the process of creating Business Intelligence solution over the ERP system MS Dynamics NAV. The successful development and deployment of prototype version is also the main goal of this work. The work is divided into two parts in accordance with sub-objectives: theoretical and practical. The theoretical part starts witch research of works with similar theme and then continues with description of the current state of Czech market with BI solutions on the MS Dynamics NAV, basic principles of Business Intelligence development and then the description of the method of setting benchmarks using the Balanced Scorecard. The practical part describes the development of Business Intelligence solution starting with identifying potential customer as a wholesale distributor company and setting the requirements for BI. The practical part continues through the design of a data warehouse in MS SQL Server, creation of data pump connected to the MS Dynamics NAV database, filling the data warehouse, OLAP cubes creating and ends with an example of output reports form working solution using MS Excel 2013.

This diploma thesis is focused on designing a prototype Business Intelligence solution for a company operating in financial markets. The company does not possess a full-scaled system for measuring enterprise performance and performs this task by the means of manual data collection. The current system is not sufficient for covering the growing number of the com-pany's dealings. The theoretical part of the thesis deals with introducing basic principles of Enterprise Per-formance Management, Balanced Scorecard and, subsequently, Business Intelligence. The practical part covers the defined strategic goals of the company using the Balanced Sco-recard method. The discovered strategic goals are transposed into a strategic map. Metrics for measuring these goals are assigned to them. Only some of the goals are chosen for the implementation of the Business Intelligence solution. Source data for assessing the reached values are defined for the given indicators. Data from the data source were transposed into the data hub. Subsequently, an OLAP cube connected to a reporting tool for displaying the calculated metrics is created.

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.

In recent years, Business Intelligence is one of the fastest growing software industry according to foreign analyzes. More and more companies realize the importance of tools for Business Intelligence and dashboarding. That is why I chose this topic for my thesis. The main part of this thesis focuses on study support for subject 4IT314 Enterprise Information Systems. This course teaches student how to work with the ERP system Microsoft Dynamics AX. The main shortage of this subject is the lack of feedback to students. Therefore it was decide to integrate BI tools that will be used for dashboarding over database of Microsoft Dynamics AX. In the theoretical part are explains the basic terms essential to understanding BI and dashboarding. On the basis of defined criteria was chose BI tool for integration in to the subject 4IT314. In the practical part of this thesis is described the implementation of this tool and created user documentation, which is used as study materials for students.

Diploma thesis is focused on elaboration of database solution for saving measured data. In theory part analyses database query language and database management system Microsoft SQL Server 2017. Further in theory part is focused on programming environment for application development using C# .NET. Thesis includes database solution for saving measured data, service console application for saving data into the database and user application for creating new measuring, representation of data and user administration.

The diploma thesis focuses on the design, creation and implementation of a desktop application for managing a swimming database of the ASK Blansko swim club. It analyzes the current state of processes in the club and compares them with modern practice. It contains a description of all the functions of the application together with the economic evaluation of the project. It represents a complete solution because of the inefficient and outdated way of keeping the club database. It emphasizes the successful implementation of the application in the club practice.

Master's thesis focuses on BI projects maintenance optimization of company Intelligent Technologies s.r.o., which is one of the leading suppliers of Business Intelligence and Data Warehousing solutions in Czech Republic. The thesis is divided into three main sections – theoretical, analytical and practical. The main goal of these sections is an explanation of important concepts that are necessary to understand the solution, which is being created, analysis of the current state of selected company and detailed description of creating main solution. In this thesis following Microsoft programs were used - Visual Studio 2015, SSIS, SQL Server Management Studio 2017 and Power BI.