|
|
Design and Implementation of an OLAP Data Cube
Hurdálek, Pavel ; Smejkal, Milan (referee) ; Hruška, Tomáš (advisor)
This diploma thesis deals with the creation of a data OLAP cube for the purpose of analyzing big data. The process is shown when creating a cube containing data from the university's admissions process (specifically Brno University of Technology). The data is processed by the commercial tool Business Warehouse from the German company SAP, the cube visualization itself takes place in the program Excel using the Analysis extension. The result of this work is an OLAP cube, which can be used to create analyses of the university's admission procedure and obtain data to fill in the relevant section of the annual activity report.
|
|
|
Information System for Management of Company Employees
Sklenář, Pavel ; Křivka, Zbyněk (referee) ; Bartík, Vladimír (advisor)
Purpose of this thesis is to help companies in terms of managing their own employees including analysis of employees shifts using OLAP, thanks to OLAP analysis companies can find out for example total delays on employees shifts. Information system is created as a web application implemented in PHP using the Laravel framework with MySQL database. Information system functionalities are: employees management, including management of employees attendances, Google Drive management, generating various files in PDF format, viewing various statistics, employees ratings, shifts management, vacations management, diseases management, employees languages management, reports management, injuries management.
|
|
|
Rozšíření analytické vrstvy s využitím nástrojů firmy Microsoft
Ščudla, Petr
Thesis deals with the realization of complex Business Intelligence (BI) solution, which is an extension of current analytical layer of the company and also includes implementation of data warehouse, data cubes and report. The introductory part of the thesis describes theory of BI problematics, usage of data warehouse in Customer Realationship Management (CRM) and data-driven marketing. Later part describes specification of requirements, analysis of the current state of the company and own work. Microsoft tools and technologies were used for development of the solution.
|
|
|
Možnosti analytických nástrojů v prostředí MS SQL Serveru
Mazáčová, Markéta
The thesis compares the development time and performance of two types of Microsoft analytical models created in Visual Studio that are deployed on the local analytics servers and the Azure cloud server. Theoretical research will be summarizing business intelligence and data warehouses components, Microsoft tools for business intelligence realization and features using in-memory database technologies. The practical part introduces the AdventureWorks demonstration database,describes the implementation of both analytical models and compares both models with respect to the time-consuming development, performance and suitability of deployment.
|
|
|
Framework pro generování demo dat do OLAP datových kostek
Dubšík, Lukáš
This thesis deals with implementation of a new framework, which allows to define and generate demo data for the star schema structure. Work analyses and com-pares available demo data generators. In theoretical part of the thesis, there are described concepts and technologies using in the field of Business Intelligence. Practical part deals with the design and implementation of the framework. In the final section, there are actual examples of generated data and their possible rep-resentation (samples of possible reports and dashboards).
|
|
|
Realizace datového skladu pro analýzu závad železničních vozidel
Richter, Jan
This thesis follows up the creation of data warehouse on Microsoft SQL Server for analysis of measured railway vehicle transits, with provided weather data by Dark Sky service. Thesis represents full data warehouse design (by Kimball Group model) with ETL processes to secure data initialization and automatic updates. Thesis also shows two approaches to presentation layer on data warehouse, by Microsoft Excel (linked to multidimensional cube) and by Power BI.
|
|
|
Application for Displaying OLAP Data Cubes
Kiss, Tomáš ; Burget, Radek (referee) ; Bartík, Vladimír (advisor)
The main aim of this thesis is to provide information about the basic issues of data warehouses, data cubes and OLAP analysis. Furthermore, in the theoretical part is introduced the stage of data preprocessing and its elementary parts performed before their insertion in to data warehouses. Additionally, there are listed the basic types of OLAP operations and the possible ways of displaying data cubes. Acquired information is used to create application for displaying OLAP data cubes in suitable format.
|
|
|
Integration of Business Intelligence Tools into IS
Novák, Josef ; Bartík, Vladimír (referee) ; Stryka, Lukáš (advisor)
This Master's Thesis deals with the integration of Business Intelligence tools into an information system. There are concepts of BI, data warehouses, the OLAP analysis introduced as well as the knowledge discovery from databases, especially the association rule mining. In the chapters focused on practical part of the thesis, the design and implementation of resultant application are depicted. There are also the applied technologies like i.e. Microsoft SQL Server 2005 described.
|
|
|
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.
|
|
|
Information System for Energetic Consultant Service
David, Lukáš ; Šebek, Michal (referee) ; Burget, Radek (advisor)
This bachelor thesis deals with the information system design for the BV Consulting company. The thesis presents the principles of the company functioning including all the internal regulations that are important for the system design. The thesis describes the requirements on the system, system design based on these requirements and its implementation. The main function of system is providing an interface for administration and registration of employees, their contracts and reports. The implementation is based on Microsoft Office Access and ASP.NET.
|
guest ::
