|
|
Self-service BI in higher education
Heřmanský, Michal ; Pour, Jan (advisor) ; Pavlíčková, Jarmila (referee)
This diploma thesis deals with the design of self-service business intelligence reporting in higher education. The main goal of this thesis is to create set of analytical dashboards in Tableau. First chapter is an introduction into the business intelligence area and its core principles and types of users involved. Next, main disadvantages of traditional enterprise level BI tools are explained from business user´s point of view. Self-service BI is introduced as a response to these issues. The main advantages and requirements for successful implementation into enterprise environment are described. At the same time, there are reasons why it is not appropriate to use SS BI as the primary enterprise-wide reporting. Subsequently, the Tableau platform is introduced as a representative of selfservice BI tools. The Tableau Desktop tool is characterized as a reporting tool. It explains how to connect to data sources and how to work with extracts of data. Further, the method of working with the tool is explained and given examples of Tableau analytical functions. The Tableau Server´s architecture is described along with its security features. The administration and assignment of user roles are presented. The last part shows the process of publishing a dashboard from Tableau Designer to the server. The following section deals with the analysis of the higher education. The organizational structure is described and the main and support processes identified. Subsequently, metrics and dimensions are designed to track these processes. The final part proposes sample reports in Tableau for the area of subject evaluation, student study visits abroad, project activities and monitoring of accepted applications for study.
|
|
|
Self-service Business Intelligence benefits in retail
Chalas, Jan ; Topolová, Ivana (advisor) ; Rosenkrancová, Martina (referee)
This bachelor thesis deals with the benefits of using Self-service Business Intelligence (SSBI) tools in retail. It compares SSBI with the traditional concept, in the context of current managers requirements and general trends in the implementation and use of enterprise information systems. Describes the fundamental differences in SSBI versus traditional solutions and draws attention to the benefits and disadvantages that arise.
|
|
|
Self–service Data Preparation Tools
Polák, Tomáš ; Matějka, Martin (advisor) ; Novotný, Ota (referee)
This bachelor thesis is focused on a specific area of Self-service Business Intelligence called Self-service Data Preparation. The main focus of the Self-service Data Preparation tools is to simplify retrieval and processing of data for end users. These tools accelerate the process of data processing, and at the same time, decrease demands and spending on IT departments. The aim of this work is to define the area of Self-service Data Preparation, determining the criteria according to which the tool can be accounted as a Self-service Data Preparation tool. Furthermore, market analysis of the Self-service Data Preparation tools and comparison of selected tools. The main goal of this thesis is to give the reader an understanding of the Self-service Data Preparation area, make a market analysis of the Self-service Data Preparation tools and comparison of the selected tools based on established criteria.
|
|
|
Design of a methodology for BI solutions in QlikView environment
Judová, Eva ; Pour, Jan (advisor) ; Kunst, Jan (referee)
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.
|
|
|
BI Tools in MS Excel 2013 for eCommerce
Šleis, Jakub ; Pour, Jan (advisor) ; Šedivá, Zuzana (referee)
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.
|
|
|
Identification of the state of the market with self-service BI tools
Horák, Josef ; Gála, Libor (advisor) ; Pour, Jan (referee)
The focus of this thesis is the Self-service Business Intelligence. The aim of this paper is to analyze the state of the market with BI tools supporting self-service approach. The thesis acquaints readers with the trending Self-service BI and describes criteria needed for being included in this category. The practical part determines to what extent are the currently available BI tools fulfilling those criteria. The thesis could therefore be useful for BI users as a guide for choosing a product enabling them to be more self-sufficient and as a result, more effective.
|
|
|
Self service BI in the marketing department of a telecommunications company
Prchal, Tomáš ; Pour, Jan (advisor) ; Stecenková, Marina (referee)
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.
|
|
|
Implementation of Self-Service BI at MVNO GoMobil
Řehoř, František ; Pour, Jan (advisor) ; Malecha, Jiří (referee)
The main objectives of this work are determining Self-Service Business Intelligence as one of Business Intelligence approaches, description and characterization of Qlik Sense and finally development of particular solution using the above tool. In the first part thesis deals with the theoretical side of the approach, describes its advantages and disadvantages and users coming into contact with the respective technologies. Subsequently, thesis specifies requirements for Self-Service Business Intelligence and mentions different requirements and sizes of solutions in organizations. At the end recommendations for the implementation of the approach and technologies are mentioned. The second part is devoted to Qlik Sense platform, as one of the representatives based on the Self-Service approach. At first basic features, options and benefits are described. Then the development of solutions and principles of work with this tool are explained. Finally, architecture of enterprise server solution is described together with installation steps and basic configuration of a Qlik Sense site. The third part is focused on mobile virtual operator GoMobil, its current state, Business Intelligence needs and last but not least the requirements and development of solution using Qlik Sense platform.
|
|
|
Business Intelligence tools - analysis market of Self-serviceBusiness Intelligence tools
Sklenář, Ondřej ; Stanovská, Iva (advisor) ; Hnake, Michael (referee)
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.
|
|
|
Self-service BI a PowerPivot
Černý, Ondřej ; Pour, Jan (advisor) ; Horčička, Jiří (referee)
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).
|
guest ::
