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 master thesis is devoted to a design for methodology of BI projects in QlikView. The main aim is to propose a recommended procedure solutions reflecting the strengths and weaknesses in the development of QlikView applications. Accompanying chapter to the discussed issue is a chapter Business Intelligence which explains the principles, characteristics and reasons for implementation in companies. Part of defining the differences between traditional and self-service solutions serves as a theoretical basis for understanding the increasing attractiveness of self-service solutions and environment of the proposed methodology. The next chapter presents the company Qlik as a market leader in BI and the owner of QlikView. The reasons for its establishment, subsequent development and actual vision are listed to create a comprehensive view of the environment where the described product was created. Along with the chapter focusing on characteristics and main advantages of QlikView a knowledge base is established for the implementation of proposed methodology. Crucial chapter of this thesis is based on the author's experience gained while implementing QlikView projects. The proposed methodology is based on the description of each phase, its activities, inputs and outputs and its concrete application in a demo environment for the area of receivables in manufacturing company. The key contribution of the author is pointing out potential problems during development or warning about critical parts or providing appropriate recommendations and benefits of the proposed procedures. The designed methodology can serve as a useful guide for self-service projects implemented the QlikView environment.

The thesis deals with problematics of tools marked as Self Service Business Intelligence (SSBI) which is paid close attention by its users as well as producers due to expected progressive growth of this trend. Two products are evaluated: SAS Visual Analytics and IBM Cognos Analytics, both tools are evaluated by their extent of user´s autonomy and support of data visualization. Basic principles and concepts connected to the area of business intelligence are defined in theoretical part of the thesis. The problematics of data visualization is introduced and trend of self-service business intelligence is discussed with analyzing its benefits as well as restrictions. Technological factors which helped to fast development of SSBI are mentioned as well. A methodology has been created within practical part of the thesis. It is enforceable for any other tool from the family of SSBI and it is possible to assess the extent of support within observed categories through this methodology: Using information, Creation of information, Creation of sources and Visualization. A set of criteria on basis of which the evaluator can create evaluation form corresponding to his/her needs was defined for each of the stated categories. Usability of the methodology is illustratively demonstrated at mutual comparison of chosen modules of both tools while those parts are sufficiently described before the evaluation itself.

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

The diploma thesis is focused on a specific area of self-service business intelligence. The advantage of this approach to the business intelligence is reduction of demands on IT development and using tools by end users. They can generate reports and outputs according to their requirements during the relevant time period. The theoretical part is dedicated to illustrate this concept with all benefits and risks. Furthermore, it describes trends occurring in the domain of business intelligence. These trends transcend outline the domain of business intelligence and are valid throughout IT. The practical part is dedicated to the analysis market of self-service business intelligence tools. On basis of established criteria are then compared these tools and deduced general conclusions regarding their functionality. Then, by using three selected tools is created comprehensive business intelligence task with the aim of clarifying a degree of self-service for these instruments. The main benefit of this thesis is based in the integrated analysis of market self-service business intelligence tools and determination of their functionality.

As data becomes a ubiquitous part of today’s business, trust in data is recognised as a crucialfactor for organisations on the data-driven journey to stay competitive in the fast-evolvingmarketplace. To support the journey, Self-Service Business Intelligence (SSBI) has emerged asa popular approach for organisations to empower business users and gain actionable insightfrom data faster and better. Despite its importance and relevance at the organisational level,SSBI has suffered sluggish adoption rates at the user level. The purpose of this thesis is toexplore the importance of trust in data and how it influences SSBI adoption by business users.Through seven semi-structured interviews, this thesis is able to establish that: 1) trust in data isa prerequisite for SSBI adoption by business users; 2) business users trust the people behind thedata; 3) trust in SSBI tools is essential; and 4) trust in data is necessary for user adoption.Furthermore, these findings lead to a descriptive model of how trust in data influences SSBIadoption by business users as well as how business users can transition between a vicious cycleof SSBI resistance and a benign cycle of SSBI adoption.

With the increasing amount of valuable data that companies have access to the need for tools visualizing this data have reached a wider group of users, many of which are not tech-savvy. Self-service Business Intelligence applications aim to meet this need and many guidelines regarding the general design of Business Intelligence have been produced in recent years. In this thesis some of these guidelines are interpreted and applied during the development of a Qlik Sense application for the Device Connection Platform department at Ericsson. The purpose of this thesis is to produce more specific guidelines that aim to complement existing general guidelines on Self-service Business Intelligence design; guidelines that should be taken into account when developing Qlik Sense applications. As a result, five guidelines that concerns conditional dimensions, screen resolutions, naming conventions for master items, the data layer and Qlik Sense conventions for visualizations are presented. Pros and cons regarding these guidelines are discussed along with alternative approaches. The conclusion states that the general guidelines interpreted in this project work were helpful for the workflow and readability of the application, but that more specific guidelines such as the ones presented in the result could be well needed when it comes to customizabil ity and flexibility for end users. / Allt eftersom mängden värdefull data som företag har tillgång till ökar har behovet av verktyg som visualiserar dessa data nått en bredare grupp användare, där många är mindre tekniskt kunniga. Self-service Business Intelligence applikationer syftar till att möta detta behov och många generella riktlinjer för hur sådana applikationer ska designas har tagits fram under senare år. I denna rapport blir dessa riktlinjer tolkade och därefter applicerade under tiden av skapandet av en Self-service Business Intelligence applikation i mjukvaran Qlik Sense och för Ericsson Device Connection Platform. Syftet med rapporten är att utforma och presentera specifika riktlinjer för Qlik Sense att användas som komplement till de existerande och mer generella riktlinjerna för design av Self-service Business Intelligence i allmänhet. Rapportens resultat består av fem riktlinjer som avser villkorliga dimensioner, skärmupplösning, namnkonventioner för original, datalagret och Qlik Sense egna konventioner för visualiseringar. Föroch nackdelar med de framtagna riktlinjerna diskuteras tillsammans med alternativa tillvägagångssätt. Vi drar slutsatsen att de generella riktlinjerna som tolkats genom projektet i denna rapport var speciellt hjälpfulla för att uppnå läsbarhet och ett bra arbetsflöde för slutanvändaren i applikationen. Vidare konstateras att fler mjukvaruspecifika riktlinjer kan vara välbehövliga när det kommer till anpassningsbarhet av applikationer och flexibilitet för slutanvändare.

Studien syftar till att undersöka hur utbildning av de anställda påverkar deras arbetssätt med Self-Service Business Intelligence (SSBI). SSBI kan sammanfattas som en arbetsmetod baserad på dataunderlag som ger beslutstöd för anställda inom verksamheten. Vid tidigare beslutstöd som Business intelligence (BI) fanns det specifika roller som använde sig av dataunderlag och skapade rapporter. Dessa roller befann sig i IT-avdelningen och fick förfrågningar av anställda som var i behov av rapporter för att ta beslut. Syftet med SSBI är att möjliggöra för anställda att vara oberoende av IT-avdelningen och självständigt kunna analysera och tolka data för att sedan skapa rapporter. Detta är något som effektiviserar arbetet hos företag och skapar mer värde genom att underlätta för IT-avdelningen. Även om SSBI tillåter anställda till att bli mer självständiga inom sitt arbete, finns det utmaningar vid införandet. Den väsentliga utmaningen som denna uppsats fokuserar på är hur utbildning påverkar BI-användarna i sitt arbete med SSBI. Studien baseras på kvalitativa intervjuer med totalt fyra företag och fem respondenter. Frågorna som ställts har utgått från det teoretiska ramverket med teorier och modeller om självständighet, kunskap, utbildning och värdeskapande. Detta har varit en substantiell aspekt för att kunna generera kunskap om huruvida utbildning påverkar anställdas arbetssätt med SSBI.   Resultatet av uppsatsen presenterade att utbildning har en tydlig påverkan och en stor roll vid användningen av SSBI. Införandet av SSBI har lett till att anställda känner sig mer självständiga med en större frihet, däremot klarar de med formell utbildning mer avancerade arbetsuppgifter med SSBI. Arbetet inom organisationen har förenklats med SSBIeftersom navigering, definitioner och tolkning av data kan ske självständigt. Uppsatsen visar en tydlig indikation att deltagarna blivit påverkade av införandet av SSBI på olika nivåer framför allt beroende på utbildning men även tidigare kunskap och hur engagerade företag är med att kontinuerligt utveckla SSBI inom verksamheten. / The purpose of this study is to investigate how the education of employees affect their way of working with Self-Service Business intelligence (SSBI) as a working method. SSBI can be summarized as a working method based on data that provides decision support for employees within the business. In previous decision support such as Business intelligence (BI), there were specific roles that were used for data and creating of reports. These roles were in the IT department and received inquiries from employees who needed reports to make decisions. The purpose of SSBI is to enable employees to be independent of the IT department and to be able to independently analyze and interpret data so that reports can be created. With this method implemented in companies, it will create more value by creating more relief for the IT department. Although SSBI applies to employees to become more independent in their work, there are challenges with the implementation. The significant challenges that this study focuses on are how education affects BI users in their work with SSBI. The study has been conducted with qualitative interviews with a total of four companies and five respondents. The questions are based on the theories and models of independence, education, knowledge and value creation to generate knowledge whether training affects employees' working methods.  The results of the study showed a clear impact on how education plays a major role in the use of SSBI. The implementation of SSBI has made employees feel more independent with greater freedom, but with a formal education they can handle more advanced tasks with SSBI. The work within the organization has been simplified with SSBI because navigation, definitions and interpretation of data independently. The study shows a clear indication that the participants have been affected by the introduction of SSBI at different levels, primarily due to training but also previous knowledge and how committed companies are to continuously developing SSBI within the business.

Denna uppsats syftar till att undersöka hur ett införande av Self-Service Business Intelligence och SSBI-verktyg kan påverka organisationsstruktur samt anställdas roll inom organisationen. Self-Service Business Intelligence kan definieras som ett verktyg som möjliggör decentralisering av Business Intelligence vilket innebär att BI-användaren i en verksamhet kan utföra diverse uppgifter på egen hand utan att vara beroende av IT-avdelningen (Sarkar 2017). För att konkretisera arbetet undersöks fyra organisationer. Fem intervjuer som bestod av fyra semistrukturerade intervjuer och en strukturerad intervju genomfördes för att erhålla kunskap om hur dessa företag använder Self-Service Business Intelligence i praktiken. Därtill erhålls kunskap om innebörden för organisationen och dess anställda när verktyget tillgängliggjordes. I studien har bland annat TOE-ramverk använts för att analysera vilka faktorer som har en betydelse vid införande av en ny teknologi. Teorin om Organisatorisk IT mognadsnivå (OITM) användes för att analysera organisationens beredskap för att skapa värde ur informationsteknologi. Andra teorier om olika roller av BI-användare, utbildning och organisationsförändring användes för att få en djupare inblick kring de faktorer som påverkar organisationsstrukturen och anställdas roller.  Resultatet av studien visade att de anställdas roller och organisationsstrukturen påverkades av Self-Service Business Intelligence i olika grader. Det noterades en tydlig indelning av användarroller, avancerade BI-användare och vanliga BI-användare, inom samtliga organisationer. Konkreta förändringar inom organisationerna var bättre beslutfattningsprocess, avlastning hos IT-avdelningen och effektivare arbetsflöde. Bland de organisationer där Self-Service Business Intelligence har fått stor spridning noterades det en större påverkan på organisationsstruktur och anställdas roller medan de organisationerna med en mindre spridning av verktyget hade en mindre inverkan på deras verksamhet. Detta förutsätter dock att organisationerna utbildar sina anställda genom ett strukturellt träningsprogram och motiverar syftet med Self-Service Business Intelligence för en större spridning av verktyget och således en större inverkan på organisationen och de anställdas roller. / In this essay we have chosen to investigate how an implementation of Self-Service Business Intelligence can affect organizational change and the role of users within the organization. Self-Service BI is a tool that enables decentralization of BI which means that the user in a business can perform various tasks themselves without being dependent on the IT department. To concretize the work, we have chosen to examine four companies. The survey was conducted via five interviews (four semi-structured and one structured interviews) to gather insight on how these companies use Self-Service Business Intelligence and the result for their organization and employees when the tool was applied in the organization. In the study, TOE-framework has been used to analyze which factors play a role in the implementation of a new technology. The theory of Organizational IT maturity (OITM) was used to analyze the organizations and its employees' different attitudes towards IT while other theories of different roles of users, training and organizational change were used to gain a deeper insight into the factors that affect organizational structure, employee roles and factors which causes the changes. The results of the study showed that the roles of the employees and the organizational structure were affected by Self-Service Business Intelligence to varying degrees. There was a clear division of user roles, power users and casual users, within all organizations. Concrete changes in the organizations were better decision-making processes, relieves in the IT department and more efficient workflow. Among the organizations where Self-Service Business Intelligence has become widespread, a greater impact on organizational structure and employee roles has been noted, while it has been noted that those organizations with a smaller spread of the tool have seen a smaller impact on their operations. However, this presupposes that the organizations train their employees through a structural training program and justifies the purpose of Self-Service Business Intelligence for a greater spread of the tool and thus a greater impact on the organization and the employees' roles.

Business intelligence is a tool that helps decision makers make informed decisions based on data. Self-Service is an extension of Business Intelligence that focuses on the individual that uses BI-tools and how independent they are. The purpose of this research paper is to cover missing pieces from previous research regarding Self-Service Business Intelligence and to identify factors that can help organizations succeed to become more independent decision makers. This paper is focused only on the combination of Self-Service and Business Intelligence and on organizations that are in the beginning of their usage of BI- tools. Previous research shows that there are many challenges that can affect users and organizations in the process of becoming more Self-Serviced in Business Intelligence. By conducting a case study with the help of a qualitative research method consisting of seven semi-structured interviews, a strategy has been created to help organizations identify what they need to do, to reach a higher level of independent decision-making. The collected data has been analyzed by using an inductive method. The results of the analysis and previous research has led to the conclusion of the study which involves a model consisting of four steps that need to be assessed to overcome the challenges of becoming Self-Service Business Intelligence users. The four steps consist of; becoming aware of the organization’s level of digital maturity; conducting education to raise internal knowledge; identifying different internal needs; and, finally, making BI-reports available to the users, thus increasing accessibility.