課程目標：介紹資料建模的概念與其在各行業別的應用方式，並透過範例資料的練習以熟悉操作的手法。

用書：The Data Warehouse Toolkit 3rd edition, Ralph Kimball, Wiley

大綱：

• Data Warehousing, Business Intelligence, and Dimensional Modeling primer
• Kimball Dimensional Modeling Techniques Overview
• Retail Sales
• Inventory
• Procurement
• Order Management
• Accounting
• Customer Relationship Management
• Human Resources Management
• Financial Services
• Telecommunications
• Transportation
• Education
• Healthcare
• Electronic Commerce
• Insurance
• Kimball DW/BI Lifecycle Overview
• Dimensional Modeling Process and Tasks
• ETL Systems and Techniques
• ETL System Design and Development process and Tasks
• Big Data Analysis