Changelog
Last updated
Last updated
In this section, we track updates and changes to the data model.
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.
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.
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.
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