|
|
Analysis and proposal of Business Intelligence for ZVL AUTO s.r.o.
Ligus, Slavomír ; Pour, Jan (advisor) ; Prokopovič, Tomáš (referee)
The main objective of this bachelor thesis is to analyse the environment of the production company ZVL auto s.r.o. and to suggest and realize a model solution in the field of Business Intelligence based on this analysis. Thesis is divided into two parts. The first part contains a brief description of components that Business Intelligence consists of and the analysis of the company's environment. In the second part, there is the initial analysis, data model that was created, and an example of a model solution created based on the analysis of the company. The added value of this thesis is to demonstrate and introduce the possibilities and advantages of Business Intelligence usage to the company's management, and possibly to motivate the company to implement a complete solution in the future.
|
|
|
Implementation of BI in car sales and servicing
Gottwald, Karel ; Novotný, Ota (advisor) ; Maryška, Miloš (referee)
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.
|
|
|
Iplementation of Business Intelligence into warehouse of spare parts
Filip, Petr ; Novotný, Ota (advisor) ; Kadleček, Ladislav (referee)
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.
|
guest ::
