Database Reference
In-Depth Information
11. Save the Excel sheet.
Creating Power Map visualization
With the Microsoft Power Map add-in for Excel, we can take a big step in data visualiza-
tion. Data can be visualized three-dimensionally (3D) and also based on the geographic
(map) location. Visualization can be created as 3D Bing maps or a custom map for your
data layout. Data is delivered from the query. Then it is filtered and visualized on the map.
With Power Map, you can create the following:
•
Geographical data mapping
: Visualize your Excel tables or data model, which
can include more than a million rows on the maps. Maps could be based on
Bing
Maps
or custom maps that represent an environment of interest.
•
New insights
: Data visualization of your data in a geographic representation that
visualizes data changes (with timestamps) over specific periods creates a new in-
sight into analysis.
•
Share complete data analysis stories
: Power Maps completes the Power BI add-
ons for Microsoft Excel. You can extend this functionality by creating guided
tours of the analysis that you share with colleges as a link, or export the analysis
for offline use.
You'll find the
Map
button in the
Tours
group on the
Insert
tab of the Excel ribbon, as
shown in this screenshot: