Enterprise Reporting
  • Introduction
  • Understanding reports with clarity (Definitions)
  • Optimizing key performance indicators (via the Groups tab)
    • Dashboard
    • Reporting section
      • Progress report
      • Adoption report
      • Engagement report
      • Content insights
        • XP
        • Courses
        • Projects
        • Tracks
      • Assessments
      • Certifications
      • Time in Learn
      • DataLab
      • Export
    • Skill Matrix
  • Integrating our data into your tools (via Data Connector 2.0)
    • Explore the data model
      • Fact tables
      • Dimension tables
      • Bridge tables
      • Metrics tables
    • Common use cases
    • Sample queries
    • Queries to recreate key reports in the Groups tab
      • Dashboard
        • Members who have earned XP
      • Reporting section
        • Progress report
        • Content insights
        • Assessments
        • Certification Insights
        • Time in Learn
    • Domain Gotchas
    • Getting started with Data Connector 2.0
      • Enable Data Connector 2.0
      • Your credentials
      • Storing your credentials
    • Using Data Connector 2.0
      • Integrating with your BI tools
        • Microsoft Power BI
        • Tableau
        • Looker
        • DataLab
      • Downloading your data
        • S3 Browser (Windows)
        • Cyberduck (Mac or Windows)
        • AWS CLI (Linux)
    • Changelog
    • Migrating from Data Connector 1.0
  • FAQ
  • Data Connector 1.0 - Documentation
    • [Data Connector 1.0] Explore Data Model
      • [Data Connector 1.0] Data Model
      • [Data Connector 1.0] Changelog
      • [Data Connector 1.0] Example queries
    • [Data Connector 1.0] Getting started
      • [Data Connector 1.0] Enabling the Data Connector
      • [Data Connector 1.0] Your Credentials
      • [Data Connector 1.0] Storing your Credentials
    • [Data Connector 1.0] Using the Data Connector
      • [Data Connector 1.0] Analyzing data
        • [Data Connector 1.0] DataLab
        • [Data Connector 1.0] Microsoft Power BI
        • [Data Connector 1.0] Tableau
      • [Data Connector 1.0] Downloading data
        • [Data Connector 1.0] S3 Browser (Windows)
        • [Data Connector 1.0] 3Hub (Mac)
        • [Data Connector 1.0] AWS CLI (Linux)
    • [Data Connector 1.0] Data Connector FAQ
      • [Data Connector 1.0] Deprecating dcdcpy and dcdcr
Powered by GitBook
On this page
  • April 22, 2025
  • April 17, 2025
  • April 16, 2025
  • March 31, 2025
  1. Integrating our data into your tools (via Data Connector 2.0)

Changelog

PreviousAWS CLI (Linux)NextMigrating from Data Connector 1.0

Last updated 23 days ago

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

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)