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.

The Thesis deals with a relatively new approach to managing groups of projects / programs as a portfolio, which comes from the general Theory of portfolio. The main objective of this Diploma Thesis entitled ICT Project Portfolio Management: Theory and Application in the Czech banking sector is to provide a theoretical base of affecting the most important knowledge about the problems of portfolio management of ICT projects with a focus on the operational level. The second main objective of the Thesis is to design the optimal process management (sub) portfolio of ICT projects at the operational level in the Business Intelligence department -- the separate organizational unit in Komercni banka, a.s. This Thesis is beneficial to its readers for the processing of international standard entitled Portfolio Management. This standard has never been previously treated at the University of Economics in Prague. The Thesis is thanks to processing of other expert information sources full of new, timely and quality information about this theme that is compatible with international standards. In addition to the theory the reader is enriched by a practical demonstration of application portfolio management at Komercni banka, a.s., one of the leading banking institutions in the Czech Republic The contribution of the Thesis for Komercni banka, a.s., specifically for the Business Intelligence department, consists in the identification of constraints in the process (sub) portfolio management of BI projects with a proposal of their optimization.

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.

Business Intelligence is one of the fastest growing areas of computer science. Corporate Performance Management (CPM) is often referred as next-generation of Business Intelligence (BI). Recently leading vendors of BI and CPM software and applications were primarily engaged in creating products for large enterprises and corporations. However, now they have also started to aim at the segment of SMEs (small and medium enterprises). This thesis analyzes the CPM market in segment of small and medium enterprises. Introductory part deals with my own research. This research was conducted on a sample of firms from SME whose business activities are within the same industry. The research focuses on the expectations and demands from reporting tools and CPM applications. The second half of the chapter is evaluating the information obtained, which will serve in the next section. The second part introduces principles of corporate performance management (CPM), describing the basic functionality that CPM applications cover and showing which added value is offered to companies. Furthermore, this chapter focuses on market analysis and identification of the main vendors of CPM applications for small and medium-sized businesses. The final part of the chapter defines criteria for evaluating CPM tools for reporting. The final part of diploma thesis has a practical character. It describes installation and setting up BI/CPM suite of applications from two chosen vendors and shows possibilities in their tools for creating reports. Finally these reporting tools are compared by predefined criteria from the previous chapter.

The main objective of the thesis is to present SaaS business intelligence as a set of concepts and methods aimed at improvement of business decision making process based on Software as a Service model. To understand this, it's important to describe first general principles, on which are based conventional so-called on-premises solutions and the means how they work. It's also necessary to present Software as a Service as today's very popular software deployment model. Further objective is the description of these solutions, introduction of their strengths, weaknesses and guidelines how to choose a suitable service provider. Final objective of the thesis is to compare these two different methods of BI tools deployment, in that case on-premises and on-demand and to sketch out means, following them will be possible to decide for one of the methods.

This diploma thesis deals with performance dashboards and QlikView tool which serves for creation of these dashboards. The work is divided into seven parts. The first and the second part together focus on defining the theoretical foundations of Business Intelligence and Corporate Performance Management, which create basis for performance dashboards. The focus of the third part lies in definition of term performance dashboard and clarifying its major advantages and benefits for a company. An important part is also the description of performance dashboard composition in terms of their usability, layered structure and division into various types. The forth part analyses existing criteria for evaluating of tools dedicated for creation of dashboards. Its goal is, according to the forgone analysis, to make the own list of criteria for evaluating these tools. The aim of the fifth part of this work is to describe QlikView platform. It provides a brief overview of the platform in terms of its most important components and their purpose and also provides an insight into basic architecture of this platform and compares it with traditional BI solutions. The sixth part describes basic principles of work in QlikView. Its goal is to demonstrate the basic procedure of dashboards creation in this environment on sample examples, which should also serve as a simple guide for beginner users of this tool. The last seventh part deals with evaluation of QlikView solution. Its main purpose is to review possibilities and capabilities of this tool for dashboard creation according to the predetermined criteria which are applied to the tool during its evaluation.

The thesis deals with the topic of social networks, particularly with the opportunities the utilisation of social network data can provide to an enterprise. The thesis is divided into two parts: The theoretical part contains definitions of the terms of data, information and knowledge, followed by descriptions of Business Intelligence and Big Data -- the two means of data analysis in an enterprise, and later by describing social networks themselves. The practical part contains an analysis of the data provided by social networks Facebook and Twitter, and at the same time defines the process of data extraction. The outcome of the analysis is a set of data that may possibly be obtained by the enterprise. This data is then used to determine the possible ways in which enterprises can leverage the data for their business. Finally data provided by Czech e shop is used to provide an example of how an entity can utilise social network data.

The final thesis focuses on the issue of measuring efficiency in the delivery of information and communication services in one of the multinational banking institutions operating within Czech market, particularly in the context of its information technology department. Measuring of the effectiveness is demonstrated on built Business Intelligence (BI) solution. The main goal of this work is therefore the development and implementation of BI solution that provides automated reporting to measure the effectiveness of mentioned department. The thesis is divided into two parts -- theoretical and practical. Theoretical part focuses on BI basics, efficiency measurement models, ITIL and issue of SLA. In the practical part there is development of BI solution described with the entire application life cycle demonstration. Benefit of the final thesis is mainly in the deployment of BI product in real company. For of a wider audience is the key benefit contained especially in the theoretical part where the basic information of BI and performance measurement possibilities can be found.

My thesis deals with comparison with Business Intelligence software for data visualization for Microsoft platform to selected open source product. The aim of my thesis is to find visualization software that is suitable for small company and firm can handle visualization by itself. At first there is introduction to issues of Business Intelligence following description of visualization resources of Microsoft platform, specifically Excel, Power View, Power Map and Reporting. Subsequently open source software was chosen that is able to compete with visualization products of Microsoft platform specifically CDE Dashboard from Pentaho platform. There are compared chosen products via proposed scenario and evaluated standards. Finally there are evaluated suitability of individual software for data visualization.

Diploma thesis deals with the implementation of Key Performance Indicators (KPIs) throught the Balanced Scorecard method in IT company. The thesis is divided into theoretical and practical part. The theoretical part focuses on the definition of terms related to the Performance Measurement and the Performance Management. The fourth chapter presents the Balanced Scorecard and its perspectives. The next section deals with the types of indicators and furhter focuses on the KPIs description. The practical part applies the theoretical knowledge gained in previous chapters into practice. The sixth chapter focuses on the analysis of the current position of the company and defines its strategic objectives, KPIs and strategic map. The seventh chapter focueses on the implementation of the solution in graphical form as application in QlikView.