|
|
Monitoring and Profiling Solution for the BI System
Veselovský, Matej ; Bednář, Luboš (referee) ; Kříž, Jiří (advisor)
This master’s thesis focuses on monitoring and profiling multidimensional database and reports. The project was created in MS SSIS to this purpose and it contains 4 ETL packages. The thesis is divided into three main sections. First section consists of theoretical background needed to accomplish the goal. In second section there is analysis of the company for which is the solution created and in the third part of the thesis there is described the proposal and it’s solution. Proposal of the solution and the solution itself was created in MS Visual Studio 2015, MS SQL Management Studio and Power BI.
|
|
|
Monitoring Solution for the BI Project Maintenance Optimization
Böhmer, Richard ; Bednář, Luboš (referee) ; Kříž, Jiří (advisor)
Master's thesis focuses on BI projects maintenance optimization of company Intelligent Technologies s.r.o., which is one of the leading suppliers of Business Intelligence and Data Warehousing solutions in Czech Republic. The thesis is divided into three main sections – theoretical, analytical and practical. The main goal of these sections is an explanation of important concepts that are necessary to understand the solution, which is being created, analysis of the current state of selected company and detailed description of creating main solution. In this thesis following Microsoft programs were used - Visual Studio 2015, SSIS, SQL Server Management Studio 2017 and Power BI.
|
|
|
Monitoring Solution for the BI Project Maintenance Optimization
Böhmer, Richard ; Bednář, Luboš (referee) ; Kříž, Jiří (advisor)
Master's thesis focuses on BI projects maintenance optimization of company Intelligent Technologies s.r.o., which is one of the leading suppliers of Business Intelligence and Data Warehousing solutions in Czech Republic. The thesis is divided into three main sections – theoretical, analytical and practical. The main goal of these sections is an explanation of important concepts that are necessary to understand the solution, which is being created, analysis of the current state of selected company and detailed description of creating main solution. In this thesis following Microsoft programs were used - Visual Studio 2015, SSIS, SQL Server Management Studio 2017 and Power BI.
|
|
|
Implementace Business Intelligence v MVNO
Kamenchshikova, Alena ; Pour, Jan (advisor) ; Basl, Josef (referee)
The goal of this paper is to implement Business Intelligence solution for mobile virtual network operator Erbia Mobile. The first part is devoted to description and analysis of concepts and architecture associated with BI implementation. The second part deals with technical aspects of BI introduction to the company based on listed requirements gathered from series of interviews with management. Implementation is initiated by analysis of company data sources and detailed description of attributes essential to the telecommunication industry. Based on requirements and data source examination outputs, multidimensional analysis is created and described in detail. Next part describes individual components (Data Warehouse, ETL, OLAP cubes) implementation as well as different optimization techniques. Given components created on Microsoft platform using Integration, Analysis and Reporting Services. Final reports and dashboard visualizations are created using MS Excel and Power BI software tools.
|
|
|
Monitoring and Profiling Solution for the BI System
Veselovský, Matej ; Bednář, Luboš (referee) ; Kříž, Jiří (advisor)
This master’s thesis focuses on monitoring and profiling multidimensional database and reports. The project was created in MS SSIS to this purpose and it contains 4 ETL packages. The thesis is divided into three main sections. First section consists of theoretical background needed to accomplish the goal. In second section there is analysis of the company for which is the solution created and in the third part of the thesis there is described the proposal and it’s solution. Proposal of the solution and the solution itself was created in MS Visual Studio 2015, MS SQL Management Studio and Power BI.
|
|
|
Data warehousing on technological platform TERADATA and Informatica in the insurance industry
Šiler, Zdeněk ; Maryška, Miloš (advisor) ; Hanušová, Jana (referee)
This thesis focuses on data warehousing on technological platform TERADATA and Informatica Power Center (further only IFPC). TERADATA provides a robust database system for storage of big volume data and query processing over such data. Product Informatica Powercenter is a tool for developing of ETL processes. Both of tools belong to mature technology for large data warehouse development which stores large volumes of data over the enterprise. The thesis analyses both tools to build data warehouse and the specifics of their use in the insurance sector. The thesis is divided into two main thematic sections - theoretical and practical part. The theoretical part describes database system TERADATA and ETL tool IFPC in details, including analysis of business intelligence architecture in the insurance segment, which often uses this platform for data warehouse development. The thesis describes the architecture of database system TERADATA and the way to data storage and query processing. Then specific features, on which is necessary to focus by TERADATA data warehouse development, are characterized. Also its advantages and disadvantages are analyzed. Database system TERADATA is faced with other competing database systems. The thesis deals with general characteristics of ETL tool IFPC -- software architecture a its components. It examines the advantages and disadvantages of IFPC compared to competitors on the market. Conclusion of the theoretical part analyzes the synergies between Teradata and IFPC. The thesis explains the real benefits of combination TERADATA and IFPC. The practical part of thesis demostrates the use of tools for data warehousing development on real project Unification of client data. This project describes the entire development process in a data warehouse from business requirements through functional and technical design to implementation of ETL mapping in Informatica Power Center. It deals with bug fixing during ETL development and testing methods. The pratical part focuses on implementation of chosen mapping in IFPC which is deployed in the insurance sector. Part of this thesis is a comparison of ETL tools IFPC with SSIS ETL tool integrated in MS SQL Server 2008 R2.
|
|
|
Optimization of ETL processes
Huňa, Tomáš ; Pour, Jan (advisor) ; Novotný, Ota (referee)
This bachelor's thesis deals with optimization of ETL processes; it is extraction, transformation and load of data warehouse. It is about performance optimization of ETL. The aim of the thesis is to explore ways the particular ETL phases can be optimized, to describe recommendations, methods, suggestions and findings, which can positively affect performance, and to summarize everything into one piece in Czech. The thesis is divided into three chapters. The first chapter deals with basic description of ETL, ways how to estimate duration of processing, and ways how to measure performance of each phase of ETL. Next part is aimed at optimization. Suggestions, methods and recommendations are introduced both for whole ETL and for every single process; extraction, transformation and load. The last chapter is about parallel processing, which can be applied to all ETL processes.
|
|
|
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.
|
|
|
Comparison of tools for application's integration
Kmínek, Jiří ; Chlapek, Dušan (advisor) ; Chocholatý, Drahomír (referee)
In this diploma thesis, I focus on the application integration. Main goal of this thesis is comparison of integration platforms of the biggest vendors on the market, there are products of companies Microsoft, IBM, Oracle and SAP. I compare these products according criteria, which I had chosen. I use mainly own experiences with the products to achieve a goal. These products I compare with respect to general, technological and possibility of using point of view. My work can be as a source for decision, which of the integration platforms is optimal to use. Then I describe one of them - Microsoft Biztalk Server with simple example. The next goal of this work is to summarize the theory of application integration, where I describe the possibilities of integration's application from the simplest till the most complicated. The next goal of this work is making a methodology in Biztalk Server, which will contain concrete solutions and techniques in different situations. This methodology can help developers and analysts to make better proposals, more convenient solutions and beware of needless problems.
|
guest ::
