Dimensional Modeling for the Data Warehouse

This course provides students with the skills necessary to design a successful data warehouse using multi-dimensional data modeling techniques. It is based on the following Ralph Kimball book: The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, Third Edition, Wiley, ISBN: 1118530802, published on July 1, 2013. The students each get this book plus a set of printed PowerPoint slides. The course also discusses additional industry-wide best practices concerning Dimensional Modeling and Star Schemas. The class uses the free CA Erwin Community edition data modeling software. The customer should talk with the instructor before the course concerning which data modeling software to use.

4 Days/Lecture & Lab

This course is targeted at technical staff, team leaders, project managers, and users who need to understand how to design a data warehouse using multi-dimensional data modeling techniques.

  • Dimensional Modeling Primer
  • Retail Sales
  • Inventory
  • Procurement
  • Order Management
  • Customer Relationship Management
  • Accounting
  • Human Resources Management
  • Financial Services
  • Telecommunications And Utilities
  • Transportation
  • Education
  • Health Care
  • Electronic Commerce
  • Insurance
  • Building The Data Warehouse

Students should have at least some experience with any relational database management system.


Copyright © 2017 ProTech. All Rights Reserved.

Sign In Create Account

Navigation

Social Media