Extract, Transformation, and Load (ETL) system is responsible for the extraction of data from several sources, their cleansing, conforming and insertion into a data warehouse. The thesis is focused on building ETL methodology to better understanding of ETL process and its application in the real environment. I've worked on project "BI Cookbook" with Clever Decision, a software consulting company that specializes in Business Intelligence. The aim was to create ETL part of the BI methodology. This methodology has been designed to provide ease of use, flexible and extensible material for the purpose of building ETL solution. The main goal of this work is to introduce created ETL methodology, all of its components and the way in which it could be used. Following goal is to discuss options of its implementation and modification for the wide range of use. The main contribution of this work is to provide ideas of creating and implementing ETL methodology or ideas for creating methodology in general. The thesis is divided into three parts. The first theoretical part deals with basic definition, architecture and implementing of ETL system. The second part presents the proposed methodology. The last part contains of the possible options for implementation a modification of the methodology.

由於科技快速進步，企業經營也隨著科技的進步而產生重大變化，不但需求變化快速，企業還要即時快速反應外在環境，於是企業對於資訊系統整合的議題越來越重視，希望將功能導向的系統轉變為流程導向的系統，將資訊有效的整合及標準化，讓企業能快速地與外在環境連結，進而提升整體營運績效。 整合的方法非常的多，大致上可分為四類。目前對於哪一種整合方法是最有效率、效益也無一定論。最主要的原因是不同的整合個案會有不同的整合需求，若只從理論方面來探討資訊系統整合所帶來的效用並無法具體地呈現其價值。 有鑑於此，本研究之目的是希望透過個案單位的作業模型，分析、建構出整合的資料模型。因此，本研究以階段性的方法設計資料整合模型及其運作方法。在第一、二階段當中，先針對個案單位的流程進行系統資料流程塑模及業務流程塑模，再從業務面及系統面找出資訊中斷的地方及因素，並將問題具體地描述出來。在第三階段中，本研究挑選了最適合此個案單位的整合方法，也就是使用資料層級（Data-Level）整合的方法，設計整合的資料模型將資訊流完整的串接起來以支援企業的決策需求。最後一階段則要利用ETL說明整合的系統運作模式，並說明此個案單位使用ETL時，可能會遇到的問題及初步的解決方法。 / Owing to rapid advances in technology, enterprises have a major change of the progress of science and technology. The enterprises not only change rapidly in demand, but also have to response to the external environment rapidly. Hence, enterprise information system integration issues get more attentions. Enterprises hope to improve their systems from function-oriented to process-oriented because the effective integration of information and standardization allows enterprises to quickly link with the external environment and to enhance the overall operating performance. However, there are many kinds of integrated approaches. At present, there is no substantive conclusion in approaches to integrate efficiently all systems in business. The main reason is that the integration of different cases has different integration requirements. Therefore, it cannot concretely show the value of system integration through the discussion of the theoretical aspects. In this thesis, this study aims to enhance the operation of a case to model, analyze, and construct an integrated data model. This research has 4 phases to construct integrated data model. In phase 1 and 2, this study builds the case data flow modeling and business process modeling and discovers information gap. In phase 3, the study selects the most suitable method for this case, that is, to use the data level integrated approach to design integrated data model. Finally, using ETL illustrates system operation mode and describes the case which may encounter problems and initial solutions follow in phase 4.

This thesis deals with Business Intelligence and its testing. It seeks to highlight the differences from the classical software testing and finally design a methodology for BI solutions testing that could be used in practice on real projects of BI companies. The aim of thesis is to design a methodology for BI solutions testing based on theoretical knowledge of Business Intelligence and software testing with an emphasis on the specific BI characteristics and requirements and also in accordance with Clever Decision's requirements and test it in practice on a real project in this company. The paper is written up on the basis of studying literature in the field of Business Intelligence and software testing from Czech and foreign sources as well as on the recommendations and experience of Clever Decision's employees. It is one of the few if not the first sources dealing with methodology for BI solutions testing in the Czech language. This work could also serve as a basis for more comprehensive methodologies of BI solutions testing. The thesis can be divided into theoretical and practical part. The theoretical part tries to explain the purpose of Business Intelligence use in enterprises. It elucidates particular components of the BI solution, then the actual software testing, various types of tests, with emphasis on the differences and specificities of Business Intelligence. The theoretical part is followed by designed methodology for BI solutions using a generic model for the BI/DW solution testing. The practical part's highlight is the description of real BI project testing in Clever Decision according to the designed methodology.