Sunday, April 30, 2017

Office 365 Usage report customisation

image

Many people don’t appreciate the flexibility that Office 365 usage reports provide.

image

For example, in the top left, under the breadcrumb navigation you’ll find a Select a report option.

image

Which you can see has a large number of reports to select from. You’ll also notice that there is a Office 365 groups activity report.

image

If you select the ‘hamburger’ menu in the top right of any column,

image

You’ll be presented with additional options as shown above.

image

Selecting Columns will allow you to add additional fields to the report as shown above.

I’d encourage you to go into your Office 365 Admin center and have a look at all the report and options that are available to you. I think you’ll be pleasantly surprised at what you find. And if the reports here aren’t exactly what you are after you can easily export them to a CSV file and potentially then analyse the data in Power BI.