Implementation of BI in car sales and servicing

Diploma thesis focuses on topic of business performance management realized through Business Intelligence application created on the basis of a balanced set of indicators within the Balanced Scorecard method. The first part introduces the reader with theoretical foundations. First, it describes the basic principles of the BSC method and meaning of dividing strategic objectives into four perspectives. Subsequently, it introduces the heart of BI - a multidimensional approach, displays the BI architecture and defines its components. At the end it compares the types of database systems. There is also a comparison of this thesis with other projects dealing with similar themes in the theoretical part. After the theoretical chapters comes a practical part which aims at design and development of BI applications for a real company so as to comply with the requirements of top managers and the corporate strategy. At the beginning it introduces a firm to which the project is applied. This is an existing organization operating in the area of car sales and services. The corporation is called under a fictitious name "AUTO a.s." in this thesis. In cooperation with its managers the SWOT analysis and strategic objectives is defined. This determines the key requirements for setting up the BI application. An example of a BI solution that allows managers to effectively monitor the development objectives, brings the main benefit of the whole work. For this purpose is built data warehouse, which is then filled with transformed data from source systems using Data Pump. Then, above the Data Warehouse, two OLAP cubes can be created. Presentation layer, created in MS Excel 2007, handles the interpretation of the results to end-users.