Analysis and design of Self-service business intelligence solution for a retail company

The bachelor thesis deals with the analysis and design of Self-service business intelligence solution for a selected retail company, which sells groceries, toiletries and miscellaneous goods. The goal of this thesis is to analyze the business characteristics of the company, from both the internal as well as the external points of view, based on which a prototypical SSBI design in program Power Pivot will be conducted. This solution should fit the analyzed needs of the chosen business unit, which are real and required by the company owner. The thesis is divided into two main parts, theoretical and practical, from which an emphasis will be put on the practical one. The beginning of the thesis provides the introduction to the topic BI and particularly SSBI, where the reader can gain an overall understanding of their basic concepts. The following sub-part deals with the general characteristics of the chosen company and hereafter emphasizes on the current state of its information system. Thanks to these examined findings, a prototypical design of the SSBI application will be carried out, which serves as an auxiliary tool for the company’s manager as well as its employees. The application being designed to monitor the economic state of the company can help its staff with better decision-making in important matters and changes, which can be necessary for the functioning of their small family retail company as well as for obtaining better economic results.