|
|
Management of Information Flow of Small Software Company
Klimeš, Jiří ; Martoch, Zbyšek (referee) ; Kříž, Jiří (advisor)
This diploma thesis deals with the management of information flow of a small company using Business Intelligence tools and the data mart. There is defined the problem of working with information from the point of view of selected company in the first part. The next part presents selected theoretical background on the basis of which was the aim achieved. The fourth part analyses the current situation of the company. There is recommended complex improvement of the current situation in the practical part. Selected information management problem is accomplished factually. There are also introduced suitable software tools, which were used for the solution.
|
|
|
Datamart malých a stredne veľkých podnikov
Balko, Michal
The thesis describes the realization of datamart for small and medium-sized businesses (SMB) in an existing data warehouse environment conforming to Kimball Bus architecture. The introductory section deals with the theoretical guidelines of data warehousing and Business Intelligence. Following with the analysis of the current state of SMB datamart and data warehouse architecture. The results together with business requirements are used for the design of new datamart which encompasses ETL processes, OLTP database, OLAP model and reports. Each of these components are implemented using the tools from Microsoft. Final solution is tested and deployed on the production instance of database server running MS SQL Server.
|
|
|
Management of Information Flow of Small Software Company
Klimeš, Jiří ; Martoch, Zbyšek (referee) ; Kříž, Jiří (advisor)
This diploma thesis deals with the management of information flow of a small company using Business Intelligence tools and the data mart. There is defined the problem of working with information from the point of view of selected company in the first part. The next part presents selected theoretical background on the basis of which was the aim achieved. The fourth part analyses the current situation of the company. There is recommended complex improvement of the current situation in the practical part. Selected information management problem is accomplished factually. There are also introduced suitable software tools, which were used for the solution.
|
|
|
An analysis and implementation of Dashboards within SAP Business Objects 4.0/4.1
Kratochvíl, Tomáš ; Pour, Jan (advisor) ; Šedivá, Zuzana (referee)
The diploma thesis is focused on dashboards analysis and distribution and theirs implementation afterwards in SAP Dashboards and Web Intelligence tools. The main goal of this thesis is an analysis of dashboards for different area of company management according to chosen of architecture solution. Another goal of diploma thesis is to take into account the principles of dashboards within the company and it deals with indicator comparison as well. The author further defines data life cycle within Business Intelligence and deals with the decomposition of particular dashboard types in theoretical part. At the end of theory, it is included an important chapter from point of view data quality, data quality process and data quality improvement and an using of SAP Best Practices and KBA as well for BI tools published by SAP. The implementation of dashboards should be back up theoretical part. Implementation is divided into 3 chapters according to selected architecture, using multisource systems, SAP Infosets/Query and using Data Warehouse or Data Mart as an architecture solution for reporting purposes. The deep implementing section should be help reader to make his own opinion to different architecture, but especially difference in used BI tools within SAP Business Objects. At the end of each section regarding architecture and its solution, there are defined pros and cons.
|
|
|
Client workers‘ performance reporting
Klepetko, Vítězslav ; Novotný, Ota (advisor) ; Pour, Jan (referee)
The thesis aims at design and implementation of a corporate performance management system in retail banking. It proposes a tree of performance metrics based on Dupont pyra-mid model. Using financial as well as non-financial measures, the proposed model manages to link all levels of management together into one shared hierarchy. As a result, the model shows how performance of a single worker adds up to the performance of the company as a whole. The model uses financial metrics such as interest margin, account balance, fees and remuneration cost and links them with non-financial measures such as client worker activities with clients, success rate of marketing campaigns, or client complaints. Implementation of the corporate performance management system is done using regular business intelligence tools. Third normal form data warehouse is the source for all data needed. A datamart on Teradata platform is proposed to hold the SQL transformed data from the data warehouse. Using the datamart a metadata layer in Microstrategy is created to distribute data among users.
|
|
|
The analysis of BI tools in Oracle's environment
Nisznanský, Petr ; Pour, Jan (advisor) ; Derfler, Václav (referee)
Hlavním cílem diplomové práce (DP) je provedení analýzy prostředí a jednotlivých nástrojů na podporu Business Intelligence (BI) na platformě Oracle. Analýza zahrnuje komplexní proces BI řešení od instalace potřebných programových prostředků (databáze, BI balíky, dokumentace atd.) až po zprovoznění praktické demonstrační aplikace a zhodnocení celé platformy. Práce se skládá ze čtyřech hlavních částí. V první části uvádím čtenáře do problematiky BI. V druhé části analyzuji globální charakteristiky prostředí Oracle BI a porovnávám je s SQL Serverem. Třetí část obsahuje analýzu a komparaci systému Oracle BI se systémem SQL Server ve třech oblastech (oblasti zahrnují: extrakci ? transformaci ? natažení dat, analytické zpracování dat a reporting) včetně vyhodnocení uvedených oblastí podle několika kritérií. V jednotlivých oblastech zjišťuji zejména dílčí architektury, používané nástroje a jejich funkcionalitu. Poslední část doplňuje stručnou analýzu světového trhu OLAP technologií.
|
guest ::
