|
|
Strategy of further IT development at University of Economics Prague
Trčka, Adam ; Chlapek, Dušan (advisor) ; Nenadál, Karel (referee)
This thesis deals with problems of development and future heading of IS/ICT at the University of Economics Prague. Its main focus is on application integration. First part of this thesis is aimed towards explanation of corporate and information strategy, its need, benefits and possible risks. Second part of this thesis covers possible approaches to integration, mainly to the integration of various applications. Last part discusses actual situation at the university. Primary goal of this thesis is to determine actual IS/ICT conditions and lay down possible ways of improvement in each area. Secondary objective is to develop a base documentation for project aimed towards implementing an integration platform to the university. Those goals were achieved by thorough analysis of present situation accompanied by discussions with experts about possible development in IS/ICT at the university supplemented by literature research. Main benefits of this thesis lay in detailed revision of current state if IS/ICT along with specification of next possible projects towards having an advanced IT at the university. Partial benefits are in the area of preparation of contractual documents for project of implementing an integration platform.
|
|
|
Reaction to errors and alerts in ETL
Klimt, Roman ; Pour, Jan (advisor) ; Zajíc, Ján (referee)
This work deals with information systems called Business Intelligence (BI). Especially, it focuses on one part, whose task is to extract data from primary information systems. This stage is known as extract, transform, load (ETL). ETL is one of the most important stage in BI solutions because the quality of data depends on this stage. These data are used for all analyses and created reports. The goal of this work is to suggest solution for active projects, which are short of automated controlling mechanism. This mechanism should inform users of BI solutions about errors in data. If data from primary systems are in such bad state that ETL process is not able to match primary keys to them, the data are stored in special tables and are not used for future analyses. This is a very serious problem because analyses and reports based on the data may be misrepresentative. This problem must be solved by repairing the data in primary information systems. The administrator of primary information system has to know about the incorrect so that the data could be repaired. Therefore, an automated e-mailing system has been designed to inform about the incorrect data.
|
|
|
Implementation of Business Intelligence in ČON s.r.o. company
Hofman, Lukáš ; Novotný, Ota (advisor) ; Maryška, Miloš (referee)
This dissertation thesis deals with the topic of Business Intelligence and Balanced Scorecard and its use in České odborné nakladatelství, s.r.o., a relatively small company of 29 employees, which publishes magazines about business, gastronomy, textile, foods, hotels etc. The first part of my thesis describes the BI and BSC theoretically and offers a methodical basis for the following chapters. It gives the reader a definition and structure of BI, with access to a Data Warehouse including the fundamentals of building an OLAP database. It furthermore explains what BSC is, which perspectives use and what a strategic map is. The theoretical chapters of my paper will draw conclusions about the use of BI and BSC and the links between them. The practical, hands-on, chapters continue with the actual application of BI and BSC in the afore-mentioned ČON, s.r.o. It describes the goals and ambitions of the company, which are further on divided into individual strategic goals and metrics, fragmented into perspectives of the BSC and portrayed in a strategic map. Upon analyzing the demands of the company a BI framework is created, data sources are identified, Data Warehouse are designed and brought into effect. In the end a multidimensional OLAP cube is created with MS SQL Server 2008. Finally, there is a MS Excel 2007 explanation and interpretation of the measured values (reporting), which is taken from the available sources of ČON, s.r.o. and is compared against the set strategic goals and metrics of the company. The results of this thesis are based on actual demands of the company and are ready to be implemented and used in real-life.
|
|
|
Building of large Data Warehouses on MS SQL Server 2008 platform
Gottwald, Tomáš ; Novotný, Ota (advisor) ; Pour, Jan (referee)
This diploma thesis deals with building of large Data Warehouses on Microsoft SQL Server 2008 platform. First part of the thesis discuss about news in MS SQL Server 2008, which I have considered as being important for Business Intelligence area. Following chapters are focused on approach to implementation of real Data Warehouse for Customs Administration of Czech Republic on MS SQL Server 2008 basis. These parts of the thesis cover specifics of the Customs Administration of Czech Republic, current state of Data Warehouse and reasons for migrating to MS SQL Server 2008. Further the thesis describes both logical and physical architecture of proposed solution and a way of implementation Data Warehouse on MS SQL Server 2008. The main aim of the thesis is to create a list of critical success factors (CSF) of building large Data Warehouses on MS SQL Server 2008 platform. It's not only plain list CSF, but rather the best practices for MS SQL Server Data Warehouses implementation. The most significant contribution of this thesis is that it offers instruction manual for designing and implementing large Data Warehouse on MS SQL Server basis. Background for the creation of summary of CSV and recommendations were vendor's publications and especially my own experience with the product. My colleagues from company Adastra gave me an advisory opinion as well.
|
|
|
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.
|
|
|
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.
|
|
|
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.
|
|
|
ETL procesy
Husáriková, Světlana ; Rydzi, Daniel (advisor) ; Liška, Miroslav (referee)
Tato práce se zabývá ETL procesy a snaží se pokrýt jak obecné termíny, tak praktické informace a rady. Postupně vysvětluje jednotlivé fáze celého procesu, související termíny a pojmy a uvádí, kde se lze s ETL procesy nejčastěji setkat. Dále se věnuje návrhu celého ETL procesu. V praktické části upozorňuje na mnoho běžných úskalí, se kterými se vývojáři ETL procesů setkávají. Následuje výběr několika nejpoužívanějších ETL nástrojů, včetně shrnutí jejich hlavní funkcionality, a v jednom z těchto nástrojů je vytvořen ukázkový příklad. Závěr práce se věnuje několika nejvýznamnějším technologiím, které budou s největší pravděpodobností ovlivňovat vývoj ETL procesů v nejbližších letech.
|
|
|
Implementation Business Intelligence in a small-sized company and practical check on personal placement agency
Dörfl, Jakub ; Novotný, Ota (advisor) ; Machart, Robert (referee)
Cílem diplomové práce je návrh a implementace Business Intelligence v malé firmě, jako je personální agentura zabývající se poskytováním ?TEMPORARY HELP?. Požadavky na aplikaci BI jsou koncipovány na základě metodiky Balanced Scorecard. Teoretická část: popis základních principů a nástrojů konceptů BSC a BI včetně definování jejich vzájemného vztahu a specifických nároků daných užitím v malé firmě. Praktická část: ověření získaných poznatků z teoretické části práce v personální agentuře. V rámci BSC byly definovány konkrétní strategické cíle s měřítky a stanoveny strategické akce. Vybrané strategické cíle jsou sledovány vytvořenou BI aplikací v prostředí MS SQL 2000 a MS OFFICE XP.
|
|
|
Srovnání komerčních BI nástrojů s nástroji OpenSource
Okleštěk, Petr ; Novotný, Ota (advisor) ; Tlapák, Jiří (referee)
Cílem této diplomové práce je porovnat komerční a OpenSource Business Intelligence řešení pro střední podnik. Za účelem srovnání byl vybrán databázový server MS SQL Server s Analysis Services a dva možné způsoby nasazení OpenSource technologií. Prvním z nich je komplexní BI řešení od společnosti Insight Strategy a.s. ?The Bee?. Druhým způsobem je řešení pomocí dílčích aplikací nalezených na Internetu a to pomocí aplikací Keetle, Firebird, Mondrian a Openi. Jednotlivá řešení jsou porovnána na základě předem stanovených a popsaných metrik. Hlavním cílem je ověření na fiktivní firmě zda OpenSource BI řešení fungují a mohou nahradit komerční řešení a zda je to z finanční stránky výhodné.
|
guest ::
