Master thesis deals with a problem of data integration between Big Data platform and enterprise data warehouse. Main goal of this thesis is to create a complex transfer system to move data from a data warehouse to this platform using a suitable tool for this task. This system should also store and manage all metadata information about previous transfers. Theoretical part focuses on describing concepts of Big Data, brief introduction into their history and presents factors which led to need for this new approach. Next chapters describe main principles and attributes of these technologies and discuss benefits of their implementation within an enterprise. Thesis also describes technologies known as Business Intelligence, their typical use cases and their relation to Big Data. Minor chapter presents main components of Hadoop system and most popular related applications. Practical part of this work consists of implementation of a system to execute and manage transfers from traditional relation database, in this case representing a data warehouse, to cluster of a few computers running a Hadoop system. This part also includes a summary of most used applications to move data into Hadoop and a design of database metadata schema, which is used to manage these transfers and to store transfer metadata.

The Kimball methodology, often referred to as dimensional modelling, is well established in data warehousing and business intelligence as a highly successful means for turning data into information. Yet weaknesses exist in the Kimball approach that make it difficult to rapidly extend or interrelate dimensional models in complex business areas such as Health Care. This Thesis looks at the development of a methodology that will provide for the rapid extension and interrelation of Kimball dimensional models. This is achieved through the use of techniques similar to those employed in the semantic web. These techniques allow for rapid analysis and insight into highly variable data which previously was difficult to achieve. / Graduate

This thesis analyzes the situation in the area of Business Intelligence at O2 Czech Republic. It focuses on identifying key issues and finding solutions to the overall improvement of the service within the company. It can be a guide for managers on how to proceed in the analysis of the BI environment, finding opportunities for improving organization setup and technical aspects, especially in the data warehouse solution. Here one can also find recommendations on how to proceed with the definition of development methodologies and how to effectively set the tools and processes associated with the development of the data warehouse. This approach results in an efficient, clearly documented and sustainable development concept of the data warehouse in a large company.

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.

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.