Explore the data model

Learn more about the data we expose through the Data Connector 2.0 by exploring the data model.

Data Model

The data model for Data Connector provides data on activity for users in an organization across different content types.

• The currently supported content types are:

  • Assessments

  • Certifications

  • Competitions

  • Courses

  • Course chapters

  • Projects

  • Practices

  • Tracks

  • DataLab

  • Resources

    • Infographics

    • Ebooks

    • Webinars

    • Podcasts

    • Whitepapers

    • Code-Alongs

    • Data Sheets

    • Case Studies

    • Tools

    • Cheatsheets

How to work with the data?

The data available from Data Connector is modeled using a dimensional model. This means fact, dimension, bridge, and mart tables are available.

You can join the fact tables with the dimension tables to summarize XP and time spent across technology, topic, etc.

The data model also provides dimension and bridge tables for team- or user-level analysis.

For example, you can aggregate the XP and time spent by technology for January 2025 with the following query:

/* Aggregate XP and time spent for January 2025 on courses, 
practices, projects, and assessments */

SELECT 
    content.technology,
    sum(xp_earned) as total_xp,
    sum(duration_engaged) as time_spent_seconds
FROM group_1234.fact_learn_events AS events
LEFT JOIN group_1234.dim_content AS content
    ON content.content_id = events.content_id
-- limit to courses, practices, projects, and assessments
WHERE events.event_name IN ('course_engagement', 
                            'practice_engagement',
                            'project_engagement',
                            'assessment_engaged')
    AND date(events.occurred_at) BETWEEN '2025-01-01' AND '2025-01-31'
GROUP BY content.technology

• In the following sections, we explore the different components of our data model:

  • Fact tables

  • Dimension tables

  • Bridge tables

  • Metrics tables

Data Connector's ERD

The diagram below shows the relationships between the different tables that make up the Data Connector's data model:

The ER-Diagram covers fact, dimension, and bridge tables. The aggregated detail tables (group_detail, user_engagement_detail, track_engagement_detail) are documented separately on the Metrics tables page.