|
|
Methodology for solving an BI analytical tasks
Žebrák, Miroslav ; Pour, Jan (advisor) ; Jakoubek, Jiří (referee)
The thesis focuses mainly on OLAP technology and its tools using to analyze corporate data. One of the objectives is to define the analytical tools market and provide an overview which shows the current situation concerning those tools on Business Intelligence (BI) market. Another objective is to obtain an overview of some current and future trends in the BI market. The main purpose of the thesis is to create a "methodology" for solving an BI analytical tasks using analytical services in SQL Server 2008 R2 from Microsoft. To achieve these objectives a theoretical analysis of available resources and, in particular consultation with employees of Clever Decision company is used. The main contribution of this work is the development of analytical database itself, which is divided into separate phases where each phase contains best practices and recommendations, including examples.
|
|
|
Design and implementation of metrics for campaign management in telecommunications
Rakár, Peter ; Novotný, Ota (advisor) ; Šimáček, Martin (referee)
Diploma thesis is focused on the evaluation of marketing campaigns which are realized in the environment of telecommunication companies. The thesis' main goal is the identification, analysis and design of metrics and dimensions which can be used for evaluation of marketing campaigns benefits, and which can provide feedback in the process of new campaign definition. The solution offered in the thesis provides a tool for more effective and more reliable analysis of marketing campaigns. The analysis of the current evaluation process and a suggestion of the process modification is also part of the proposed solution. The first part of thesis explains the relation between marketing, marketing campaigns and process of campaigns evaluation. The theoretical knowledge necessary in campaign evaluation is examined. The next chapter is focused on the characteristics of the telecommunication company which affect the way how campaigns are evaluated. The introduction of the thesis' practical part identifies the metrics actually used, where the knowledge of employees is imposed. Metrics are analyzed in the third chapter. The output of the analysis is used to design an automatized solution which generates the OLAP cube and reports for campaign evaluation. The functionality and suitability of the solution is verified by the implementation of a pilot solution with an example of reports on model campaign. The thesis' last part is supplemented with an analysis of the current evaluation process in the given telecommunication company, and suggestion of process modifications, there where the designed solution is utilized.
|
|
|
Implementation of BI in car sales and servicing
Gottwald, Karel ; Novotný, Ota (advisor) ; Maryška, Miloš (referee)
Diploma thesis focuses on topic of business performance management realized through Business Intelligence application created on the basis of a balanced set of indicators within the Balanced Scorecard method. The first part introduces the reader with theoretical foundations. First, it describes the basic principles of the BSC method and meaning of dividing strategic objectives into four perspectives. Subsequently, it introduces the heart of BI - a multidimensional approach, displays the BI architecture and defines its components. At the end it compares the types of database systems. There is also a comparison of this thesis with other projects dealing with similar themes in the theoretical part. After the theoretical chapters comes a practical part which aims at design and development of BI applications for a real company so as to comply with the requirements of top managers and the corporate strategy. At the beginning it introduces a firm to which the project is applied. This is an existing organization operating in the area of car sales and services. The corporation is called under a fictitious name "AUTO a.s." in this thesis. In cooperation with its managers the SWOT analysis and strategic objectives is defined. This determines the key requirements for setting up the BI application. An example of a BI solution that allows managers to effectively monitor the development objectives, brings the main benefit of the whole work. For this purpose is built data warehouse, which is then filled with transformed data from source systems using Data Pump. Then, above the Data Warehouse, two OLAP cubes can be created. Presentation layer, created in MS Excel 2007, handles the interpretation of the results to end-users.
|
|
|
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.
|
|
|
Reference management model for managing business informatics economics
Maryška, Miloš ; Novotný, Ota (advisor) ; Král, Bohumil (referee) ; Smolíková, Eva (referee)
Thesis is focused on management of business informatics. The aim of this thesis is to develop Reference management model for managing business informatics and to integrate this reference model into ITGPM Reference management model for managing business informatics. Within an analytical part is reviewed current situation in the field of managing economics of business informatics as well as managing economics out of business informatics. Attention is paid to costs in busi-ness informatics, their classification, categorisation and their management. Very important part is analysis of methods for cost management thought various types of calculations and especially thought ABC methods. The principles of these methods are applied in the design of the Reference model. Further are solved questions of business informatics effect, their categorisations, classification, definition of their attributes and also their management. Development of this field is an important part of this thesis. The main part of the thesis contains the Business informatics management Reference model design. This design contains identification of the most important metrics of measuring business informatics, dimen-sions used for analysis of proposed metrics and relationships between metrics and dimensions. An impor-tant part is also a presentation level design and definition of condition that should be fulfilled, if the pres-entation level should be beneficial to final users. The main part also contains designed method for imple-mentation of the Reference model into a company. Application parts are devoted to preparation of a pilot application based on the Reference model design developed in the main part of the thesis. Designed Reference model for managing business informatics is adapted according to the needs, requests and characteristics of the company in which this pilot application is implemented. In these parts are also verified designs, processes and methods designed in the first and second part of this thesis, so there are verified possibilities of adaption of the designed model to the requests of the target company, adaption of the pilot application to the target environment including data level, ELT procedures and presentation level. In application part of the thesis is verified correctness of the designed implantation methodology into the company.
|
|
| |
|
|
Implementace BI ve firmě Haguess a.s.
Bendák, Martin ; Novotný, Ota (advisor) ; Bláha, Jiří (referee)
The subject of this thesis is a pilot project of the implementation of the BI (Business Intelligence) solution in the company Haguess, a. s. The project is concerned with the analyses of data stored in a database -- DataBase Management System (DBMS) -- which is used as a data source by the web application Customer Support Center (CSC). Haguess primarily uses CSC as a helpdesk for its clients and partners, but also uses it for internal purposes. The main use of the CSC application is to support information systems delivered by Haguess. There were two motives for the choice of this subject: BI software tools had not previously been used by Haguess, and the company management was keen to get data analyses from the CSC application. That's why I decided to do these analyses. My goal was to create a practically useful solution which would be an incentive for Haguess to use BI software tools for other purposes. This thesis has two main goals. The first one is the realisation of the pilot BI solution, which would outline the possibilities for analysis of data from the CSC application using BI software tools. This involved the following activities: multidimensional analysis and BI solution design -- i.e. design of data pipelines, OLAP (On-Line Analytical Processing) cube/cubes, and user tools in MS Excel calculator. The second goal was to select the proper software tools for a future complex realisation and running of the BI solution. The first objective was achieved by doing the following: proper analysis of the CSC application data model, definition of user requests for output analysis and its comparison with the data model analysis. Based on this comparison, the basic subjects of output analyses were determined. These basic subjects were the starting point for the implementation of the BI solution. The second objective was achieved as follows: on the basis of the implementation results, basic demands (criteria) for BI software tools features were determined, bearing in mind the possible future complex realisation and running of a BI solution. Research determined which BI software tools were available on the market. The most suitable BI software tool was selected following a comparison of available options, and the criteria mentioned above. The primary outcome of this thesis is the creation of a practically usable BI solution.
|
|
|
Nonlinear Physics and Chaos Theory
NÁHLÍK, Tomáš
This thesis deals with nonlinear physics and chaos theory from its begining, through the main people to its application in various fields. This work has also part of fractals and fractal geometry. There are also source codes of various examples.
|
|
|
Measuring operation processes of IS for petrol stations
Šebelík, Jan ; Novotný, Ota (advisor) ; Ďásek, Pavel (referee)
The thesis concerns with measurement of processes of support and maintenance of a specialized information system for petrol stations. It is a system for support of retail sale of fuel and other non-fuel goods. As the main objective of the thesis was selected design of set of metrics for measurement of these processes based on multidimensionality principle. It means that dimensions and indicators are designed separately and a set of recommended metrics is based on their combinations. It is possible to get additional metrics using other combinations. The theoretical basis of the thesis is the ITIL library -- which is an internationally respected standard for IT service management -- and metrics designed in other literature and diploma theses. The designed metrics are adapted for the analyzed environment and service information system, however, they should be usable in other environments as well. Selected metrics were implemented to the service information system and measured in a relatively wide sample of input data. This allowed evaluating usability of the metrics and comparison of the threshold values with the measured ones. The relationship of metrics and service agreements (SLAs) is described in the end of the thesis. Specific metrics suitable to be incorporated to SLA were designed including a real-life example.
|
|
| |
guest ::
