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 3×5 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