Data Modeling Training

Dimensional Modeling

Learn How to Use a Star Schema Model to Combine Data from Disparate and Complex Source Systems

Course Information

$1,495

Cost *

TBD

Date

A sound, well thought out data model is at the core of every successful data warehouse implementation. It ensures the analytical needs of any organization.

In this 2-day Dimensional Modeling course, learn how to combine source system data and present the resulting information in an easy to understand reportable format.

Ideal For:

This Dimensional Modeling course is designed for business analysts, data analysts, data architects, data developers, data scientists and anyone who has a passion for improving access to data and analytics within their organization.

TR – Business Intelligence – Dimensional Modeling


Instructor was knowledgeable, personable, communicative and provided real-world examples. Excellent!

Prerequisites:

Familiarity with relational databases, data analysis and reporting concepts.

Learning Objectives & Approach:

This course provides interactive training on the core dimensional model concept using a combination of instructor lead discussion, real world examples, and engaging hands-on labs.

Upon completion of this course, participants will know how to design effective dimensional data models to support simplified and more effective use of data with their organization.

Key Topics

  • The key benefits of dimensional modeling – it’s not just about simplification
  • Data fundamentals – core relational and dimensional modeling concepts
  • Breaking down the data – facts and dimensions: identifying metrics and the attributes to describe them
  • Keeping track of history – managing changes in your data, even when the source doesn’t
  • Related dimensions – using bridge tables and snowflake patterns
  • Linking subject areas – extending the model using conformed dimensions
  • Data Loading – introduction to extracting, transforming, and loading (ETL) data into a dimensional model

Registration

Dimensional Modeling

  • 8:30am - 4:30pm

Courses are also offered privately to teams and organizations looking for more immersive training.

Mentoring services are also available to reinforce or advance learned principles and practices.

Contact us for more information.

* Cost is per participant in Canadian dollars plus GST

You May Like These Other Courses

Improve or master Business Intelligence and Data Management by enrolling in any of our public or private courses. Contact us for further information, and/or to learn about private training options.

Contact us
Arrow to the top