Power Map
Software Requirements:
- If you have any subscription for Microsoft Office 365, you have access to Power Map for Excel as part of the self-service business intelligence tools.
- Whenever any new Power Map features and performance enhancements are released, you'll get them as part of your subscription plan.
- If you have Office 2013 Professional Plus or a standalone version of Excel 2013, you can download and use the Power Map Preview for Excel 2013 as an add-in.
- You can download Power Map Addin from this link:
- http://www.microsoft.com/en-in/download/details.aspx?id=38395
What is Power Map?
- Microsoft Power Map for Excel 2013 is a three-dimensional (3-D) data visualization tool that lets you look at information in new ways. You can discover insights that you might not see in traditional two-dimensional (2-D) tables and charts.
- With Power Map, you can plot geographic and temporal data on a 3-D globe, show it over time, and create visual tours you can share with other people.
You’ll want to use Power Map to:
- Map data: Plot more than a million rows of data visually on Bing maps in 3-D format from an Excel table or Data Model in Excel.
- Discover insights: Gain new understandings by viewing your data in geographic space and seeing time-stamped data change over time.
- Share stories: Capture screenshots and build cinematic, guided video tours you can share broadly, engaging audiences like never before. Or export tours to video and share them that way as well.
Let us create a Power
map report:
STEPS:
STEP 1: Open Excel 2013 having your data with at least one column as
country\State\Province\Zip Code\City name\Address (which Bing Map can identify\locate)
STEP 2: Click on Insert à Map à Launch
Power Map\Add Selected Data to Power
STEP 3:
Power Map uses Bing to geocode data based on its geographic
properties. After a few seconds, the globe will appear next to the first screen
of the Layer Pane.
This window has 4 visible parts:
- Power Map Ribbon: On Top
- Tours Window: Left Pane
- Layer Pane : Right side
- Map Window : Middle
Tours window will open if you
have already created a power map earlier and want to add\edit new\existing
tours as shown below :
In layers pane on left side; we can choose geography based
on available data:
Based
on our selection Geography is visible as dots on the Map.
STEP 4:
Click NEXT and start
Exploring:
Select values,
Category, Time (If any column have time based data) and create nice visualizations.
Additionally you can
create Tours, Add more layers, Create videos, create flat maps etc…
Let’s discuss the available options on ribbon:
TOUR:
1.
Play Tour : Switch to tour view and watch it
play
2.
Add Scene: Add a new scene to the list of
existing scenes in your tour.
3.
Create video: Turn the tour you have created
into a video so that you can share it.
4.
Capture Screen: Take a static picture of your
current map to put it on the clipboard so that you can paste it somewhere else.
MAP:
5.
Themes: Pick a theme to give your tour instant
personality or a more professional look. Each scene can have different theme
and a theme can have different colors. Some themes even have satellite images
for the globe.
6.
Map Levels: Show or hide the labels on the map.
7.
Flat Map: Switch between globe and flat map
format.
8.
Find location: Go to any city, address, state,
or other geographical location on the map. Just enter the one you want and
search by typing the name of the location you would like to find.
LAYER:
9.
Add layer: Add another data layer to the
selected scene.
10.
Refresh data: Update all layers of all scenes to
show the most current data.
11.
Data Shapes: Change the shape of the columns on
the map.
INSERT:
12.
2D Chart: Show the top or bottom 100 locations
by value for any data layer on a 2D Chart, and quickly navigate to each
location.
13.
Text Box: Add text to a scene that stays on the
screen when playing your tour. Resize it or move it to the place you want.
14.
Legend: Show the legends for all data layers in
the scene. You can turn individual legends ON or OFF afterwards.
TIME:
15.
Time Line: Show or hide the Time Line control.
Use this to play a tour over time. This option is available when a time field
is added to a Scene’s time box.
16.
Date & Time: Show or hide the date or time
you have added to the time box in the scene. This option is available when a
time field is added to a Scene’s time box.
VIEW:
17.
Tour Editor: Show or hide the tour editor. Use
the tour editor to view all scenes in your tour and to rename your tour.
18.
Layer Pane: Show or hide the layer pane. Use the
Layer pane to manage layers, add data to layers and change settings.
Let me add some visuals of maps and videos which I have created to attract your interest in Power Map :
Note : India Population data used in this Map has been downloaded from Public Catalogue available for download from govt website using power query. Watch out for my blog on Power Query Coming Soon...
There are plenty of other options for you to
explore.
So Get...Set...GO...
Enjoy using Power Map!!!
Thanks,
Paras Singh
04th Feb 2015
07:18 PM IST
No comments:
Post a Comment