BI Modeling and Data Marts

Course overview

BI modeling approach and data mart construction with Codex: star schema design, building fact and dimension tables, data mart validation, and documentation and lineage of transformations.

Describes star schema design assisted by Codex, using test datasets to guide dimensional modeling decisions.

Advises on building operational fact and dimension tables and includes a hands-on session to implement them.

Presents data mart validation methods with a practical exercise to evaluate consistency and correctness.

Emphasizes documentation and lineage practices: traceability methods and a lab for building the star schema and data mart.