|
|
Design and creation of BI systems documentation
Andrle, Ondřej ; Pour, Jan (advisor) ; Zajíc, Ján (referee)
This work deals with the different kinds of documents and documentations accompanying an implementation of Business Intelligence Systems. The character and structure of this work is influenced by cooperation with the Cleverdecision company. This company has enabled analytic work with data from medical registers by implementing the BI solution into the medical sphere. The implemented BI solution is in this work documented in two directions. First documentation is certain specification of the BI solution including architecture, descriptions of single components and applied hardware and software. This documentation is mainly a demonstration of the description of possibilities of the BI system and it is put after the theoretical part. The Theoretical part is about document types, which originates at the projecting of BI systems. The second documentation is intended for end users of the systems and it is put in the enclosure. It explains the possibilities of work with pivot tables in Microsoft Excel backgrounds that are used for analytic work with data. By the help of this documentation the user will be able to connect to multidimensional cube and draw up quality and predicative outputs. These two documentations are the main aims of the work. This work also mentions different end users groups and their abilities to work with the reports. In the end of the work there is an analysis of the single periods and principles of formulation of the user documentation.
|
|
|
Corporate Performance Management and its support by BI tools
Koucký, Jiří ; Novotný, Ota (advisor) ; Maryška, Miloš (referee)
Corporate Performance Management (CPM) je poměrně nově se rozvíjející obor. Vychází z předpokladu, že řízení podniků vyžaduje vytvoření speciálních procesů, metodologií, metrik a systémů potřebných k měření a řízení podnikové výkonnosti. Mým cílem je v této práci rozlišit a popsat různé přístupy k této problematice. V prvním přístupu se zkoumá především finanční výkonnost podniku, finanční plánování a finanční konsolidace. Druhý přístup se zaměřuje na metody pro naplňování strategie jako je ballanced scorecard nebo strategické mapy. Poslední přístup reprezentuje CPM jako celopodnikovou manažerskou metodologii. Zmiňuji se o nejlepších manažerských praktikách a o celostním pohledu na CPM podle renomovaných světových konzultantů. Nemohu zapomenout poukázat na význam moderních informačních technologií pro podporu CPM, jimiž jsou nástroje Business Intelligence (BI). Ve zvláštní kapitole píši o předních světových dodavatelích BI a o kategoriích BI nástrojů pro podporu CPM.
|
|
|
Low-cost Business Intelligence Solution for Small and Medium Business
Machander, Aleš ; Šalamon, Tomáš (advisor) ; Skala, David (referee)
This thesis is concerned with use of business intelligence in small and medium business. The main issue is to find such solutions, which are suited to needs and requirements of this type of business. The most suitable method of implementation of business intelligence is according to outputs of this thesis a development of own solution in low costs. On the contrary integrated solutions delivered by the big players on this market are too complex and very expensive for small and medium business. Web-based and SaaS solutions are interesting to these companies, but their support and provided services are not in sufficient level in Czech Republic. To reach all these goals there were analyzed information focused on possibilities and needs of small and medium business and consequently was performed analysis of business intelligence market. The gained outputs were verified in practical part, which is based on project of implementation of business intelligence solution to specific small company. Resources for the final figure of this project are mainly the interviews with shareholder. The main contributions of this thesis are previously mentioned analysis and project of implementation of business intelligence solution. By the help of these studies was found a suitable way, how to implement a business intelligences solution to small and medium business in low costs. Another contribution is in gained opinions and points of view of managers of these companies on implementation of business intelligence.
|
|
|
Aplikace Business Intelligence v telekomunikačním sektoru
Višňová, Marika ; Novotný, Ota (advisor) ; Slánský, David (referee)
Čtenář bakalářské práce z kontextu pochopí logickou souvztažnost mezi děním na trhu telekomunikačního sektoru a potřebou orientace společnosti na zákazníka a tím i na Churn management. V práci jsou popsány principy a komponenty Business Intelligence a dolování dat, které tvoří technologický základ Churn managementu. V poslední kapitole, která je věnována samotnému Churn managementu, je ukázáno jak probíhá vytvoření prediktivního modelu dle metodiky CRISP-DM, což by mělo alespoň zprostředkovaně přiblížit Churn management v praxi.
|
|
|
Corporate performance management (CPM) and its use in practice
Gřešák, Ondřej ; Novotný, Ota (advisor) ; Perušič, Boris (referee)
This thesis addresses a new management approach - "Corporate Performance Management" (CPM). It sets forth the concept of this new approach as a business performance monitoring and strategic support tool, its assumptions, framework, components, relationship to business intelligence, and related methodologies. Particular focus is placed on "key performance indicators" (KPI), their characteristics, segmentation, methods for their selection, and implementation procedures. The theoretical part of this work is devoted to creating a methodology by which CPM can be effectively implemented on projects in the financial sector with an emphasis on the critical success factors of such a project as a whole. The primary elements of this methodology are the selection of the best possible metrics, the project's overall success and the development of efficient reporting. The practical part of this work initially introduces "Project KPI 2008", which ran in Komerční banka (Czech Commercial Bank), then pits it against the theoretical methodologies defined in the theoretical section. The entire project is then assessed based on the results of the comparison, and finally, conclusions and recommendations are made for the future of this project. The main asset of this thesis is its creation of the afore-mentioned management methodologies and the ideal, course to be taken in implementing a KPI-focused project. This work is valuable not only for investigating key performance indicators themselves, but also as an informative tool for managers who would like to acquaint themselves with or learn more about the CPM concepts in general.
|
|
|
Comparison of commercial BI tools with Open Source tools
Válek, Jan ; Novotný, Ota (advisor) ; Maryška, Miloš (referee)
Cílem této práce je porovnání komerčních business intelligence nástrojů s nástroji Open Source v procesu implementace BI řešení ve střední firmě. V práci jsou porovnávány komerční aplikace Oracle (http://www.oracle.com) ? Oracle Warehouse Builder, Oracle Discoverer a Open Source nástroje z projektu Pentaho (http://www.pentaho.com) ? Kettle, Cube Designer a BI Platforma. Hodnocení obou systémů probíhá na základě předem definovaných metrik. Práce kromě popisu realizace obou řešení a jejich vzájemného porovnání také dává odpověď na zcela zásadní otázku, zda může Open Source řešení konkurovat tomu komerčnímu. Dalším přínosem je návrh modifikovatelného a znovupoužitelného stromu metrik, který je k hodnocení systémů použit.
|
|
|
Applying Business Intelligence tools for the Financial and Property Analysis of Municipalities
Horký, Martin ; Novotný, Ota (advisor) ; Toth, Petr (referee)
This master thesis deals with the software support of one Financial and Property Analysis of Municipalities (FAMA). The co-author of this method is Doctor Petr Toth from the Institute of Public Administration and Regional Development at University of Economics in Prague. The method is supported by Microsoft Access database application and two C++ applications ArisDestiller and Prognoza at present time. The aim of this thesis is to evaluate the present software support of Financial and Property Analysis and implement an alternative solution based on Business Intelligence tools. Chosen part of analysis is implemented in the pilot project using Microsoft SQL Server 2005 environment. The thesis focuses mainly on using integration tools for XML data. The contribution of the thesis is to implement data warehouse, which uses the municipalities'annual bills in XML format from the database of Ministry of Finance of the Czech Republic. The Financial and Property Analysis method and the current software support are discussed in the first half of this thesis. The other half of the work is dedicated to the Business Intelligence pilot project. Both means of software support are reviewed and compared from various perspectives in the conclusion.
|
|
|
Analysis of SAP NetWeaver Business Intelligence 2004s
Michna, Petr ; Novotný, Ota (advisor) ; Ing. Daniel Trhoň, Ph.D., MBA, (referee)
This diploma thesis deals with the analysis and evaluation of one of the most important Business Intelligence platform in the BI market -- SAP NetWeaver Business Intelligence 2004s. The main objective of the analysis is to provide reader with very comprehensive theoretical and practical platform overview that is based among others on valuable implementation of SAP NetWeaver BI sample application. The sample application not only allows better understanding of the platform, but also provides significant inputs to evaluation final phase. This evaluation is based on a metric system, which is defined as a part of this thesis as well. The evaluation result is then, apart from the quantitative quality interpretation of analyzed platform, included in a quality comparison (some areas) with BI platforms Oracle and Open Source Pentaho, whose evaluation and comparison have been made in diploma thesis [VÁLEK, 2008]. At the end of this thesis is then provided an overview of SAP NetWeaver Business Intelligence 2004s strengths and weaknesses.
|
|
|
Business Intelligence in bank sector
Langmaier, Petr ; Pour, Jan (advisor) ; Švec, Karel (referee)
The main goal of this thesis is proposal and implementation of the support of decision making with help of Business Inteligence tools in bank environment for deparment of the risk management. The proposal include enlargement of the current used dimensions with new ones. Designed system should fully replace contemporary system and extend possibilities of obtaining informations from data resources and improve the quality of decision making. Designed system will be part of portfolio quality review of multiple business products. The next goal of this work is to analyse current trends in Business Inteligence and analyse the usage of BI in banking. Further analyse the support of BI from operative to strategic decision making. The goals are achieved on the basis of analyses accessible relevant electronic and printed resources, further from knowledge and experience of bank's analysts from deparment of the risk management and BI. Further from service documentation and further from my work experience in deparment of the risk management and from implementation of credit scoring projects. As the personal contribution of the author is possible to consider the demonstration of the usage of BI in bank risk management and at the same time the proposal of one possible way of solving implementation of the supports of decision making in bank's environment.
|
|
|
Implementation of Business Intelligence in building industry
Melichar, Jan ; Novotný, Ota (advisor)
Diploma thesis is focused on the strategic performance management and Business Intelligence domain. Main objectives of the thesis are to define strategic goals of building enterprise by help of the Balanced Scorecard (BSC) concept and to assign specific metrics to these strategic goals. Another objective of this work is to design Business Intelligence (BI) implementation which means building a data warehouse upon company data, multidimensional cubes and user-defined reports. Initial theoretical principles are described in the first part of this work in which main issues of strategic performance management, BSC concept and BI domain are specified. In the practical part the strategic goals and specific metrics of building enterprise are defined. The output of this chapter is an overall strategic map containing strategic goals with assigned metrics and also comments describing mutual relationships of these goals. Next chapter deals with building a data warehouse upon company data, multidimensional cubes and user-defined reports with measured values interpretation. Contribution of the thesis consists in the enterprise management model upon BSC concept which helps specify strategic goals and also the design of BI implementation which should simplify monitoring of these strategic goals by the help of the metrics specified. Another contribution for building industry enterprise management can be an overview of main BI technologies and the ways and means of its practical application.
|
guest ::
