Abstract This diploma thesis treats about the latest technologies in the field of self-service BI from Microsoft Corporation. The main goal of this work is to analyze the Microsoft self-service BI solutions, to describe the benefits and advantages of this technology and to show examples with real data in Microsoft self-services BI tools. To achieve the goal, the internet resources, recommended literature, and the software applications PowerPivot and PowerView (Excel 2013) are59 used. In its first part this thesis describes the basic characteristics and technology of classical BI solutions. The second part examines the actual self-service BI solution and its usability. And then analyzes the advantages and benefits compared to conventional technologies. Finally, in its last section describes self-service BI solutions, the DAX language used in PowerPivot and shows example reports with real data from banking sector. The key benefit of this diploma is the verification of the usability and advantages of self-service BI by using Microsoft self-service BI products and tools.

This thesis is focused on the design of Business Intelligence solution to the logistics sector. Its main goal is to enable the unnamed central-bohemian company, which deals with truck road transportation, to follow up and evaluate its data better. The theoretical part is focused on the basic principles of Business Intelligence and on the analysis of current market situation. The next section is dedicated to the specifics of this problematic in the logistics field. The practical part deals with the design of Business Intelligence solution to the concrete company. The analysis of company preparedness for Business Intelligence and the specification of requirements on its solution precede the resultant reporting tool. There is the unification of company's data in the form of data warehouse and the design of individual indexes and dimensions, from whose point of view data will be monitored. The main benefit of this thesis is resultant solution in the form of reporting tool, which can company, that is not familiar with the problematic of Business Intelligence, use as its future advantage.

This thesis deals with the design of the pilot Business Intelligence solution for e-commerce platform Shopio. The first part describes the theoretical concepts of Business Intelligence and e-commerce focused on possible approaches to performance measurement of electronic commerce. Furthermore there is a comparison of analytical tools for measuring performance of e-shops which are available on the Czech market. The second part of the thesis first describes the e-commerce platform and the current status of the reporting module. Then the requirement analysis is conducted for the purpose of identifying the current company client's needs and requirements. The new Business Intelligence solution is designed based on the identified requirements described in the previous chapters. This solution is then tested and verified with the use of real e-shop data. The main purpose of this thesis is to refine the current status of the reports and provide a better tool to measure the e-shop performance for the e-shop owners.

The thesis focuses mainly on OLAP technology and its tools using to analyze corporate data. One of the objectives is to define the analytical tools market and provide an overview which shows the current situation concerning those tools on Business Intelligence (BI) market. Another objective is to obtain an overview of some current and future trends in the BI market. The main purpose of the thesis is to create a "methodology" for solving an BI analytical tasks using analytical services in SQL Server 2008 R2 from Microsoft. To achieve these objectives a theoretical analysis of available resources and, in particular consultation with employees of Clever Decision company is used. The main contribution of this work is the development of analytical database itself, which is divided into separate phases where each phase contains best practices and recommendations, including examples.

This master's thesis focuses on the issues of selecting the Business Intelligence tools distributed under open source licenses. The main objective of this work is to compare the different instruments in all layers of the Business Intelligence architecture. The first part is focused on the definition of key concepts of the main topic. Provides necessary theoretical basis for understanding the context used in the practical part, which is dedicated to comparison tools realized according to the established methodology. These tools are selected and compared with predetermined criteria. Then each tool is introduced and verbally and numerically compared with others. At the conclusion of each comparison group of instruments referred to their final assessment and recommendations. This work is intended to provide the information base needed to select the proper tools to create a complete BI solution.

This thesis deals with the analysis and display of multidimensional data. In the theoretical part, the issue of data mining, its tasks and techniques, and a brief explanation of the terms Business Intelligence and data warehouse are presented. The issue of databases is also described in this thesis. Subsequently, the options for displaying multidimensional data are described. At the end of the theoretical part is briefly explained the problems of optical networks and especially the terms Gigabit passive optical network and its frame, because the data from the frames of this network will be displayed by an application. In the practical part, you can find creating a source database and an application to create a OLAP cube and display multidimensional data. This application is based on the theoretical knowledge of multidimensional databases and OLAP technology.

This master’s thesis deals with comparison of the standard Business Intelligence platform specifically IBM Cognos BI and BI module integrated in the ERP system QI. In the first part it defines basic concepts of this topic and describes the life cycle of business information systems with emphasis on Business Intelligence. In the next part current situation on the market of these platforms and BI tools which create management information systems is described. Both types of BI solutions are compared with concentration on standard functionality usage. It also describes their ability to analyze through using data warehouse technology, integration with third-party products and business and economic aspects.

Aim of master’s thesis is design of Business Intelligence solution based on non commercial technology, consideration of installation costs, estimation of economic benefits and designing of final solution of currently unsatisfactory situation in company Fortemix s.r.o.

Designing and creating the finished OLAP solutions within Business Intelligence for an undertaking by the customer's requirements using standard technologies and practices that are designed for this purpose. This work describes the work of the design, creation and deployment of the finished project Business Intelligence solution that allows the customer to perform more accurate analysis of their own data in the context of controlling.

The thesis deals with a decision making support in CRM systems. The goal of this thesis was to design a module for decision making support in the CRM system using Pentaho analysis tools. The theoretical part contains a description of the data warehousing and data mining with a focus on analytic operations and decision making support. It also contains brief description of CRM systems and possible application of decision making support in these systems. The practical part deals with the description of architecture of CRM system CRMminer and describes the decision making support module in this system.