Changelog

In this section, we track updates and changes to the data model.

June 5, 2025

We’ve updated the data model to support custom assessments. The dim_content table now includes a new boolean field: assessment_is_custom. This field indicates whether an assessment is custom (true) or standard (false).

If your group uses custom assessments, you’ll now see corresponding rows reflected in this table.

We have also added a last_sso_nameid column to the bridge_user_group table. This field contains the last SSO NameID of the user in the group. Some groups that authenticate with SSO use this field to include custom identification data for their users.

May 28, 2025

We’ve updated the underlying data in the data model (note: this is not a schema change) to improve the accuracy of engagement metrics:

  • Filtered course activity: We now exclude course_engagement events associated with courses that are not in one of the three expected states: Live, Soft Launched, or Archived. Previously, some engagement data from courses in other states may have been included. This change may slightly reduce reported course durations. This does not affect XP calculations.

  • Filtered assessment activity: We now exclude assessment_engaged events for assessments that are not in the public state. Previously, engagement data for non-public assessments was included. This change may slightly reduce assessment duration metrics. This does not affect XP calculations.

May 22, 2025

We've enhanced the data model to include the description and short description for courses and chapters. New fields, description and short_description has been added to the dim_content table.

April 22, 2025

We've enhanced the data model to include the estimated time required to complete courses and projects. A new field time_needed_in_hours has been added to the dim_content table. This field represents the expected duration (in hours) to complete a given piece of content and is currently populated only for courses and projects.

April 17, 2025

We've added a course_is_skipped column to fact_learn_events . This column will contain a boolean (true/false) for course_completed events, indicating whether the course was skipped. A skipped course is still treated as a completed course. For cases when the course was skipped, the occurred_at timestamp for the course completion event will reflect the time at which the course was skipped.

April 16, 2025

We’ve updated the data model to support custom certifications. The dim_certification table now includes a new boolean field: certification_is_custom. This field indicates whether a certification is custom (true) or standard (false).

If your group uses custom certifications, you’ll now see corresponding rows reflected in this table.

March 31, 2025

Launched Data Connector 2.0!!

  • With Data Connector 2.0, we’ve significantly improved the data model, making it simpler, more efficient, and aligned with the rest of our reporting.

    • Simplified data model – Fewer tables (29 → 13) for easier querying

    • Data alignment with Groups tab reporting - Data Connector 2.0 now uses the same source as the rest of our reporting, ensuring consistency across all analytics and no discrepancies.

    • Includes mobile data - Now includes learner data done via the mobile app

    • Pre-aggregated metrics – New pre-aggregated metric tables to speed up reporting

    • Easier querying – Significantly fewer complex joins for common reports

    For more info on the differences, check out Migrating from Data Connector (1.0)

Last updated