|
|
Analysis of Public Data of the Czech Statistical Office
Pohl, Ondřej ; Burget, Radek (referee) ; Bartík, Vladimír (advisor)
The aim of this thesis is analysis of data of the Czech Statistical Office concerning foreign trade. At first, reader familiarize with Business Intelligence and data warehousing. Further, OLAP analysis and data mining basics are explained. In next parts the thesis deal with describing and analysis of data of foreign trade by the help of OLAP technology and data mining in MS SQL Server including selected analytical tasks implementation.
|
|
|
Utilization of Data Mining for Personnel Agency
Ondruš, Erik ; Janata, Michal (referee) ; Luhan, Jan (advisor)
This master’s thesis will look into the use of data mining in the area of segmentation and the prediction of onboarding candidates of a recruitment agency. The obtained results should serve to make company processes more effective concerning the processing of orders, and should also facilitate a more personal approach to candidates. The first chapter includes imperetive theoretical bases from the studies of Business Intelligence, data warehouses, data mining and marketing. Thereafter an analysis of the current state is presented with a focus on the capture of the key processes in processing and order. The last chapter looks at the proposed solution and implementation on the platform Microsoft SQL Server 2014. To conclude there are proposals of utilizing data mining in direct marketing.
|
|
|
Knowledge Discovery over Data Warehouses
Pumprla, Ondřej ; Chmelař, Petr (referee) ; Stryka, Lukáš (advisor)
This Master's thesis deals with the principles of the data mining process, especially with the mining of association rules. The theoretical apparatus of general description and principles of the data warehouse creation is set. On the basis of this theoretical knowledge, the application for the association rules mining is implemented. The application requires the data in the transactional form or the multidimensional data organized in the Star schema. The implemented algorithms for finding of the frequent patterns are Apriori and FP-tree. The system allows the variant setting of parameters for mining process. Also, the validation tests and efficiency proofs were accomplished. From the point of view of the association rules searching support, the resultant application is more applicable and robust than the existing compared systems SAS Miner and Oracle Data Miner.
|
|
|
Use of Agile Methodologies in the Data Warehouse Design
Janečka, Pavel ; Kreslíková, Jitka (referee) ; Bartík, Vladimír (advisor)
Scope of this master’s thesis contains agile data warehouse design. It begins with a brief demonstration of data warehouse issues, shows the architectures dimensional data warehouse, corporate information factory and data vault. Furthermore, the thesis introduces agile methodologies suitable for data warehouses. Main part of this thesis focuses on the data warehouse design and development in Kentico Software s.r.o. using the modelstorming, shows implementation of universal ETL process for loading dimensional data warehouse, designs ETL processes, data warehouse storage and presentation layer. In the end, the thesis discusses future extensions to the data warehouse such as knowledge discovery module or large-scale data expansion.
|
|
|
Client for Displaying OLAP Cubes
Zahradník, Jan ; Stryka, Lukáš (referee) ; Bartík, Vladimír (advisor)
The purpose of this work is in analytical tool supporting manager decision making. The goal was to develop a reporting system which simplifies company customer's orientation in key performance indicators. As implementation environment has been used .NET Framework 3.5 with C\# language and database server Microsoft SQL 2008 with Analysis Services extension, for web interface has been used ASP.NET.
|
|
|
ALVAO Service Desk Data Analysis and Reporting
Václavík, Marek ; Novák, Lukáš (referee) ; Kříž, Jiří (advisor)
The diploma thesis focuses on the analysis of the current state of reporting and data analysis of the ALVAO Service Desk system in the company's internal operation. Based on the findings of deficiencies, a new method of reporting and data analysis on the Microsoft Power BI platform is proposed. The proposal includes the entire Power BI feature cycle from data accessing to sharing.
|
|
|
Client for Displaying OLAP Cubes
Podsedník, Lukáš ; Kupčík, Jan (referee) ; Bartík, Vladimír (advisor)
At the beginning, the project describes basics and utilization of data warehousing and OLAP techniques and operations used within the data warehouses. Then follows a description of one of the commercial OLAP client - based on the features of this product the requirement analysis of the freeware OLAP cube client displayer is desribed - choosing the functionality to be implemented in the client. Using the requirement analysis the structural design of the application (including UML diagrams) is made. The best solution from compared libraries, frameworks and development environments is chosen for the design. Next chapter is about implementation and tools and frameworks used in implemetation. At the end the thesis clasifies the reached results and options for further improvement.
|
|
|
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.
|
|
|
Model of Cycling Traffic Intensity in Brno
Eliáš, Radoslav ; Burget, Radek (referee) ; Hynek, Jiří (advisor)
Oddelenie dát v Brne má prístup k viacerým dátovým sadám o počtoch cyklistov. Cieľom práce bolo vytvoriť model integrujúci tieto zdroje pre odbor dopravy magistrátu mesta, aby získali prehľad o tom, ako sa infraštruktúra denne využíva. Každý súbor údajov je agregovaný na inú základnú mapu s mierne odlišnou sieťou ulíc. Táto práca predstavuje algoritmický prístup k porovnávaniu ulíc na základe podobnosti, percentuálneho prekrytia a dalších parametrov. Poskytnuté sú dva algoritmy na porovnávanie geometrie založenej na bodoch a úseckách geometrie. Rovnako aj model priraďujúci lokácie medzi rôznymi dátovými sadami a informačný panel vizualizujúci hodnoty z nich vedľa seba. Robustnosť algoritmov umožnuje ich použitie v akejkoľvek geografickej aplikácii využívajúcej priestorové údaje. Informačný panel poskytuje užitocné informácie o cyklistickej doprave pre bežných používatelov aj odborníkov, ktorí navrhujú infraštruktúru mesta Brna.
|
|
|
Data Warehouse Design for Specific Subject
Paraska, Mikuláš ; Špatenka, Jan (referee) ; Luhan, Jan (advisor)
The subject of the bachelor thesis is to design and create a data warehouse for a startup operating in the gaming industry. The data warehouse will be designed for a newly developed mobile game. The main parts of the thesis include both theoretical and practical design of the data warehouse according to specific company requirements. Its functionality will be subsequently tested using reporting and visualization tools.
|
guest ::
