Module 3: Advanced Modeling

COURSE MAP

Advanced Modeling

Data Marts: The Good Stuff

Star Schema for Schools

We need to organize our data into facts and dimensions:

Dim_Student: Demographics, Enrollment history
Fact_Attendance: Daily attendance records
Fact_Assessment: Standardized test scores

The Semantic Layer

Don't let users guess what "Enrollment Count" means. Define it once!


                        metrics:

                          - name: enrollment_count

                            type: simple

                            sql: count(distinct student_id)

Hands-on: Documentation

Run `dbt docs generate` to create your own data dictionary site.

<< Back | Next: Module 4 >>