Search This Blog

Tuesday, February 2, 2016

Excel Power Map vs. Power BI Globe Map visualization

[2016-02-02] PowerMap in Excel is a great tool with good design and comprehensive user experience. I’ve started using it about a year ago when our team participated at first Canadian Microsoft Big Data hackathon (http://blogs.technet.com/b/cansql/archive/2015/04/13/big-data-hackathon-a-story-from-a-winning-team.aspx).

So I gradually developed a taste to this Geo analytical tool that helps to map data points and describe insightful and informative stories. Later on in November of 2015, visually similar tool has been added to the Power BI (http://blogs.msdn.com/b/powerbi/archive/2015/11/24/visual-awesomeness-unlocked-the-globe-map.aspx). And this gave me an opportunity to compare and analyse both tools’ functionality.

Basically they’re not competing with each other, but rather live in two different worlds: one is a client application in Excel, the other one is a custom Power BI visualizations. They’re friends and they’re siblings :-)


Things that Excel Power Map and Power BI Globe Map have in common:
  • Mapping data points to a 3D Globe visualization using geo coordinates (Latitude/Longitude and regular address coordinates)
  • Data facts explorations being attached to associated geo coordinates.



Things that Power BI Globe Map doesn’t have compared with the Excel Power Map:

o   Ability to change globe themes
o   Ability to create visual tours and save them as video files
o   Change the chart shapes
o   Change the height and thickness scale of visuals
o   Change color for a series
o   Find location feature
o   Add an annotation with image
o   Legends
o   Bubble charts, pie charts and region charts
o   Power Map graphics options

Things that Excel Power Map doesn’t have compared with Power BI Globe Map:
  • Geo filtering based on additional visualizations that are sourced from the same data model (this is one of my favorites).
  • Power Map has an option to add a 2D chart to a globe visualization too, but Power BI integration of multiple visualizations is on a different level (great way for a real data exploration!).
  • Power BI Globe visualization is free compared with a slightly cumbersome licensing aspect to enable a Power Map option in Excel. 

Few suggestions if you want to build a data visualization in Excel Power Map:
  • Power Map requires really powerful machine to process and create video (go with 64 bit Office; more memory, especially if you try to work with very complicated shape data files and attempting to add images as annotations).
  • When you add a new layer to existent scene, make it invisible first (do all the adjustments) and then make it visible, otherwise as soon you place a field name to Location then your scene will be turned.
  • No Save button and Undo/Redo buttons' behavior are difficult to understand.
  • A few times I've had a glitch with a text box when later you try to change its text or background color (no changes after pressing OK  button); only by recreating this text box all necessary adjustments were possible.
  • Scene effect (difficult to predict, without actually trying them), but when you master your skills changing different effects between different scenes, then you get all the enjoyment of creating nice Map visualizations :-)




[2016-02-06] Update:
Three days ago Microsoft announced Power BI "publish to web" functionality (https://powerbi.microsoft.com/en-us/blog/announcing-power-bi-publish-to-web/) and I've just tried to publish my latest Power BI report of with public Berkeley Earth data of over land temperatures (http://berkeleyearth.org/).

And now I can really rotate a Power BI Globe inside my blogger post, and you can do this as well; plus, you can interact with all other controls of the reports and check how the Globe rotate itself based on your data criteria selections (Country or Temperature range).

It works! Great feeling!

Happy data adventures!

17 comments:

  1. This comment has been removed by a blog administrator.

    ReplyDelete
  2. Helpful commentary , I loved the insight ! Does someone know if my company might get a sample a form copy to fill in ?

    ReplyDelete
  3. Best Excel Training Academy in Noida, Excel Training in Noida with Lowest Cost. Compare all Academies in Noida-Price, Reviews, Address, Maps and Photos. Contact us- 9312580474
    More@ http://99excel.com/

    ReplyDelete
  4. Find best training academy for Ms Excel Training, advanced excel classes in Noida within Your Budget and 100% Satisfaction Facility. Compare all Clinics in Delhi- Price, Reviews, Address, Maps and Photos. Contact us- 9312580474
    More@ http://99excel.com/

    ReplyDelete
  5. Ms Excel Training In Noida.99 Excel is one of the top Training academies in Noida for Excel Training Within Your Budget. Compare all Training academy – Price, Reviews, Address, Maps and Photos. Contact us- 9312580474.
    More@ http://99excel.com/

    ReplyDelete
  6. Ms Excel Training In Noida.99 Excel is one of the top Training academies in Noida for Excel Training Within Your Budget. Compare all Training academy – Price, Reviews, Address, Maps and Photos. Contact us- 9312580474.
    More@ http://99excel.com/

    ReplyDelete
  7. Find the best institute in Noida for Excel Training in Noida, Lowest Cost, Free Demo, 100 Satisfaction Service. Compare all Training institute in Noida- Price, Reviews, Address, Maps and Photos. Contact us- 9312580474.
    More@ http://99excel.com/

    ReplyDelete
  8. Find the top Institute for Advanced Excel Classes in Noida, Lowest Cost, Free Demo, 100% Satisfaction Service. Compare all institutes in Noida- Price, Reviews, Address, Maps and Photos. Contact us- 9312580474
    More@ http://99excel.com/

    ReplyDelete
  9. 99 Excel is one of the best Training Institutes for Ms Excel Training Institutes in Delhi Ncr With Lowest Cost, Free Demo, 100% Satisfaction Service. Get Phone Number, Address, Maps and Contact us-9312580474 http://99excel.com/

    ReplyDelete
  10. your blog look nice and informative which I found on internet.thank you for your post .
    Power BI Online Training USA

    ReplyDelete
  11. Thanks so much for sharing this awesome info! I am looking forward to see more postsby you!
    excel vba training

    ReplyDelete
  12. Thanks for sharing the very useful info about power bi  and please keep updating......
    Power BI Online Training india
    Power BI Online Training USA

    ReplyDelete
  13.  wondered upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I’ll be subscribing to your feed and I hope you post again soon.
    Power BI Online Course
    Power BI Online Course bangalore

    ReplyDelete
  14. Very informative ..i suggest this blog to my friends..Thank you for sharing
    Power BI Online Training

    ReplyDelete