|
|
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).
|
|
|
Analýza registra zmlúv
Kuciaková, Andrea
The thesis describes the creation of the acquisition and analysis of data from the public register of contracts and other defined sources. In the introduction there are described the existing variants of scrapping tools and their use, as well as the problems of Business Intelligence and data warehouses. The next section is devoted to identifying source data. Subsequently, the procedure and design of the solution are described, on which basis was designed the data warehouse. Implementation of ETL processes and creation of final reports are mentioned in the implementation part.
|
|
|
Application of OLAP in an e-Shop
Lysý, Jan ; Dolíhal, Luděk (referee) ; Jirák, Ota (advisor)
The aim of this thesis is to design an e-shop that uses OLAP database. Multidimensional scheme was assembled for the database. Using Business Intelligence tool that is part of SQL Server 2008 Enterprise the database was realized according to the scheme. Data from the OLAP system are accessible through administrator interface implemented with ASP.NET in the form of graph or table.
|
|
|
The planning applications in Business Intelligence
Rusnák, Petr ; Pour, Jan (advisor) ; Zajíc, Ján (referee)
The main goal of this thesis is to create a manual for planning application named Targetty appropriately so, for the academical purposes used at University of Economics, Prague and also to create a demo of this application for Vetrotech company. The goal is fulfilled through detailed analysis of the application and by describing its functionality via screenshots of the application and their description. The app demo is created on data model which was suggested for this purpose. This thesis can be divided into three main parts. The first part considers the issue of the enterprise planning by both the economical and the Business Intelligence points of view. The planning principles are demonstrated via examples and explained into detail. The second part is dedicated to analysis of the planning application called Targetty and in the last one a demo of application for Vetrotech company is created. This thesis proves that the planning application Targetty is a suitable application for small or medium companies. It also contains an application demo for Vetrotech company based on data model which may be used for creating a solution for any companies specializing in commercial industry.
|
|
|
The implementation of Business Intelligence in a raw materials trading company
Hanák, Ondřej ; Novotný, Ota (advisor) ; Maryška, Miloš (referee)
This diploma thesis is focused on an implementation of a Business Intelligence (BI) in a raw materials trading company, which trades brown coal. At first, a Balanced Scorecard analysis is made in this trading company. Then results of this analysis are used for the implementation of the BI. The first chapter of this thesis describes goals, methods and structure of the thesis. The second chapter contains information about those theses, which have similar topics as my thesis. Next chapters are theoretical part of the thesis. The third chapter describes the Business Intelligence and the fourth chapter describes the Balanced Scorecard. The fifth chapter is a theoretical-practical chapter and describes the company and the brown coal market. Practical part starts on the chapter six, which describes the use of the Balanced Scorecard in the given company. Next chapter uses the outputs of the chapter six and in a chapter seven there is an implementation of the BI. The eighth chapter describes reports of the BI and the ninth chapter contains conclusion and an evaluation of achieving the goals set by this thesis. Main contribution of this thesis is in the demonstration of design and implementation of the BI in a raw materials trading company.
|
|
|
Practical Use of Data Mining Technologies
Uhlíř, Radek ; Pour, Jan (advisor) ; Zajíc, Ján (referee)
This bachelor's thesis maps available technologies of extracting knowledge from the raw data. These methods are globally known as Data Mining. Some of these methods are implemented in the second part - proof of concept of Data mining support in sales department. The aim of this work is to identify and implement suitable technologies for answering analytical questions and getting knowledge from data owned by business companies. It should help to improve and optimize business processes and resource utilization. Customer segmentation support and association rules identification are also expected. In the second part are identified possible weaknesses and problems during the process of implementation and deployment of these systems. The work should propose optimal methods of solving these problems or at least modifications in process of implementation to eliminate some vulnerability. The work is divided into two parts -- first is theoretical and maps available methods and second part is about implementation of project in pharmaceutical company. This solution was built using Microsoft SQL Server platform.
|
guest ::
