|
CPM and implementation of dashboarding
Koucký, Jiří ; Pour, Jan (advisor) ; Zajíc, Ján (referee)
Corporate Performance Management (CPM) is a broad concept focused on managing performance of companies and is related to information technologies like Business Intelligence (BI). CPM and its associated technologies are currently one of the most tracked areas in the field of business informatics. The reason is the growing market competition, globalization, the dynamic changes on the market and the growing need for companies to effectively manage their performance. The aim of the theoretical part of the thesis is to familiarize readers with this concept, with its components and link to business informatics. The work focuses on a specific area of CPM, which is monitoring and analysis, i.e. dashboarding. In the thesis there is analyzed monitoring and analytical functionality of the software Microsoft Office PerformancePoint Server 2007 (PPS). Furthermore, there are identified dashboard and scorecard concepts and analyzed the characteristics and categorization of dashboards. There are various best-practices approaches to deployment of dashboarding into business. In the thesis there are mentioned some of these practices and basic rules for proper dashboard design. At the end of the theoretical part of the thesis there are evaluated the world's leading suppliers of CPM solutions. The aim of the practical part of the thesis is design and documentation of CPM dashboarding solution based on the real business data of the company that provides consulting services and develops BI software. The solution is designed in the PPS software and its purpose is to support the company's management in terms of monitoring the effectiveness of internal and external projects and business activities of the company. The solution is not a definitive CPM solution, but a step by the company to reveal possible weaknesses in the organization and encourage efforts to develop its own holistic CPM solution.
|
|
Integration of .NET/Java technologies with SAS
Jandák, Miroslav ; Slánský, David (advisor) ; Pour, Jan (referee)
This thesis is focused on SAS Enterprise Intelligence Platform product and it's capabilities to integrate within a Business Intelligence solution. The aim of the thesis is to describe integration technolgies that the platform features, as well as to determine their application field and compare them, eventually add usage examples. The first part of the thesis explains the general concept and architecture of Business Intelligence, afterwards the reader gets familiar with the SAS Enterprise Intelligence Platform, it's stucture and components and it's Business Intelligence market position. The second part of the thesis contains description (how they work and what they are good for) of the integration technologies available in SAS Enterprise Intelligence Platform. Those technologies are mostly implementations of the most common industry standards (database APIs, COM/DCOM, CORBA, web services). The study also includes description of these standards supported by SAS. The thesis features also comparisions of the integration technologies, namely comparison of database API implementations and comparision of Integrated Object Model API with SAS BI Web Services.
|
|
Business Activity Monitoring
Frühauf, Michal ; Řepa, Václav (advisor) ; Pálka, Jan (referee)
Main focus of the thesis lies in the corporate management decision support deploying and using IT / ICT. Specific technology described is Business Activity Monitoring. The contribution of the work lies primarily in two planes. The first plane is to create as far as the most comprehensive view of the BAM. The findings are collected from different directions and areas. The first direction of research is focused on the development of Business Intelligence and description of BAM as a trend of BI, including the stages of development and projections into the future. The second direction focuses primarily on a detailed circumscribe of BAM. Its definition, deployment assumptions, basic models, the way how business can benefit from BAM usage. The third guideline shows the classification of BAM surrounded by the other / similar technologies and business solutions -- BI and BSM, and the search key differences. The second level of the work is to support the AML implementation in a specific environment of banks using BAM. This is a practical demonstration of the possibility of using BAM in practice. Basic design solution lies in the analysis of risks arising from the law and the current state of the solution. By mapping of banking processes and searching for points of risk it is then possible to deploy these risks BAM tools for their management. Motion of support lies mainly in conceptual terms.
|
|
Possibilities of CPM solution in banking sector
Janata, Pavel ; Pour, Jan (advisor) ; Matuštík, Ondřej (referee)
This thesis addresses issues of measuring and managing the performance of commercial bank institutions by means of a system called Corporate Performance Management (CPM). The theoretical part of this work is devoted to introduction of banking industry and methods of performance measurement in commercial banks. It introduces a general concept and key components of CPM supported by Business Intelligence technology. In the practical part of this work there is introduced the design of two concrete CPM solutions which are being currently built in banks -- KPI processing and interest margin calculation. The main thesis contribution to the existing literature is a creation of complex material about relevant aspects of implementation CPM solutions in data warehouses of commercial banks and creation the conceptual design of a concrete solution.
|
|
Analytical portals, their role in running the company and the criteria for their development and operation
Bartoš, Petr ; Novotný, Ota (advisor) ; Pour, Jan (referee)
The dominant trend of the current corporate information systems is undoubtedly a growing emphasis on information and their quality. But quality is not the only crucial factor. No less important is speed and flexibility of information acquisition. Due to a dynamic environment in which today's corporation must survive, even the high-quality information are very quickly getting older, lose their value and reduce the competitive advantage the company which manages them. This thesis deals with the analytical portals, which significantly improve work with information and are used largely in modern enterprises. The work consists of two main parts, theoretical and practical. Theoretical part tries to explain what exactly the term "analytical portal" means and what is the role of analytical portal in reference to the company management procedures and existing information systems. In addition to this introduction, theoretical part also contains instructions on how to evaluate the analytical portals. This guidance includes both the various aspects of which you can evaluate the portal and the proposal of possible way of processing results, so they could be used for an objective comparison of more competing products. The practical part contains a practical example of evaluation of specific product. This evaluation is based on the basis of the use of specific tool for creating analytical portal as the implementation of demonstration example, as well as the use of theoretical background as defined in the previous section. In addition to a general introduction to the problems of analytical portals, work may also serve as a basis for the creation of a specific methodology for evaluating different products on the market.
|
|
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.
|
|
Use of Business Intelligence with web analysis of an electronic store
Erlebach, Jakub ; Novotný, Ota (advisor) ; Maryška, Miloš (referee)
In the time of recent economic crisis is more than ever difficult to keep old and find new customers. Along with the growth of sales on the Internet there are also a growing number of competitors, which want their share of the market pie. The aim of this thesis is to use technologies and processes of Business Intelligence with web analysis of an electronic store in order to get new information and knowledge that should later on help with overcoming the two mentioned problems most companies running an internet business are today dealing with. In the first, theoretical part of this thesis there are described basic principles and processes of search engine optimization in term of both users and search engines. Next chapter follows the theory of web analysis. There are also described general as well as own selection criteria of the web analysis tool. Upon these criteria there are these tools described and evaluated. Last theoretical chapter deals with Business Intelligence, in particular with a data warehouse theory and with a process of a BI project. Introduction to the practical part is formed by a description of a current e-shop situation. In this part there is also mentioned current architecture solution, standing of the firm and its future vision. On the basis of selected web analysis tool and theoretical knowledge described in previous chapters there is than designed concrete solution and described process of its implementation, some of its outputs and also its costs. The main contribution of this thesis I see in gaining new and otherwise hardly accessible reports about the visit rate, which should ease and improve the process of website optimization and therefore help the company to strengthen its market position. Another contribution would be in demonstration of the BI implementation on a small business scale also with its cost accounting.
|
|
Data Quality, Data intagrity and Data Consolidation in BI
Smolík, Ondřej ; Pour, Jan (advisor) ; Zajíc, Ján (referee)
This thesis fights with the data quality in business intelligence. We present basic principles for building data warehouse to achieve the highest data quality. We also present some data clearing methods as deviation detection or name-address clearing. This work also deals with origin of erroneous data and prevention of their generation. In second part of this thesis we show presented methods and principles on real example of data warehouse and we suggest how to get sales data from our business partners or customers.
|
|
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.
|
|
Corporate Performance Management Based on Business Intelligence
Křepinská, Veronika ; Pour, Jan (advisor) ; Zajíc, Ján (referee)
Nowadays, corporations run their business on dynamic markets with really harsh competition. If they want to survive, they need to manage their business effectively and increase corporate performance. Management is today highly supported by information and communication technologies that develop and bring new solutions and technologies continuously. One of these new solutions is Corporate Performance Management based on Business Intelligence technologies that enables complex and integrated view of business performance and its management. This thesis is devoted to this new developing approach in IS/ICT. Readers will become familiar with its basic principles, advantages, particular components and process of implementation. After this more theoretical part, follows the practical issue - realization of this solution for an existing organization in order to get expected results and effects. The solution is designed for a company that provides consulting and software development in Business Intelligence technologies. According to the cycle of CPM, firstly, a Performance Management method is chosen, after that the corporate strategy and concrete KPIs as they enhance the goals and strategy achievement. Afterwards data sources are identified and optimized as needed. On these data sources, all the visualization tools for Performance management are developed. In this case we are talking about interactive scorecards and dashboards. After this phase, the solution is ready for the developers to create it in the concrete application. In this case the Microsoft Office PerformancePoint Server 2007.
|