N5350A 教學大綱表

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

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

課程名稱 Course Title	(中文) 資料倉儲 (英文) Data Warehousing			開課單位 Departments	資訊經營研究所
				課程代碼 Course No.	N5350A
授課教師 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節
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能區別資料庫與資料倉儲之異同			2節
3	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進行小型資料倉儲專案規畫			2節
4	Dimensional modeling primer	1. Dimensional modeling vocabulary 2. Dimensional modeling myths	1能描述何謂維度為模 2區別維度模型與正規化模型之差異			1節
5	Retail Sales	1. Four-step demensional design process 2. Declar the grain 3. Choose the demensions 4. Identify the facts	1能以維度計設四步驟進行維設建模 2能辨別不同的資料顆粒度			3節
6	Inventory	1. Periodic snapshot 2. Transaction snapshot 3. Accumulation snapshot 4. Data warehouse bus matrix 5. Conformed dimensions and facts	1能區別三種類型的資料顆粒度 2在維度設計時能恰當選顆粒度			3節
7	Procurement	1. Multiple- VS Single- transaction fact tables 2. Slowly changing dimensions 3. More rapidly changing demensions	1能判斷何時該採單一事實表或多重事實表 2具體描述三種不同類型的漸變維度 3區別漸變維度與快變維度			3節
8	Order Management	1. Fact normalization 2. Dimension role-playing 3. Degenerate dimension 4. Junk dimensions	1能運用維度角色扮演、退化維度、雜項維度等技巧於維度計設			2節
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運用本單元所授的技巧於維度設計			3節
10	Term project veview (1)	Review the design of dimensional model	1運用於本課所習的知識，設計一小型資料倉儲 2確認學期專題的維度模型之正確性			3節
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			3節
12	Introducing Data Integration	1. Data Integration Concepts 2. BigData Overview 3. Velocity Methodology of Data Integration 4. Introducing Informatica PowerCenter	1具體描述業界常用的ETL產品			3節
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			3節
14	Designing Data Integration Process with ETL Tools (2)	1. Processing Operational Data Store (cont.) 2. Processing Dimension Tables	1運用ETL工具處理維度表			3節
15	Designing Data Integration Process with ETL Tools (3)	1. Processing Dimension Tables (cont.) 2. Processing Fact Tables	1運用ETL工具處理事實表			3節
16	Introduce Profiling , Analyze and Data Quality	1. Introducing Data Profiling 2. Introducing Data Analyze 3. Introducing Data Quality	能判斷資料來源的資料品質			3節
17	Term project review(2)	Review the design of ETL process	1運用於本課所習的知識，設計一小型資料倉儲 2確認學期專題的ETL程序之正確性			3節
18	Term project presnt, Mid Exam, Final Exam	Term project present	1展示學期專題成果			3節 3節 3節

教學要點概述：
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：期末考：25% 期中考：25% 其他評量：10% 專題：20% 平時考：10% 作業：10%

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