I dagens affärsvärld är det i princip ett måste för verksamheter att ta del av den konkurrensfördel som Jinns möjlig via att använda affärsdata genererat av en verksamhets processer för att sedan ta eventuella beslut, detta möjliggörs inom en Business Intelligence- miljö. Dock behöver dessa beslut ofta tas snabbare, mer nu än förr, detta sätter allt större press på den IT-avdelning som skall tillhandahålla beslutsfattare det beslutsunderlag som är nödvändig. På grund av nödvändigheten för dom snabba besluten behöver verksamheter korta ner dom ledtider som den traditionella Business Intelligence-miljön skapar. Ledtiderna skapas via att en beslutsfattare skapar en förfrågan på en analys och IT-avdelningen sedan tar fram en rapport som kan svara på förfrågan. För att verksamheter tillsammans med IT-avdelningen skall kunna minska ledtider kan verksamheten införa en så kallad Self-Service BI-miljö[SSBI]. SSBI fokuserar mer på att göra beslutsfattare självständiga genom att möjliggöra för beslutsfattare att själva, utan hjälp av en IT-avdelning ta del av data och analysera data för att ta sina eventuella beslut. Verksamheter lyckas inte alltid med att införa SSBI, det har visat sig Jinnas många stora utmaningar med ett sådant införande. Att tillgängliggöra data för beslutsfattare inom en sådan miljö är en del av alla utmaningar, men vad Jinns det för utmaningar inom just tillgängliggörandet? Vilka faktorer bör verksamheter fokusera på vid tillgängliggörandet av data, detta är frågor som denna studie skall besvara. Studien baseras på frågeformuleringen nedan: • Hur bör data tillgängliggöras till slutanvändare vid införande av SSBI? Studien genomförs via en fallstudie som involverar ett Jlertal intervjuer av respondenter anställda på ett ledande företag inom Sverige som konsulterar stora verksamheter att inom Business Intelligence och dessutom Self-Service BI. En litteraturgranskning av forskning inom samma domän sker också under studiens gång för att skapa en grund inför intervjuerna. Samt också berika informationen från respondenterna. Resultatet av studien är en modell med diverse faktorer och utmaningar med tre huvudkategorier med tillhörande underkategorier som verksamheter bör fokusera på vid tillgängliggörande av data i en SSBI-miljö. / In today's business world, in fact, it is a must for businesses to take part of the competitive advantage that is made possible by using business data generated by a business's processes and then taking decisions, this is made possible within a Business Intelligence environment. However, these decisions often need to be taken more quickly, more now than before, this is putting increasing pressure on the IT department to provide decision makers with the necessary supporting documentation. Due to the necessity for the quick decisions, businesses need to shorten the lead times that an traditional Business Intelligence environment creates. This is because a decision maker creates an inquiry for an analysis and the IT department then produces a report that can respond to the request. In order for businesses to be able to reduce lead times together with the IT department, the company can introduce a so-called Self- Service BI environment [SSBI]. SSBI focuses more on making decision makers self-reliant by enabling decision makers to themselves, without the help of an IT department, to analyze data to make their decisions. Businesses do not always succeed in introducing SSBI, it has proved to be many major challenges with such introduction. Making data available to decision makers in such an environment is one part of all the challenges, but what are the challenges in the area of accessibility? What factors should businesses focus on when making data available, these are questions that this study answer. The study is based on the question below: • How should data be made available to end users when introducing SSBI? The study is carried out by a case study that involves a number of interviews of respondents employed at a leading company in Sweden that consult large businesses within Business Intelligence and also Self-Service BI. A literature review of research within the same domain also takes place during the study to enrich the information from the respondents. The result of the study is a model with various factors and challenges with three main categories with associated subcategories that businesses should focus on when making data available in an SSBI environment.

In a time where information is ever present and in large quantities, it becomes of extreme importance to organisations to find a way to store and analyse all this information in order to maintain their position on the market. One way to deal with this, which has been adopted by large company groups as well as smaller organisation, is the use of business intelligence, BI. This feature helps organisations to store and analyse information and provide analytical reports to support decision making. Despite the fact that BI has been around for a couple of decades it is still a rather new phenomena with a couple of problem areas which has been highlighted by several international studies and articles. Sweden as a market has been considered as somewhat of a pioneer when it comes to IT-development in general and early usage of business intelligence as well as the emerging trend in the business intelligence market; self-service BI. This solution aims to make business intelligence more user friendly in order to increase the amount of users and ease the pressure on IT-departments within organisations. The purpose of this study is to identify these problems and investigate whether they can be applied to decision makers on the Swedish market and if self-service BI is affecting these problems. The study was done by using a survey with 46 respondents from different organisations located in Sweden. The result shows that the problem areas were not recognised by the majority of the respondents and there were correlations between user-friendliness and how often the respondents used self-service BI.

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 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.

The thesis deals with analysing and designing an effective dashboard. By way of introduction the topics of Business Intelligence, data storages and data quality are described. Then, an overview of analytical outputs is given and the process of their formation is outlined. The basic principles of an effective design of management reports are described, with emphasis laid on the end user. The thesis focuses on important factors of efficiency, such as applicability of transferred information and the form of their transfer. The practical part concentrates on the improvement of the efficiency of a particular dashboard. Besides the rules of a correct design, knowledge of cognitive psychology is also used for this purpose. Upon an analysis of deficiencies of an existing dashboard, proposed changes are incorporated. Changes resulting in more effective transfer of information via a dashboard are based on a theoretical basis of the previous section.

Submitted by Milena Rubi ( ri.bso@ufscar.br) on 2017-10-16T17:29:35Z No. of bitstreams: 1 SILVA_Manoela_2017.pdf: 5765067 bytes, checksum: 241f86d72385de30ffe23c0f4d49a868 (MD5) / Approved for entry into archive by Milena Rubi ( ri.bso@ufscar.br) on 2017-10-16T17:29:46Z (GMT) No. of bitstreams: 1 SILVA_Manoela_2017.pdf: 5765067 bytes, checksum: 241f86d72385de30ffe23c0f4d49a868 (MD5) / Approved for entry into archive by Milena Rubi ( ri.bso@ufscar.br) on 2017-10-16T17:29:57Z (GMT) No. of bitstreams: 1 SILVA_Manoela_2017.pdf: 5765067 bytes, checksum: 241f86d72385de30ffe23c0f4d49a868 (MD5) / Made available in DSpace on 2017-10-16T17:30:06Z (GMT). No. of bitstreams: 1 SILVA_Manoela_2017.pdf: 5765067 bytes, checksum: 241f86d72385de30ffe23c0f4d49a868 (MD5) Previous issue date: 2017-08-07 / Não recebi financiamento / In the current knowledge age, with the continuous growth of the web data volume and where business decisions must be made quickly, traditional BI mechanisms become increasingly inaccurate in order to help the decision-making process. In response to this scenario rises the BI 2.0 concept, which is a recent one and is mainly based on the Web evolution, having as one of the main characteristics the use of Web sources in decision-making. However, data from Web tend to be volatile to be stored in the DW, making them a good option for situational data. Situational data are useful for decision-making queries at a particular time and situation, and can be discarded after analysis. Many researches have been developed regarding to BI 2.0, but there are still many points to be explored. This work proposes a generic architecture for Decision Support Systems that aims to integrate situational data from Web to user queries at the right time; this is, when the user needs them for decision making. Its main contribution is the proposal of a new OLAP operator, called Drill-Conformed, enabling data integration in an automatic way and using only the domain of values from the situational data.In addition, the operator collaborates with the Semantic Web, by making available the semantics-related discoveries. The case study is a streamings provision system. The results of the experiments are presented and discussed, showing that is possible to make the data integration in a satisfactory manner and with good processing times for the applied scenario. / Na atual era do conhecimento, com o crescimento contínuo do volume de dados da Web e onde decisões de negócio devem ser feitas de maneira rápida, os mecanismos tradicionais de BI se tornam cada vez menos precisos no auxílio à tomada de decisão. Em resposta a este cenário surge o conceito de BI 2.0, que se trata de um conceito recente e se baseia principalmente na evolução da Web, tendo como uma das principais características a utilização de fontes Web na tomada de decisão. Porém, dados provenientes da Web tendem a ser voláteis para serem armazenados no DW, tornando-se uma boa opção para dados transitórios. Os dados transitórios são úteis para consultas de tomada de decisão em um determinado momento e cenário e podem ser descartados após a análise. Muitos trabalhos têm sido desenvolvidos em relação à BI 2.0, mas ainda existem muitos pontos a serem explorados. Este trabalho propõe uma arquitetura genérica para SSDs, que visa integrar dados transitórios, provenientes da Web, às consultas de usuários no momento em que o mesmo necessita deles para a tomada de decisão. Sua principal contribuição é a proposta de um novo operador OLAP , denominado Drill-Conformed, capaz de realizar a integração dos dados de maneira automática e fazendo uso somente do domínio de valores dos dados transitórios. Além disso, o operador tem o intuito de colaborar com a Web semântica, a partir da disponibilização das informações por ele descobertas acerca do domínio de dados utilizado. O estudo de caso é um sistema de disponibilização de streamings . Os resultados dos experimentos são apresentados e discutidos, mostrando que é possível realizar a integração dos dados de maneira satisfatória e com bons tempos de processamento para o cenário aplicado.

Subject of honor thesis is self-service business intelligence. Its goal is to prove that it is pos-sible to create a unified industry-specific dashboard above set of different ERP systems. First part familiarizes readers with the main theme of the paper, business intelligence, and selected tool for dashboard creation, Microsoft Power BI. The next part characterizes Soli-tea holding of which project is used and described later in this paper. There is also a place for analysis of all ERP systems provided by the group, from which is in the end chosen a sample for dashboard design. Own contribution to this field of study is proven fact that it is possible to achieve universal business intelligence solution in Power BI in a manner of single dashboard above any ERP system.

The diploma thesis focuses on the analysis of the current state of reporting and data analysis of the ALVAO Service Desk system in the company's internal operation. Based on the findings of deficiencies, a new method of reporting and data analysis on the Microsoft Power BI platform is proposed. The proposal includes the entire Power BI feature cycle from data accessing to sharing.