N5350 教學大綱表

教學大綱表 (113學年度第1學期)

請遵守智慧財產權，勿使用非法影印教科書，避免觸法。

課程名稱 Course Title	(中文) 資料倉儲 (英文) Data Warehousing			開課單位 Departments	資訊經營研究所
				課程代碼 Course No.	N5350
授課教師 Instructor	陳明賢
學分數 Credit	3.0	必/選修 core required/optional	選修	開課年級 Level	研究所
先修科目或先備能力(Course Pre-requisites)：資料庫系統及企業流程相關知識
課程概述與目標(Course Overview and Goals)：The data warehouse industry has reached full maturity and acceptance across the business world. This course helps students get about the business of building and managing a data warehouse that is a platform for business intelligence applications.
教科書(Textbook)	Ralph Kimball & Margy Ross, "The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling," 3nd Ed., Wiley, 2013, ISBN: 9781118530801
參考教材(Reference)	Ralph Kimball, Margy Ross, "The Kimball Group reader : relentlessly practical tools for data warehousing and business intelligence," Wiley, 2015. https://onlinelibrary.wiley.com/doi/book/10.1002/9781119228912
圖書館電子書(E-book of the Library)	http://www.sciencedirect.com/science/book/9780123743190 http://www.sciencedirect.com/science/book/9781558606845 http://link.springer.com/book/10.1007%2F978-3-540-74405-4 http://link.springer.com/book/10.1007%2F978-1-4302-0528-9 http://www.sciencedirect.com/science/book/9780123737267 https://link.springer.com/book/10.1007%2F978-1-4842-0082-7 https://onlinelibrary.wiley.com/doi/book/10.1002/9781119228912

課程大綱 Syllabus			學生學習目標 Learning Objectives	單元學習活動 Learning Activities	學習成效評量 Evaluation	備註 Notes
序 No.	單元主題 Unit topic	內容綱要 Content summary	學生學習目標 Learning Objectives	單元學習活動 Learning Activities	學習成效評量 Evaluation	備註 Notes
1	Evolution of Decision Support Systems & The data warehouse environment	1. The Evolution 2. Problems with the naturally evolving architecture 3. The architected environment & 1. The structure of the data warehouse 2. Subject orientation 3. Day 1-day n phenomenon 4. Granularity	1能具體描述DSS沿革 & 1能具體描述資料倉儲特徵 2能區別資料庫與資料倉儲之異同	講授	作業期中考
2	Dimensional modeling primer	1. Dimensional modeling vocabulary 2. Dimensional modeling myths	1能描述何謂維度為模 2區別維度模型與正規化模型之差異	講授	作業期中考
3	Retail Sales	1. Four-step demensional design process 2. Declar the grain 3. Choose the demensions 4. Identify the facts	1能以維度計設四步驟進行維設建模 2能辨別不同的資料顆粒度	講授	作業期中考
4	Inventory	1. Periodic snapshot 2. Transaction snapshot 3. Accumulation snapshot 4. Data warehouse bus matrix 5. Conformed dimensions and facts	1能區別三種類型的資料顆粒度 2在維度設計時能恰當選顆粒度	演講	作業期中考
5	Procurement	1. Multiple- VS Single- transaction fact tables 2. Slowly changing dimensions 3. More rapidly changing demensions	1能判斷何時該採單一事實表或多重事實表 2具體描述三種不同類型的漸變維度 3區別漸變維度與快變維度	講授	期中考
6	Order Management	1. Fact normalization 2. Dimension role-playing 3. Degenerate dimension 4. Junk dimensions	1能運用維度角色扮演、退化維度、雜項維度等技巧於維度計設		作業期中考
7	Other Dimensional modeling issues	1. Large changing dimensions 2. Consolidated fact tables 3. Time-stamped transaction tracking in a dimension 4. outrigger dimension 5. Household dimension 6. Multivalued dimensions 7. Surrogate keys	1運用本單元所授的技巧於維度設計	講授	作業期末考
8	Mid Exam	Mid Exam	Mid Exam		期中考
9	Introducing the Kimball Lifecycle	1. Lifecycle History Lesson 2. Lifecycle Milestones 3. Using the Lifecycle Roadmap 4. Lifecycle Navigation Aids 5. Lifecycle Vocabulary Primer	1能按Kimball Lifecycle進行小型資料倉儲專案規畫	講授	作業期中考
10	ETL Subsystems and Techniques	1. Round Up the Requirements 2. Extracting Data 3. Cleaning and Conforming Data 4. Delivering Data for Presentation 5. Managing the ETL Environment	1能整體概述ETL	講授	作業期末考
11	ETL System Design and Development Process and Tasks	1. Develop the ETL Plan 2. Develop One-Time Historic Load Processing 3. Develop Incremental ETL Processing 4. Real-Time Implications	能為專案設計ETL程序	講授	作業期末考
12	Designing Data Integration Process with ETL Tools (1)	1. Introduction of MS SSIS 2. Installation of MS SSIS & VS data tools 3. Introduction of VS data tools' User Interface 4. Config Lab environment	1 安裝及組態SSIS 2 安裝及組態VS data tools 3 能基本操作VS data tools	上機實習講授	作業期末考
13	Designing Data Integration Process with ETL Tools (2)	1, create project of SSIS 2, create & config. data connection 3, different kind of data sources and data destinations	能建立並組態SSIS專案能為不同類型資料建立資料連接	上機實習講授	作業期末考
14	Designing Data Integration Process with ETL Tools (3)	1. Processing Dimension Tables (cont.) 2. Processing Fact Tables	1運用ETL工具處理事實表	上機實習講授	作業
15	Designing Data Integration Process with ETL Tools (4)	1. Extract, Transform, Load 2. PowerCenter Components and User Interface 3. Config Lab environment 4. Processing Operational Data Store	1ETL工具基本功能操作 2運用ETL工具處理ODS	上機實習講授	作業
16	Final Exam	Final Exam	Final Exam		期末考

彈性教學週活動規劃

序 No.	實施期間 Period	實施方式 Content	教學說明 Teaching instructions	彈性教學評量方式 Evaluation	備註 Notes
1	起:2024-10-07 迄:2025-01-06	5.小專題 Project	完成資料庫 LargeCo的資料倉儲，透過 MS SSIS 服務，設計其維度模型及設計資料轉換整合之 ETL 程序。	ETL程序完成後，撰寫心得報告、簡報，並錄製6分鐘口頭報告上傳YouTube，同儕互評

教學要點概述：
1.自編教材 Handout by Instructor：
□ 1-1.簡報 Slids
□ 1-2.影音教材 Videos
□ 1-3.教具 Teaching Aids
■ 1-4.教科書 Textbook
□ 1-5.其他 Other
□ 2.自編評量工具/量表 Educational Assessment
■ 3.教科書作者提供 Textbook

成績考核 Performance Evaluation：期末考：30% 期中考：30% 彈性教學：10% 作業：30%

教學資源(Teaching Resources)：
□ 教材電子檔(Soft Copy of the Handout or the Textbook)
□ 課程網站(Website)
扣考規定：https://curri.ttu.edu.tw/p/412-1033-1254.php