|
|
Risk Behaviour of ETL Processes in a Data Warehouse
Košinová, Kateřina ; Očenášek, Pavel (referee) ; Bartík, Vladimír (advisor)
This thesis is about hazardous of ETL processes in their data warehouse. In the first part of this thesis I have defined the ETL processes and the aim of this thesis. The second part is about theoretical solutions needed to create a data warehouse, the definition of ETL processes and discovering potential risks. The third part is about discovering potential risks of ETL processes using an analysis and risk assessment. This part also includes a control of the potential risks. The fourth part concentrates on modifying the ETL processes to prevent potential risks. An important part of this chapter is an emergency plan containing necessary processes which must be applied in case of a risk. The fifth part of this thesis is a summary of all knowledge found during the analysis and development.
|
|
|
Comparison of functionality of the standard BI platform and BI module integrated in the ERP system
Fargačová, Tamara ; Klčová, Hana (referee) ; Sodomka, Petr (advisor)
This master’s thesis deals with comparison of the standard Business Intelligence platform specifically IBM Cognos BI and BI module integrated in the ERP system QI. In the first part it defines basic concepts of this topic and describes the life cycle of business information systems with emphasis on Business Intelligence. In the next part current situation on the market of these platforms and BI tools which create management information systems is described. Both types of BI solutions are compared with concentration on standard functionality usage. It also describes their ability to analyze through using data warehouse technology, integration with third-party products and business and economic aspects.
|
|
|
Information System Design
Nečas, Jan ; Voznica, Martin (referee) ; Koch, Miloš (advisor)
The aim of this bachelor’s thesis is to design a partial segment of information system in in faculty hospital Brno, that will monitor how many patients come to ambulances and the movement of hospitalized patients trough out the whole organization.
|
|
|
Management of Information Flow of Small Software Company
Klimeš, Jiří ; Martoch, Zbyšek (referee) ; Kříž, Jiří (advisor)
This diploma thesis deals with the management of information flow of a small company using Business Intelligence tools and the data mart. There is defined the problem of working with information from the point of view of selected company in the first part. The next part presents selected theoretical background on the basis of which was the aim achieved. The fourth part analyses the current situation of the company. There is recommended complex improvement of the current situation in the practical part. Selected information management problem is accomplished factually. There are also introduced suitable software tools, which were used for the solution.
|
|
| |
|
|
Automation of ordering system errors
Bažant, Milan ; Stojanov, Marek (referee) ; Kříž, Jiří (advisor)
The bachelor thesis focuses on the creation of the automatic error cleansing software which clears the errors generated by the ordering system. Based on the error analysis (e.g. their causes and possibilities of their correction) the software enables the automatic error correction without the necessity of any manual action resulting in minimal delay of customers’ orders.
|
|
|
INTEGRATED SOLUTION OF DIAGNOSTICS OF PRODUCTION EQUIPMENT IN THE CZECH ENERGY INDUSTRY
Cvešpr, Pavel ; Szabó,, Radek (referee) ; Kratochvíl, Petr (referee) ; Hammer, Miloš (advisor)
This dissertation thesis is concerned with the diagnostics of the main production facilities in Czech power engineering with a focus on its integrating role in the process of gaining, saving and processing information for the purpose of evaluating the technical state of the operated facilities and the plan to manage their lifetime. It is divided into two parts, theoretical and practical. The theoretical part presents the conclusions of examination of the needs of involved workers in the areas of diagnostics, maintenance and expert assessment of technical state of equipment. These conclusions were formulated based on the completed analysis of the current status ("as - is" analysis) of performing diagnostics of systems operated in the technological units of both nuclear and classical power engineering. The monitored equipment involves electrical installations and machinery, steel and building constructions, measuring instruments and vibrodiagnostics. Based on the analysis results, process diagrams are created for the solution of partial tasks. The analysis of the proposed solution for problems in question ("should - be" analysis) includes a design of the fundamental scheme of the data model for a software solution and a design of data flows from the individual data sources. The following part presents an application layer which includes a detailed description of major functionalities. Further, important activities and procedures are described that are necessary to evaluate the technical state of equipment. The practical part deals with the implementation of the LTO suite software product in the environment of power engineering in Czech Republic, specifically within ČEZ, a.s.. The LTO suite functionality is demonstrated in this part of the thesis by screens recorded within the LTO suite individual modules, which work above the actual data. It starts with the initial screen for configuration of displayed data, continues to present examples of the equipment register, planning, processing and saving of information collected through the diagnostic activities over to the module of integration – analytical layer, which is designed for evaluation of the technical state of equipment at the entered date with a reporting output. The thesis also includes the chapters on "Aims of the Study" and "Conclusion". The key chapter presents the "Benefits of the Study", whose overview describes the original results of the research as well as those applicable also outside the power engineering area.
|
|
|
Data Mining for Suggesting Further Actions
Veselovský, Martin ; Burget, Radek (referee) ; Bartík, Vladimír (advisor)
Knowledge discovery from databases is a complex issue involving integration, data preparation, data mining using machine learning methods and visualization of results. The thesis deals with the whole process of knowledge discovery, especially with the issue of data warehousing, where it offers the design and implementation of a specific data warehouse for the company ROI Hunter, a.s. In the field of data mining, the work focuses on the classification and forecasting of the advertising data available from the prepared data warehouse and, in particular, on the decision tree classification. When predicting the development of new ads, emphasis is put on the rationale for the prediction as well as the proposal to adjust the ad settings so that the prediction ends positively and, with a certain likelihood, the ads actually get better results.
|
|
|
Implementation of the CMIS protocol for the Kentico CMS Data Warehouse
Počatko, Boris ; Jirák, Ota (referee) ; Ruttkay, Ladislav (advisor)
This thesis is dealing with the CMIS standard, which should provide a common management approach to every CMS data repository which supports this technology. There are services, data types and the form of the data logging of the mentioned stanadard described. The paper also presents tools which are neccessary for completing the task in the .NET environment. It deals also with the CMS data repository of the system, on which is the CMIS standard implemented. Implementational details are described in the second half of the thesis.
|
|
|
Modern Technologies in OLAP
Janoška, Daniel ; Kužela, Alois (referee) ; Hruška, Tomáš (advisor)
OLAP systems are sought-after tool which are deployed in companies and industry environment. The fundamental task of these systems are support of executive management. This work is dealing with OLAP analysis and its capabilities. It also discussed FLEX and AIR technology, their base principles and functions.
|
guest ::
