The Exchange Online Protection Reporting Workbook provides a way to view messaging traffic data and message detail information using the reporting web service.
The application is built as a customized Microsoft Excel workbook and uses Microsoft SQL Server PowerPivot for Excel. In the workbook, users fetch the data from the reporting web service, use it to populate a PowerPivot model, use the PowerPivot model data to render charts in Excel, and to provide PivotTable and slicer capabilities.
The PivotTable also supports drill through. This allows you to double-click on a cell in the PivotTable and drill through to the underlying message-level metadata. This message-level data is loaded into a simple table for list, sort, and filter capabilities.
The application is packaged as a compressed file that contains the Excel workbook along with the required manifest files and binaries that define and implement the customization.
Download Exchange Online Protection Reporting Workbook for Office 365 Preview - Microsoft Do