N5350 教學大綱表

教學大綱表 (112學年度第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)	1, Ralph Kimball & Margy Ross, "The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling," 3nd Ed., Wiley, 2013, ISBN: 9781118530801
參考教材(Reference)	1, Ralph Kimball, Margy Ross, "The Kimball Group reader : relentlessly practical tools for data warehousing and business intelligence," Wiley, 2015
圖書館電子書(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	1. The Evolution 2. Problems with the naturally evolving architecture 3. The architected environment 4. Who is the user 5. The development life cycle	1能具體描述DSS沿革	講授	作業期中考
2	The data warehouse environment	1. The structure of the data warehouse 2. Subject orientation 3. Day 1-day n phenomenon 4. Granularity 5. Cost justification	1能具體描述資料倉儲特徵 2能區別資料庫與資料倉儲之異同	講授	作業期中考
3	Dimensional modeling primer	1. Dimensional modeling vocabulary 2. Dimensional modeling myths	1能描述何謂維度為模 2區別維度模型與正規化模型之差異	講授	作業期中考
4	Retail Sales	1. Four-step demensional design process 2. Declar the grain 3. Choose the demensions 4. Identify the facts	1能以維度計設四步驟進行維設建模 2能辨別不同的資料顆粒度	講授	作業期中考
5	Inventory	1. Periodic snapshot 2. Transaction snapshot 3. Accumulation snapshot 4. Data warehouse bus matrix 5. Conformed dimensions and facts	1能區別三種類型的資料顆粒度 2在維度設計時能恰當選顆粒度	演講	作業期中考
6	Procurement	1. Multiple- VS Single- transaction fact tables 2. Slowly changing dimensions 3. More rapidly changing demensions	1能判斷何時該採單一事實表或多重事實表 2具體描述三種不同類型的漸變維度 3區別漸變維度與快變維度	講授	期中考
7	Order Management	1. Fact normalization 2. Dimension role-playing 3. Degenerate dimension 4. Junk dimensions	1能運用維度角色扮演、退化維度、雜項維度等技巧於維度計設		作業期中考
8	Mid Exam	Mid Exam	Mid Exam		期中考
9	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運用本單元所授的技巧於維度設計	講授	作業期末考
10	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進行小型資料倉儲專案規畫	講授	作業期中考
11	Overall introducing Extract, Transformation, and Load	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	講授	作業期末考
12	Introducing Data Integration	1. Data Integration Concepts 2. BigData Overview 3. Velocity Methodology of Data Integration 4. Introducing Informatica PowerCenter	1具體描述業界常用的ETL產品	講授	作業平時考期末考
13	Designing Data Integration Process with ETL Tools (1)	1. Extract, Transform, Load 2. PowerCenter Components and User Interface 3. Config Lab environment 4. Processing Operational Data Store	1ETL工具基本功能操作 2運用ETL工具處理ODS	上機實習講授	作業
14	Designing Data Integration Process with ETL Tools (2)	1. Processing Operational Data Store (cont.) 2. Processing Dimension Tables	1運用ETL工具處理維度表	上機實習講授	作業
15	Designing Data Integration Process with ETL Tools (3)	1. Processing Dimension Tables (cont.) 2. Processing Fact Tables	1運用ETL工具處理事實表	上機實習講授	作業
16	Final Exam	Final Exam	Final Exam		期末考

彈性教學週活動規劃

序 No.	實施期間 Period	實施方式 Content	教學說明 Teaching instructions	彈性教學評量方式 Evaluation	備註 Notes
1	起:2023-11-01 迄:2024-01-10	3.實作 Practical class	完成資料庫 LargeCo的資料倉儲，設計其維度模型及設計資料轉換整合之 ETL程序。	完成ETL後，找老師interview、互動驗收

教學要點概述：
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% 平時考：10% 作業：20%

教學資源(Teaching Resources)：
□ 教材電子檔(Soft Copy of the Handout or the Textbook)
□ 課程網站(Website)
扣考規定：http://eboard.ttu.edu.tw/ttuwebpost/showcontent-news.php?id=504