Training Hub: Reports

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.

the learner status by course report showing the filters available.

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.

the course section enrollment report with available filters.

Accessing reports

  1. Log into Training Hub
  2. Select the Admin Console.
  3. Scroll down to Training Hub Reports.
  4. Click Learner Status by Course or Course/Section Enrollment.
  5. Choose your training provider name under Administered By.
  6. Use other filters as desired

Using filters to view a subset of data

To view a subset of the data:

  1. Click a filter
  2. Uncheck All
    1. It will take a few seconds to reload the report
  3. Click the checkbox for the item(s)
    1. Multiple items can be checked
    2. 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.
      the deptid filter only shows 4 departments since the RRC is set to OIT

Date Range filters

Each report has filters that will limit the data displayed based on certain date based events.

the three date filters

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 is no filter for due date available because there is no data in the set with a due date.

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.
      the available options in a date range filter.

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.

a tableau report showing the different areas. Filters, Pie chart, data table. and the download option highlighted at the bottom of the page.

Download the report as it appears on the screen

  1. Click Download. The download options window appears.
  2. Click Image or PDF.
    the download option for images and pdfs.

Download the data for a table

  1. Click the table to select it.
  2. Click Download. The download options window appears.
  3. 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.