Data connector cover five types of report:
I. Assessments
II. Courses
III. Practice
IV. Projects
V. Tracks
The data model includes a fact table (e.g. course fact) with metrics like XP and time spent, as well as a dimension table (course dim) with descriptors like technology, topic, and so on, for each content type.
To summarise XP and time spent across technologies, topics, and so on, you can link the fact tables with the dimension tables.
In addition, the data model includes dimension tables for users (user dim, team dim, group dim), as well as bridge tables (user team bridge) to aid in team or user analysis.
