Inom Business Intelligence har begreppet Self-Service Business Intelligence (Self-Service BI) vuxit fram. Self-Service BI omfattar verktyg vilka möjliggör för slutanvändare att göra analyser och skapa rapporter utan teknisk support. Ett av dessa verktyg är Microsoft PowerPivot.På Transportstyrelsens Järnvägsavdelning finns behov av ett Self-Service BI-verktyg. Vi fick i uppdrag av Sogeti att undersöka om PowerPivot var ett lämpligt verktyg för Transportstyrelsen. Målet med uppsatsen har varit att testa vilka tekniska möjligheter och begränsningar PowerPivot har samt huruvida PowerPivot är användbart för Transportstyrelsen.För att få en djupare förståelse för Self-Service BI har vi kartlagt vilka möjligheter och begränsningar med Self-Service BI-verktyg som finns beskrivna i litteraturen. Vi har sedan jämfört dessa med våra testresultat vilket har varit syftet med uppsatsen.Resultatet av testerna har visat att Transportstyrelsens Järnvägsavdelning initialt behöver teknisk support för att använda PowerPivot. Testerna har även visat att vissa av Transportstyrelsens krav inte kan uppfyllas. Detta minskar användbarheten för Transportstyrelsen.Vidare har vi kommit fram till att Self-Service BI inte alltid är enkelt att använda för slutanvändare utan teknisk support. Resultatet visar även att det krävs en BI-infrastruktur för att enkelt skapa rapporter med god kvalitet och högsta möjliga korrekthet.

The main objective of this thesis is to design dashboards proposals for MBI metrics. In the theoretical part, the concept of a metric is set in the context of MBI methodology and the concept of dashboard is set in contexts of Business Intelligence and Corporate Performance Management in small and medium-sized enterprises. The theoretical part is resolved by the analysis of information sources. MS Excel PowerPivot tool is used for designing dashboards proposals. Designing dashboards, assessment of the importance of Business Intelligence and Corporate Performance Management in SMEs and the proposed extension of the existing MBI metric classification system are main contributions of the author.

Abstract This diploma thesis treats about the latest technologies in the field of self-service BI from Microsoft Corporation. The main goal of this work is to analyze the Microsoft self-service BI solutions, to describe the benefits and advantages of this technology and to show examples with real data in Microsoft self-services BI tools. To achieve the goal, the internet resources, recommended literature, and the software applications PowerPivot and PowerView (Excel 2013) are59 used. In its first part this thesis describes the basic characteristics and technology of classical BI solutions. The second part examines the actual self-service BI solution and its usability. And then analyzes the advantages and benefits compared to conventional technologies. Finally, in its last section describes self-service BI solutions, the DAX language used in PowerPivot and shows example reports with real data from banking sector. The key benefit of this diploma is the verification of the usability and advantages of self-service BI by using Microsoft self-service BI products and tools.

This thesis deals with the Microsoft's self-service business intelligence tools and it's used for eCommerce. The main goal of this work is to analyze and design metrics and applications for effective management of eCommerce using PowerPivot and Power View. Metrics are based on balanced scorecard approach and applications are based on MBI reference model. This thesis is supposed to help eCommerce managers and administrators to implement a custom self-service business intelligence solution.

The main goal of this diploma thesis, which focuses on analysis and implementation of dashboards, is to build a task describing the process of creating a business dashboard. Partial goals of work are identification of benefits after successful dashboard implementation, identification of typical dashboard user and a discovery of possible creation inefficiency causes while creating dashboards. Next fundamental goal is also to extend the referential model of Management of Business Informatics (MBI), to which also responds the structure of this diploma thesis. Defined goals of this thesis are reached by using the combination of a theoretical principles orient to mostly abroad specialist literature and practical experiences. This thesis is structured to three parts. The first is defined the term dashboard, and also his historical connections, positive effects resulting his success implementation and a fully relation to the management of business efficiency. The second part deals with three categories of dashboards structured by their utilizing. There is a description of summary definition, effect and advantages resulting successful implementation and possible problems related with their realisation, by every category. The third part contained the task Creating of a dashboard. This task is created a set of relatively linked steps, which is necessary to follow for successful creating of a dashboard. Each of these steps contains a practical example for increasing of its objectivity. As a component of this part is used an application of MS PowerPivot.

This thesis addresses current topic of self-service business intelligence solutions. The main goal is to create a dimensional model and pilot applications for retail used for Management of Business Informatics (MBI). In order to achieve it is main goal there are four steps, to be taken. During fulfilling of these steps minor and practical goals are achieved as well. Minor goal focuses on comparison of the advantages and disadvantages of current business intel-ligence approaches. Practical goal is to create reports and dashboards for Management of Business Informatics (MBI). The first step is to introduce the issue of classic and self-service BI concluded by comparison of both variants. The second step is the definition of retail and identification of potential indicators. The third step is the introduction of Mi-crosoft´s self-service BI technologies and tools. The fourth step is to create applications for retail in MBI using tools PowerPivot and Power View. The main contribution of this work is to create reports and dashboards that are able to support processes of general retail mod-el. Reports and dashboards will serve as pilot applications for MBI. Another contribution is to acquaint readers with the possibilities of tools PowerPivot and Power View.

Diploma thesis focuses on Data Discovery tools, which have been growing in im-portance in the Business Intelligence (BI) field during the last few years. Increasing number of companies of all sizes tend to include them in their BI environments. The main goal of this thesis is to compare QlikView, Tableau and PowerPivot using a defined set of criteria. The comparison is based on development of human resources report, which was modeled on a real life banking sector business case. The main goal is supported by a number of minor goals, namely: analysis of existing comparisons, definition of a new set of criteria, basic description of the compared platforms, and documentation of the case study. The text can be divided into two major parts. The theoretical part describes elemental BI architecture, discusses In-memory databases and data visualisation in context of a BI solution, and analyses existing comparisons of Data Discovery tools and BI platforms in general. Eight different comparisons are analysed in total, including reports of consulting companies and diploma theses. The applied part of the thesis builds upon the previous analysis and defines comparison criteria divided into five groups: Data import, transformation and storage; Data analysis and presentation; Operations criteria; User friendliness and support; Business criteria. The subsequent chapter describes the selected platforms, their brief history, component architecture, available editions and licensing. Case study chapter documents development of the report in each of the platforms and pinpoints their pros and cons. The final chapter applies the defined set of criteria and uses it to compare the selected Data Discovery platforms to fulfil the main goal of this thesis. The results are presented both numerically, utilising the weighted sum model, and verbally. The contribution of the thesis lies in the transparent confrontation of three Data Discovery tools, in the definition of a new set of comparison criteria, and in the documentation of the practical testing. The thesis offers an indirect answer to the question: "Which analytical tool should we use to supplement our existing BI solution?"

This thesis deals with the extension of Office application Microsoft Excel -- PowerPivot program. First, the thesis focuses on the topic of the actual Business Intelligence (BI) and compares the classical BI approach and self-service BI approach. In the first part are dis-cussed current trends in BI. The second and main part is focused to the PowerPivot. Grad-ually are mentioned benefits and news in PowerPivot on the examples compared to classical analysis in Excel. In the initial description of the features are also instructions for installing the program and its news in version 2013. An important chapter is focused to the DAX expressions and all the calculations that can be implemented in PowerPivot. Separate chapters are devoted to data import and connection with MS SharePoint Server. As an ex-ample, is introduced the calculation of the ABC analysis to classify products, used mainly in logistics. The last part deals with implementation of applications in PowerPivot for MBI model (Management of Business Informatics).

This diploma thesis is focused on the issue of IT management in the companies, which is described in the MBI (Management of Business Informatics) model, at all levels of IT management in the way how they are defined and used by MBI. The main goal of this diploma thesis is design and create (new/modified) content in the area of IT management in the MBI model for broader usage of this model in the company sphere. The main goal is fulfilled by fulfilling of two sub-goals. Firstly, it is designing and creating new metrics, dimensions and applications or modification (extension) of already existing content in MBI model. Secondly, it is implementation of new or (selected) modified content with Microsoft PowerPivot into the form of interactive applications and then into the dashboards composed from them. The structure of this diploma thesis is adjusted to make those sub-goals achievable. The structure is divided into theoretical and practical section containing together six main parts. Firstly, the two most widely used methodologies of IT management and mainly MBI model are described. Then the definitions of metric (as a main instrument, which is used in IT management) and its attributes are described. Following section contains definition of dashboards and basic description about their designing and creating. In the last part of the theoretical section are described metrics, dimensions, applications and their connections in the MBI model. First part of practical section is about designing and creating of new metrics, dimensions and applications or modifying of already existing content. The last part of this thesis contains implementation of a new or (selected) modified content into applications or dashboards. Main benefit of this diploma thesis is enrichment of existing content in the MBI model in IT management (specifically in the metrics, the dimensions, the applications and the dashboards based on those three things), which improved usability of the MBI in practical usage. Thanks to this extended content, the users or mainly the management employees can react in better way on the potential problems, have better overview about level of quality of the IT resources, can manage the employees in better way and can coordinate quality and quantity of the IT outputs in better way in general.