Analýza a návrh business intelligence pro společnost REFRAMAT a.s

This bachelor thesis focuses on market analysis and design of Business Intelligence solution for the company Reframat a.s., which operates in the field of securing imports mainly of ceramic materials for large customers in the manufacturing sector. The aim of this work is to create a Business Intelligence solution that would make it easier for the management of the company to make appropriate decisions. The first part of the thesis provides basic information about the company, defines the subject of the company business, presents the offer of goods, main competitors of the company and identifies the strengths and weaknesses, opportunities and threats to the company using SWOT analysis. The second part of the thesis analyzes the current state of the information system in the company and introduces options which it offers. In the next part of the thesis an introductory study is done, which includes a description of the current state of Business Intelligence in the company, the definition of BI solution goals, the requirements of the management for BI solution and the design of BI architecture. The last part of the thesis is devoted to the design of the BI application itself; it means designing dimensions, metrics, relationships between them, creating a physical model of the data warehouse and demonstrating outputs. Finally, the entire proposal is evaluated by the management of the company and the benefits of the solution for the company are described.