Search

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.

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.

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.

The objective of my diploma thesis is an analysis and comparison of commercial Self-Service Business Intelligence tools. Publication compares Microsoft Power BI and Tableau software tools. In the first theoretical chapter, which includes overview of publications related to main topic, I explain the Business Intelligence and its architecture in currently used approaches: standard, In-memory and Self-Service. The chapter also explains the pros and cons of changing the current IT environment to Self-Service BI model and the related roles. The analytical chapter covers definition of suitable parameters, which are used for compari-son of chosen tools by multicriterial analysis of different approaches. Parameters and met-rics are grouped by several layers following the BI architecture concept. These layers are data, transformation, presentation, publishing and comunity layer. To set the criteria weig-hts, the Fuller method is used and the results are achieved by weighted sum of acquired values. The main benefit of diploma thesis is a comparison of chosen Self-Service BI tools and their analysis by various criteria. Reader should get the complex picture of Business Intelli-gence topic and will be able to choose the right tool for his needs and be familiar with its pros and cons.

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.

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.

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.

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.

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.

Diploma thesis focuses on Data Discovery tools, which have been growing in im-portance in the Business Intelligence (BI) field during the last few years. Increasing number of companies of all sizes tend to include them in their BI environments. The main goal of this thesis is to compare QlikView, Tableau and PowerPivot using a defined set of criteria. The comparison is based on development of human resources report, which was modeled on a real life banking sector business case. The main goal is supported by a number of minor goals, namely: analysis of existing comparisons, definition of a new set of criteria, basic description of the compared platforms, and documentation of the case study. The text can be divided into two major parts. The theoretical part describes elemental BI architecture, discusses In-memory databases and data visualisation in context of a BI solution, and analyses existing comparisons of Data Discovery tools and BI platforms in general. Eight different comparisons are analysed in total, including reports of consulting companies and diploma theses. The applied part of the thesis builds upon the previous analysis and defines comparison criteria divided into five groups: Data import, transformation and storage; Data analysis and presentation; Operations criteria; User friendliness and support; Business criteria. The subsequent chapter describes the selected platforms, their brief history, component architecture, available editions and licensing. Case study chapter documents development of the report in each of the platforms and pinpoints their pros and cons. The final chapter applies the defined set of criteria and uses it to compare the selected Data Discovery platforms to fulfil the main goal of this thesis. The results are presented both numerically, utilising the weighted sum model, and verbally. The contribution of the thesis lies in the transparent confrontation of three Data Discovery tools, in the definition of a new set of comparison criteria, and in the documentation of the practical testing. The thesis offers an indirect answer to the question: "Which analytical tool should we use to supplement our existing BI solution?"

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.