Introduction
This guide provides a comprehensive overview of how to effectively use Docebo's Insights to analyze your learning data. You'll learn about the core components of Insights, including visuals, datasets, and platform filters, with specific instructions on how they interact to help you customize and refine your dashboards. Understanding these relationships is key to leveraging the full power of Insights. By following the guidelines outlined in this article, you can effectively leverage Docebo's Advanced Insights to gain deeper insights from your learning data. The comprehensive tables and explanations of visual-dataset relationships and filter behaviors will help you navigate the platform with confidence, whether you are utilizing pre-built dashboards or configuring custom ones.
Understanding Insights
Docebo's Insights allows users to gain deeper understanding from their learning data. It's built on Amazon QuickSight, enabling both basic and advanced users to create and customize dashboards.
For more general information, refer to the following articles:
- Introduction to Insights
- Insights ready-to-use dashboards
- Creating and managing custom dashboards
- Assigning dashboards
- Managing dashboards
- Insights Questions and answers
Understanding dashboard visuals and datasets
In Insights, visuals are the interactive charts and graphs you see on your dashboards, while datasets are the raw collections of data that power these visuals. Each visual directly pulls its information from a specific dataset. For example, a learning plan progress rate visual will retrieve its data from the LP Enrollments dataset, the data returned by the dataset can then be optionally further filtered in order to tailor the reporting of the visual to your specific needs. Understanding this fundamental link is crucial for building and customizing effective dashboards.
For creating basic custom dashboards, please see Creating and managing custom dashboards, if you need to customize the dashboards using specific datasets, please see Using advanced insights.
Below are the comprehensive tables for dashboard visuals and dashboard datasets.
Dashboard visuals
Visuals are the graphical representations of data that you see in a dashboard (for example, charts, graphs, tables). Each visual draws its data from a specific dataset and can be influenced by various platform filters.
The following chapters provide an overview of the available visuals, the dataset they utilize and the platform filters that can affect them.
Tip: Filters operate by applying criteria directly to the underlying datasets of your visuals. As a result, any visual on the dashboard built upon a dataset that supports a specific filter will automatically update to reflect the selected criteria.
Exceptions to this behavior are the date filters. Unlike other filters, date filters are applied at the visual level, not at the dataset level. This means that when building custom dashboards, you must explicitly configure the date filter in the dashboard editor to apply it to the desired visuals or to entire dashboard sheets.
Completions Rate
This visual represents the percentage of learners who completed a course or courses out of all learners enrolled in the course or courses.
| Dataset used | COURSE ENROLLMENTS |
|---|---|
| Platform filters affecting this visual |
First Access to Completion
This visual describes the median time from the first access to completion of a course or courses.
| Dataset used | COURSE ENROLLMENTS |
|---|---|
| Platform filters affecting this visual |
Enrollment to Completion
This visual describes the median time from enrollment to completion of a course or courses.
| Dataset used | COURSE ENROLLMENTS |
|---|---|
| Platform filters affecting this visual |
Enrollments Status
This visual describes the total number of enrollments by status for the selected periods.
| Dataset used | COURSE ENROLLMENTS |
|---|---|
| Platform filters affecting this visual |
First Access to Completion Breakdown
This visual represents the time from first access to completion, broken down by average time.
| Dataset used | COURSE ENROLLMENTS |
|---|---|
| Platform filters affecting this visual |
Self-Enrollments
This visual shows the breakdown between self-enrollments and enrollments created by others.
| Dataset used | COURSE ENROLLMENTS |
|---|---|
| Platform filters affecting this visual |
Completions Trend
This visual describes the distribution of course completion date over time.
| Dataset used | COURSE ENROLLMENTS |
|---|---|
| Platform filters affecting this visual |
Completions by Group
This visual displays the number of completions by user group.
| Dataset used | COURSE ENROLLMENTS by GROUPS |
|---|---|
| Platform filters affecting this visual |
Completions by Branch
Number of completions by branch of the same level
| Dataset used | COURSE ENROLLMENTS by BRANCH |
|---|---|
| Platform filters affecting this visual |
Most and Least Completed Courses
Course ranking by completion
| Dataset used | COURSE ENROLLMENTS |
|---|---|
| Platform filters affecting this visual |
Overdue Rate
Percentage of all overdue enrollments, regardless of status, considering the courses that have a deadline
| Dataset used | COURSE ENROLLMENTS |
|---|---|
| Platform filters affecting this visual |
Overdue by Status
Number of overdue enrollments by status
| Dataset used | COURSE ENROLLMENTS |
|---|---|
| Platform filters affecting this visual |
In-Progress Enrollments
Total number of enrollments to date where the status is In-Progress
| Dataset used | COURSE ENROLLMENTS |
|---|---|
| Platform filters affecting this visual |
In-Progress Enrollments Trend
Distribution of In-Progress enrollments over time considering first access date
| Dataset used | COURSE ENROLLMENTS |
|---|---|
| Platform filters affecting this visual |
Course Enrollments & Completions - Detailed Report
List of the course enrollment records
| Dataset used | COURSE ENROLLMENTS |
|---|---|
| Columns displayed |
|
| Platform filters affecting this visual |
Learning plans enrollments by status
Total number of enrollments in learning plans for the selected period with the breakdown by status
| Dataset used | LP ENROLLMENTS |
|---|---|
| Platform filters affecting this visual |
Learning plan completion rate
Percentage of learners having completed learning plans compared to the total number of learners enrolled in learning plans
| Dataset used | LP ENROLLMENTS |
|---|---|
| Platform filters affecting this visual |
Learning plan progress rate
Percentage of learning plans completed courses compared to the total number of courses found in the learning plans
| Dataset used | LP ENROLLMENTS |
|---|---|
| Platform filters affecting this visual |
Learning plan completion trend
Distribution over time of the number of learners who completed learning plans
Dataset used
| Dataset used | LP ENROLLMENTS |
|---|---|
| Platform filters affecting this visual |
Learning plan courses completion breakdown
Enrollment status details of all courses found in the selected learning plans
| Dataset used | LP ENROLLMENTS |
|---|---|
| Columns displayed |
|
| Platform filters affecting this visual |
Courses enrollment by status
Overview of the enrollment status of the courses found in the selected learning plans
| Dataset used | LP ENROLLMENTS |
|---|---|
| Platform filters affecting this visual |
Learning plan completions by group
Number of completed learning plans in each group
| Dataset used | LP ENROLLMENTS by GROUP |
|---|---|
| Platform filters affecting this visual |
Learning plan completions by branch
Number of completed learning plans broken down by branches of the same level
| Dataset used | LP ENROLLMENTS by BRANCH |
|---|---|
| Platform filters affecting this visual |
Learning plan completions by user
Number of completed learning plans by each user
| Dataset used | LP ENROLLMENTS |
|---|---|
| Platform filters affecting this visual |
Most/Least completed learning plans
Number of completions recorded for every selected learning plan
| Dataset used | LP ENROLLMENTS |
|---|---|
| Platform filters affecting this visual |
User completion rate in learning plans
Completion rate of each user in every learning plan they are enrolled in
| Dataset used | LP ENROLLMENTS |
|---|---|
| Columns displayed |
|
| Platform filters affecting this visual |
Learning plan overdue rate
Percentage of all overdue enrollments, regardless of status, considering the learning plans that have a deadline
| Dataset used | LP ENROLLMENTS |
|---|---|
| Platform filters affecting this visual |
Test pass rate
Percentage of participants who passed the test out of the total number of participants
| Dataset used | TESTS |
|---|---|
| Platform filters affecting this visual |
Average test score
Average test scores normalized on a 0 to 100 scale
| Dataset used | TESTS |
|---|---|
| Platform filters affecting this visual |
Average number of test attempts
Average number of attempts made by users to pass the tests
| Dataset used | TESTS |
|---|---|
| Platform filters affecting this visual |
Most attempted tests
Test by number of attempts regardless of whether they were passed or not
| Dataset used | TESTS |
|---|---|
| Columns displayed |
|
| Platform filters affecting this visual |
Questions by accuracy rate
List of all the questions by accuracy rate
| Dataset used | TESTS |
|---|---|
| Columns displayed |
|
| Platform filters affecting this visual |
Test - Detailed report
List of all the questions by accuracy rate
| Dataset used | TESTS |
|---|---|
| Columns displayed |
|
| Platform filters affecting this visual |
Registered users by status
Overall number of users registered on the platform, split by activated and inactivated users
| Dataset used | USERS |
|---|---|
| Platform filters affecting this visual |
Registered users by time period
Overall number of registered users for the last time periods - expressed in days - dating back 120 days or less
| Dataset used | USERS |
|---|---|
| Platform filters affecting this visual |
Registered users by level
Overall number of users registered on the platform divided by level (Superadmin, Power User, User)
| Dataset used | USERS |
|---|---|
| Platform filters affecting this visual |
Registrations over time
Distribution of registrations over time
| Dataset used | USERS |
|---|---|
| Platform filters affecting this visual |
Last access date
Number of users whose last access happened in the last time periods - expressed in days - dating back 120 days or less
| Dataset used | USERS |
|---|---|
| Platform filters affecting this visual |
Users engaged in training
Number of users who have accessed a course at least once in the selected time period - expressed in days - dating back 180 days or less
| Dataset used | USERS |
|---|---|
| Platform filters affecting this visual |
Users engaged in training trend
Distribution over time of active users (users that have accessed a course)
| Dataset used | TIME SPENT ON LEARNING |
|---|---|
| Platform filters affecting this visual |
Evolution in the number of users engaged in training
Comparison between the last 30 days and the last 30 days before that for the number of users who have accessed a course
| Dataset used | TIME SPENT ON LEARNING |
|---|---|
| Platform filters affecting this visual |
Users by branch
Number of users divided by branch
| Dataset used | USERS by BRANCH |
|---|---|
| Platform filters affecting this visual |
Users by group
Number of users divided by group
| Dataset used | USERS by GROUP |
|---|---|
| Platform filters affecting this visual |
Users - detailed report
List of user records
| Dataset used | USERS |
|---|---|
| Columns displayed |
|
| Platform filters affecting this visual |
ILT Attendance Rate
Percentage of learners who attended the ILT events compared to the expected number of learners
| Dataset used | ILT ATTENDANCES |
|---|---|
| Platform filters affecting this visual |
Attendance Trend
Number of learners having attended the ILT events vs learners who did not, for each time period
| Dataset used | ILT ATTENDANCES |
|---|---|
| Platform filters affecting this visual |
ILT Completion Rate
Percentage learners having completed ILT courses/sessions during the selected timeframe
| Dataset used | COURSE ENROLLMENTS |
|---|---|
| Platform filters affecting this visual |
ILT Completion Trend
Completion of ILT courses/sessions by learners over time
| Dataset used | COURSE ENROLLMENTS |
|---|---|
| Platform filters affecting this visual |
Seat Booking vs. Capacity
Percentage of booked seats over total capacity for each location
| Dataset used | ILT ATTENDANCES |
|---|---|
| Platform filters affecting this visual |
Number of hours of ILT delivered in the selected timeframe
Number of hours of ILT delivered in the selected timeframe
| Dataset used | ILT ATTENDANCES |
|---|---|
| Platform filters affecting this visual |
Number of ILT Consumed Hours
Number of hours of ILT consumed in the selected timeframe
| Dataset used | ILT ATTENDANCES |
|---|---|
| Platform filters affecting this visual |
Average Number of ILT Consumed Hours per User
Average number of hours of ILT consumed per user in the selected timeframe
| Dataset used | ILT ATTENDANCES |
|---|---|
| Platform filters affecting this visual |
Number of ILT hours delivered by Instructor
Number of ILT hours delivered by each instructor for the selected timeframe
| Dataset used | ILT ATTENDANCES by INSTRUCTOR |
|---|---|
| Platform filters affecting this visual |
Instructor-Led Training (ILT) - Detailed Report
List of ILT attendance records
| Dataset used | ILT ATTENDANCES |
|---|---|
| Columns displayed |
|
| Platform filters affecting this visual |
Total time spent by learners
Sum of all session durations within a time period
| Dataset used | TIME SPENT ON LEARNING |
|---|---|
| Platform filters affecting this visual |
Average time spent per learner
Sum of the total time spent on learning divided by the number of learners enrolled in at least one session
| Dataset used | TIME SPENT ON LEARNING |
|---|---|
| Platform filters affecting this visual |
Time spent to completion
Average time spent by users from the first access to the course until the completion
| Dataset used | TIME SPENT ON LEARNING |
|---|---|
| Platform filters affecting this visual |
Time spent by learner
Time spent by each learner in the given time period
| Dataset used | TIME SPENT ON LEARNING |
|---|---|
| Platform filters affecting this visual |
Engagement rate
Ratio of the time spent by learners in the last 30 days compared to the time spent in the previous 30 days
| Dataset used | TIME SPENT ON LEARNING |
|---|---|
| Platform filters affecting this visual |
Time spent trend
Time spent on learning by all learners in a specific time period
| Dataset used | TIME SPENT ON LEARNING |
|---|---|
| Platform filters affecting this visual |
Time spent by branch
Time spent by learners broken down by branches of the same level
| Dataset used | TIME SPENT ON LEARNING by BRANCH |
|---|---|
| Platform filters affecting this visual |
Time spent by group
Time spent by learners for each user group
| Dataset used | TIME SPENT ON LEARNING by GROUP |
|---|---|
| Platform filters affecting this visual |
Time spent by course
Time spent by learners in each course
| Dataset used | TIME SPENT ON LEARNING |
|---|---|
| Columns displayed |
|
| Platform filters affecting this visual |
Certification By Status
Number of certifications to date by status
| Dataset used | CERTIFICATIONS |
|---|---|
| Platform filters affecting this visual |
Issued Certifications
Total number of certifications issued over the selected period
| Dataset used | CERTIFICATIONS |
|---|---|
| Platform filters affecting this visual |
Expired Certifications
Number of certifications issued and expired in the given periods
| Dataset used | CERTIFICATIONS |
|---|---|
| Platform filters affecting this visual |
Valid Certification to Date by Branch
Number of valid certifications to date by branch
| Dataset used | CERTIFICATIONS by BRANCH |
|---|---|
| Platform filters affecting this visual |
Valid Certification to Date by Group
Number of valid certifications to date by group
| Dataset used | CERTIFICATIONS by GROUP |
|---|---|
| Platform filters affecting this visual |
Valid Certifications to Date by User
Number of valid certifications to date by user
| Dataset used | CERTIFICATIONS |
|---|---|
| Platform filters affecting this visual |
Issued Certifications by period
Number of certifications issued over time
| Dataset used | CERTIFICATIONS |
|---|---|
| Platform filters affecting this visual |
Issued Certification to Date by Branch
Number of issued certifications to date by branch
| Dataset used | CERTIFICATIONS by BRANCH |
|---|---|
| Platform filters affecting this visual |
Issued Certifications by Group
Number of issued certifications by group in the selected time period
| Dataset used | CERTIFICATIONS by GROUP |
|---|---|
| Platform filters affecting this visual |
Issued Certifications by User
Number of issued certifications by user in the selected time period
| Dataset used | CERTIFICATIONS |
|---|---|
| Platform filters affecting this visual |
Most issued Certifications
Most issued certifications in the selected period
| Dataset used | CERTIFICATIONS |
|---|---|
| Platform filters affecting this visual |
Renewing Certifications to Date
Total number of certifications in renewing status
| Dataset used | CERTIFICATIONS |
|---|---|
| Platform filters affecting this visual |
Renewed Certifications to date
Total number of valid certifications that have already been renewed at least once
| Dataset used | CERTIFICATIONS |
|---|---|
| Platform filters affecting this visual |
Expiring certifications
Overview of the certifications expiring in the next 90 days
| Dataset used | CERTIFICATIONS |
|---|---|
| Platform filters affecting this visual |
Expired Certifications over Time
Number of expired certifications over time
| Dataset used | CERTIFICATIONS |
|---|---|
| Platform filters affecting this visual |
Top Certifying Courses
Top certifying courses in the selected period
| Dataset used | CERTIFICATIONS |
|---|---|
| Platform filters affecting this visual |
Top Certifying Learning Plans
Top certifying learning plans in the selected period
| Dataset used | CERTIFICATIONS |
|---|---|
| Platform filters affecting this visual |
Certifications - Detailed Report
List of certification records
| Dataset used | CERTIFICATIONS |
|---|---|
| Columns displayed |
|
| Platform filters affecting this visual |
Registrations
Total number of registrations in the selected period
| Dataset used | COMMUNITY |
|---|---|
| Platform filters affecting this visual |
Registrations trend
Number of registrations over the selected period
| Dataset used | COMMUNITY |
|---|---|
| Platform filters affecting this visual |
Active sessions
Total number of user sessions in the selected period
| Dataset used | COMMUNITY |
|---|---|
| Platform filters affecting this visual |
Active sessions trend
Number of user sessions over the selected period
| Dataset used | COMMUNITY |
|---|---|
| Platform filters affecting this visual |
New posts and comments
Number of posts and comments created over the selected period
| Dataset used | COMMUNITY |
|---|---|
| Platform filters affecting this visual |
Most active members
Top users with the highest sum of interactions with the community, as measured by creating posts, commenting, and adding reactions
| Dataset used | COMMUNITY |
|---|---|
| Columns displayed |
|
| Platform filters affecting this visual |
Most viewed/voted/commented posts
Top posts with the highest number of interactions
| Dataset used | COMMUNITY |
|---|---|
| Columns displayed |
|
| Platform filters affecting this visual |
Top voted comments
Top comments with the highest number of upvotes
| Dataset used | COMMUNITY |
|---|---|
| Columns displayed |
|
| Platform filters affecting this visual |
Origin of training materials
Overview of materials by origin: central repository or course management
| Dataset used | TRAINING_MATERIALS |
|---|---|
| Platform filters affecting this visual |
Training material types
Breakdown of training materials by type
| Dataset used | TRAINING_MATERIALS |
|---|---|
| Platform filters affecting this visual |
Usage of central repository training materials
Overview of used and unused training materials in the central repository
| Dataset used | TRAINING_MATERIALS |
|---|---|
| Platform filters affecting this visual |
Training materials used in courses
Details about all training materials used in courses
| Dataset used | TRAINING_MATERIALS |
|---|---|
| Columns displayed |
|
| Platform filters affecting this visual |
Training material completion status
Progress of training material completion
| Dataset used | TRAINING_MATERIAL_USAGES |
|---|---|
| Platform filters affecting this visual |
Training material engagement rate
Percentage completed training materials out of those started
| Dataset used | TRAINING_MATERIAL_USAGES |
|---|---|
| Platform filters affecting this visual |
Training materials - Detailed report
List of training material usage records
| Dataset used | TRAINING_MATERIAL_USAGES |
|---|---|
| Columns displayed |
|
| Platform filters affecting this visual |
Visuals datasets
Datasets are the foundational data sources for all visuals within Advanced Insights. Each dataset contains specific types of learning data (for example, course enrollments, user information, test results). Visuals are built upon these datasets, and standard filters are applied at this dataset level through underlying queries.
For more information, please see the Using datasets chapter of the Using Advanced Insights article.
Platform Filters
Platform filters allow users to narrow down the data displayed in their dashboards. These filters can be applied from the dashboard's side panel and interact with visuals in different ways, depending on whether they are standard or date-based filters. These tables list the available filters and provides a concise description of their function.
Please note:
Filters operate by applying criteria directly to the underlying datasets of your visuals. As a result, any visual on the dashboard built upon a dataset that supports a specific filter will automatically update to reflect the selected criteria.
Exceptions to this behavior are the date filters. Unlike other filters, date filters are applied at the visual level, not at the dataset level. This means that when building custom dashboards, you must explicitly configure the date filter in the dashboard editor to apply it to the desired visuals or to entire dashboard sheets.
- All date and time filters accept values in UTC time zone only.
Dataset-level filters
Date filters
Relationship Between Components
The power of Docebo's Advanced Insights comes from the way its components interlink and interact. Understanding these relationships is crucial for precise data analysis and dashboard customization:
Visuals pull from Datasets: Every visual (for example, Course Enrollment Overview) is based on a specific dataset (for example, Course Enrollments). This relationship dictates what kind of data the visual can display.
How Platform Filters Influence Visuals
All filters applied by a user on the platform —whether standard filters or date filters— are passed to QuickSight through parameters. When a user selects a value in the filter panel, that value populates the corresponding parameter.
How these parameters affect the visuals depends on the filter type:
- Dataset-Level Filters (for example, Branch or Group): For these filters, the parameter values are automatically applied at the dataset level. This means any visual built on a dataset that supports these filters will immediately and automatically reflect the user's selection with no further configuration needed.
- Date Filters: Parameters related to date filters must be manually configured at the visual level within the QuickSight dashboard editor. While the platform passes the selected date range into the parameter, you must explicitly connect that parameter to the specific visuals or entire sheets you want it to control.