|
|
BI and DWH Solution on Oracle Platform
Podbraný, Petr ; Pour, Jan (advisor) ; Krch, David (referee)
The main objective of the thesis is to propose complex business intelligence and data warehouse architecture on the Oracle platform respecting current best-practice and recommendations. Part of the thesis is focused on selecting the right components for data warehousing and business intelligence, as well as on evaluating their suitability within the proposed business intelligence architecture and incorporating of these components into the complex business intelligence architecture. My thesis consists of four parts. The first part is dedicated to more general description of business intelligence and data warehousing subject and it represents entry level specification of BI on the Oracle platform. The second part describes individual software and hardware components of business intelligence solution based on the Oracle platform. In the third part I am proposing a complex business intelligence solution, based on particular Oracle components. There I also compare some individual components, determine their suitability in respect of proposed architecture and introduce some other recommendations. The last part of my thesis briefly describes economic and non-economic benefits of business intelligence solution based on the Oracle platform.
|
|
|
Implementing SugarCRM and BI solution using opensource tools
Ullrich, Jan ; Novotný, Ota (advisor) ; Dušek, Jiří (referee)
Diploma thesis is focused on the implementation of customer relationship management and Business Intelligence solutions in the small business company using open source technologies. Main objective of the thesis is implementation of CRM and Business Intelligence and evaluation of usability of these solutions. Thesis describes basic elements of these solutions. For the setting up metrics is using Balanced Scorecard. In the next part of this thesis is designed the whole Business Intelligence including the creating of data model and OLAP cubes using open source technologies. Theoretical background is described in the first part of thesis. There are defined basic terms from scope of strategic management using Balanced Scorecard, CRM and Business Intelligence. Thesis demonstrates using and creation of the whole Business Intelligence solution. There are also evaluated difficulties in implementation of these products. In thesis is designed data warehouse and the whole solution including reports.
|
|
|
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.
|
|
|
Iplementation of Business Intelligence into warehouse of spare parts
Filip, Petr ; Novotný, Ota (advisor) ; Kadleček, Ladislav (referee)
This thesis is focused on topics of Business Intelligence, Balanced Scorecard and its implementation in agricultural company Novak Co. Both methods will be applied to section warehouse of spare parts. Warehouse by Novak Co. deals with provision of spare parts for own consumption and sale of spare parts to external customers. The thesis consists of theoretical and practical parts. Theoretical part deals with a description of essential ideas of BSC and BI. Practical part deals with examination of gained knowledge by implementation BSC and BI to warehouse by Novak Co.. To begin with, the first chapter is focused on Balanced Scorecard methodology. There is a description of principles BSC, description of company goals via four perspectives and the definition of strategic map. There are described basic principles of BI, multidimensionality, main components of BI application and a few definitions of BI from different sources in the second charter. In theoretical part, there are mentioned a few thesis, which deals with the same or similar subject, like this thesis. The practical part is focused on design of pilot project of BI solution for the warehouse of spare parts in the company Novak Co.. At first there was processed the analysis of BSC and the analysis of accessible resources in order to determine possibilities and requests for BI application. Based on requests there is designed the data warehouse, ETL tools and OLAP cubes. Reporting is carried out by MS Excel 2007. The Outputs of BI application are based on real company's requests. The main benefit of this thesis is to demonstrate the usability of BI tools and BSC methodology in section of warehouse of spare parts.
|
|
|
Recognition and measurement of Business Intelligence effects
Tůma, Martin ; Pour, Jan (advisor) ; Zajíc, Ján (referee)
This thesis deals with recognition and measurement of Business Intelligence(BI) effects. The aim of this thesis is to create tables for potential effects in the variety of application areas. Tables will respect character of effects in order to serve BI vendor as a basis of marketing communication. BI effects and informatics effects will be defined. Followed by an introduction to possible ways of classification. BI market condition considering effects will be mentioned. After that tables will be designed. Selection of application areas, recognition and classification of effects are next steps. After these steps additional information such as assumption, description of achieving, proposal of quantification, unit or potential exteriorization of effect is filled in tables. Possibilities, limits and reasons for measuring effects will be mentioned. My contribution is creating and filling in tables of potential effects in the variety of BI application areas.
|
|
|
Evaluation's criteria of analytical portals using SAS Enterprise Bussiness Intelligence Server
Čáp, Jakub ; Novotný, Ota (advisor) ; Pour, Jan (referee)
The need for reliable and exact information that are needed to run a company is still growing. This fact leads to finding new ways to obtain, transform, but especially deliver these information. One of the most efficient way is to integrate Business Intelligence into company's information system that leads to the usage of analytical portals. This thesis's target is to acquaint the readers with the topic of analytical portals and conceivable method to evaluate analytical portals and tools designed to build them. This thesis consists of two general sections, theoretical and practical. The theoretical section consists of the explanation of the term analytical portal and the ways a company can benefit from usage of analytical portals. The criteria and the conceivable method to evaluate analytical portals and the tools designed to build them are specified further in this section. The practical section contains description and evaluation of certain tool designed to build analytical portals (SAS Portal). The evaluation is based on the criteria described in the theoretical section and data used in the exhibition of the SAS Portal are purely exemplificative.
|
|
|
Measuring Effects of Business Intelligence Application
Šild, Vladimír ; Novotný, Ota (advisor) ; Zajíc, Ján (referee)
Currently, Business Intelligence has a very solid position in the enterprise information systems' market. However, there is no unified approach to the evaluation of effects of these solutions in the enterprise. It is a common practice that the transmission of the accepted solution automatically means successful completion of the development project, causing a gradual decrease in the supplier's interest of the users' satisfaction with this solution. This thesis deals with the problem of evaluating the success of custom Business Intelligence solutions. The main objective of this work is a new perspective on the issue of users' satisfaction and create a generally applicable concept for its evaluation. This objective will be achieved on the basis of a comprehensive theoretical analysis of effects of these solutions with the reasons why the work focuses on the analysis of users. It presents a total of two methods for evaluating the users' satisfaction of reporting solutions from the users. In order to demonstrate the viability of this concept, the two methods will be applied in practical part to a specific BI solution, including the demonstration of achieved results and assessing the suitability of both methods. This section is based on the experience of the real project.
|
|
|
Propojení produktů BPM a BI
Zikmund, Martin ; Kunstová, Renáta (advisor) ; Švík, Martin (referee)
Interconnection between various types of IT systems used in an enterprise is crucial in these days. Most of companies are using many different kinds of applications in their daily running of the enterprise which leads to necessity of sharing data across those applications to enable all employees to make a right decision upon correct information. In my diploma thesis I deal with interconnection of two systems -- Business Process Management (BPM) and Business Intelligence (BI). Both systems belong to group of top IT systems with big influence on ongoing business and right decision making on all levels from operational to strategic. My paper contains theoretical as well as practical part of the solution for interconnection of BI and BPM systems. First part is about presenting and describing basic concepts and technologies which are used in process of integration of BI and BPM. At the beginning there is a short introduction to BPM, BI and SOA. Following part is including analysis of three major ways of interconnection between BI and BPM systems. Last part of the first theoretical section presents two products. IBM FileNet P8 representative of BPM system and IBM Cognos 8 BI as a representative of BI system. Second part deals with the practical example of real integration between BI and BPM systems. In first part of this section is simple description of the scenario -- business case. After that there is a detail depiction of two different kinds of integration of BI and BPM. Analysis of benefits, advantages and further possibilities are at the end of work.
|
|
|
SAP BI Platform Analysis and Comparison with Chosen Tools of MS SQL Server BI Solution
Řezníček, Jiří ; Pour, Jan (advisor) ; Nedbal, Michal (referee)
This diploma thesis deals with an analysis of SAP Business Intelligence platform (SAP NetWeaver BI 7.0) and compares its chosen tools with Microsoft SQL Server BI. The main aim of the thesis is to evaluate SAP BI system in a comprehensive way whereas extra attention is paid to certain areas, such as a data warehouse. One of the goals is the comparison of approaches and methods of the creation of the data warehouse with MS SQL Server BI solution. The thesis consists of theoretical insight into Business Intelligence, which is focused on the architecture of data warehouse, and OLAP technologies. There is an evaluation of the role of SAP in the BI market followed by the introduction of SAP NetWeaver, an application and integration platform. Included is also an analysis of the architecture of data warehouse, methods of storing data, ETL process and other chosen functions and tools (including presentation tools) in next sections. A sample application in the final part provides the reader with better understanding of different ETL approaches, which are analyzed into detail and evaluated. There is the comparison of OLAP technologies in the end and the comparison of basic reporting tools, as well.
|
|
|
Decision Making Support Using Exact Software's Enterprise Information Systems
Pitka, Lukáš ; Pour, Jan (advisor) ; Šváb, Jiří (referee)
This diploma thesis deals with an information technology support of organization's decision making processes using Exact Software's enterprise information systems. The main goal of this paper is a demonstration of various Exact Software applications using real world examples from several Czech enterprises. Illustration of various benefits of integrated enterprise systems architecture is another goal of this paper. Possible benefits gained during the process of implementation of Exact Software's applications and necessary requirements that have to be fulfilled create the last goal. Risks and issues that can be encountered during the implementation process are mentioned along with benefits. To achieve these goals this diploma paper contains a lot of practical illustrations supplemented by theoretic explanation. Paper includes four parts. First part is an introduction into decision making processes in enterprises and provides a general overview of Exact Software's enterprise information systems portfolio. Another area covered by the first part is an overview of possible benefits of these systems in according to the level of organization management. Second part is dedicated to Exact Synergy Enterprise. At the beginning of this part there are outlined procedures, benefits and assumptions necessary for successful system implementation. The following text in part two contains many real world examples from the decision making point of view. Third part covers Business Intelligence application Exact Business Analytics from the standpoint of implementation guidelines, prerequisites and benefits. Subsequent subchapters contain practical examples of usage of this system. The last part is comprised from two case studies of Exact Software's systems implementation -- first one is a financial counseling company, second one is a company from the IS/ICT area. The paper as a whole represents unique material for companies that are looking for solutions on their decision making and analytical procedures problems. On the basis of this paper the reader can create an overview of current capabilities of enterprise information systems. A vast majority of presented solutions are system independent i.e. the usage of systems from Exact Software is only exemplary. Case studies of complex enterprise IS architectures in real world enterprises represents another great contribution to this diploma paper.
|
guest ::
