|
|
Increasing the information value of the data using modern approaches to visualization
Král, Jakub ; Slánský, David (advisor) ; Pour, Jan (referee)
This thesis solves the area of data visualization in Business Intelligence. We live in a time when the amount of data grows turbulently. These data need to be processed into a form with added value for management and business objectives of the company. The first task is to adjust the data into the required format, the second task is to choose the appropriate visualization so that the data are providing the highest value. This work deals with data visualization and its main aim is to introduce a different approach to data visualization, which has a higher added value than conventional visualization methods used in dashboards and reports. First of all, theoretical part is describing data area (including the trend of Big Data) and reporting (chapter 3). Followed by chapter 4, which is enriching the reader with the information about the need to deal with data visualization and also with the design theory of visualization components. The theoretical part is finished with fifth chapter. It deals with current trends in the field of data visualization and Business Intelligence and also introduces D3.js library as a tool for creating interactive and efficient visualization components. The practical part is offering suggestions for interactive and dynamic visualization of input data (chapter 6). It presents a convenient way to choose a visualization component with greater value than the traditional static component in the form of a graph or table. Proposals contained in D3.js library are presented to the reader. Chosen components according to the author are interesting from the view of design and, if properly used, offer an innovative approach to data visualization. For purposes of practical examples of visualization, author is using D3.js library and open source tool for Business Intelligence from Pentaho. Practical example is part of the final chapter 7.
|
|
|
Automation and visualization project boards in the specific company
Vancl, Jakub ; Slánský, David (advisor) ; Pour, Jan (referee)
The aim of the work is create and describe solution of automation and visualization of project boards in the specific manufacturing company. Methods and tools of Business Intelligence are used in this process. Project board is arranged summary of information, which is part of the monitor, in this context. There is for example information about produced pieces, the cost of poor quality, project Scorecard, downtime analyses, bottleneck of project, and so on. The theoretical part is dealing with description methods and components of Business Intelligence and serves to explanation basic principles on the basis of which are formed data staging area, data warehouse, OLAP cubes and dashboards. The main emphasis is on the practical part, in which is detail describe process of data elaboration from source data, which are taken primarily from MS Excel files, till data visualization in the form of dashboard. As software workspace were selected Microsoft products, specifically SQL Server Management Studio, Visual Studio and Excel which has been mentioned before. The main output is solution that will gradually fully replace paper project boards. This solution also brings both financial and time savings in the creation and managing project boards, because this process is automated.
|
|
|
Knowledge management and knowledge base
Kybkalo, Anatoliy ; Slánský, David (advisor) ; Pour, Jan (referee)
The theme of this diploma thesis is Knowledge Management that is becoming the focus of business companies. The theoretical part of the work is divided into several chapters that discuss the basic principles of Knowledge Management. The aim of this work is to describe the principle of knowledge management and create a basic draft of the knowledge base for the KPMG company. In the introductory part of the work, terms commonly used in knowledge management are explained. Further, the knowledge capital of the company, types of knowledge management and the related knowledge strategies are described. Second half of the theoretical part concerns the responsibilities, tasks and roles in knowledge management. The last chapters of the theoretical part describe the individual phases of knowledge management introduction in a company. The practical part of this thesis is focused at analysis of KPMG company knowledge management and design of a knowledge base that can substantially reduce the time necessary for completion of certain deliverables. The chapter concerns mainly with description of the system architecture of the knowledge base, that the author has designed for the KPMG company.
|
|
|
Mitigace rizik mapování komplexních datových zdrojů na příkladu Solvency II projektu
Abrahamyan, Nazeli ; Slánský, David (advisor) ; Pour, Jan (referee)
The purpose of this diploma thesis is to describe the basic principles of Business Intelligence, its meaning in business reporting with focus on ensuring relevant information for stakeholders and consequently to identify the major risk factors in complex data mapping process of a project carried out for an insurance company Solvency II regulatory reporting. The identification of risks is based on a detailed analysis of the mapping process and its weak points. The main benefit of the thesis will then be the proposed methods by which the risks are mitigated or entirely eliminated. The diploma thesis is focused on specific project, which delivers complex Business Intelligence solution in compliance with Solvency II European insurance regulatory reform. Therefore the flawless mapping of data and mitigation of risks are key to meet the Solvency II requirements on reporting in high quality. The introductory section of the thesis is devoted to definition of Business intelligence and its purpose in organizations. This part also includes the definition of key aspects of successful business reporting and its role in effective decision-making. The other part of the introductory section shortly represents the BI architecture and components of specific Solvency II BI solution. The second main section of the work defines the Solvency II project and describes the specificities of its implementation on a specific project for unnamed organization. Based on the experience of this project is then further described the mapping process of complex data sources. The result is a list of risks arising at each stage of mapping activities. As a completion of the main objective of the thesis there are suggested ways of mitigation for each risk. The benefit of this thesis is that identified risks and the recommendations for their mitigation might lead to more effective project management, increase the quality of its outcomes and satisfaction of company clients.
|
|
|
Browser extensions analysis based on usage trends and their improvements
Marek, Lukáš ; Slánský, David (advisor) ; Pour, Jan (referee)
This master thesis deals with the topic of browser extensions, their environment and analysis. The goal is to describe the extensions environment, online Webstores, that offers extensions and to show best practices for analysis and optimization of its extensions and their assets. Within the thesis you can find very precise analysis of online Webstores for Google Chrome extensions and Mozilla Firefox add-ons. Conclusions are made based on this analysis that include special characteristics of the previously mentioned browsers. The master thesis consists of two parts, theoretical and practical. The theoretical parts deals with the description of the browser extensions environment and it presents specific characteristics about online Webstores and browser extensions to the reader. In the practical part the thesis is focused on objectives set by the thesis and it presents the results of the Webstore analysis and description of the universal Google Analytics solution that helps developers to analyze their extensions The thesis contributes to the topic mainly with the precise description of the browser Webstores and extensions environment, best practices and recommendations and by creating the universal Google Analytics solutions for the developers.
|
|
|
Principles of effecitve report design
Jančík, Jakub ; Slánský, David (advisor) ; Pour, Jan (referee)
This thesis focuses on reporting and problems which are related to it. The main goal is to define the principles of effective report design and its usage and also define rules for choice of appropriate and useful content. This principles and rules are result of detailed analysis based on problems with reports. Contemporary theses are above all focused on technical and visual aspects of reporting. This thesis the contemporary field of view extends by aspect of content. It also focuses on mechanisms, which are important in reporting systems and setting of these mechanisms. The thesis consists of five related parts. The first two chapters define a theoretical basis, while first chapter is dedicated to principles of Business Intelligence and second chapter focuses on reports. Next chapter contains the analysis of problems with reports and defines their fundamental causes. Fourth chapter defines principles of effective report design and the last chapter confronts conclusions of author of this thesis with practice.
|
|
|
Analýza a návrh průzkumu trhu ohledně BI reportingu a dashboardů
Andiľová, Alexandra ; Slánský, David (advisor) ; Pour, Jan (referee)
The main objective of the diploma thesis called "Analysis and design of BI Reporting and Dashboards Survey" is to analyze the main principles of Business Intelligence and Corporate Performance Management approach with a focus on performance reporting and dashboards, and to design a survey form for BI Reporting and Dashboards Survey which will focus on the current state of the reporting and dashboards in European enterprises. The final design of the market survey form is based on the identified key areas of the topic and is created by using the basic principles of statistics which help to compose successful market surveys. It represents the main input for the conduct of the quantitative market survey planned to be realized in the summer of 2014. The first part of the diploma thesis represents the theoretical baseline for the analysis of the key areas of the survey's content. This part includes introduction to the BI and CPM principles (chapter 2) followed by the identification and definition of key elements of successful BI reporting and dashboards (chapter 3). The last chapter of this part (chapter 4) summarizes the key principles of statistics leading to beneficial composition of market surveys. The second, practical part of the diploma thesis (chapter 5), presents the overall design of the BI Reporting and Dashboards Survey. This design includes scope, objectives of the survey, profile of respondents, and specification of the question form with predefined range of possible answers to each individual question. The final design of the question form is also available in Appendix 1 in MS Excel file. This diploma thesis emphasizes the importance of the effective performance reporting and the beneficial use of dashboards in organizations and outlines the key areas of those topics which business representatives should focus on. Another benefit of this thesis is the prepared question form itself which might bring interesting and valuable findings about the current state of BI reporting and dashboards implemented and used among the European countries.
|
|
|
Advantages and disadvantages of relational and non-relational (NoSQL) databases for analytical tasks
Klapač, Milan ; Slánský, David (advisor) ; Pour, Jan (referee)
This work focuses on NoSQL databases, their use for analytical tasks and on comparison of NoSQL databases with relational and OLAP databases. The aim is to analyse the benefits of NoSQL databases and their use for analytical purposes. The first part presents the basic principles of Business Intelligence, Data Warehousing, and Big Data. The second part deals with the key features of relational and NoSQL databases. The last part of the thesis describes the properties of four basic types of NoSQL databases, analyses their advantages, disadvantages and areas of application. The end of this part in-cludes specific examples of the use of NoSQL databases, together with the reasons for the selection of those solutions.
|
|
|
Creation of principles of the mobile reporting development and their practical verification.
Bursa, Jan ; Slánský, David (advisor) ; Pour, Jan (referee)
This diploma thesis deals with design principles of mobile reporting. In the introduction the difference between report and dashboard is described because these two concepts are usually falsely perceived. Then a compilation of a list of properties follows, which of them a well-designed dashboard should have and this is the main objective of this thesis. In its content the document describes, how to achieve certain properties, what to avoid in the layout and recommended features which can help to end users to simplify and streamline the work. These recommendations are also applied in practice by using some examples. The description is given, including workflow and available options of the selected tools. This thesis offers detailed instructions, how to form mobile dashboards, including comments and opinions provided by end users. I find this as the main benefits of this thesis.
|
|
|
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 ::
