|
|
Apache Hadoop as analytics platform
Brotánek, Jan ; Novotný, Ota (advisor) ; Kerol, Valeria (referee)
Diploma Thesis focuses on integrating Hadoop platform into current data warehouse architecture. In theoretical part, properties of Big Data are described together with their methods and processing models. Hadoop framework, its components and distributions are discussed. Moreover, compoments which enables end users, developers and analytics to access Hadoop cluster are described. Case study of batch data extraction from current data warehouse on Oracle platform with aid of Sqoop tool, their transformation in relational structures of Hive component and uploading them back to the original source is being discussed at practical part of thesis. Compression of data and efficiency of queries depending on various storage formats is also discussed. Quality and consistency of manipulated data is checked during all phases of the process. Fraction of practical part discusses ways of storing and capturing stream data. For this purposes tool Flume is used to capture stream data. Further this data are transformed in Pig tool. Purpose of implementing the process is to move part of data and its processing from current data warehouse to Hadoop cluster. Therefore process of integration of current data warehouse and Hortonworks Data Platform and its components, was designed
|
|
|
Business Intelligence reporting tools and possibilities
Němečková, Petra ; Matuštík, Ondřej (advisor) ; Vacek, Martin (referee)
This bachelor thesis focuses on the area of Business Intelligence. The aim is to show the basic BI, analysis of new trends in this area and comparison of selected reporting tools according to established criteria. In bachelor thesis was achieved the stated objectives becoming familiar with the concept of BI, its basic principles and general architecture. The bachelor thesis analyzes the main trends in this area. The practical part contains a comparison of selected reporting tools and criteria for this comparison. This work give readers generally knowledge in BI, can also serve as a basis for the selection of reporting tools.
|
|
|
Client workers‘ performance reporting
Klepetko, Vítězslav ; Novotný, Ota (advisor) ; Pour, Jan (referee)
The thesis aims at design and implementation of a corporate performance management system in retail banking. It proposes a tree of performance metrics based on Dupont pyra-mid model. Using financial as well as non-financial measures, the proposed model manages to link all levels of management together into one shared hierarchy. As a result, the model shows how performance of a single worker adds up to the performance of the company as a whole. The model uses financial metrics such as interest margin, account balance, fees and remuneration cost and links them with non-financial measures such as client worker activities with clients, success rate of marketing campaigns, or client complaints. Implementation of the corporate performance management system is done using regular business intelligence tools. Third normal form data warehouse is the source for all data needed. A datamart on Teradata platform is proposed to hold the SQL transformed data from the data warehouse. Using the datamart a metadata layer in Microstrategy is created to distribute data among users.
|
guest ::
