Introduction
The Insights area of your learning platform allows you to collect data and useful information on the activities taking place on your platform. Insights comes with a number of built-in dashboards. You can also build your own custom dashboards picking visuals from the Visual library according to your needs.
Learn more about Creating and managing custom dashboards.
You can go one step further using Advanced Insights.
Please note! Advanced Insights is only available for custom dashboards. It is not available for the built-in dashboards as those are not editable.
Reasons to use Advanced Insights
Using Advanced Insights can grant you the following benefits:
- Build fully customized dashboards: Leverage the power of analytics in a full authoring mode embedded in your platform.
- Choose your own metrics: Build a specific analysis aligned with your business logic.
- Create your own visuals: Create visuals from scratch, customizing each detail, from the data to the look and feel.
Important notes about the use of the QuickSights User guide
Some of QuickSight features are not included in Advanced Insights because they have been deactivated, predefined in your account, or they are managed by Docebo. For this reason, you will find some differences between the features described in the QuickSight User guide and the ones included in Advanced Insights.
Please disregard any references or dedicated articles in the QuickSight documentation about:
- QuickSight console
- Account / user management
- Analysis management
- Data source management
- Dataset creation and management / data connections
- Data preparation (except calculated fields)
- Data refresh / SPICE
- Publishing dashboards
- Sharing dashboards or analyses
- Themes
- Paginated reports
- Anomaly detections
- Alerts
- Q / Generative BI
Limitations related to AWS QuickSight
Advanced Insights relies on QuickSight and therefore has the same limitations as this solution described in the following sections:
- Visual display limits (opens in a new tab)
- Data points limits (opens in a new tab)
- Data source limits (opens in a new tab)
Accessing Advanced Insights
To use the Advanced mode of Insights, follow these steps:
- Access the Admin menu by clicking on the gear icon in the top right corner of the page.
- Locate the Insights area in the E-learning section of the menu.
- Create or access a custom dashboard in edit mode as described in the article Creating and managing custom dashboards. Then go to the Builder tab.
- Activate the Advanced mode toggle in the bottom left corner of the page.
You will access all the available QuickSight functionalities embedded in your platform allowing you to build your visuals and your dashboard.
The page will include one single sheet (with the visuals you have already added to your dashboard, if any). You can also add other sheets to the dashboard following the instruction outlined in this article: Adding sheets (opens in a new tab).
Using customization panels
When you start editing a dashboard with Advanced Insights, you will see a header allowing you to customize the dashboard.
Let’s take a look at the main options:
- Dataset: Add datasets to your visuals and edit them.
- Visualization: Add visuals to your dashboard, edit a visual type or the data related to the visual.
- Filters: Update filters and narrow down data.
- Parameters: Define the additional fields you want to use. More on the use of additional fields for Advanced Insights
- Insights: Suggestions of some of the interesting insights you can get from the data
- Properties: Access and edit the properties of each visual
- Add a visual: Quickly create a new visual
- Add text: Add descriptions and other notes
Using datasets
The datasets provided by Docebo cannot be modified, and new datasets cannot be added. However, it is possible to extend the datasets by adding calculated fields.
To select datasets, click on Data in the header to open the panel. Each visual can be linked to only one dataset. The datasets are not listed alphabetically but you can easily look for them using the dedicated search field within the dropdown menu.
Insights currently covers six topics. Each topic works with different datasets that only differ by a few fields:
- Certifications
- Course enrollments and completions
- ILT attendance
- Learning plan enrollments
- Time spent on learning
- Users
For each topic, Advanced Insights offers a main dataset as well as datasets that capture specific aspects of that topic. For example, if you want to conduct a branch-level analysis on a particular topic, a dedicated dataset is provided for that purpose. This is especially common for resources where multiple values are assigned to a single record. You will find below a list of the different types of datasets available:
- Main dataset: For each topic, you will find a main dataset. This is the dataset you should use by default unless you need to analyze, filter, or display results by branch, by group or another item. A main dataset is available for each topic covered by Advanced Insights.
- Dataset showing results by branch: Use this dataset if you need to analyze, filter or display results by branch. The first 9 levels of the branch hierarchy are included and separated by level. This is a version of the main dataset where the results for each user are expanded to reflect their assignment to multiple branches (of different levels). A dataset by branch is available for each topic covered by Advanced Insights.
- Data showing results by group: Use this dataset if you need to analyze, filter, or display results by group. This is a version of the main dataset where the results for each user are expanded to reflect their assignment to multiple groups. A dataset by group is available for each topic covered by Advanced Insights.
- Dataset showing results by instructor: Use this dataset if you need to analyze, filter, or display results by instructor. This is a version of the main ILT dataset with the attendances in ILT sessions expanded to reflect the instructors of the sessions. This dataset is only available for the ILT topic.
Using additional fields as a visual field of filter
Please note! At the moment, five User additional fields and five Course additional fields can be used per dashboard. The additional field parameters are only available for the Course enrollments main dataset. The use of additional fields will soon be extended to all datasets and the number of available additional fields will increase.
The User additional fields and Course additional fields you have set on your platform can be used when editing a dashboard with Advanced Insights. To use an additional field, follow the steps below:
- Start editing your dashboard with the Advanced Insights mode
- Click on Data in the header and select Parameters
- In the Parameters section that opens, look for one of these parameters:
- CustomUserAdditionalField1
- CustomUserAdditionalField2
- CustomCourseAdditionalField1
- CustomCourseAdditionalField2
- Click on the ellipsis menu next to the parameter name and select Edit parameter
Please note! For each of the parameters listed above, you will see one version named [parameter name]_value and another one named [parameter name]_translation. This second version simply gives you the user additional field label that you selected. The parameter to use is [parameter name]_value.For example: if you have defined the first User additional field, you will have to select user_additional_field_1_value in the dataset field list. The other available field user_additional_field_1_translation will include the User additional field label that you have selected.
Once you start editing the parameter, follow these guidelines:
- Do not edit the Name field.
- Edit the CustomAdditionalFieldLanguage field, to add the label of the additional field you want to use. Please note: The value you enter here must precisely match the label of the additional field set on your platform (respecting the case).
- If your additional field label is not set in English on the platform, you must edit the Static default value field to set it to the language used.
After completing these steps, you can use Additional fields for your visuals.
For example, if you have defined the first user additional field, select user_additional_field_1_value in the dataset field list by clicking on the field name.
If no value for this additional field has been defined for a specific user, the corresponding cell will show a null value.
If you want to use this field to filter the visual or the whole dashboard, follow the steps outlined in the Using filters chapter of this document. Edit the filter and select Custom filter from the Filter type drop-down menu. You can choose to include or exclude multiple values from your filter using the Filter condition drop-down and entering one value per line. When you are done editing your filter, click on Apply.
The steps described here should be applied for each dashboard, which means that the additional fields used can be different for every dashboard.
Adding a visual
To add a visual to your dashboard, you can use the Visual library as described in the article Creating and managing custom dashboards.
When using Advanced Insights, you can edit any visual or create one from scratch.
Read the following articles to learn how to create and use visuals:
- Creating a new visual (opens in a new tab)
- Different visual types available (opens in a new tab)
- Duplicating a visual (opens in a new tab)
- Renaming a visual (opens in a new tab)
- Deleting a visual (opens in a new tab)
Managing visuals’ fields
Read the following articles to find out how to manage the visuals’ fields:
- Using visual field controls (opens in a new tab)
- Adding or removing a field (opens in a new tab)
- Changing a field association (opens in a new tab)
- Changing field aggregation (opens in a new tab)
- Changing date field granularity (opens in a new tab)
- Customizing field format (opens in a new tab)
- Sorting visual data (opens in a new tab)
Using filters
When creating or editing a dashboard with Advanced Insights, you can set predefined filters. Filters can be applied to a single visual, the entire sheet, or the entire dashboard. Follow these steps to add and configure predefined filters:
- Click on Filters in the header
- In the Filters panel that opens, click on Add and select a field. You can use the search bar to find the field you are looking for.
- The filter is added to your list of predefined filters. Click on the ellipsis menu next to the filter’s name and select Edit.
- Set the filter type, condition, and value and click on Apply.
Once you have set predefined filters following the steps outlined above, and you have added them to a visual or a dashboard, these filters will be available to Insights’ users. Users can use them to filter a visual or a dashboard but they cannot modify them.
Example: If you have created a visual using the Course enrollments dataset and including the Course filter, then this filter will be available to users when viewing the visual.
Please note! Date filters require an extra step to be available to users. When editing the filter, after having set the filter type and conditions, you need to map the filter to the relevant parameters. Enable the checkbox Use parameters and set a start date and an end date.Date filters are:
- Course enrollment date
- Course completion date
- Certification issue date
- Certification expiration date
- Event date
- Learning plan enrollment date
- Learning start date
- User registration date
Read the following articles to learn more about filters:
- Cross-sheet filters and controls (opens in a new tab)
- Filter types in Amazon QuickSight (opens in a new tab)
Customizing the format of a visual
Read the following articles to learn how you can customize the format of a visual:
- Formatting a visual (opens in a new tab)
- Format options per visual type (opens in a new tab)
- Format options for tables and pivot tables (opens in a new tab)
- Showing and hiding axis grid tick (opens in a new tab)
- Changing visual colors (opens in a new tab)
- Format field colors (opens in a new tab)
- Conditional formatting for visuals (opens in a new tab)
- Customizing font and style on visuals (opens in a new tab)
- Customizing visual labels (opens in a new tab)
- Customizing visual legend (opens in a new tab)
- Customizing missing data controls (opens in a new tab)
- Changing visual scale axis range (opens in a new tab)
- Customizing a visual title (opens in a new tab)
- Customizing visual tooltips (opens in a new tab)
Using calculated fields
Calculated fields allow you to prepare and refine data within a dataset for improved visualization. In the Data panel, you can either create a new calculated field by clicking the + CALCULATED FIELD button or modify an existing one through the ellipsis menu (⋮ -> Edit calculated field).
Please note that calculated fields are specific to the current dashboard, meaning if you want to use the same field in another dashboard, you’ll need to recreate it there.
Read the following articles to learn how to use calculated fields
- Adding a calculated field
- Order of evaluation in QuickSight
- Using level aware calculations
- Functions and Operators for calculated fields
Here are some examples of calculated fields:
- Full user name:
concat({user_firstname}, " ", {user_lastname}, " (", toString({user_id}), ")")
- Is there an expiration date for the certification:
isNotNull({user_certification_expire_date_dt})
- Counter to calculate the overdue rate (course enrollment datasets):
sumIf(1, {enrollment_is_overdue} = 1) / sum(1)
- Pre-calculate the completion rate at the user level, impacted by filters selected in the dashboard (course enrollment datasets)
ifelse((sumOver(ifelse({user_enrollment_status}='Completed',1,0),[{user_userid}],PRE_AGG)/countOver(count,
[{user_userid}],PRE_AGG)) < 1, 0 ,1) - Pre-calculate the completion rate at the user level, indifferent to filters selected in the dashboard (course enrollment datasets)
ifelse((sumOver(ifelse({user_enrollment_status}='Completed',1,0),[{user_userid}],PRE_FILTER)/countOver(count,
[{user_userid}],PRE_FILTER)) < 1, 0 ,1) - Calculate the average number of course enrollments by user (overall, indifferent to dashboard filters) on the dimensions of a visual (course enrollment datasets)
First you define a calculated field ‘Enrollment Count by User’distinctCountOver({course_id},[{user_id}],PRE_FILTER)
Then you create the second calculated field :
avg({Enrollment Count by User},[{user_id},${visualDimensions}])
- Rename a dimension with custom labels (course enrollment datasets)
switch(
toLower({user_enrollment_status}),
'to begin', 'Enrolled',
'waiting list', 'Waiting User',
'in overbooking', 'Overbooking',
'to confirm', 'Enrollement to Confirm',
'in progress', 'In Progress',
'suspended', 'Suspended',
'completed', 'Completed',
'Uknown') - Classify first access to completion time in different ranges (course enrollment datasets):
ifelse( {firstaccess_to_completion_diff} < 15,
"n < 15min",
ifelse(
{firstaccess_to_completion_diff} >= 15 and {firstaccess_to_completion_diff} < 30,
"15min < n < 30min",
ifelse(
{firstaccess_to_completion_diff} >= 30 and {firstaccess_to_completion_diff} < 60,
"30min < n < 60min",
ifelse(
{firstaccess_to_completion_diff} >= 60 and {firstaccess_to_completion_diff} < 120,
"60min < n < 120min",
"120min < n"
)
)
)
)
Please note! Some calculated fields have been predefined by Docebo in relation to the Visual library. You can edit these predefined calculated fields but this will also alter the behavior of the related visuals if you use them in the dashboard. Any changes in these predefined calculated fields will only impact visuals within the dashboard where the changes were made.
Adding interactivity (optional)
This is an advanced feature that is not needed for a basic use of Advanced Insights. Read the following articles if you want to learn more about adding interactivity to your dashboard.
- Using parameters (opens in a new tab)
- Using custom actions (opens in a new tab)
- Adding conditional rules for the dashboard content (opens in a new tab)
AI features (optional)
This is an advanced feature that is not needed for a basic use of Advanced Insights. Read the following articles to learn more about using AI features in your dashboard.