cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JerryWhite Frequent Visitor
Frequent Visitor

Office 365 Usage Analytics Data Manipulation

Hi everyone,

 

We're exploring the reports available in the Microsoft 365 Adoption Preview & 365 Usage Analytics using Power BI. The reports are really helpful, however we're hoping to further manipulate the data.

 

Our next big focus is to breakdown each user's activity - each month, on each O365 product with the different types of Activity. This will allow us to create a relationship to our different services which we can then use to filter through the data to identify areas of improvement and measure successes.

 

The barrier we have currently is that the Usage Analytics & Adoption Preview seems to only report total activity for a product in a given month as 'count' of activity data - we don't seem to be able to break this down further to see which users are included in such a count.

 

For example, we want to view how many Skype IM messages & Outlook emails were sent within X sub-department of our organisation on a month-by-month breakdown over the last 6 or 12 months - but we have not found a way to obtain this. information Is there any way to obtain further usage data from the available APIs for us to break down, or is there a way to 'go up a level' for the Adoption Preview data?

 

Any help or advice would be greatly appreciated.

 

Many thanks,

Jeremy White (SCC)

7 REPLIES 7
JerryWhite Frequent Visitor
Frequent Visitor

Office 365 Usage Analytics Data Manipulation

Hi everyone,

 

We're exploring the reports available in the Microsoft 365 Adoption Preview & 365 Usage Analytics using Power BI. The reports are really helpful, however we're hoping to further manipulate the data.

Our next big focus is to breakdown each user's activity - each month, on each O365 product with the different types of Activity. This will allow us to create a relationship to our different services which we can then use to filter through the data to identify areas of improvement and measure successes.

 

The barrier we have currently is that the Usage Analytics & Adoption Preview seems to only report total activity for a product in a given month as 'count' of activity data - we don't seem to be able to break this down further to see which users are included in such a count.

 

For example, we want to view how many Skype IM messages & Outlook emails were sent within X sub-department of our organisation on a month-by-month breakdown over the last 6 or 12 months - but we have not found a way to obtain this. information Is there any way to obtain further usage data from the available APIs for us to break down, or is there a way to 'go up a level' for the Adoption Preview data?

 

Any help or advice would be greatly appreciated.

 

Many thanks,

Jeremy White (SCC)

JenniferO Occasional Visitor
Occasional Visitor

Re: Office 365 Usage Analytics Data Manipulation

Hi Jeremy,

 

Have you had any luck getting your question answered?  I have a similar question -- how to see which users make up the First Time Users count in the Microsoft 365 Usage Analytics content pack.

 

Thanks,

Jennifer

JerryWhite Frequent Visitor
Frequent Visitor

Re: Office 365 Usage Analytics Data Manipulation

Hi Jennifer,

 

Thanks for 'bumping' this thread, I'm afraid there seems to be no solution so far for the adoption preview pack. My only workaround has been to manually export usage statistics of each application from the O365 admin hub, format the exported data as desired and to then use this to build my own preview from scratch, which I then update by appending the main query each month to include the new data exports. This is a real manual process and can take some time - and it doesn't include any historic data, but at least it's functional.

 

Hopefully someone can advise soon a better solution or maybe the API team can amend the source to include the information we're after, but in the meantime the above seems to work - albeit with a lot of effort!

 

Kind regards,

Jeremy

Greymane Frequent Visitor
Frequent Visitor

Re: Office 365 Usage Analytics Data Manipulation

This is a relevant question. Would be great to get some inputs from Microsoft on this.

nhamilton80 Frequent Visitor
Frequent Visitor

Re: Office 365 Usage Analytics Data Manipulation

I am also looking for a solution to be able to report on historic user-specific activity.  Does anyone know if there is an API where this information could be retreived?  Maybe Microsoft Graph?

shw528 New Member
New Member

Re: Office 365 Usage Analytics Data Manipulation

Hi @JerryWhite ,

 

Thanks for posting about this.  I am currently trying to solve this exact same problem for one of my clients.  Are you aware of any kind of "product roadmap" for the O365 Usage Analytics Data Moddel.  I'd love to be able to see when Microsoft plans on releasing any updates.  Thanks!

 

Seth

Nika Frequent Visitor
Frequent Visitor

Re: Office 365 Usage Analytics Data Manipulation

Hi All,

having the same issue... There are pre-defined reports from Microsoft using M365 Usage Analytics, but I don't know which connectors can be used to retrieve the data.

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 71 members 1,061 guests
Please welcome our newest community members: