Learn how to create custom PivotTable reports using Office Telemetry data in Excel 2013—without using Telemetry Dashboard.
Customers often ask us if it’s possible to set up a separate Excel workbook for creating custom reports of Office Telemetry data. The answer is yes indeed! But it takes some extra steps to get custom reports working just like they do in Telemetry Dashboard. Fortunately, once you save your Excel workbook, you don’t have to repeat these steps again.
To complete these steps, you’ll need:
After you have these prerequisites ready, you can start the following steps.
Step 1: Open the MyCustomReport workbook in Excel 2013
Step 2: Connect the MyCustomReport workbook to the telemetry database and create the PivotTable report
Step 3: Create the data relationships
Step 4: Add Lookup_issue_definitions to the Active list in the PivotTable Fields pane
Now you’re ready to create custom reports of telemetry data using Excel 2013. If you’d like to learn more about custom reporting in Telemetry Dashboard, see Custom reporting and database schema reference for Telemetry Dashboard.