Introduction to Dimensional Modeling

Course Number: 
DW-100
Duration: 
21 h
Description:
The purpose of this course is to introduce students to the use and application of data warehousing modeling technique commonly known as “dimensional modeling”. Using a combination of theory and practice, the goal is to first understand the conventions, approaches, and techniques then, if possible, apply them to actual data and requirements from your own workplace. This course is taught without the use of a modeling tool but can be tailored to include one for additional cost.
Learning Objectives
  • Be able to describe the basic concepts, terms & definitions associated with BI/DW.
  • Develop familiarity with the key architectural components and layers required for a complete data warehouse solution.
  • Develop core skills in dimensional modeling techniques.
  • Apply dimensional modeling techniques to create a preliminary model or set of models.
Pricing: 
$800 per student, min 8 students, max 15 students
Schedule:
No current public offerings of this course are currently scheduled.

Contact us to schedule private/custom courses on demand.
Additional Details
Prerequisite: 
Students should have general experience with data modeling and database concepts in general.
Level: 
Introductory
Delivery Options: 
Classroom
Downloads