|
|
Iplementation of Business Intelligence into warehouse of spare parts
Filip, Petr ; Novotný, Ota (advisor) ; Kadleček, Ladislav (referee)
This thesis is focused on topics of Business Intelligence, Balanced Scorecard and its implementation in agricultural company Novak Co. Both methods will be applied to section warehouse of spare parts. Warehouse by Novak Co. deals with provision of spare parts for own consumption and sale of spare parts to external customers. The thesis consists of theoretical and practical parts. Theoretical part deals with a description of essential ideas of BSC and BI. Practical part deals with examination of gained knowledge by implementation BSC and BI to warehouse by Novak Co.. To begin with, the first chapter is focused on Balanced Scorecard methodology. There is a description of principles BSC, description of company goals via four perspectives and the definition of strategic map. There are described basic principles of BI, multidimensionality, main components of BI application and a few definitions of BI from different sources in the second charter. In theoretical part, there are mentioned a few thesis, which deals with the same or similar subject, like this thesis. The practical part is focused on design of pilot project of BI solution for the warehouse of spare parts in the company Novak Co.. At first there was processed the analysis of BSC and the analysis of accessible resources in order to determine possibilities and requests for BI application. Based on requests there is designed the data warehouse, ETL tools and OLAP cubes. Reporting is carried out by MS Excel 2007. The Outputs of BI application are based on real company's requests. The main benefit of this thesis is to demonstrate the usability of BI tools and BSC methodology in section of warehouse of spare parts.
|
|
|
Analysis of Current Areas of Data Warehouse Solutions
Hník, Pavel ; Pour, Jan (advisor) ; Dvořáková, Dana (referee)
This thesis analyzes various factors of impact on current data warehouse solutions. It is structured along three main sections. The first section dissects current issues faced by data warehouses. The second section focuses on an analysis of how the market for data warehouse solutions has developed; within this context, it also mentions other, related markets. The last section is devoted to current trends in the area of data warehouses and Business Intelligence. While this work focuses on data warehouses proper, the topic is closely interconnected with the overarching category of Business Intelligence, which is why a suitable degree of discussion also of this area appeared to be in order. This paper does not seek to provide advice as to which specific solutions management should choose for their business, nor to serve as a manual on how exactly to implement a data warehouse so as to avoid potential issues. Rather, this thesis attempts to provide a comprehensive and transparent overview of the factors which have impact on today's data warehouse solutions. The rationale behind this thesis is to draw special attention to the key influences on data warehouse solutions at this point in time and to give an informed estimate of their likely future development.
|
|
|
Teradata Database System Optimization
Krejčík, Jan ; Chlapek, Dušan (advisor) ; Štaud, Karel (referee)
The Teradata database system is specially designed for data warehousing environment. This thesis explores the use of Teradata in this environment and describes its characteristics and potential areas for optimization. The theoretical part is tended to be a user study material and it shows the main principles Teradata system operation and describes factors significantly affecting system performance. Following sections are based on previously acquired information which is used for analysis and optimization in several areas of described environment.
|
|
|
Possibilities of CPM solution in banking sector
Janata, Pavel ; Pour, Jan (advisor) ; Matuštík, Ondřej (referee)
This thesis addresses issues of measuring and managing the performance of commercial bank institutions by means of a system called Corporate Performance Management (CPM). The theoretical part of this work is devoted to introduction of banking industry and methods of performance measurement in commercial banks. It introduces a general concept and key components of CPM supported by Business Intelligence technology. In the practical part of this work there is introduced the design of two concrete CPM solutions which are being currently built in banks -- KPI processing and interest margin calculation. The main thesis contribution to the existing literature is a creation of complex material about relevant aspects of implementation CPM solutions in data warehouses of commercial banks and creation the conceptual design of a concrete solution.
|
|
|
How to implement data warehouse in banks and insurance companies
Matějka, Martin ; Řepa, Václav (advisor) ; Kyjonka, Vladimír (referee)
This diploma thesis deals with data warehouse applications in banking and insurance sector. The aim is to define this sphere, describe it and create a set of reccomendations and methodology connected with the best ways of implementation in financial institutions. Because of the wide range of this topic it can not be taken globally. I focused primarily on interesting or problematic areas. The result is a material which is devoted to technical and logical implementation and its ways. Then the importance of a data warehouse and its function in a financial institution are also presented to the readers. One part of my bachelor work deals with the historical development of data warehouses' solutions in this market segment. During the writing I wanted to utilize several years of my experience in this area and that is why this work results mainly from practical knowledge and it is also focused on real implementation.
|
|
|
Data Quality, Data intagrity and Data Consolidation in BI
Smolík, Ondřej ; Pour, Jan (advisor) ; Zajíc, Ján (referee)
This thesis fights with the data quality in business intelligence. We present basic principles for building data warehouse to achieve the highest data quality. We also present some data clearing methods as deviation detection or name-address clearing. This work also deals with origin of erroneous data and prevention of their generation. In second part of this thesis we show presented methods and principles on real example of data warehouse and we suggest how to get sales data from our business partners or customers.
|
|
|
SAP BI Platform Analysis and Comparison with Chosen Tools of MS SQL Server BI Solution
Řezníček, Jiří ; Pour, Jan (advisor) ; Nedbal, Michal (referee)
This diploma thesis deals with an analysis of SAP Business Intelligence platform (SAP NetWeaver BI 7.0) and compares its chosen tools with Microsoft SQL Server BI. The main aim of the thesis is to evaluate SAP BI system in a comprehensive way whereas extra attention is paid to certain areas, such as a data warehouse. One of the goals is the comparison of approaches and methods of the creation of the data warehouse with MS SQL Server BI solution. The thesis consists of theoretical insight into Business Intelligence, which is focused on the architecture of data warehouse, and OLAP technologies. There is an evaluation of the role of SAP in the BI market followed by the introduction of SAP NetWeaver, an application and integration platform. Included is also an analysis of the architecture of data warehouse, methods of storing data, ETL process and other chosen functions and tools (including presentation tools) in next sections. A sample application in the final part provides the reader with better understanding of different ETL approaches, which are analyzed into detail and evaluated. There is the comparison of OLAP technologies in the end and the comparison of basic reporting tools, as well.
|
|
|
Architecture of banking data warehouse
Bureš, Petr ; Pour, Jan (advisor) ; Meixner, Jiří (referee)
The thesis deals with banking data warehouse and the factors which influence their architecture. The goal of the thesis is to analyze the influence by fulfilling the three partial goals -- defining banks' requirements on data warehouses, analyzing a data warehouse in the real banking environment and making a comparison of the Czech banks' data warehouses. First, the thesis briefly introduces elements of business intelligence (BI) and data warehousing. Second, after deducing reasons for BI implementation in commercial banks, the requirements on data warehouse are synthesized and their impacts on the data warehouse architecture are analyzed. Finally, conclusions of the thesis are applied on creation of the survey which enables comparison of the Czech banks' data warehouses. The thesis applies the theory of relationship between BI maturity, requirements on BI and data warehouse architecture and creates a tool for evaluating and comparing the data warehouses of banks with respect to bank's BI maturity and predisposition for a particular architecture. The tool can serve as a basis for a general tool able to compare data warehouses in other branches of economy and can help to better understand relations between organizations' need for information, BI solutions used and underlying data warehouses.
|
|
|
Reaction to errors and alerts in ETL
Klimt, Roman ; Pour, Jan (advisor) ; Zajíc, Ján (referee)
This work deals with information systems called Business Intelligence (BI). Especially, it focuses on one part, whose task is to extract data from primary information systems. This stage is known as extract, transform, load (ETL). ETL is one of the most important stage in BI solutions because the quality of data depends on this stage. These data are used for all analyses and created reports. The goal of this work is to suggest solution for active projects, which are short of automated controlling mechanism. This mechanism should inform users of BI solutions about errors in data. If data from primary systems are in such bad state that ETL process is not able to match primary keys to them, the data are stored in special tables and are not used for future analyses. This is a very serious problem because analyses and reports based on the data may be misrepresentative. This problem must be solved by repairing the data in primary information systems. The administrator of primary information system has to know about the incorrect so that the data could be repaired. Therefore, an automated e-mailing system has been designed to inform about the incorrect data.
|
|
|
Implementation of Business Intelligence in ČON s.r.o. company
Hofman, Lukáš ; Novotný, Ota (advisor) ; Maryška, Miloš (referee)
This dissertation thesis deals with the topic of Business Intelligence and Balanced Scorecard and its use in České odborné nakladatelství, s.r.o., a relatively small company of 29 employees, which publishes magazines about business, gastronomy, textile, foods, hotels etc. The first part of my thesis describes the BI and BSC theoretically and offers a methodical basis for the following chapters. It gives the reader a definition and structure of BI, with access to a Data Warehouse including the fundamentals of building an OLAP database. It furthermore explains what BSC is, which perspectives use and what a strategic map is. The theoretical chapters of my paper will draw conclusions about the use of BI and BSC and the links between them. The practical, hands-on, chapters continue with the actual application of BI and BSC in the afore-mentioned ČON, s.r.o. It describes the goals and ambitions of the company, which are further on divided into individual strategic goals and metrics, fragmented into perspectives of the BSC and portrayed in a strategic map. Upon analyzing the demands of the company a BI framework is created, data sources are identified, Data Warehouse are designed and brought into effect. In the end a multidimensional OLAP cube is created with MS SQL Server 2008. Finally, there is a MS Excel 2007 explanation and interpretation of the measured values (reporting), which is taken from the available sources of ČON, s.r.o. and is compared against the set strategic goals and metrics of the company. The results of this thesis are based on actual demands of the company and are ready to be implemented and used in real-life.
|
guest ::
