|
|
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.
|
|
|
Designing a controlling concept using the business intelligence system
Hejdánek, Michal ; Král, Bohumil (advisor) ; Houser, Václav (referee)
The Master Thesis deals with the use of the controlling concept in business management, Business Intelligence systems and their interconnection. The aim is to propose this integration link on the example of a particular company and at the same time to give management recommendations in areas that will be evaluated in the analysis as insufficient. The theoretical part of this thesis is divided into three main chapters. The first deals with the definition of controlling, its tools and organizations. The second one describes business intelligence, not just the basic principles of this technology, but also the choice of tools and the implementation process are explained. The following chapter lists two software tools that combine controlling and business intelligence in practice. The practical part is divided into a general description of the company, analysis of the applied elements of controlling and then the proposal of solution of insufficient areas and the process of BI implementation, which contains 12 steps which would enable to implement the BI concept.
|
|
|
Comparison of reporting applications for mobile devices
Stejskal, Karel ; Šedivá, Zuzana (advisor) ; Novotný, Ota (referee)
This bachelor thesis focuses on the mobile devices market and the possibilities of their use for presentation of key business data using reporting applications. The goal of the thesis is to provide a comprehensive view of the mobile devices market as well as available reporting applications of commercial suppliers who play a crucial role in this segment. Then compare these applications using a multi-criteria evaluation based on a list of criteria and determine the most suitable application that has received the highest rating in this comparison. The final output is a table of compared applications with the ratings assigned to the individual criteria. The thesis serves as a basic orientation in the mobile reporting applications market. Application comparison results can be a useful source of information for companies planning to integrate them into their enterprise information system.
|
|
|
Critical Factors of Management Information System Implementation on Platform Tableau
Svarovský, Jiří ; Honza, Dalibor (referee) ; Sodomka, Petr (advisor)
This master´s thesis deals with critical factors of management information systems implementation. In first part its describing the present state of the topic, defines the basic terminology, clarifies theoretical background and determines how to understand to a concept of management information systems. In next part is survey of current business intelligence solutions of three leaders of the world market and its detailed comparison, description of their basic properties their advantages and disadvantages. In Conclusion is detailed description of platform Tableau, its practical application, example of implementation, critical succes factors and benefits of its use in companies.
|
|
|
Transformation of Network Data Reporting Process
Tolar, Tomáš ; Matuštík, Ondřej (advisor) ; Malinová, Ludmila (referee)
This thesis deals with transformation of network data reporting process in a Telecom company. The current process is MS Excel based and is inadequate and inefficient. The goal is to find the right tools and to implement them. The thesis is divided into three parts. First part is focused on theoretical background of reporting, i.e. Business Intelligence and other approaches. Second part explains general Network reporting principles and trends. In contrast with these theoretical recommendations, the actual level of the company's process is depicted. The last part of this thesis covers a practical implementation of selected applications. First, a choice is made within a variety of tools based on department's needs then the architecture is proposed and applications are implemented. The final part of the thesis provides an assessment of the benefits attained by this project.
|
|
|
Cross-channel attribution modelling
Žárský, Jiří ; Šperková, Lucie (advisor) ; Vraná, Lenka (referee)
This bachelor thesis focuses on attribution in the context of online marketing and studies available evaluation models for the performance of advertising campaigns. This performance is measured on the basis of the campaigns' effectiveness in catching the attention of customers and generating revenue. Data containing information about users' interactions with real advertising campaigns were used for the analysis. Prior to solving the attribution problem, data from the AdForm platform were cleansed and transformed into the required structures. This process is automated by the ETL tool called Keboola. Afterwards, data are analyzed using various attribution modelling techniques such as simple heuristics, the Shapley Value or Markov chains. The thesis discusses the theoretical side, as well as the actual application of these models. In the last section, the results of individual models are interpreted, taking into account the campaign costs. The interpretation is performed in the Tableau visualization software, using metrics such as the return on advertisement spending. This thesis presents a critical assessment of attribution models based on predetermined criteria. A scheme of data transformations, which can be used for future analyses of advertisement campaigns, was also created as part of this work. The thesis further includes a chapter discussing issues potentially leading to inaccuracies in the models' results.
|
|
|
Comparison of selected commercial reporting BI platforms
Krečmerová, Petra ; Novotný, Ota (advisor) ; Daněk, Lukáš (referee)
This Diploma thesis focuses on a comparison of selected commercial reporting BI platforms. The goals of the thesis are to create pilot dashboards based on three Business Intelligence tools, compare these tools among themselves and select the most optimal one for creating dashboards. The theoretical part describes the problematics of Business Intelligence, its principles and components. These are divided into several layers such as production systems, transformation and data layers, data analysis and presentation layer. The performance dashboard are then described and an indepth analysis of the commercial tools market has been performed. In the practical part pilot dashboards are created based on retail chains data in three selected Business Intelligence tools Power BI, QlikView and Tableau. These are then compared and based on a multi-criteria analysis the optimal tool for creating dashboards is selected and recommended. The evaluation criteria, their weights using Fuller´s method and the final evaluation based on the Weighted Sum Approach are set in the analysis. The Diploma thesis is set up for a project of the Competency center Retail Analytics and for the professional community. It shall be used as one of the sources in the selection of BI reporting platform.
|
|
|
Big Data Analytics tools
Miloš, Marek ; Pour, Jan (advisor) ; Andrle, David (referee)
The thesis covers the term for specific data analysis called Big Data. The thesis firstly defines the term Big Data and the need for its creation because of the rising need for deeper data processing and analysis tools and methods. The thesis also covers some of the technical aspects of Big Data tools, focusing on Apache Hadoop in detail. The later chapters contain Big Data market analysis and describe the biggest Big Data competitors and tools. The practical part of the thesis presents a way of using Apache Hadoop to perform data analysis with data from Twitter and the results are then visualized in Tableau.
|
|
|
Principles and processes of making reports and their verification in the selected reporting tools
Čelikovský, Filip ; Maryška, Miloš (advisor) ; Pesek, Jan (referee)
The diploma thesis covers the principles of dashboard or report design. The first part of thesis is focused on introduction to the issue of reporting, based on current literature. There are the definitions of basic terms, position of reporting in corporate structure, history and basic division in this part. Further, this thesis is focused on information design. There are descriptions of basic visualization elements commonly used in reporting, after that the issue of using colours and finally the information about the appropriate distribution of these elements on the surface of the dashboard or report. In the practical part of the thesis, there is primarily created the methodology of comparison of reporting tools. The goal of this methodology is to compare two specific tools for obtaining information about the qualities of compared reporting tools. As a part of this methodology, there is also a list of required functions and also a few user criteria which are assessed based on the practical use of these tools during creation of specific dashboard. Complex design of this sample dashboard is also part of the methodology. Methodology was proved by its application to two compared tools, namely the SAP Crystal Reports 2011 and Tableau Desktop 8.1. Result of this comparison contained a lot of information about the tools which can be used by reader as a basis for creation his or her own opinion on the tools. Author stated his own recommendation which of the compared tools he would choose for future work in dashboard design.
|
|
|
Comparison of commercial and Open Source Business Intelligence reporting tools
Bednář, Jan ; Slánský, David (advisor) ; Pour, Jan (referee)
Diploma thesis deals with comparison of commercial and Open Source Business Intelligence (BI) reporting tools. The main aim of the thesis is to provide a list of BI reporting tools and their further comparison. Evaluation is based on a set of criteria. Every criterium has its assigned value that represents the importance of the criterium in a given group. The same procedure is applied on the groups. The final evaluation is based on defined values of these groups. The output of the thesis is a table structured into five parts according to defined groups of criteria. The second part of the thesis walks the reader through the practical showcase of implementation one of the selected tools that is SAP Business Objects Enterprise 4.0. At the beginning, there is a description of report proposal that contains graphical design and functionality requirements. Next part shows the whole process in detail.
|
guest ::
