Technology trainings

Hands-on training in the platforms teams actually use.

Live, instructor-led programs across Snowflake, Databricks, Microsoft Fabric, Data Vault 2.0, modeling, engineering and AI for data teams. 30% concepts, 70% hands-on, with real business scenarios.

Training catalogue

1 training match your filters

Dimensional ModelingBeginner

Dimensional Modelling for Analytics

Design star schemas that make reporting fast, consistent and trustworthy.

Duration
16 hrs
Mode
Live online
Starts
To be announced
Syllabus · 4 modules · Weekday evenings, 7–9pm IST
  1. Foundations · 3h
    Business processes, grain, facts and dimensions
  2. Facts · 4h
    Transaction, periodic and accumulating snapshots; additivity
  3. Dimensions · 5h
    Conformed dimensions, SCD types 1, 2 and 3, junk and role-playing dimensions
  4. Delivery · 4h
    Bus matrix, semantic models, modelling review with the trainer
You will be able to: Declare the grain and design fact tables · Design conformed dimensions and slowly changing dimensions · Build a bus matrix for an enterprise data warehouse · Translate a star schema into a semantic model
Fees on requestEnquire for fees and the next batch
View course detailsEnquire