There are two built-in reports in Training Hub: Learner Status by Course and Course/Section Enrollment. Both reports are hosted on the Tableau Server, so have the same interactivity. The reports are connected to the Data Warehouse, and are updated daily in the early morning. Both reports have the ability to download in various formats.
These reports are only available to Training Administrators.
In this article:
- Report overviews
- Learner Status by Course
- Course/Section Enrollment
- Accessing reports
- Using filters to view a subset of data
- Downloading report data
Report Overviews
Learner Status by Course
The Learner Status by Course allows for viewing learner enrollment and completion dates for a course. The report can filter learners by:
- Collegiate or administrative unit, ZDeptID, and/or department
- Learner Type (Employee, Guest, Student)
- Learner Status (Actively Enrolled, Complete, Incomplete, Withdrawn)
The report also has date range filters for Enrolled Date, Completed Date, and Due Date.
Course/Section Enrollment
View total numbers of enrolled, in progress, and complete learners for course sections by who administers the course. The report has filters for:
- Administered By
- Course Title
- Section
The report also has date range filters for Enrolled Date, Completed Date, and Due Date.
Accessing reports
- Log into Training Hub
- Select the Admin Console.
- Scroll down to Training Hub Reports.
- Click Learner Status by Course or Course/Section Enrollment.
- Choose your training provider name under Administered By.
- Use other filters as desired
Using filters to view a subset of data
To view a subset of the data:
- Click a filter
- Uncheck All
- It will take a few seconds to reload the report
- Click the checkbox for the item(s)
- Multiple items can be checked
- For the DeptID and Department filters in the Learner Status by Course, it's best to first filter on either the RRC or the ZDeptID first to limit the number of departments listed.
Date Range filters
Each report has filters that will limit the data displayed based on certain date based events.
If the report is filtered in a way such that no event occurred, the filter will not be displayed. In the following image, no learner has a due date assigned for any of the courses selected, so the middle filter (Due Date Range) is not displayed:
There are two buttons on the right side of the date filter: a clear filter button, and a data action list. The data action list controls what data is included in the table.
- Values in Range
- In the example below, only learners that have a due date between 6/7/2018 and 6/20/2018 will be displayed
- Values in Range and Null Values
- In the example below, only learners that have a due date between 6/7 and 6/20 AND any learner with no due date will be displayed
- Null Values Only
- In the example below, all learners without a due date will be displayed
- Non-Null Values Only
- In the example below, all learners that have a due date between 6/7/2018 and 6/20/2018 will be displayed.
- In the example below, all learners that have a due date between 6/7/2018 and 6/20/2018 will be displayed.
Downloading Reports
Both of the reports are made up of three items: the filters in the top left, the pie chart in the top right, and the data table in the bottom half.
Download the report as it appears on the screen
- Click Download. The download options window appears.
- Click Image or PDF.
Download the data for a table
- Click the table to select it.
- Click Download. The download options window appears.
- Click Data or Crosstab.
Data Option
Choosing data as the download option will open a new window with options for downloading. There are two tabs: Summary Data and Full Data. The Full Data tab has an option to include all columns in the download.
The Summary tab will download the data as it appears in the table in the Tableau.
The Full data tab will download all columns of the detail behind the summary
Crosstab Option
Choosing Crosstab will download the summary data in an Excel workbook. The data will be formatted in a tabular view.