由於科技快速進步，企業經營也隨著科技的進步而產生重大變化，不但需求變化快速，企業還要即時快速反應外在環境，於是企業對於資訊系統整合的議題越來越重視，希望將功能導向的系統轉變為流程導向的系統，將資訊有效的整合及標準化，讓企業能快速地與外在環境連結，進而提升整體營運績效。 整合的方法非常的多，大致上可分為四類。目前對於哪一種整合方法是最有效率、效益也無一定論。最主要的原因是不同的整合個案會有不同的整合需求，若只從理論方面來探討資訊系統整合所帶來的效用並無法具體地呈現其價值。 有鑑於此，本研究之目的是希望透過個案單位的作業模型，分析、建構出整合的資料模型。因此，本研究以階段性的方法設計資料整合模型及其運作方法。在第一、二階段當中，先針對個案單位的流程進行系統資料流程塑模及業務流程塑模，再從業務面及系統面找出資訊中斷的地方及因素，並將問題具體地描述出來。在第三階段中，本研究挑選了最適合此個案單位的整合方法，也就是使用資料層級（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.

The main goal of this thesis is to summarize and introduce general theoretical concepts of Data Warehousing by using the systems approach. The thesis defines Data Warehousing and its main areas and delimitates Data Warehousing area in terms of higher-level area called Business Intelligence. It also describes the history of Data Warehousing & Business Intelligence, focuses on key principals of Data Warehouse building and explains the practical applications of this solution. The aim of the practical part is to perform the evaluation of theoretical concepts. Based on that, design and build Data Warehouse in environment of an existing company. The final solution shall include Data Warehouse design, hardware and software platform selection, loading with real data by using ETL services and building of end users reports. The objective of the practical part is also to demonstrate the power of this technology and shall contribute to business decision-making process in this company.