|
|
Business Intelligence trends
Meloun, Jaroslav ; Kerol, Valeria (advisor) ; Novotný, Ota (referee)
The main goal and contribution of this Bachelor thesis is to analyse and compare Business Intelligence (BI) solutions according to the actual trends in order to help a potential customer to select a suitable BI solution. Firstly, the minor goals are achieved: the basic theoretical knowledge about BI (definition of BI, a general architecture and components of BI) is provided to a reader, actual BI trends are identified and a current BI market is analysed. Next, the criteria are set and the analysis and the comparison of selected BI solutions are performed. Finally, there is a final evaluation in the form of tables. Also, strengths and weaknesses of each analysed solution are identified based on the performed analysis and the comparison.
|
|
|
Corporate Performance Measurement
Pavlová, Petra ; Novotný, Ota (advisor) ; Krejčí, Jiří (referee)
This thesis deals with the application of Business Intelligence (BI) to support the corporate performance management in ISS Europe, spol. s r. o. This company provides licences and implements original software products as well as third-party software products. First, an analysis is conducted in the given company, which then serves as basis for the implementation of the BI solution that should be interconnected with the company strategies. The main goal is the implementation of a pilot BI solution to aid the monitoring and optimisation of corporate performance. Among secondary goals are the analysis of related concepts, business strategy analysis, strategic goals and systems identification and the proposition and implementation of a pilot BI solution. In its theoretical part, this thesis focuses on the analysis of concepts related to corporate performance and BI implementations and shortly describes the company together with its business strategy. The following practical part is based on the theoretical findings. An analysis of the company is carried out using the Balanced Scorecard (BSC) methodology, the result of which is depicted in a strategic map. This methodology is then supplemented by the Activity Based Costing (ABC) analytical method, which divides expenses according to assets. The results are informational data about which expenses are linked to handling individual developmental, implementational and operational demands for particular contracts. This is followed by an original proposition and the implementation of a BI solution which includes the creation of a Data Warehouse (DWH), designing Extract Transform and Load (ETL) and Online Analytical Processing (OLAP) systems and generating sample reports. The main contribution of this thesis is in providing the company management with an analysis of company data using a multidimensional perspective which can be used as basis for prompt and correct decision-making, realistic planning and performance and product optimisation.
|
|
|
Design of methodology for BI solutions testing
Jakubičková, Nela ; Pour, Jan (advisor) ; Zajíc, Ján (referee)
This thesis deals with Business Intelligence and its testing. It seeks to highlight the differences from the classical software testing and finally design a methodology for BI solutions testing that could be used in practice on real projects of BI companies. The aim of thesis is to design a methodology for BI solutions testing based on theoretical knowledge of Business Intelligence and software testing with an emphasis on the specific BI characteristics and requirements and also in accordance with Clever Decision's requirements and test it in practice on a real project in this company. The paper is written up on the basis of studying literature in the field of Business Intelligence and software testing from Czech and foreign sources as well as on the recommendations and experience of Clever Decision's employees. It is one of the few if not the first sources dealing with methodology for BI solutions testing in the Czech language. This work could also serve as a basis for more comprehensive methodologies of BI solutions testing. The thesis can be divided into theoretical and practical part. The theoretical part tries to explain the purpose of Business Intelligence use in enterprises. It elucidates particular components of the BI solution, then the actual software testing, various types of tests, with emphasis on the differences and specificities of Business Intelligence. The theoretical part is followed by designed methodology for BI solutions using a generic model for the BI/DW solution testing. The practical part's highlight is the description of real BI project testing in Clever Decision according to the designed methodology.
|
|
|
Principles of function and the possibility of BI in small and medium enterprises
Tříska, Aleš ; Pour, Jan (advisor) ; Plach, Marek (referee)
Business intelligence is an effort to better understanding of company processes and business consequences in which company occur. The main goal of this thesis is to characterize the principles and possibilities of implementation and application Business intelligence in small or medium enterprise. This goal should be achieved by description of general needs which small or medium enterprise, looking forward to use business intelligence, has. This includes evaluation and universal description of information technologies in small and medium enterprises, as well as what data are used for managerial decisions and how are they made. In order to implement BI into the small or medium enterprise, it is necessary to imply how the Business intelligence work and on what principles. The application part of this thesis describes real procedures in preparation of BI implementation, impact on company and evaluation of the meaningfulness of this solution.
|
|
|
Methodology of solving analytical tasks in BI
Masagutov, Dmitry ; Pour, Jan (advisor) ; Zajíc, Ján (referee)
All big and important decisions come through analysis. The main aim of the analysis is to examine or investigate more complicated problems by decomposing them into simpler ones whereas we come to certain conclusions on the basis of a detailed recognition of particularities. This diploma thesis is dedicated to analytic tasks solving techniques in Business Intelligence which would describe and support the whole process of analysis, its needs and premises in real surrounding environment. During the project I cooperated with Clever Decision company and took part in the real project. This company deals with Business Intelligence solutions/applications development and this project is meant to set the method of how to treat the development of the solutions. My work consists in designing a template of BI analysis method which is a part of a complex technique. The aim of this diploma thesis is to introduce my own method of Business Intelligence solution analysis, to introduce its basic components and common work instructions for this method. I reached my aim by analyzing documents and reports provided by Clever Decision company and other methods and suggestions. The main contribution of my diploma thesis is that the method works as a draft for assistance and standardizing the process of Business Intelligence solution analysis in Clever Decision company. This draft can nevertheless work as a basis for creating a wholly new method. My work consists of three parts. The first part, a theoretical one, deals with recapitulation of basic terms and methods I worked with. The second part represents properties, components and general working instructions for this method. It moreover presents main outputs, more precisely documents that are practical attachments to the method itself. The third part introduces the method itself including presentation of outputs/document drafts designed by me.
|
|
|
Methodology for solution of transformation part of BI (ETL)
Cimbaľák, Michal ; Pour, Jan (advisor) ; Zajíc, Ján (referee)
Extract, Transformation, and Load (ETL) system is responsible for the extraction of data from several sources, their cleansing, conforming and insertion into a data warehouse. The thesis is focused on building ETL methodology to better understanding of ETL process and its application in the real environment. I've worked on project "BI Cookbook" with Clever Decision, a software consulting company that specializes in Business Intelligence. The aim was to create ETL part of the BI methodology. This methodology has been designed to provide ease of use, flexible and extensible material for the purpose of building ETL solution. The main goal of this work is to introduce created ETL methodology, all of its components and the way in which it could be used. Following goal is to discuss options of its implementation and modification for the wide range of use. The main contribution of this work is to provide ideas of creating and implementing ETL methodology or ideas for creating methodology in general. The thesis is divided into three parts. The first theoretical part deals with basic definition, architecture and implementing of ETL system. The second part presents the proposed methodology. The last part contains of the possible options for implementation a modification of the methodology.
|
|
|
Multidimensional modeling
Tříska, Aleš ; Pour, Jan (advisor) ; Mezník, Lubomír (referee)
This thesis deals with the processing of data through Business Intelligence. Any operating company today is using some kind of information system, which generates enormous amount of data. Business intelligence is responsible to structure this data and enable previews which help corporate decision-making. The thesis is divided into theoretical and practical parts. The theoretical part describes ideas and role of Business Intelligence (BI). The practical part is about implementation of BI in the existing company in that way, to do its job. This could be achieved by understanding corporation processes and its database. Integral part of making BI was also communication with the management company that has established requirements for the data previews. Due to this, it was possible to create Business Intelligence solution that will preview data in structure, which will be user friendly and inexpensive.
|
|
|
Data quality, data integrity and consolidation of data in BI
Dražil, Michal ; Pour, Jan (advisor) ; Zajíc, Ján (referee)
This thesis deals with the areas of enterprise data quality, data integrity and data consolidation from the perspective of Business Intelligence (BI), which is currently experiencing significant growth. The aim of this thesis is to provide a comprehensive view of the data quality in terms of BI, to analyze problems in the area of data quality control and to propose options to address them. Moreover, the thesis aims to analyze and assess the features of specialized software tools for data quality. Last but not least aim of this thesis is to identify the critical success factors in the field of data quality in CRM and BI projects. The thesis is divided into two parts. The first (theoretical) part deals with data quality, data integrity and consolidation of data in relation to BI trying to identify key issues, which are related to these areas. The second (practical) part of the thesis deals at first with the features of software tools for data quality and offers their fundamental summary as well as the tools breakdown. This part also provides basic comparison of the few selected software products specialized at the corporate data quality assurance. The practical part hereafter describes addressing the data quality within the specific BI/CRM project conducted by Clever Decision Ltd. This thesis is intended primarily for BI and data quality experts, as well as the others who are interested in these disciplines. The main contribution of this thesis is that it provides comprehensive view not only of data quality itself, but also deals with the issues that are directly related to the corporate data quality assurance. This thesis can serve as a sort of guidance for one of the first implementation phases in the BI projects, which deals with the data integration, data consolidation and solving problems in the area of data quality.
|
|
|
Corporate Performance Management in connection to Business Intelligence applications
Klimko, Jozef ; Pour, Jan (advisor) ; Derfler, Václav (referee)
The bachelor thesis is devoted to the issue of Corporate Performance Management (CPM) as a comprehensive approach to managing performance of the company including processes, metrics, methodologies and technologies. The main aim of the bachelor thesis is to bring out a comprehensive view to the questions of Corporate Performance Management, analyse the market and neccessery parts of CPM. The thesis is based on available literature and internet sources dealing with this topic. The thesis is composed of three basic parts. The first part of the thesis is focused on the definition of the Corporate Performance Management and Business Intelligence. It also defines the basic components necessary to successful implementation of CPM systems and differences between CPM and BI solutions. The second part of the thesis analyses in more detail the necessary components of the implementation of CPM, which includes processes, metrics, methodologies, technologies and basic types of applications needed to support the CPM approach. The third part of the thesis deals with the situation of the CPM suites market based on the Gartner's Magic Quadrant for CPM suites 2007 and 2009 and Forrester's Business Performance Solutions: Clash Of The Titans.
|
guest ::
