Now we can use PowerBI and use the Microsoft intune data warehouse to build reports for the entire organization to foresee the intune analytics and the status. PowerBI being a very potential platform for data gathering and analysis this intune data warehouse can help in terms of analyzing the Microsoft intune statistics and provide us the overall metrics.
When we look into the get data from the PowerBI desktop version, we do see the option Intune Data WareHouse Beta Preview connector. Once authenticated with the account we can select this connector
At this point of writing this blog , we could see that this connector is integrated with a 3rd party service as of now and it in the progress of full mature version and can expect more improvements in the future.
On further progress we have an option to pull data up to 60 days as of now.
Once connected we can see there are 48 datasets that can be helpful in building the required reports and the dashboard for Microsoft Intune.
Here just for an example have loaded few datasets that might be helpful for us in creating a reporting for the intune statistics.
For instance we could measure how many users have intune licensed , jailbroken devices , azure ad registered devices , trends of OS versions getting enrolled in intune and even see the amount if MAM getting enforced on devices.
Once the data is segregated and creating the report we can go ahead and publish them to the Workspace.
On a successful operation we get this below message. There is an option to create a portrait view of the report which is compatible for mobile phones.
We could publish this report to dashboard and share them to users which can provide insights to enterprise mobile environment.
Finally below is an sample overview of the shared dashboard view.
There are lot of benefits in using the Data Warehouse when compared to the Azure Portal. The Data WareHouse is like accessing the raw data from the backend where the delta is refreshed in the daily fashion and we have option to pull the historical intune data.
One important point to note here is that the Intune Data Warehouse only contains Intune data. Just in case if co-management is utilized then additional steps to retrieve the data from configuration manager is required.
Power Bi desktop is used to create the reports and this can be done with the free version of the PowerBI. PowerBI Pro license is required for publishing the reports and share them for collaboration.