Instructions for Creating Advanced Power Pivot Table Reports from Commissioner Tools Reports

Step-by-Step Instructions for Using Power Pivot Tables

Detailed Explanation of the Power Pivot Table Reports

Job Aide Handout (prints two sided 3x5 for Avery5388 stock)

Alternate location for reports

Step 1: Run Commissioner Tools report.
Step 2: Download CSV file.
Step 3: Open tool (.xlsx) and load the CSV file.
Step 4: Analysis reports ready to print or PDF.

Power Pivot
Table Name

Step 1 and 2
Required Commissioner Tools
CSV report file (your raw data)

Step 3
Power Pivot Table spreadsheet
(Analysis Tool)

Step 4
Sample Output

Unit Contact Analysis

District_Contact_Stats_201x.csv

Unit Contact Analysis Tool

Unit Contact Analysis

Unit Health Analysis

Unit_Health_201x.csv

Unit Health Assessment Tool

Unit Health Analysis

Commissioner Contact Analysis

Commissioner_Contacts_201x_Without_SubTotal.csv

Commissioner Contact Analysis

Commissioner Contact Analysis

Roundtable Analysis

Unit_Health_201x.csv

Roundtable Assessment Tool

Roundtable Analysis Calendar Year

Roundtable Analysis Program Year

District Commissioner Visual Analysis

District_Contact_Stats_201x.csv

DC Visual Analysis Tool

DC Visual Analysis

Units Needing Attention

Unit_Health_201x.csv
Priority_Needs_Units.csv
Assigned_Units.csv

Units Needing Attention Tool

Units Needing Assistance Tool

Units_Needing_Attention_Sample_Reports.pdf

Merge Tools

Multiple Unit_Health_201x.csv
District_Contact_Stats_201x.csv files
Multiple Assigned_Units.csv
Multiple Priority_Needs_Units.csv

Merge_UH_v2017-2.xlsm
Merge_DCS_v2017-2.xlsm
Merge_AU_v2017-2.xlsm
Merge_PN_v2017-2.xlsm

Using the Merge Tools.pdf