excel power 3d map vs. power bi globe map visualization
TRANSCRIPT
![Page 1: Excel Power 3D Map vs. Power BI Globe Map visualization](https://reader030.vdocuments.us/reader030/viewer/2022013123/58796a7b1a28ab37368b4b75/html5/thumbnails/1.jpg)
Excel Power Map vs. Power BI Globe Map
SQL Saturday #487Ottawa 2016
Rayis ImayevBI Developer/Consultant at Dawn InfoTek Inc.
![Page 2: Excel Power 3D Map vs. Power BI Globe Map visualization](https://reader030.vdocuments.us/reader030/viewer/2022013123/58796a7b1a28ab37368b4b75/html5/thumbnails/2.jpg)
Excel Power Map vs. Power BI Globe Map
Agenda:
Microsoft BI: History of 3D Map visualization
Excel PowerMap
Power BI Globe Map
And the Winner is …
4/16/2016 | Excel Power Map vs. Power BI Globe Map2 |
![Page 3: Excel Power 3D Map vs. Power BI Globe Map visualization](https://reader030.vdocuments.us/reader030/viewer/2022013123/58796a7b1a28ab37368b4b75/html5/thumbnails/3.jpg)
Why 3D Map for SQL Saturday ?
Data Analytics SQL Server
combines them both
4/16/2016 | Excel Power Map vs. Power BI Globe Map3 |
![Page 4: Excel Power 3D Map vs. Power BI Globe Map visualization](https://reader030.vdocuments.us/reader030/viewer/2022013123/58796a7b1a28ab37368b4b75/html5/thumbnails/4.jpg)
Microsoft BI: History of 3D Map visualization
4/16/2016 | Excel Power Map vs. Power BI Globe Map4 |
Apr 2013"GeoFlow" Preview for Excel 2013
July 2013PowerMap for Excel 2013 Sep 2015
3D Map for Excel 2016
Nov 2015Globe Map for Power BI
![Page 5: Excel Power 3D Map vs. Power BI Globe Map visualization](https://reader030.vdocuments.us/reader030/viewer/2022013123/58796a7b1a28ab37368b4b75/html5/thumbnails/5.jpg)
Excel Power Map vs. Power BI Globe Map
Agenda:
Microsoft BI: History of 3D Map visualization
Excel PowerMap
Power BI Globe Map
And the Winner is …
4/16/2016 | Excel Power Map vs. Power BI Globe Map5 |
![Page 6: Excel Power 3D Map vs. Power BI Globe Map visualization](https://reader030.vdocuments.us/reader030/viewer/2022013123/58796a7b1a28ab37368b4b75/html5/thumbnails/6.jpg)
Excel PowerMap
Key functionality: 3D Globe visualization using geo coordinates Data facts explorations associated with geo coordinates
Additional Features: Over time data visualization (animation) Various charts and heat maps Customer geo shape files support Multiple data layers support
4/16/2016 | Excel Power Map vs. Power BI Globe Map6 |
![Page 7: Excel Power 3D Map vs. Power BI Globe Map visualization](https://reader030.vdocuments.us/reader030/viewer/2022013123/58796a7b1a28ab37368b4b75/html5/thumbnails/7.jpg)
Excel PowerMap (video sample #1)
4/16/2016 | Excel Power Map vs. Power BI Globe Map7 |
![Page 8: Excel Power 3D Map vs. Power BI Globe Map visualization](https://reader030.vdocuments.us/reader030/viewer/2022013123/58796a7b1a28ab37368b4b75/html5/thumbnails/8.jpg)
Excel PowerMap
4/16/2016 | Excel Power Map vs. Power BI Globe Map8 |
Demo Creating PowerMap in Excel
![Page 9: Excel Power 3D Map vs. Power BI Globe Map visualization](https://reader030.vdocuments.us/reader030/viewer/2022013123/58796a7b1a28ab37368b4b75/html5/thumbnails/9.jpg)
Excel PowerMap (video sample #2)
4/16/2016 | Excel Power Map vs. Power BI Globe Map9 |
![Page 10: Excel Power 3D Map vs. Power BI Globe Map visualization](https://reader030.vdocuments.us/reader030/viewer/2022013123/58796a7b1a28ab37368b4b75/html5/thumbnails/10.jpg)
Excel Power Map vs. Power BI Globe Map
Agenda:
Microsoft BI: History of 3D Map visualization
Excel PowerMap
Power BI Globe Map
And the Winner is …
4/16/2016 | Excel Power Map vs. Power BI Globe Map10 |
![Page 11: Excel Power 3D Map vs. Power BI Globe Map visualization](https://reader030.vdocuments.us/reader030/viewer/2022013123/58796a7b1a28ab37368b4b75/html5/thumbnails/11.jpg)
Power BI Globe Map
First demonstration at PASS Summit 2015
Month later available in Power BI Custom Visualization Library
4/16/2016 | Excel Power Map vs. Power BI Globe Map11 |
![Page 12: Excel Power 3D Map vs. Power BI Globe Map visualization](https://reader030.vdocuments.us/reader030/viewer/2022013123/58796a7b1a28ab37368b4b75/html5/thumbnails/12.jpg)
Power BI Globe Map
4/16/2016 | Excel Power Map vs. Power BI Globe Map12 |
![Page 13: Excel Power 3D Map vs. Power BI Globe Map visualization](https://reader030.vdocuments.us/reader030/viewer/2022013123/58796a7b1a28ab37368b4b75/html5/thumbnails/13.jpg)
Power BI Globe Map
4/16/2016 | Excel Power Map vs. Power BI Globe Map13 |
Demo Creating Globe Map in Power BI
![Page 14: Excel Power 3D Map vs. Power BI Globe Map visualization](https://reader030.vdocuments.us/reader030/viewer/2022013123/58796a7b1a28ab37368b4b75/html5/thumbnails/14.jpg)
Power BI Globe MapThings that Power BI Globe Map doesn’t have compared with the Excel Power Map:
Over time data visualization Full support for multiple data layers Shapefiles are not supported for geo visualization
Some of the minor but very useful features that PowerMap has in Excel:o Ability to change globe themeso Ability to create visual tours and save them as video fileso Change the chart shapeso Change the height and thickness scale of visualso Change color for a serieso Find location featureo Add an annotation with imageo Legendso Bubble charts, pie charts and region chartso Power Map graphics options
4/16/2016 | Excel Power Map vs. Power BI Globe Map14 |
![Page 15: Excel Power 3D Map vs. Power BI Globe Map visualization](https://reader030.vdocuments.us/reader030/viewer/2022013123/58796a7b1a28ab37368b4b75/html5/thumbnails/15.jpg)
Power BI Globe MapThings 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
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.
Power BI Globe visualization is free compared with a slightly cumbersome licensing aspect to enable a Power Map option in Excel.
4/16/2016 | Excel Power Map vs. Power BI Globe Map15 |
![Page 16: Excel Power 3D Map vs. Power BI Globe Map visualization](https://reader030.vdocuments.us/reader030/viewer/2022013123/58796a7b1a28ab37368b4b75/html5/thumbnails/16.jpg)
Excel Power Map vs. Power BI Globe Map
Agenda:
Microsoft BI: History of 3D Map visualization
Excel PowerMap
Power BI Globe Map
And the Winner is …
4/16/2016 | Excel Power Map vs. Power BI Globe Map16 |
![Page 17: Excel Power 3D Map vs. Power BI Globe Map visualization](https://reader030.vdocuments.us/reader030/viewer/2022013123/58796a7b1a28ab37368b4b75/html5/thumbnails/17.jpg)
And the Winner is …
4/16/2016 | Excel Power Map vs. Power BI Globe Map17 |
![Page 18: Excel Power 3D Map vs. Power BI Globe Map visualization](https://reader030.vdocuments.us/reader030/viewer/2022013123/58796a7b1a28ab37368b4b75/html5/thumbnails/18.jpg)
Excel Power 3D Map considerations:
• Use 64 bit Office• When you add a new layer to existent scene, make it
invisible first• Save button and Undo/Redo buttons are highly desired
but not available at the moment• Test different scene effect during Video tour creation
Enjoy your 3D Map visualization !!!
4/16/2016 | Excel Power Map vs. Power BI Globe Map18 |
![Page 19: Excel Power 3D Map vs. Power BI Globe Map visualization](https://reader030.vdocuments.us/reader030/viewer/2022013123/58796a7b1a28ab37368b4b75/html5/thumbnails/19.jpg)
Excel PowerMap (video sample #3)
4/16/2016 | Excel Power Map vs. Power BI Globe Map19 |
![Page 20: Excel Power 3D Map vs. Power BI Globe Map visualization](https://reader030.vdocuments.us/reader030/viewer/2022013123/58796a7b1a28ab37368b4b75/html5/thumbnails/20.jpg)
Thank you for attending this session !
4/16/2016 | Excel Power Map vs. Power BI Globe Map20 |
Rayis Imayev
Blog: http://datanrg.blogspot.ca/Twitter: @RayisImayevEmail: [email protected]