|
|
Management of reporting in the banking sector
Hyblbauer, Jan ; Svatoš, Oleg (advisor) ; Bruckner, Tomáš (referee)
The diploma thesis focuses on a proposal for a methodological framework of reporting management in the banking sector and identifying key weaknesses of the current state. Using the proposed methodology precedes weaknesses and proves it on practical example from the real environment. The main benefit of this work is design of a methodological framework that allows the organized management and control of the reporting. It also brings identification of main weaknesses of the current reporting and last but not least universal template for the report specification. The work consists of three parts. The first, theoretical, defines area of reporting in a banking institution. It includes all the terminology, characteristics and types of reports. The second part, analytical, examines the current weaknesses of reporting within the defined area. Provides an overview of three to six major weaknesses in a particular phase of a new report development based on the scientific literature and practical experience of the author of this work in the banking environment. The third and final section contains a draft concept of reporting management in the banking sector with avoidance of the identified weaknesses from the analytical part.
|
|
|
The use of a business intelligence tool on an example of specific organization
Jurošová, Andrea ; Matyáš, Ondřej (advisor) ; Novotný, Ota (referee)
This Master Thesis deals with the use of modern information technologies in business man-agement, business data processing and measurement of business performance, in order to achieve better management decisions. This thesis aims to: introduce a business intelligence principle and business performance management within a certain designated area, their us-age in management systems and, last but not least, their usage in creation of modern presentation tools, dashboards. The theoretical part of this thesis is divided into three chapters. The first deals with busi-ness intelligence, which not only explains this concept and the basic principles of this tech-nology, but also the importance of quality in processing data. The next chapter describes business performance management. The subchapters provide information about the types of control systems and their performance, balanced scorecard method, and types of indicators to measure performance. The chapter dealing with management applications for decision support describes how the above-mentioned technologies and processes can be used for managerial praxes. The practical part is divided into two chapters. The first chapter provides a suggestion of indicators for measuring the selling performance of retail companies. The second part deals with a selection of indicators for a prototype of a dashboard, which is incorporated into a Competence Center of Retail Analytics.
|
|
|
Implementation of Business Intelligence solution in TN Biofaktory company
Kocfelda, Jan ; Maryška, Miloš (advisor) ; Novak, Viktor (referee)
The thesis describes implementation of Business Intelligence solution in mid-sized company which produces and sells animal nutrition products. Currently the company uses basic tools for reporting, mostly Excel application. Considering the data growth, that solution is about not to be sufficient. In the first part of the thesis, the Business Intelligence principals are introduced to the reader, so one is provided with enough knowledge to understand the issue of data processing, transforming and storing. Basics of data visualization used for decision making in the company are introduced as well. At the end of the chapter, there is a list of general rules for creating a dashboard. The secord part describes the Trouw Nutrition Biofaktory s.r.o. company, where the implementation of new Business Intelligence solution is going to take place. The reader will learn about the company size, structure and history. The last part contains a new procedure how to process data for reporting purposes. The design includes data loading to MS SQL 2012 database server and further processing for analytical purposes. In addition, OLAP cube is created as well as three monthly dashboards.
|
|
|
Dashboards - their analysis and implementation by using PowerPivot
Křemenák, Jakub ; Pour, Jan (advisor) ; Pražský, Petr (referee)
The main goal of this diploma thesis, which focuses on analysis and implementation of dashboards, is to build a task describing the process of creating a business dashboard. Partial goals of work are identification of benefits after successful dashboard implementation, identification of typical dashboard user and a discovery of possible creation inefficiency causes while creating dashboards. Next fundamental goal is also to extend the referential model of Management of Business Informatics (MBI), to which also responds the structure of this diploma thesis. Defined goals of this thesis are reached by using the combination of a theoretical principles orient to mostly abroad specialist literature and practical experiences. This thesis is structured to three parts. The first is defined the term dashboard, and also his historical connections, positive effects resulting his success implementation and a fully relation to the management of business efficiency. The second part deals with three categories of dashboards structured by their utilizing. There is a description of summary definition, effect and advantages resulting successful implementation and possible problems related with their realisation, by every category. The third part contained the task Creating of a dashboard. This task is created a set of relatively linked steps, which is necessary to follow for successful creating of a dashboard. Each of these steps contains a practical example for increasing of its objectivity. As a component of this part is used an application of MS PowerPivot.
|
|
|
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.
|
|
|
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.
|
|
|
Využití moderní self-service BI technologie v praxi
Buyankhishig, Agiimaa ; Pour, Jan (advisor) ; Zajíc, Ján (referee)
Abstract This diploma thesis treats about the latest technologies in the field of self-service BI from Microsoft Corporation. The main goal of this work is to analyze the Microsoft self-service BI solutions, to describe the benefits and advantages of this technology and to show examples with real data in Microsoft self-services BI tools. To achieve the goal, the internet resources, recommended literature, and the software applications PowerPivot and PowerView (Excel 2013) are59 used. In its first part this thesis describes the basic characteristics and technology of classical BI solutions. The second part examines the actual self-service BI solution and its usability. And then analyzes the advantages and benefits compared to conventional technologies. Finally, in its last section describes self-service BI solutions, the DAX language used in PowerPivot and shows example reports with real data from banking sector. The key benefit of this diploma is the verification of the usability and advantages of self-service BI by using Microsoft self-service BI products and tools.
|
|
|
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.
|
|
|
Application of dashboards in the area of support of IT management
Sakař, Václav ; Pour, Jan (advisor) ; Šedivá, Zuzana (referee)
This diploma thesis is focused on the issue of IT management in the companies, which is described in the MBI (Management of Business Informatics) model, at all levels of IT management in the way how they are defined and used by MBI. The main goal of this diploma thesis is design and create (new/modified) content in the area of IT management in the MBI model for broader usage of this model in the company sphere. The main goal is fulfilled by fulfilling of two sub-goals. Firstly, it is designing and creating new metrics, dimensions and applications or modification (extension) of already existing content in MBI model. Secondly, it is implementation of new or (selected) modified content with Microsoft PowerPivot into the form of interactive applications and then into the dashboards composed from them. The structure of this diploma thesis is adjusted to make those sub-goals achievable. The structure is divided into theoretical and practical section containing together six main parts. Firstly, the two most widely used methodologies of IT management and mainly MBI model are described. Then the definitions of metric (as a main instrument, which is used in IT management) and its attributes are described. Following section contains definition of dashboards and basic description about their designing and creating. In the last part of the theoretical section are described metrics, dimensions, applications and their connections in the MBI model. First part of practical section is about designing and creating of new metrics, dimensions and applications or modifying of already existing content. The last part of this thesis contains implementation of a new or (selected) modified content into applications or dashboards. Main benefit of this diploma thesis is enrichment of existing content in the MBI model in IT management (specifically in the metrics, the dimensions, the applications and the dashboards based on those three things), which improved usability of the MBI in practical usage. Thanks to this extended content, the users or mainly the management employees can react in better way on the potential problems, have better overview about level of quality of the IT resources, can manage the employees in better way and can coordinate quality and quantity of the IT outputs in better way in general.
|
guest ::
