Today I would like to demonstrate a real life example on how to use Microsoft Power BI.
Setting the scene :
We are currently deploying the Windows 10 platform in a large environment, we have allready performed a swap of approx 6000 devices and are now starting the refresh on existing devices that are capable of running Windows 10.
In order to do so we rely on our network or Champions. These are skilled , ict minded collegues that each have a group of enduser under their “care”. They can assist their group of users and have specific tools and communication channels available with the ICT service.
Now the customer has approximately 350 different locations in Belgium and we have created a “self-service” system where the end-user drives the upgrade by contacting his favorite champion. He/she can start the refresh operation after performing some manual, some semi-automated actions and after a few hours the laptop is completely up and running with Microsoft latest operating system.
However there are approx 12k devices that will need to be upgraded so this will be an ongoing operation for quite some time. So we needed a way to visualise and to stimulate progress. In comes Power BI !
In short Power Bi is the Business Intelligence part of Office 365 , allowing you to create valuable insight in data. We are not going to discuss the details , we are just going to perform a quick overview and show the result.
Additional info and step by step can be found here :
Step 1 : get the data
Easy , we export the data from sccm query to excel. We get raw data like pc name , AD site and client OS name.
We allready modify the data by creating a pivottable that show totals for location , OS version and devices.
Now we can import this file in our Power BI environment.
Step 2 : manipulate the data
Well our sccm report has the following parameters : pc name, operating system version and AD Site name. The AD site name has a syntax that contains postal code, city and adress information.
Because we want to visualise per province we needed to do the following :
=> Split the column with the ad site information based on “,”
=> Create an additional column that displays province information based on the postal code. Use a formula.
Then combine the information for maximum accuracy on geo location. Also rename to English language.
Good ! Now we want to display something that show the number of devices with Windows 10 versus thet total number of devices. We use a new measure.
Tip ! Rename you headers so you know which data you are using.
Now we define the location field and select the visualisation.
Stunning ! We quickly get an interactive overview of how the rollout is progressing.
And we can even create a location based visualisation.
The sky is the limit … Enjoy.