The main goal of this thesis is proposal and implementation of the support of decision making with help of Business Inteligence tools in bank environment for deparment of the risk management. The proposal include enlargement of the current used dimensions with new ones. Designed system should fully replace contemporary system and extend possibilities of obtaining informations from data resources and improve the quality of decision making. Designed system will be part of portfolio quality review of multiple business products. The next goal of this work is to analyse current trends in Business Inteligence and analyse the usage of BI in banking. Further analyse the support of BI from operative to strategic decision making. The goals are achieved on the basis of analyses accessible relevant electronic and printed resources, further from knowledge and experience of bank's analysts from deparment of the risk management and BI. Further from service documentation and further from my work experience in deparment of the risk management and from implementation of credit scoring projects. As the personal contribution of the author is possible to consider the demonstration of the usage of BI in bank risk management and at the same time the proposal of one possible way of solving implementation of the supports of decision making in bank's environment.

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.

Cílem této práce je porovnání komerčních business intelligence nástrojů s nástroji Open Source v procesu implementace BI řešení ve střední firmě. V práci jsou porovnávány komerční aplikace Oracle (http://www.oracle.com) ? Oracle Warehouse Builder, Oracle Discoverer a Open Source nástroje z projektu Pentaho (http://www.pentaho.com) ? Kettle, Cube Designer a BI Platforma. Hodnocení obou systémů probíhá na základě předem definovaných metrik. Práce kromě popisu realizace obou řešení a jejich vzájemného porovnání také dává odpověď na zcela zásadní otázku, zda může Open Source řešení konkurovat tomu komerčnímu. Dalším přínosem je návrh modifikovatelného a znovupoužitelného stromu metrik, který je k hodnocení systémů použit.

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.

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.

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.

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.

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.

Since 1989, there rose many branches. One of them the company grounds with their work scope as ICT services, ICT trainings and system development. The households had started to use in huge the PCs and round 1992 joined WEB. The companies did start to ask for applications which would have been able to be in connection with the other branch offices and had been looking for such solutions that would have brought the new added value. There had been rising new bank systems, telecommunication, insurance, energy, industrial systems and the like. Today, we are dating 2011 and it is more than 20 year; and the systems are still in use. Therefore it is unavoidable to store all the data to be used further and based on the data to create competitive environment. Every company has got its own department assuring data storage, data analysis and reporting the results to the top management. In past the data was used to process decision streamline, and thus remedy the key branches. Hence a new line of business came up focused on data processing, the new technology standards conception, new storage data types etc. The new fundamental term was formed -- Business Intelligence. The subject of the diploma paper is Business Intelligence Solution in enterprise scoped to the process design, development, data purity and project management in pharmacy. There are mentioned the base components of Business Intelligence Solution, technology and meritorious aspect of design. Integral part of this work is description of pharmacy problematic and project management.

This thesis deals with the linkages between data models from conceptual models to physical design of information bases, used for implementation. The aim is to analyze the modern approach to design systems and specify how detailed the conceptual modeling and impact on the quality of the final form of application or system, including processes that take place in advance to the next level of design. Approximated the techniques the transition between these levels and will take into account structural features and limitations of selected platforms and requirements for their design and mutual coherence level view of the system. For the purpose of the thesis the well known data modeling methods are being analyzed together with their applicabilities.