Microsoft Dynamics CRM

{POWER BI} Unleashing POWER BI to do Map based analytics

Do you have data stored in CSV/Excel files and wished you could do some map based analytics with it. Well POWER BI lets you do all of that?

Here I have collected a random data of my Blog traffic across regions and am uploading this into POWER BI desktop:

clip_image002

Launching POWER BI desktop:

clip_image003

Once Loaded:

clip_image004

Now I can do some insights on this data:

On visualizations I took Filled map, Chose Country as Latitude and Hits as Longitude:

clip_image005

Here is the result:

clip_image007

Not only did it plot all content, it has relevant tooltips for each region with color encoding:

clip_image009

Pretty cool, isn’t it?

Well, just wait. The next thing I am going to show is I am going to get Hits added to the filter, For this I am just dragging the field for Hits to Page Level filters area:

clip_image010

Once dragged, it will look like below:

clip_image011

This coloured up regions where there were more than 100 hits:

clip_image013

In case you need any assistance for POWER BI, just get in touch.

Hope this helped!

Twitter: https://twitter.com/msdynamicsblog
LinkedIn: https://www.linkedin.com/in/deepesh-somani-00296932

Google Play Store:

https://play.google.com/store/apps/details?id=com.dynamicsofdynamicscrm.msdynamicsblog&hl=en

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s