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
Courses
Course chapters
Projects
Practices
Tracks
DataLab
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:
In the following sections, we explore the different components of our data model:
Data Connector's ERD
The diagram below shows the relationships between the different tables that make up the Data Connector's data model:
Last updated