Self service BI in the marketing department of a telecommunications company

This bachelor thesis describe ways of dealing with self-service business intelligence in the marketing department of a telecommunications company. The main objective of this thesis is to introduce technologies for self-service business intelligence, which are part of the program Microsoft Excel 2013 and demonstrate their potential use for the needs of the marketing department. The first part describe the theoretical side of the business intelligence with the division on the classic approach and on self-service. It is later complemented by the introduction of tools for self-service business intelligence contained in Excel. The second part is devoted to practical solutions. Firstly, dimensional model of the available data and secondly, build self-service solutions using the tools in Excel. These are the PowerPivot and Power Query, which is used primarily for the acquisition and management of source data, but also offer a basic visualization. For outputs are then used tools Power View, which allows a clear view of the required information and add-on PowerMaps, which displays the source data on a map. The output is then specific self-service solutions created according to specifications from employees of the marketing department, showing the required information through self- service tools.