SQL Power Business Intelligence & Data Migration ConsultingThe Canadian Business Intelligence (BI) Authority, based in Toronto
Company OverviewConsulting ServicesMobile BIXBRL SolutionsCase Studies: Client Success StoriesResources & TrainingTechnology PartnersContact Us
DW101: Intro to BI/DW
SQL101: Intro to SQL
BI101: Intro to BI Reporting
DM101: Data Modeling for BI
DC101: Data Cleansing Workshop

DM101: Data Modeling for Business Intelligence
DM101: Data Modeling for Business Intelligence
Shop by category:
DM101: Data Modeling for Business Intelligence
Location and DateGroup Discount
Price
WEBINAR (date TBA)
IN-CLASS (date TBA)
1 - 2 students
(price per student)
3 or more students
(price per student)


 

Recommended for:
Technical Users

Duration: 2 Days

Pre-requisites: None

Webinar
On-line Webinar:
$365 per student
(groups of 3 or more: $295 per student)

In-class
In-class at SQL Power Toronto Training Facility:
$895 per student
(groups of 3 or more: $750 per student)

 

This comprehensive course will teach users Data Modelling for Business Intelligence with a focus on dimensional modeling. The course covers the theory and practical application using exercises.

 

Topics covered:

  1. Data Modeling Fundamentals
  2. Business Benefits of Data Models
  3. Relatinal Data Model
  4. Data Normalization Rules
  5. Data Model Elements: Relationships
  6. Data Model Elements: Keys
  7. Data Model Levels
  8. Dimensional Data Modeling
  9. Dimensional Data Model Characteristics
  10. Facts & Dimensions
  11. Granularity & Aggregation
  12. Designing for DW Performance
  13. Data Modeling Workshop
  14. Top 10 Mistakes to Avoid in Dimensional Data Modeling
  15. Dimensional Data Model in DW Architecture
  16. Data Modeling in UML

 
Quick Links

BI Savings Calculator

XBRL Case Study

Contact Us

Share

Email this

Print‑friendly

Member Log-in

Email/ID

Password

Need an account?
Register for free