Thomas.I Microsoft BI & Analytics

A Site Dedicated to General BI Issues and MS BI Issues: Architecture and Technology

Power View in Excel 2013 Part Two: Maps

Posted by thomasivarssonmalmo on July 22, 2012

This is my second blog post about the functionality in Power View for Excel 2013 that will show you have easy it is to create map visualizations in Excel 2013.

I start with the basic model with relational data from the Adventure Works database with country, calendar year and internet order quantity. What you can see here is a basic tables when you drag the attributes and the measure to the default box in the down right corner.

The Basic Model

Now we will change this boring table into something more visually useful. Make sure that the table is marked and press the map button in the ribbon.

The Map Button

After you have pressed the map button you will see something like this on the canvas.

 

The first map

 

But we can extend this even more. Here is the design tool to the right where I have added CalendarYear to vertical multiplies.

 

The map design tool

The result is this map.

The final report

The purpose of this blog post is to show you how easy it is to integrate maps into your reporting and change a boring table into something more useful with a few clicks.

One Response to “Power View in Excel 2013 Part Two: Maps”

  1. […] Excel 2013 and BISM Multidimensional, Power View in Excel 2013 Part One: Pie Charts, Power View in Excel 2013 Part Two: Maps […]

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

 
Follow

Get every new post delivered to your Inbox.

Join 29 other followers

%d bloggers like this: