This article includes step-by-step instructions on how to load your learning data to Tableau using the text/CSV connector, to create popular reports. You can download all the reports featured in this article from this Tableau public page.
You first need to have downloaded your CSV files from the Data Connector by completing the steps in this article: Viewing or downloading the Data Connector data from Windows/Mac/Linux
- Connecting a fact to a dimension table
- Connecting to the team_dim table
- Analyzing the distribution of experience points (XP)
- Analyzing completion rates
- Calculating the number of learners per course
- Calculating completion rates per course
- Completion rate calculation
Connecting a fact to a dimension table
- Each fact table contains a corresponding dimension table, and you could for example create a left join between the course_id from learning_course_fact. and id course_dim table.
- You can follow the same principle to connect any fact table to its corresponding dimension table.
Connecting to the team_dim table
- You can also use the user_team_bridge table to connect e.g. the learning_exercise_fact table to the team_dim table, to do an XP analysis on a team level.
Analyzing the distribution of experience points (XP)
- To analyze the distribution of experience points (XP) per user you can create a histogram. To do this, first create a Level-of-Detail or LoD calculation to calculate the XP per user.
- Secondly, you can create bins. There are many bin sizes we can use, but a course corresponds with around 4000-5000 XP, so create bin sizes of 7500. That way you can see how many people completed two or fewer courses. It will still allow us to look at the longtail of users who use Datacamp more extensively.
- The result is a histogram showing the learners in each bin. Although most learners have fewer than 7500 XP, the graph grows a healthy amount of learning having over 50,000 XP. This histogram will of course look different for each organization but can give you an idea of how much your learners are using the platform.
Analyzing completion rates
- Before you can start analyzing completion rates using the learning_course_fact table, it is important to have a look at the structure of the table. User_id in this case has many records when with different date_ids and time_spents.
- You will also notice the XP column is only filled in for learners that have completed a course, so let’s filter for that when calculating the completions per course.
Calculating the number of learners per course
To calculate the number of learners per course, you can simply calculate the distinct user_ids per course.
Calculating completion rates per course
- To achieve this report you will need to only want to count the completed at column when XP is not null. You can make Tableau do this by using the ISNULL() function.
- Finally, you count the completed at column by course_id and user_id to see if a user completed the course.
Completion rate calculation
- You can calculate the completion rate per course by simply dividing the completions by learners per course
- This provides a clear overview of a bar chart to look at completion rate by course of different learners. You can then apply filters by teams, technologies, etc to slice and dice your data.
Visit the Data Connector help pages for more information on using the Data Connector.