|
|
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.
|
|
|
Building of large Data Warehouses on MS SQL Server 2008 platform
Gottwald, Tomáš ; Novotný, Ota (advisor) ; Pour, Jan (referee)
This diploma thesis deals with building of large Data Warehouses on Microsoft SQL Server 2008 platform. First part of the thesis discuss about news in MS SQL Server 2008, which I have considered as being important for Business Intelligence area. Following chapters are focused on approach to implementation of real Data Warehouse for Customs Administration of Czech Republic on MS SQL Server 2008 basis. These parts of the thesis cover specifics of the Customs Administration of Czech Republic, current state of Data Warehouse and reasons for migrating to MS SQL Server 2008. Further the thesis describes both logical and physical architecture of proposed solution and a way of implementation Data Warehouse on MS SQL Server 2008. The main aim of the thesis is to create a list of critical success factors (CSF) of building large Data Warehouses on MS SQL Server 2008 platform. It's not only plain list CSF, but rather the best practices for MS SQL Server Data Warehouses implementation. The most significant contribution of this thesis is that it offers instruction manual for designing and implementing large Data Warehouse on MS SQL Server basis. Background for the creation of summary of CSV and recommendations were vendor's publications and especially my own experience with the product. My colleagues from company Adastra gave me an advisory opinion as well.
|
|
|
Applying Business Intelligence tools for the Financial and Property Analysis of Municipalities
Horký, Martin ; Novotný, Ota (advisor) ; Toth, Petr (referee)
This master thesis deals with the software support of one Financial and Property Analysis of Municipalities (FAMA). The co-author of this method is Doctor Petr Toth from the Institute of Public Administration and Regional Development at University of Economics in Prague. The method is supported by Microsoft Access database application and two C++ applications ArisDestiller and Prognoza at present time. The aim of this thesis is to evaluate the present software support of Financial and Property Analysis and implement an alternative solution based on Business Intelligence tools. Chosen part of analysis is implemented in the pilot project using Microsoft SQL Server 2005 environment. The thesis focuses mainly on using integration tools for XML data. The contribution of the thesis is to implement data warehouse, which uses the municipalities'annual bills in XML format from the database of Ministry of Finance of the Czech Republic. The Financial and Property Analysis method and the current software support are discussed in the first half of this thesis. The other half of the work is dedicated to the Business Intelligence pilot project. Both means of software support are reviewed and compared from various perspectives in the conclusion.
|
|
|
Data architecture and data marts in banks
Juhás, Michal ; Pour, Jan (advisor) ; Dobáková, Martina (referee)
In this diploma thesis I analyze data architecture and data marts in a bank area. Firstly I analyze different theoretical approaches to build the data warehouse. Consequently I specialize in operational and analytical data marts -- I analyze their business value, differences and location at the warehouse. In the third chapter I analyze reasons that have led to implement Asset Liability Management data mart. In the following chapter I analyze a life-cycle of this data mart not only from the technical point of view, but also from the project management perspective. The main benefit from this thesis is in the analysis of these aspects of ALM life cycle.
|
|
|
Critical Success Factors of Business Intelligence Implementation in the Non-commercial Sector
Jelínek, Petr ; Novotný, Ota (advisor) ; Zajíc, Ján (referee)
The main objective of this thesis is to create a list of critical success factors (CSF) of Business Intelligence implementation in the non-commercial sector and check this list in practice on real projects. Part of the thesis is also the summary of all specifics and differences of BI implementation in public sector and the view of usage possibilities of BI in this sector in relationship on already implemented projects in the Czech Republic so and abroad. The thesis is composed of theoretical and practical part. Theoretical part is focused on problems related to this area, especially analyses the present state of BI in public sector and features specifics and differences related to BI implementation in this area. Further also describes all significant critical success factors of BI implementation in general. Practical part is then aimed on particular verification of Business Intelligence CSFs on real projects realized in non-commercial sector inside of the Czech Republic. As a main tool for obtaining needed and objective information were used managed interviews with competent deputies of submitter (customer) and supplier of particular BI solution. The main contribution of this thesis is determination of differences, but also consistent components of Business Intelligence implementation in non-commercial sector compared to private sector with emphasis on critical success factors. Significant is also the comprehensive view of possibilities and advantages of BI usage in public sector, created by analysis of already implemented projects. These achieved results can be utilized by future (and contemporary) suppliers and submitters of BI projects, but also of other projects from information science area.
|
guest ::
