course_fact
) consisting of measures like XP and time spent, and a dimension table (course_dim
) consisting of descriptors like technology, topic etc. You can join the fact tables with the dimension tables to summarize XP and time spent across technology, topic etc.user_dim
, team_dim
, group_dim
, and bridge tables user_team_bridge
to facilitate analysis at the team or user level.xp
gained and time_spent
by week across technology
and team
with the following query.assessment_dim
: The assessment dimension provides descriptive data about a specific assessment.assessment_fact
: The assessment fact table provides data about the users’ assessment results: score and percentile obtained and time spent on each assessment.assignment_dim
: The assignment dimension table provides data about a specific assignment.assignment_fact
: The assignment fact table provides data about the users’ progress on each assignment.certification_dim
: The certification dimension provides data about a specific certification.certification_fact
: The certification fact table provides data about the users’ progress through different stages of a certification.exercise_dim
: The exercise dimension provides descriptive data about a specific exercise. Because the model considers users’ progress on all exercises (i.e., even exercises that are no longer available), there is a specific row with the id = -1. This row is used in the exercise fact table to refer to a deleted exercise.exercise_fact
: The exercise fact table provides data about the users’ progress: XP gained and time spent on each exercise. The table provides data for exercises that can be no longer available (and deleted from our database). In this case, the exercise_id value is set to -1 and links to a “deleted exercise”” row in the exercise_dim table.Fact table for exercise content. It provides engagement and xp measurements on exercise.chapter_dim
: The chapter dimension provides descriptive data about a specific chapter. Because the model considers users’ progress on all chapters (i.e., even chapters that are no longer available), there is a specific row with the id = -1. This row is used in the chapter fact table to refer to a deleted chapter.chapter_fact
: The chapter fact table provides data about the users’ progress: XP gained and time spent on each chapter. The table provides data for chapters that can be no longer available (and deleted from our database). In this case, the chapter_id value is set to -1 and links to a “deleted chapter” row in the chapter_dim table.course_dim
: The course dimension provides descriptive data about a specific course. Because the model considers users’ progress on all courses (i.e., even courses that are no longer available), there is a specific row with the id = -1. This row is used in the course fact table to refer to a deleted course.course_fact
: The course fact table provides data about the users’ progress: XP gained and time spent on each course. The table provides data for courses that can be no longer available (and deleted from our database). In this case, the course value is set to -1 and links to a “deleted course” row in the course_dim table.practice_dim
: List of all practicespractice_fact
: Fact table for practice content. It provides engagement and xp measurements on projects. This table includes practices (aka challenges) after practice replaced challenges.project_dim
: The project dimension provides descriptive data about a specific project.project_fact
: The project fact table provides data about the users’ project progress: time spent and XP gained.track_content_dim
: List of content in all live tracks. This table has one row per track_version and content item. It currently only includes courses and projects. Note that a content item can belong to multiple tracks, and different versions of a track might contain different content items.track_content_fact
: Fact table for track content.track_dim
: List of all versions of live tracks, along with their title, technology, and descriptions. This table has one row for every track version, for tracks that are live.track_fact
: Fact table for tracks.publication_fact
: The publication fact table provides data about the users’ workspace publications: number of viewers and time spent viewing by date and viewer type (creator / viewer).workspace_dim
: The workspace dimension table provides descriptive data about a specific workspace.workspace_fact
: The workspace fact table provides data about group workspaces created by users. Note that if a user in a group creates a workspace as part of their personal account, it is NOT included in this model.team_dim
: The team dimension provides descriptive data about teams.user_dim
: List of all enterprise usersuser_team_bridge
: Bridge table to link users to their teamsxp_fact
: This fact table provides information on XP gained by a user across different content modalities.