Power View in Excel 2013 Part Two: Maps

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.

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.

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

 

 

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

 

The result is this map.

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.

About these ads

• Posted in: No Category