This thesis fights with the data quality in business intelligence. We present basic principles for building data warehouse to achieve the highest data quality. We also present some data clearing methods as deviation detection or name-address clearing. This work also deals with origin of erroneous data and prevention of their generation. In second part of this thesis we show presented methods and principles on real example of data warehouse and we suggest how to get sales data from our business partners or customers.

This diploma thesis deals with data warehouse applications in banking and insurance sector. The aim is to define this sphere, describe it and create a set of reccomendations and methodology connected with the best ways of implementation in financial institutions. Because of the wide range of this topic it can not be taken globally. I focused primarily on interesting or problematic areas. The result is a material which is devoted to technical and logical implementation and its ways. Then the importance of a data warehouse and its function in a financial institution are also presented to the readers. One part of my bachelor work deals with the historical development of data warehouses' solutions in this market segment. During the writing I wanted to utilize several years of my experience in this area and that is why this work results mainly from practical knowledge and it is also focused on real implementation.

This thesis is focused on topics of Business Intelligence, Balanced Scorecard and its implementation in agricultural company Novak Co. Both methods will be applied to section warehouse of spare parts. Warehouse by Novak Co. deals with provision of spare parts for own consumption and sale of spare parts to external customers. The thesis consists of theoretical and practical parts. Theoretical part deals with a description of essential ideas of BSC and BI. Practical part deals with examination of gained knowledge by implementation BSC and BI to warehouse by Novak Co.. To begin with, the first chapter is focused on Balanced Scorecard methodology. There is a description of principles BSC, description of company goals via four perspectives and the definition of strategic map. There are described basic principles of BI, multidimensionality, main components of BI application and a few definitions of BI from different sources in the second charter. In theoretical part, there are mentioned a few thesis, which deals with the same or similar subject, like this thesis. The practical part is focused on design of pilot project of BI solution for the warehouse of spare parts in the company Novak Co.. At first there was processed the analysis of BSC and the analysis of accessible resources in order to determine possibilities and requests for BI application. Based on requests there is designed the data warehouse, ETL tools and OLAP cubes. Reporting is carried out by MS Excel 2007. The Outputs of BI application are based on real company's requests. The main benefit of this thesis is to demonstrate the usability of BI tools and BSC methodology in section of warehouse of spare parts.

Since 1989, there rose many branches. One of them the company grounds with their work scope as ICT services, ICT trainings and system development. The households had started to use in huge the PCs and round 1992 joined WEB. The companies did start to ask for applications which would have been able to be in connection with the other branch offices and had been looking for such solutions that would have brought the new added value. There had been rising new bank systems, telecommunication, insurance, energy, industrial systems and the like. Today, we are dating 2011 and it is more than 20 year; and the systems are still in use. Therefore it is unavoidable to store all the data to be used further and based on the data to create competitive environment. Every company has got its own department assuring data storage, data analysis and reporting the results to the top management. In past the data was used to process decision streamline, and thus remedy the key branches. Hence a new line of business came up focused on data processing, the new technology standards conception, new storage data types etc. The new fundamental term was formed -- Business Intelligence. The subject of the diploma paper is Business Intelligence Solution in enterprise scoped to the process design, development, data purity and project management in pharmacy. There are mentioned the base components of Business Intelligence Solution, technology and meritorious aspect of design. Integral part of this work is description of pharmacy problematic and project management.

This thesis is focused on the design of Business Intelligence solution to the logistics sector. Its main goal is to enable the unnamed central-bohemian company, which deals with truck road transportation, to follow up and evaluate its data better. The theoretical part is focused on the basic principles of Business Intelligence and on the analysis of current market situation. The next section is dedicated to the specifics of this problematic in the logistics field. The practical part deals with the design of Business Intelligence solution to the concrete company. The analysis of company preparedness for Business Intelligence and the specification of requirements on its solution precede the resultant reporting tool. There is the unification of company's data in the form of data warehouse and the design of individual indexes and dimensions, from whose point of view data will be monitored. The main benefit of this thesis is resultant solution in the form of reporting tool, which can company, that is not familiar with the problematic of Business Intelligence, use as its future advantage.

This master's thesis deals with the topic of designing an agile methodology for Business Intelligence projects. The thesis presents the topic of Business Intelligence, methodologies for managing projects and methodologies for data warehouse development. It presents Scrum, BEAM* and Data Vault methodologies as well as approaches like pomodoro, Action Centered Leadership and a 40-hour work week. Based on synthesis of presented methodologies and approaches this thesis defines the methodology for managing Business Intelligence projects. The newly designed methodology HooBI is a minimal methodology for agile management of Business Intelligence projects based on data warehouse, containing Business Intelligence elements and approaches for effective work. The usage of methodology is double verified; firstly, by comparison of managing a completed past project with its alternative of eventual usage of the designed methodology HooBI, secondly by expert review. The Methodology should simplify the development and management of Business Intelligence projects and can be used by professionals in the field of Business Intelligence.

Main goal of this master thesis is to create Management Information System for company Dolphin consulting, s.r.o. based on technologies available within its infrastructure. Next goal is conduct preliminary verification of the created Management Information System. Generally, the Management Information System is created in accordance with resources including but not limited to Business Intelligence, Management Information Systems literature and experiences of the author. The most important assets of this thesis are creating of the system for Dolphin consulting, s.r.o. and initial verification of created system for its further development and highlight issues that arise. This master thesis is divided into two logical parts. The first part is purely theoretical and describes the issues of data warehousing according to Kimball and Inmon, OLAP Cubes and Management Information Systems. Practical part of thesis describes implementation of Business Intelligence tools as a part of created Management Information System in company Dolphin consulting, s.r.o. At the end of this part is the above stated preliminary verification of the Management Information System with list of recommendations for improving the system.

This thesis deals with transformation of network data reporting process in a Telecom company. The current process is MS Excel based and is inadequate and inefficient. The goal is to find the right tools and to implement them. The thesis is divided into three parts. First part is focused on theoretical background of reporting, i.e. Business Intelligence and other approaches. Second part explains general Network reporting principles and trends. In contrast with these theoretical recommendations, the actual level of the company's process is depicted. The last part of this thesis covers a practical implementation of selected applications. First, a choice is made within a variety of tools based on department's needs then the architecture is proposed and applications are implemented. The final part of the thesis provides an assessment of the benefits attained by this project.

This work is focused on the workload management of data warehouses based on Teradata technologies using Active System Management architecture. Objectives of this work are to characterize and analyze Active System Management architecture and types of rules, used in the workload management of Teradata data warehouses. These objectives have been achieved by a search of available resources and their subsequent analysis. Informations obtained from the analysis were empirically verified on a particular instance of a data warehouse and their synthesis is presented in this work The contributions of this work are in the documentation of technology that is currently not well known and widespread in the Czech Republic. Another contribution is identification of risks, drawbacks and presentation of recommendations in the workload management using Active System Management based on empirical tests. The repeatable implementation procedure based on induction has been proposed in the work. Maturity of the architecture for a production environment is evaluated. The work is hierarchically divided into several chapters that are dedicated to Teradata database technologies, workload management, Active System Management and implementation procedure. The first three chapters are focused on theory, however, they also contain practical informations related to the processed theory. The latter chapter is focused practically, therein is designed a repeatable Active System Management architecture implementation procedure.

The thesis focuses mainly on OLAP technology and its tools using to analyze corporate data. One of the objectives is to define the analytical tools market and provide an overview which shows the current situation concerning those tools on Business Intelligence (BI) market. Another objective is to obtain an overview of some current and future trends in the BI market. The main purpose of the thesis is to create a "methodology" for solving an BI analytical tasks using analytical services in SQL Server 2008 R2 from Microsoft. To achieve these objectives a theoretical analysis of available resources and, in particular consultation with employees of Clever Decision company is used. The main contribution of this work is the development of analytical database itself, which is divided into separate phases where each phase contains best practices and recommendations, including examples.