The present thesis deals with the specifics of Data Warehouse enhancement in a bank. The aim of the thesis is a definition of the general specifics of banks, their Business Intelligence and Data Warehouse enhancement compared to other companies. The thesis is divided into seven parts. The first part describes the theoretical basis of banking and Business Intelligence. The second part defines the general specifics of banks and their informatics compared to other companies. Then Business Intelligence in a bank, its architecture and enhancement are explored. In the fourth part a conceptual data model of Data Warehouse in a bank is introduced and described in detail. Afterwards the main source systems of Data Warehouse are identified and matched to the subject areas of the data model. The sixth part discovers important application areas of Business Intelligence usage and mentions the basic indicators. The last part presents a case study (a project of Data Warehouse enhancement in a bank). The result of this thesis is clear description of the Data Warehouse in a bank, its data model, source systems, application areas and enhancement.

The main objective of this diploma thesis is the implementation of a pilot solution of Business intelligence in the laboratory company. This company is providing tests of samples of blood and urine. The diploma thesis is divided into two main parts. The first part contains theory. It describes the usage and components of the Business intelligence. Additionaly it describes the method Balanced scorecard and its usage in laboratory companies. The second part contains practical solution. At first there is a description of the company where is the solution implemented. In the next step the goals and metrics are determined on basis of the application of the method Balanced scorecard. The strategic map is created based on company goals. The last chapter contains a description of the implementation of the pilot solution and the description of created reports.

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.

Diploma thesis deals with the application of principles and tools of business intelligence in the management and control process of the hospital facilities. In term of the definition of problem areas in the management and control process of the hospital is proposed concept of streamlining the current state, which consists of the methodological unification of the main control and managing areas, in the implementation of consolidated data structure (data warehouse) and reporting tool above the primary systems. Practical application of the analyzed areas is demonstrated in the practical part of diploma thesis, which is devoted to the real implementation of management information system in five regional hospitals in the Czech Republic. The main benefit of this thesis is the definition of the problem areas in the management and control process of hospital facilities, which can be made more effective by applying the principles and tools of business intelligence, and personal appreciation of the author's practical experience with the implementation of business intelligence solutions in healthcare facilities.

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.

Diploma thesis is about creation of support software integrated into gaming system. Thanks to non-existence of documentation of chosen gaming information system, untraditional method of software creation had to be used. The method is described by this thesis. Main objective of the thesis is creation of supporting application that generates aggregated data, stores it to a data warehouse and presents it to its users. All of this development is done using defined method. Thesis is divided in two main parts. The first one contains analysis of gaming information system. This analysis is used in the second part of the thesis, which describes how was the developed software designed and implemented. All analysis in the thesis are important part of the final product development and the product can be created thanks to them. Created application is unique in its domain and brings view at an untraditional development of this support software. Thanks to its uniqueness, created software can help with inspiration for next development in this domain.

This study addressed issues associated with implementing multiple data integrators. The process included implementing the same data integrator multiple times or implementing multiple different data integrators. It was shown that single data integrators implementations were failing at high rates. Environments were complicated because there were more acquisitions and mergers now than in the past, companies were required to be competitive while implementations were taking place, and possibly had short implementation time frames. The main goal of this study was to develop an agile, sturdy, and rigorous model that addressed the needs of companies that found themselves in situations where they needed to implement two or more data integrators and possibly business initiatives. This researcher developed a model and a questionnaire. The questionnaire was used to gather data from managers and practitioners in the information technology industry. The collected information was expected to show a consensus about the proposed JBurns Systems Implementation Model (JBSIM). Analysis showed various industry participants used different combinations of the proposed data integrators supported and they supported the proposed JBSIM. This model allowed for successful implementation of multiple data integrators used in this research. As this model matured, it had the potential that allowed the use of other data integrators not used in this research. It had potential that allowed corporate initiatives to be used.

La réutilisation des données de soins pour la recherche s’est largement répandue avec le développement d’entrepôts de données cliniques. Ces entrepôts de données sont modélisés pour intégrer et explorer des données structurées liées à des thesaurus. Ces données proviennent principalement d’automates (biologie, génétique, cardiologie, etc) mais aussi de formulaires de données structurées saisies manuellement. La production de soins est aussi largement pourvoyeuse de données textuelles provenant des comptes rendus hospitaliers (hospitalisation, opératoire, imagerie, anatomopathologie etc.), des zones de texte libre dans les formulaires électroniques. Cette masse de données, peu ou pas utilisée par les entrepôts classiques, est une source d’information indispensable dans le contexte des maladies rares. En effet, le texte libre permet de décrire le tableau clinique d’un patient avec davantage de précisions et en exprimant l’absence de signes et l’incertitude. Particulièrement pour les patients encore non diagnostiqués, le médecin décrit l’histoire médicale du patient en dehors de tout cadre nosologique. Cette richesse d’information fait du texte clinique une source précieuse pour la recherche translationnelle. Cela nécessite toutefois des algorithmes et des outils adaptés pour en permettre une réutilisation optimisée par les médecins et les chercheurs. Nous présentons dans cette thèse l'entrepôt de données centré sur le document clinique, que nous avons modélisé, implémenté et évalué. À travers trois cas d’usage pour la recherche translationnelle dans le contexte des maladies rares, nous avons tenté d’adresser les problématiques inhérentes aux données textuelles: (i) le recrutement de patients à travers un moteur de recherche adapté aux données textuelles (traitement de la négation et des antécédents familiaux), (ii) le phénotypage automatisé à partir des données textuelles et (iii) l’aide au diagnostic par similarité entre patients basés sur le phénotypage. Nous avons pu évaluer ces méthodes sur l’entrepôt de données de Necker-Enfants Malades créé et alimenté pendant cette thèse, intégrant environ 490 000 patients et 4 millions de comptes rendus. Ces méthodes et algorithmes ont été intégrés dans le logiciel Dr Warehouse développé pendant la thèse et diffusé en Open source depuis septembre 2017. / The repurposing of clinical data for research has become widespread with the development of clinical data warehouses. These data warehouses are modeled to integrate and explore structured data related to thesauri. These data come mainly from machine (biology, genetics, cardiology, etc.) but also from manual data input forms. The production of care is also largely providing textual data from hospital reports (hospitalization, surgery, imaging, anatomopathologic etc.), free text areas in electronic forms. This mass of data, little used by conventional warehouses, is an indispensable source of information in the context of rare diseases. Indeed, the free text makes it possible to describe the clinical picture of a patient with more precision and expressing the absence of signs and uncertainty. Particularly for patients still undiagnosed, the doctor describes the patient's medical history outside any nosological framework. This wealth of information makes clinical text a valuable source for translational research. However, this requires appropriate algorithms and tools to enable optimized re-use by doctors and researchers. We present in this thesis the data warehouse centered on the clinical document, which we have modeled, implemented and evaluated. In three cases of use for translational research in the context of rare diseases, we attempted to address the problems inherent in textual data: (i) recruitment of patients through a search engine adapted to textual (data negation and family history detection), (ii) automated phenotyping from textual data, and (iii) diagnosis by similarity between patients based on phenotyping. We were able to evaluate these methods on the data warehouse of Necker-Enfants Malades created and fed during this thesis, integrating about 490,000 patients and 4 million reports. These methods and algorithms were integrated into the software Dr Warehouse developed during the thesis and distributed in Open source since September 2017.

This master’s thesis focuses on monitoring and profiling multidimensional database and reports. The project was created in MS SSIS to this purpose and it contains 4 ETL packages. The thesis is divided into three main sections. First section consists of theoretical background needed to accomplish the goal. In second section there is analysis of the company for which is the solution created and in the third part of the thesis there is described the proposal and it’s solution. Proposal of the solution and the solution itself was created in MS Visual Studio 2015, MS SQL Management Studio and Power BI.

Master's thesis focuses on BI projects maintenance optimization of company Intelligent Technologies s.r.o., which is one of the leading suppliers of Business Intelligence and Data Warehousing solutions in Czech Republic. The thesis is divided into three main sections – theoretical, analytical and practical. The main goal of these sections is an explanation of important concepts that are necessary to understand the solution, which is being created, analysis of the current state of selected company and detailed description of creating main solution. In this thesis following Microsoft programs were used - Visual Studio 2015, SSIS, SQL Server Management Studio 2017 and Power BI.