In this thesis the candidate explores the apparent gaps between strategy development and strategy implementation (the strategy alignment question), and between business end-user needs and the suppliers of information technology (IT) related products and services. With business intelligence (BI) emerging as one of the fastest growing fields in IT, the candidate develops a conceptual model in which BI is placed into context with other relevant subjects such as strategy development, enterprise architecture and modelling and performance measurement. The emphasis is on the development of processes and templates that support a closed loop control system with the following process steps: - A business strategy is defined. - The implication of the strategy on business processes, supporting IT resources and organizational structure is formally documented according to enterprise architecture principles. - This documented blueprint of the organization helps to implement the selected business strategy. - A performance measurement system is developed and supported by a well-designed data warehouse. - On a regular basis the measurements that were defined to support the implementation of the strategy, together with information from the external environment are interpreted and this analysis leads to either a new strategy, or refinement of the implementation of the existing strategy. Both options may lead to changes in the enterprise architecture, the execution of business processes and/or the performance measurement system. Some of the individual components of the model are supported by existing theories, for example the Zachman Framework for enterprise architecture and the Balanced Scorecard from Kaplan and Norton. The contribution of the author was to position them in the bigger picture to indicate how they can add value with regard to the establishment of business intelligence in organizations. Instead of packaging existing ideas slightly differently under a new name, the author intentionally searched for existing theories to fulfil certain requirements in the Bigger Picture BI Context Model. Apart from a set of templates that were adapted from various other sources and packaged into practical formats that can be used during facilitation sessions, the author has also developed and described the Fourier Model and the Pots of Money Model. The Fourier Model is a powerful conceptual model that helps a business to package solutions for market related requirements through selections of previously defined building blocks (technical components) that can be delivered through various business entities, depending on the requirements of the opportunity. The Pots of Money Model is a quantitative model embedded in a spreadsheet format to illustrate and communicate the effect of spending decisions in one area of the business on other areas. The candidate demonstrates the Bigger Picture BI Context Model in several case studies. The thesis is accompanied by a CD ROM, which contains over 700 references to relevant literature (most of them available in full text) and links to internet web sites, as well as examples of the software templates that support some of the steps in the context model. The following figure depicts the conceptual model in schematic format: (See figure in the abstract of 00front) / Thesis (PhD (Industrial Engineering))--University of Pretoria, 2006. / Industrial and Systems Engineering / unrestricted

Avec la montée en charge de l’informatisation des systèmes d’information hospitaliers, une quantité croissante de données est produite tout au long de la prise en charge des patients. L’utilisation secondaire de ces données constitue un enjeu essentiel pour la recherche ou l’évaluation en santé. Dans le cadre de cette thèse, nous discutons les verrous liés à la représentation et à la sémantique des données, qui limitent leur utilisation secondaire en cancérologie. Nous proposons des méthodes basées sur des ontologies pour l’intégration sémantique des données de diagnostics. En effet, ces données sont représentées par des terminologies hétérogènes. Nous étendons les modèles obtenus pour la représentation de la maladie tumorale, et les liens qui existent avec les diagnostics. Enfin, nous proposons une architecture combinant entrepôts de données, registres de métadonnées et web sémantique. L’architecture proposée permet l’intégration syntaxique et sémantique d’un grand nombre d’observations. Par ailleurs, l’intégration de données et de connaissances (sous la forme d’ontologies) a été utilisée pour construire un algorithme d’identification de la maladie tumorale en fonction des diagnostics présents dans les données de prise en charge. Cet algorithme basé sur les classes de l’ontologie est indépendant des données effectivement enregistrées. Ainsi, il fait abstraction du caractère hétérogène des données diagnostiques initialement disponibles. L’approche basée sur une ontologie pour l’identification de la maladie tumorale, permet une adaptation rapide des règles d’agrégation en fonction des besoins spécifiques d’identification. Ainsi, plusieurs versions du modèle d’identification peuvent être utilisées avec des granularités différentes. / With the increasing adoption of Electronic Health Records (EHR), the amount of data produced at the patient bedside is rapidly increasing. Secondary use is there by an important field to investigate in order facilitate research and evaluation. In these work we discussed issues related to data representation and semantics within EHR that need to be address in order to facilitate secondary of structured data in oncology. We propose and evaluate ontology based methods for heterogeneous diagnosis terminologies integration in oncology. We then extend obtained model to enable tumoral disease representation and links with diagnosis as recorded in EHR. We then propose and implement a complete architecture combining a clinical data warehouse, a metadata registry and web semantic technologies and standards. This architecture enables syntactic and semantic integration of a broad range of hospital information System observation. Our approach links data with external knowledge (ontology), in order to provide a knowledge resource for an algorithm for tumoral disease identification based on diagnosis recorded within EHRs. As it based on the ontology classes, the identification algorithm is uses an integrated view of diagnosis (avoiding semantic heterogeneity). The proposed architecture leading to algorithm on the top of an ontology offers a flexible solution. Adapting the ontology, modifying for instance the granularity provide a way for adapting aggregation depending on specific needs

The main objective of this thesis is to create a list of critical success factors (CSF) of Business Intelligence implementation in the non-commercial sector and check this list in practice on real projects. Part of the thesis is also the summary of all specifics and differences of BI implementation in public sector and the view of usage possibilities of BI in this sector in relationship on already implemented projects in the Czech Republic so and abroad. The thesis is composed of theoretical and practical part. Theoretical part is focused on problems related to this area, especially analyses the present state of BI in public sector and features specifics and differences related to BI implementation in this area. Further also describes all significant critical success factors of BI implementation in general. Practical part is then aimed on particular verification of Business Intelligence CSFs on real projects realized in non-commercial sector inside of the Czech Republic. As a main tool for obtaining needed and objective information were used managed interviews with competent deputies of submitter (customer) and supplier of particular BI solution. The main contribution of this thesis is determination of differences, but also consistent components of Business Intelligence implementation in non-commercial sector compared to private sector with emphasis on critical success factors. Significant is also the comprehensive view of possibilities and advantages of BI usage in public sector, created by analysis of already implemented projects. These achieved results can be utilized by future (and contemporary) suppliers and submitters of BI projects, but also of other projects from information science area.

This thesis addresses issues of measuring and managing the performance of commercial bank institutions by means of a system called Corporate Performance Management (CPM). The theoretical part of this work is devoted to introduction of banking industry and methods of performance measurement in commercial banks. It introduces a general concept and key components of CPM supported by Business Intelligence technology. In the practical part of this work there is introduced the design of two concrete CPM solutions which are being currently built in banks -- KPI processing and interest margin calculation. The main thesis contribution to the existing literature is a creation of complex material about relevant aspects of implementation CPM solutions in data warehouses of commercial banks and creation the conceptual design of a concrete solution.

The objective of this thesis is a complete implementation of the Financial and Property Analysis of Municipalities (FAMA) methodology using open-source Business Intelligence (BI) tools. The FAMA methodology was developed at the Institute of Public Administration and Regional Development at University of Economics in Prague and monitors wide range of aspects of management of municipalities. The main objective of this work is to create an application that would allow users to clearly analyze the management of municipalities with indicators of this methodology, using open source BI tools. The first, theoretical part, consists of two parts. The first half of the theoretical part of this thesis is devoted to the analysis of municipal finances and describes the FAMA methodology itself. Furthermore, methods used by the Ministry of Finance to evaluate municipalities are described. The second half of the theoretical part introduces readers to principles and components used in BI, some of which are used in the actual implementation. The second, practical part, initially deals with selection of suitable open-source BI tools and these tools are subsequently used to create an application that is used to analyze the management of municipalities. The implementation itself is divided into several parts. Firstly an initial study is performed, which is based on analysis of source data and user requirements. Based on the initial analysis, data warehouse is designed. Subsequently, an ETL project is created to process financial reports of municipalities and store them in the data warehouse. After filling the data warehouse, several OLAP cubes are created, which are used for multidimensional data analysis and finally, the presentation layer of the application is introduced and suitable graphical outputs for data presentation are designed. The main contribution of this thesis is the actual implementation of the FAMA methodology using the selected tools. The solution includes all indicators of the methodology and covers financial data of all municipalities of the Czech Republic in the years 2001 to 2012. Due to the scope of this work, a complete solution was made, that is ready for use.

The diploma thesis focuses on a proposal for a methodological framework of reporting management in the banking sector and identifying key weaknesses of the current state. Using the proposed methodology precedes weaknesses and proves it on practical example from the real environment. The main benefit of this work is design of a methodological framework that allows the organized management and control of the reporting. It also brings identification of main weaknesses of the current reporting and last but not least universal template for the report specification. The work consists of three parts. The first, theoretical, defines area of reporting in a banking institution. It includes all the terminology, characteristics and types of reports. The second part, analytical, examines the current weaknesses of reporting within the defined area. Provides an overview of three to six major weaknesses in a particular phase of a new report development based on the scientific literature and practical experience of the author of this work in the banking environment. The third and final section contains a draft concept of reporting management in the banking sector with avoidance of the identified weaknesses from the analytical part.

This diploma thesis is focused on the application of a system approach, which was configured by the author. Configured approach was used to analyze project of implementation of data warehouse tool. Dynamics of the project delivery system was shown by causal loop diagram and then by system dynamics model. Thesis defined and used terms like system, system complexity, system approach, system approach configuration, causal loop diagram, system dynamics model, system archetype of shifting the burden, data warehouse and its definition against a database definition, project, project organizational structures, methods and their necessity in implementation of information systems projects, feasibility of the information system projects and problems with measurement of project performance. Time-proportional simulation of system dynamics model quantified effects of factors and also quantified different results of project implementation approaches. Based on the analyzed project was provided a brief general recommendations for information systems projects.

This diploma thesis deals with usability of the SAS system and its components for building and running data warehouse and complete solution of Business Intelligence. In the beginning it introduces the meaning and benefits of putting on Business Intelligence and its spot in an organization. It especially focuses on the running BI project in Kooperativa, a.s., insurance company. The main goal of this thesis is to aim on ETL processes of data warehouse, their specificity, characteristics and regular tasks solved across data layers, measuring their performance and feasibility of ETL optimalization. This optimalization can be considered from two different points of view – the first is a creation and maintenance of the ETL source code, the second is tuning for faster data processing. Log files, which are are the main source for performance monitoring, are processed by macroprogram specially tailored to this particular reason. Gained results are analyzed and on that basis I outline spots that need attention. The last part offers comparison of some alternatives to data transformation process typically solved by ETL tasks. Acquired results could be taken as hints used in designing and tweaking other akin ETL processes.

Nesta dissertação, são discutidas as vantagens e dificuldades de um Sistema Gerencial de Apoio a Decisão em um ambiente Intranet/Internet, sua execução, bem como a utilização de aplicações de bancos de dados na web. Um sistema dessa natureza, denominado SAG (Sistema de Apoio Gerencial), foi concebido para dar suporte às atividades de gerência, supervisão e controle da rede de distribuição de energia elétrica da Eletropaulo Metropolitana (São Paulo, Brasil). O SAG possibilita o estabelecimento de uma sistemática de supervisão, visando, a partir da análise das condições atuais da rede de distribuição e em função dos recursos disponíveis, permitir o acompanhamento da evolução da qualidade do fornecimento de energia elétrica. Disponibilizando informações que irão orientar ações para corrigir os possíveis desvios inadequados e fixar políticas e diretrizes a serem seguidas nos níveis gerenciais. Como resultado, é esperado tornar mais ágil o processo decisório, bem como o acesso a dados técnicos e de carregamento dos equipamentos da rede de distribuição. / In this dissertation are discussed the advantages and difficulties of an Executive Information System (EIS) implementation on an Intranet or Internet environment, as well as the use of Database applications on the web. An Executive Information System named SAG was implemented at Eletropaulo Metropolitana (São Paulo, Brazil); it was conceived to address maintenance, operational and engineering departments\' needs. The System allows the establishment of a systematic supervision to attend the quality of the electric energy supplied. The analysis of the actual distribution network conditions, the available resources and the electric energy supplied quality will guide the actions to correct possible inadequacies as well as set and fix policies and guidelines to be followed on a manager\'s level. As a result it\'s expected faster decision-making process and access on distribution network equipment\'s technical data and load.

A utilização de bases de dados para estudos epidemiológicos, avaliação da qualidade e quantidade dos serviços de saúde vem despertando a atenção dos pesquisadores no contexto da Saúde Pública. No Brasil, as bases de dados do Sistema Único de Saúde (SUS) são exemplos de repositórios importantes que reúnem informações fundamentais sobre a Saúde. Entretanto, apesar dos avanços em termos de coleta e de ferramentas públicas para a pesquisa nessas bases de dados, tais como o TABWIN e o TABNET, esses recursos ainda não fazem uso de técnicas mais avançadas para a produção de informação gerencial, como as disponíveis em ferramentas OLAP (On Line Analytical Processing) e de mineração de dados. A situação é extremamente agravada pelo fato dos dados da Saúde Pública, produzidos por vários sistemas isolados, não estarem integrados, impossibilitando pesquisas entre diferentes bases de dados. Consequentemente, a produção de informação gerencial torna-se uma tarefa extremamente difícil. Por outro lado, a integração dessas bases de dados pode constituir um recurso indispensável e fundamental para a manipulação do enorme volume de dados disponível nesses ambientes e, assim, possibilitar a produção de informação e conhecimento relevantes, que contribuam para a melhoria da gestão em Saúde Pública. Acompanhar o seguimento de pacientes e comparar diferentes populações são outras importantes limitações das atuais bases de dados, uma vez que não há um identificador unívoco do paciente que possibilite executar tais tarefas. Esta Tese teve como objetivo a construção de um armazém de dados (data warehouse), a partir da análise de dez anos (período de 2000 a 2009) das principais bases de dados do SUS. Os métodos propostos para coleta, limpeza, padronização das estruturas dos bancos de dados, associação de registros ao paciente e integração dos sistemas de informação do SUS permitiram a identificação e o seguimento do paciente com sensibilidade de 99,68% e a especificidade de 97,94%. / The use of databases for epidemiologic studies, quality and quantity evaluation of health services have attracted the attention of researchers in the context of Public Health. In Brazil, the databases of the Sistema Único de Saúde (SUS) are examples of important repositories, which store fundamental information about health. However, despite of the advances in terms of load and public tools for research in those databases, such as TABWIN and TABNET, these resources do not use advanced techniques to produce management information as available in OLAP (On Line Analytical Processing) and data mining tools. The situation is drastically increased for the fact that data in public health, produced for different systems, are not integrated. This makes impossible to do research between different databases. As a consequence, the production of management information is a very difficult task. On the other hand, the integration of these databases can offer an important and fundamental resource to manipulate the enormous volume of data available in those environments and, in this way, to permit the production of relevant information and knowledge to improve the management of public health. The patient follow up and the comparison of different populations are other important limitations of the available databases, due to the absence of a common patient identifier. The objective of this Thesis was the construction of a data warehouse to analyze ten years (period from 2000 to 2009) of the principal databases of SUS. The proposed methods to load, clean, database structure standardization, patient record linkage and SUS information systems integration have been permitted patient identification and follow up with sensitivity of 99.6% and specificity of 97.94%.