|
Association Rules Mining over Data Warehouses
Hlavička, Ladislav ; Chmelař, Petr (referee) ; Stryka, Lukáš (advisor)
This thesis deals with association rules mining over data warehouses. In the first part the reader will be familiarized with terms like knowledge discovery in databases and data mining. The following part of the work deals with data warehouses. Further the association analysis, the association rules, their types and mining possibilities are described. The architecture of Microsoft SQL Server and its tools for working with data warehouses are presented. The rest of the thesis includes description and analysis of the Star-miner algorithm, design, implementation and testing of the application.
|
|
Business Intelligence as Data Analysis Tool for Controlling the Company
Novák, Ondřej ; Hajn, Pavel (referee) ; Kříž, Jiří (advisor)
Designing and creating the finished OLAP solutions within Business Intelligence for an undertaking by the customer's requirements using standard technologies and practices that are designed for this purpose. This work describes the work of the design, creation and deployment of the finished project Business Intelligence solution that allows the customer to perform more accurate analysis of their own data in the context of controlling.
|
|
Analysis and Design Business Intelligence solutions for ATOZ group
Machaj, Maroš ; Pour, Jan (advisor) ; Horníček, Martin (referee)
The main objective of this work will be the analysis of BI solution for this company, which deals with the publication of professional journals and the organization of conferences. BI solution should be used by company management. In order to achieve the objective of this work it was necessary to contact the company with IT professionals and employees who have access to the IS company. It was also necessary to consult the requirements for BI solutions for a company with a higher-ranking employees of the company. Thanks to these consultations it was possible to create the skeleton for the analysis of the company and on these grounds the new key indicators were created. To these indicators then new dimensions were added as well. The practical part consists of two parts, namely the analysis of a specific BI solution for the company. The work will include a small sample of BI solution for BI benefits. This solution includes designing the data warehouse, ETL and pilot solution. The contribution of this work is to design BI for publishing (advertising) company. The company is quite specific, so another company for which it would be suitable as well, is difficult to find.
|
|
Business Intelligence v prostředí informačního systému QI
Blažek, Tomáš
This work provides a survey of creation of the Business Intelligence by using QI information system data. The work concisely describes Business intelligence functions and its user's environment. QI system and the way of data storage are also defined in this dissertation. The following chapters describe the design and implementation of Business Intelligence itself over the actions made by registered employees. The proposal describes the design of a data storage system, a method of obtaining the necessary data from the QI information system, ETL process design, OLAP cubes design, and how to interpret the information in the form of reports. The last chapter then describes the realisation of all the proposed districts in MS SQL Server.
|
|
Applying Business Intelligence tools for the Financial and Property Analysis of Municipalities
Horký, Martin Bc. ; Novotný, Ota (advisor) ; Ing. Petr Toth, Ph.D. (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.
|
|
Business Intelligence in MS Dynamics AX 2009
Hubáček, Filip ; Pour, Jan (advisor) ; Derfler, Václav (referee)
The subject of the diploma thesis entitled "Business Intelligence in Microsoft Dynamics AX" is to analyze the functionality of the ERP system Microsoft Dynamics AX 2009 in the area of Business Intelligence and Reporting with the reflection of the current market position of the company. The goal is to set the basic definition of the relationship between ERP and Business Intelligence systems, further defining the possibilities of MS Dynamics AX in BI in the terms of their practical use and also to describe the fundamental technological aspects. The aim of the work is evaluation and definition particular steps during implementation based on methodology MS Sure Step 2010 together with description of deployment process. As a reflection of insufficient coverage of some of the areas is mentioned solution of the company Circon Circle Consulting. Also is realized proposal for BI for AX cost accounting module, including designing data mart, ETL and report with respect to specifics, such as the parent-child hierarchies and many-to-many relationship between fact tables and dimensions. The contribution of this work is mainly evident for the consultants of the system, to who is provided insight into the important and for users attractive functionality and also is offered possible implementation process. Technically oriented readers may appreciate the solutions for Cost Accounting and potential approaches to the concept of data mart or other areas where they meet the above-mentioned aspects.
|
|
Application of BI in system for skill increasing
Laušman, Jakub ; Novotný, Ota (advisor) ; Svoboda, Zdeněk (referee)
This Diploma thesis deals with the analysis and proposal of the pilot BI solution for the company Svoboda & Partner CZ s.r.o., engaged in the automechanic expertise. Fundamental objectives of this work focus particularly on the above mentioned pilot BI solutions and partial objectives deal with an analysis of the company and its needs, arising from business strategy and market analysis applications available to support the visualization of transaction reporting. These objectives have been achieved by analyzing the company's business model in chapter seven, further analysis of needs and problems within the company in chapter eight. Before the analysis, the diploma thesis deals with a survey of available applications that offer functionality of dynamically generated graphs to aid visualization of transaction reporting in chapter six and finally a major analysis and preparation of pilot BI and transaction reporting for this business which you can find from chapter 9 to chapter eleven. Contribution of this work for the company will be a complete analysis and delivery of all necessary documents in order to decide whether the above BI solutions to the company implement or not. In the case of a positive decision of the company, it is expected that thanks to BI solutions the ways of looking at corporate data can be more expanded, more precise and more operational management of the company, achieving better performance, higher profits and more efficient decision-making based on better data for decision making.
|
|
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.
|
|
Corporate reporting on platform MS SQL Server
Štěrba, Ladislav ; Pitka, Lukáš (advisor) ; Adámek, Karel (referee)
The thesis dicusses the business reporting using the Microsoft SQL Server 2008 R2 platform. The first part examine the technical aspects of the problem and studies the Integration Services, Reporting Services and Analysis Services applications as well as the possibilities of their integration with other business information systems. The second part analyses the possibilities of using the Microsoft's Business Intelligence by a business establishement and its gainings. It also presents several practical examples of application.
|
|
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.
|