課程目標:介紹資料建模的概念與其在各行業別的應用方式,並透過範例資料的練習以熟悉操作的手法。
用書: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