Examples
Impfdaten-Dashboard
One possible way of representing the dashboard is with the following two tables. However, data, such as from and to (related to dim_week_year) is lost. To prevent that, use the snowflake schema, the extended version of the star schema.
School Grades
fact_grades
------------
dim_teacher
dim_class
dim_curriculum
dim_student
dim_subject
dim_schoolyear
value_grade
dim_subject
------------
subject_name
special_general
dim_class
------------
school
postal_code
district
federal_state