Företaget Nethouse har haft uppdraget att kravställa, utveckla och implementera ett verksamhetssystem åt Sveriges  Skorstensfejaremästares Riksförbund (SSR). Medlemsföretagen i SSR bedriver sotarverksamhet på uppdrag av Sveriges kommuner och är beroende av insamlad data kopplad till deras verksamhet. I det nyutvecklade systemet, som går under namnet Ritz, samlas informationen i en central databas och är tillgänglig för flertalet intressenter med hjälp av ny teknik och modernare lösningar. Systemet är helt webbaserat och körs som en molntjänst, tillgängligt via antingen en webbsida eller som mobilapplikation. Åtkomsten av data baseras på företagsnivå på ”stämplad” data i databasen och för att reglera åtkomsten för företagsanvändare till respektive företags data används rollbaserad åtkomstkontroll. Detta examensarbete har syftat till att utveckla en prototyp till en beslutsstödslösning för dynamisk åtkomst till de datamängder som lagras inom Ritz. Nethouse har efterfrågat en prototyp för en BI-lösning som visar på möjligheter och fördelar för intressenter till Ritz med att implementera en sådan. Då integration och förvaltning är viktiga faktorer för Nethouse har ett krav på prototypen varit att den utvecklats inom Microsofts programvaror, precis som resten av Ritz. Prototypen färdigställdes genom konstruerandet av ett centralt data warehouse enligt Ralph Kimballs metodologier och genom implementation av en OLAP-kub byggd i Microsoft SSAS. Dataöverföringen från datakällorna till beslutsstödslösningens data warehouse skedde genom utvecklandet av en ETL-process i Microsoft SSIS. Den resulterande kuben har främst utformats för att kunna besvara den sortens frågor som länsstyrelser ställer till sotarföretag i kontrollsyfte och stöder förfrågningar mot de två centrala affärsprocesserna sotning och brandskyddskontroll. Dessa förfrågningar kan filtreras på flertalet dimensioner som exempelvis tid, utförare, status och kontrollutfall. Prototypen begränsar även åtkomst till den information som användare har rätt att ta del av genom att koppla samman användare och objekt till geografiska indelningar som kallas distrikt. Denna dynamiska säkerhetslösning ger goda förutsättningar för att kunna hantera förändringar i användarnas behörighet i framtiden. Genom den utvalda lösningen behålls den dynamiska naturen i systemet, då åtkomst till beslutsstödstjänsten kan fås genom flertalet källor som stödjer uppkoppling mot Microsofts multidimensionella beslutsstödslösningar, bland annat Excel och SQL Server Reporting Services.

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.

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.

Extract, Transformation, and Load (ETL) system is responsible for the extraction of data from several sources, their cleansing, conforming and insertion into a data warehouse. The thesis is focused on building ETL methodology to better understanding of ETL process and its application in the real environment. I've worked on project "BI Cookbook" with Clever Decision, a software consulting company that specializes in Business Intelligence. The aim was to create ETL part of the BI methodology. This methodology has been designed to provide ease of use, flexible and extensible material for the purpose of building ETL solution. The main goal of this work is to introduce created ETL methodology, all of its components and the way in which it could be used. Following goal is to discuss options of its implementation and modification for the wide range of use. The main contribution of this work is to provide ideas of creating and implementing ETL methodology or ideas for creating methodology in general. The thesis is divided into three parts. The first theoretical part deals with basic definition, architecture and implementing of ETL system. The second part presents the proposed methodology. The last part contains of the possible options for implementation a modification of the methodology.

The dissertation describes the process of creating Business Intelligence solution over the ERP system MS Dynamics NAV. The successful development and deployment of prototype version is also the main goal of this work. The work is divided into two parts in accordance with sub-objectives: theoretical and practical. The theoretical part starts witch research of works with similar theme and then continues with description of the current state of Czech market with BI solutions on the MS Dynamics NAV, basic principles of Business Intelligence development and then the description of the method of setting benchmarks using the Balanced Scorecard. The practical part describes the development of Business Intelligence solution starting with identifying potential customer as a wholesale distributor company and setting the requirements for BI. The practical part continues through the design of a data warehouse in MS SQL Server, creation of data pump connected to the MS Dynamics NAV database, filling the data warehouse, OLAP cubes creating and ends with an example of output reports form working solution using MS Excel 2013.

The diploma thesis Risks of using VaR models for portfolio management is focused on estimation of the portfolio VaR using basic and modified methods. The goal of this thesis is to point out some weakness of the basic methods and to demonstrate the estimation of VaR using improved methods to overcome these problems. The analysis will be perform theoretically and in practice. Only market risk will be the subject of the study. Several simulation and parametric methods will be introduced.

This thesis focuses on the data warehouse of an extensive bank intitution from its operational management point of view (for the main part). To grasp the fast overview of the data warehouse the thesis includes the description of its data architecture, transformation processes and the way of presenting data to its users. Besides that the description of systems used for both the business data and for the metadata purposses is also included in this thesis. The thesis also covers operational activities including the identification of weak areas and their improvements. Another part of the thesis is represented by the project of optimization of a scheduling mechanism (Master Workflow) for running transformation processes, that helps to minimalize the metadata load of the Teradata database system. The main goal of this thesis is to describe the environment of the data warehouse in an understandable way. It's critical to understand the environment for both, the operational management personnel and for developers, that can supply the warehouse with higher quality solutions and ease the deployment of new deliveries into the production environment. This goal is achieved by the description of the data warehouse (mainly the description of its data architecture, transformation processes, operational activities and tools used to deploy changes into the production environment). Another goal is to give a feedback on the operational activities from the operational personnel point of view. This helps identify weak spots and can lead to its elimination. The last goal is to improve the scheduling mechanism that controls and runs all transformation processes. This goal is achieved by a project. The thesis describes the starting state, implemented changes, final state and the consideration whether the project was successful or not. The thesis brings several contributions: easier understanding of the data warehouse and the way of managing ETL processes -- for the operational management personnel and developers, which can bring the improvement of new solutions. The possibility of elimination of weak areas in the operational activities. And thanks to the project described there are two changes -- standardization and the metadata load of Teradata decreased. My own contribution to this issue is, besides the useful introduction to the data warehouse, the identification of the weak areas, suggested improvements and also the project of optimization Master Workflow which took about 17 MD. The thesis is devided into chapters based on the topics described: introductory information, theoretical base, characteristics of the main systems, the description of the data warehouse, the description of operational activities including the identification of weak areas, and at the end there is the project of optimization of Master Workflow. In the last chapter there is the final conclusion of the entire thesis.

The subject of the thesis is the proof of concept of Business Intelligence (BI) implementation in the Communications service department from the Kapsch BusinessCom s.r.o. company. The aim of the work is developing a BI proof solution and consequently producing an output for the final users. The main outcome of the thesis is operating BI solutions used in practice. The solution was carried out using tools MS SQL Server 2008 R2 Management Studio, MS SQL Server 2008 R2 Business Intelligence Development studio and MS Excel 2007. The project analyses the data obtained from the ERP (Enterprise Resource Planning) database acquired from the MS Dynamics Navision system. Information on "Voice" projects from the Communications service department, which mainly focuses on the service of PBXs and similar products, are recorded in the project among others. A multidimensional analysis was carried out, data warehouse was designed, data pumps were created, OLAP (On-line Analytical Processing) block and output in the Microsoft Excel 2007 program were carried out during the project.

Cílem této diplomové práce je vytvoření Business Intelligence řešení pro společnost 1188. Na základě výsledného Business Intelligence řešení bude umožněno managementu společnosti vykonávat přesnější rozhodnutí, která se budou shodovat se strategií společnosti.

The aim of this master thesis was to design and develop decision making solution (Business Intelligence) for company Toprecepty.cz. Thanks to this solution, company management will have the ability to produce better decisions based on gained analytical information.