Data Modleing

Objective: Introduction the concepts of data modeling and its application in various industrials. Students can be familiar with the processing steps by using practical sample data.

Textbook: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