Skip to content
Analytical Spine
Free foundations
Free track

Dimensional modelling the spine way

Draft a cited business process, ratify the fact grain and inspect a generated semantic model. Prerequisites: F1-F2 and SQL joins.

01 The syllabus

Inside the course.

6 lessons / read + practice
  1. 01

    Start with process and grain

    State what one fact row means before choosing a measure.

    40 min
  2. 02

    Use the domain seeds carefully

    Adapt Sales and finance starting points while preserving their draft status.

    40 min
  3. 03

    Read the source map

    Evaluate keys, relationships, coverage and source ambiguities from metadata.

    40 min
  4. 04

    Draft and validate the star

    Create a Gold contract with explicit types, conformed dimensions and reconciliation checks.

    40 min
  5. 05

    Ratify with a human record

    Preserve an authorised reviewer's identity and verbatim grain decision.

    40 min
  6. 06

    Generate and inspect TMDL

    Inspect model metadata, relationships and a bus-matrix review before measure authoring.

    40 min

Your learning evidence

A synthetic Sales contract, grain-review packet and semantic metadata worksheet.

Supported learning environment

Local installed runtime · TMDL metadata inspection

Scope and limitations

Use public or synthetic data. Keep customer evidence private. A course completion check does not qualify a live report or award a professional credential.

Curriculum source reviewed 2026-10-25. Durations are teaching estimates including exercises.

Dimensional modelling the spine way | Analytical Spine