Training Platform - Export and Analyze Your Reports

Downloading reports from the Training Platform offers a multitude of data points for your users. It can be a lot to analyze! A PivotTable is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends. 

To get started, watch this quick video from our data analyst, Charlotte MacVittie, demonstrating how to apply a PivotTable to the Assignments Download (pulled from your Analytics Participant Tab). 

Click to watch video

In addition to the video, here are steps on how to create a PivotTable.

Fun with PivotTables

1.  Select Insert > PivotTable from the Excel menu.
2. Under Choose the data that you want to analyze, select Select a table or range.
3. In Table/Range, verify the cell range.
4. Under Choose where you want the PivotTable report to be placed, select New worksheet to place the PivotTable in a new worksheet or Existing worksheet and then select the location you want the PivotTable to appear.
5. Select OK.
6. To begin to add a field to your PivotTable, select the field name checkbox in the PivotTables Fields pane and drag it to be a row, column, value, or filter.
7. As you drag and drop fields, your pivot table will begin to populate automatically.

We hope these analytics will help you with your reporting and strategy for future campaigns. 💥