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.

Main objective of the theses is pilot solution for implementations of Business Intelligence in to the Business company. The company is selling gastronomic appliances and realizes complete functioning of public alimentation , including services. The theses is devided in two parts. First part is theoretical summary of methods Balanced Scorecard and Business Intelligence. Theoretical part includes the chapter which explain operation and possibilities of Business Intelligent in small companies. The second part is practical solution, where is in the beginning introduction of the company. In the following chapters the main objective is to establish the key indicators in chosen company by using method of strategic operation of Balanced Scorecard. Next is to create strategic map, which make model for company behavior and model for usage of outputs in the course of real implementation of Business Intelligence.

The main goal of this diploma thesis is to provide advice and recommendations to increase the effectiveness of Business Intelligence using Oracle database. More specifically, the focus of the thesis is the optimization of ETL processes and objects in a data warehouse. Tests to compare different optimization techniques are performed to meet the defined goal. These tests are based on common tasks solved in data warehouses on daily basis. Tests are also supported by publications of leading authors in Oracle environment. The second goal of this work is the implementation of appropriate optimization techniques to real ETL pro-cess in order to increase its effectiveness. Performance changes are compared and measured using metrics defined for the ETL process and requirements from client. Optimization techniques presented for main objectives are used to achieve the second objective. Contri-bution of the thesis is to show the most important optimization techniques and tips that every developer should know and be able to use effectively. Another added value is au-thor's practical experiences in real data warehouse environment.

Main aim of this thesis are solutions of BI tasks in telecommunication sector. Thesis is divided into two main parts. First is theory part, which includes BI architecture and its components used in telecommunication sector. The second part is practical part that is represented by real solution and by its attitude that respects specifics of telecommunication sector. Above mentioned will be reached by getting of theoretical knowledge gained from availlable information sources as wel as by drawing of experience based on real working project. Benefit of this thesis will be transparented view of the real usage of Business Intelligence solution in telecommunication area.

京都大学 / 0048 / 新制・課程博士 / 博士(情報学) / 甲第22575号 / 情博第712号 / 新制||情||122(附属図書館) / 京都大学大学院情報学研究科社会情報学専攻 / (主査)教授 黒田 知宏, 教授 守屋 和幸, 教授 吉川 正俊 / 学位規則第4条第1項該当 / Doctor of Informatics / Kyoto University / DFAM

This diploma thesis deals with the design of a data warehouse that stores events created in the mobile app. The goal was to design an alternative to the current solution. The thesis explains concepts, mainly data warehouse terminology, which are used in subsequent chapters. An analysis of the current solution is conducted, and as well as research of available data warehouse and ETL services. Based on the results of the analysis, a suitable new solution is chosen, implemented, and tested.

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.

Master`s thesis is based on the assignment of company Honeywell to create integral system for saving and management of development documentation. Designed system will introduce data warehouse with transparent display of documents being connected with development of customer’s requirements, products and tests, test runs. Solution consists of two parts: A – Requirements and Products and B – Tests, Test runs and Person, whereas Master`s thesis deals with the part B. For system creation utilities of following programming languages were used HTML, PHP, JavaScript and database system MySQL. In the first phase was designed database structure (tables and relations between them). Except that was designed structure for authorization algorithm and integral concept of whole application was created. The second phase is realization. At first are created supporting algorithms. It is servicing database by functions, uniform displaying results from database and authorized access of users to the application. Further data library for integral display data forms, based on used template system Smarty and other libraries, f.e. attribution of the files to records in SQL tables. Important part was implementation of designed database system and related programs. In Tests and Test runs there is user interface established and individual relations between them. According to assignment all fundamental programs were designed together with support instruments. Individual source files are saved in transparent structure of folders, so this structure is possible to apply on any computer, where are installed programs to web hosting. The result of Master`s thesis is then integrated progress report together with functional source codes.

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.

This thesis focus on creating data warehouse and process of its implementation. The content is: Introduction into data warhousing, implemetation of data warehouse and process of its population.