This course provides students with the skills necessary to begin to design a successful data warehouse using multi-dimensional data modeling techniques. It is based on the following Ralph Kimball book: The Data Warehouse Lifecycle Toolkit, Second Edition, Wiley, ISBN: 0470149779, published on January 10, 2008. The students each get this book plus a set of printed PowerPoint slides. The course discusses industry-wide best practices concerning the design and construction of an Enterprise Data Warehouse featuring Dimensional Modeling techniques and Star Schemas. The class uses the free Computer Associates ERwin Community Edition data modeling software. If the customer has the licenses or would like to use the Try It versions--the class could use Embarcadero ER Studio, Power Designer, MS Access, MS SQL Server, Oracle, DB2 or InfoSphere Data Architect data modeling/table design software. The customer should talk with the instructor before the course concerning which data modeling software to use.
Students should have at least some experience with any relational database management system.
2 Days/Lecture & Lab
This course is targeted at technical staff, team leaders, project managers, and users who need to understand the basics of how to design a data warehouse using multi-dimensional data modeling techniques
- Dimensional Modeling Primer
- Retail Sales
- Building The Data Warehouse