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.

This thesis deals with automating the financial data processing for the needs of auditors. In the theoretical part is described the process of transfering financial data between companies and standards defining their format. The following section describes the procedure for export of financial data from the SAP system and their transformation to the Business Intelligence tools, where is processing and visualization part. The main aim of the work is to design and implement BI application according to given specification. There is description of the general principle of Business Intelligence as well as the specifics of tools used, QlikView and Qlik Sense. The practical part of the thesis is focused on app features presentation and quantification of economic benefit for the particular company in comparison to the actual testing procedures used for financial data testing. The conclusion is devoted to analyzing the practical usage of the application and evaluation of set goals.

<p>Huvudsyftet med detta examensarbete är att för vår uppdragsgivare ÅF:s räkning, analysera huruvida det är möjligt att, rent tidsmässigt, hämta lagrad information från en av företagets kunders databaser online samt presentera detta grafiskt, som statistisk information. Hänsyn måste tas till server- och nätverksbelastning. Vid analysen optimerade vi SQL-frågor, vilket resulterade i en minskning av den totala exekveringstiden på serversidan med 24 sekunder.</p><p>Den databasoberoende applikationen QlikView med sina inbyggda funktioner visade sig vara ett mycket användbart rapporteringsverktyg. Genom att utveckla ett grafiskt gränssnitt, tydliggjorde vi olika fråge- och svarsalternativ, vilka fungerar som underlag för sammanställning av produktionsdata.</p> / <p>The main purpose of this thesis is, on the behalf of ÅF, to examine how stored information can be gathered online in a timely fashion. Consideration must be taken to the server and network load. During our investigation we were able to optimize SQL queries that resulted in a reduction of the total execution time by 24 seconds at the server side. One analysis tool that was very useful during our assignment was QlikView, which turned out to be a database independent analysis and reporting tool. We have clarified some alternatives of the questions and answers by developing a graphical interface, which is the basis for putting together the information.</p>

Today budgeting occurs in all types of organizations, from authorities and municipalities, to private companies and non-profit associations. Depending on whether the organization is large or small it can look very different. In large organizations the budget can be such a comprehensive document that it is difficult to keep track of it. Furthermore, in large organizations, the budget work starts very early. Thus, an effective budget process could reduce resources, time and ultimately costs. This master’s thesis report describes a budget application built with the Business Intelligence software QlikView. With the application a budgeter can load desired budget data and through a QlikView Extension Object edit the loaded data and finally follow up the work of different budgets. The Extension Object has been implemented using JavaScript and HTML to create a GUI. The edited data is sent to a back-end interface built with one web server and one database server. To evaluate the usability of the Extension Object’s GUI and determine how the budget application works and to get feedback on the Extension Object and its functionality, a user study was performed. The result of the user study shows that the application simplifies budget processes and has great potential to help budgeters and controllers to increase their effectiveness.

Students at Jönköping School of Engineering were given an assignment from Jönköping municipality, to evaluate their decision support system, QlikView. The students have also developed proposals for improvement with focus on usability.The Jönköpings municipality has currently got 11000 employees and consists of nine different administrations. The target group for QlikView is approximately 600 first-line managers. The intention of QlikView is that the users can get an overall picture of their business by having all information in just one system. The purpose of the thesis is to obtain a picture of what the users think about the system today and present relevant suggestions for improvement, which the Jönköping municipality can use when the introduction of the new version of QlikView takes place. The research questions that the study aims to answer are: • Has QlikView got a user friendly interface?• How can the interface be improved to become more user friendly? Theories that this work is based on is Jacob Nielsens ten usability principles and Ben Schneidermans eight golden rules. They are both well-known authors in the subject of interaction design. The thesis also deals with theories regarding how an evaluation should be performed and how you collect data in the most positive way. The evaluation is started with a questionnaire that was sent out to the employees who had been logged into the system the past six months, the students also carried out interviews with 6 first-line managers. The result from the questionnaire and the interviews is presented in both diagrams, tables and in running text. In the questionnaire, 44% of the respondents thought that the usability in QlikView was low. Opinions that stood out were that the selections are marked in an unclear way and that respondents found it difficult to know how to use the system. The six interviewed persons agreed that they all wanted to have a search box instead of the search function that today is ”hidden”. The suggested improvements that are presented are based on theories and result from the questionnaire and interviews. The work ends with a discussion and a conclusion. The conclusion is that the Jönköping municipality should make some changes in terms of functions and layout to enhance the usability. The students hope that this work will help the Jönköping municipality in their new version of QlikView.

This diploma thesis concerns about Business Intelligence area and its current usage in business practice. The main objective is to analyze the functionality of QlikView application, which represents so called "In memory analysis" products. This work`s output may serve as basis material for making qualified decision, whether QlikView is suitable for particular implementation, or not. Work is divided into two areas. First one is general functionality analysis of QlikView in comparison to MS BI Development Studio tools. The objective of this part is to determine strengths and weaknesses of the application in various situations. In the second part business task solution is demonstrated, using QlikView to turn business requirements into working application. The main benefit of this work is detailed analysis of alternative stream of Business Intelligence applications representative with an estimation of its current market potential.

This diploma thesis deals with implementation of key performance indicators by means of Balanced Scorecard in a selected manufacturing company. The aim of the thesis is to design a strategic map and propose key performance indicators based on Balanced Scorecard system which will lead to improved management of the company. Afterwards the outputs of the designed Balanced Scorecard are used for implementation of an initial Business Intelligence solution using currently available data of the company. The thesis is divided into theoretical part, which is introduced by research of available literature. Next the author describes approaches to business performance measurement, Balanced Scorecard itself and key performance indicators. In the practical part, the author performs a strategic analysis of the company and designs the Balanced Scorecard with key performance indicators for the company. In the second part of the practical part, implementation of the initial Business Intelligence solution in Qlikview application is described.

Huvudsyftet med detta examensarbete är att för vår uppdragsgivare ÅF:s räkning, analysera huruvida det är möjligt att, rent tidsmässigt, hämta lagrad information från en av företagets kunders databaser online samt presentera detta grafiskt, som statistisk information. Hänsyn måste tas till server- och nätverksbelastning. Vid analysen optimerade vi SQL-frågor, vilket resulterade i en minskning av den totala exekveringstiden på serversidan med 24 sekunder. Den databasoberoende applikationen QlikView med sina inbyggda funktioner visade sig vara ett mycket användbart rapporteringsverktyg. Genom att utveckla ett grafiskt gränssnitt, tydliggjorde vi olika fråge- och svarsalternativ, vilka fungerar som underlag för sammanställning av produktionsdata. / The main purpose of this thesis is, on the behalf of ÅF, to examine how stored information can be gathered online in a timely fashion. Consideration must be taken to the server and network load. During our investigation we were able to optimize SQL queries that resulted in a reduction of the total execution time by 24 seconds at the server side. One analysis tool that was very useful during our assignment was QlikView, which turned out to be a database independent analysis and reporting tool. We have clarified some alternatives of the questions and answers by developing a graphical interface, which is the basis for putting together the information.

This diploma thesis deals with performance dashboards and QlikView tool which serves for creation of these dashboards. The work is divided into seven parts. The first and the second part together focus on defining the theoretical foundations of Business Intelligence and Corporate Performance Management, which create basis for performance dashboards. The focus of the third part lies in definition of term performance dashboard and clarifying its major advantages and benefits for a company. An important part is also the description of performance dashboard composition in terms of their usability, layered structure and division into various types. The forth part analyses existing criteria for evaluating of tools dedicated for creation of dashboards. Its goal is, according to the forgone analysis, to make the own list of criteria for evaluating these tools. The aim of the fifth part of this work is to describe QlikView platform. It provides a brief overview of the platform in terms of its most important components and their purpose and also provides an insight into basic architecture of this platform and compares it with traditional BI solutions. The sixth part describes basic principles of work in QlikView. Its goal is to demonstrate the basic procedure of dashboards creation in this environment on sample examples, which should also serve as a simple guide for beginner users of this tool. The last seventh part deals with evaluation of QlikView solution. Its main purpose is to review possibilities and capabilities of this tool for dashboard creation according to the predetermined criteria which are applied to the tool during its evaluation.

Diploma thesis deals with the implementation of Key Performance Indicators (KPIs) throught the Balanced Scorecard method in IT company. The thesis is divided into theoretical and practical part. The theoretical part focuses on the definition of terms related to the Performance Measurement and the Performance Management. The fourth chapter presents the Balanced Scorecard and its perspectives. The next section deals with the types of indicators and furhter focuses on the KPIs description. The practical part applies the theoretical knowledge gained in previous chapters into practice. The sixth chapter focuses on the analysis of the current position of the company and defines its strategic objectives, KPIs and strategic map. The seventh chapter focueses on the implementation of the solution in graphical form as application in QlikView.