資料建模

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

用書: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