Exploring Data with Power View Maps

You can use maps to display your data in the context of geography. Maps in Power View use Bing map tiles, so you can zoom and pan as you would with any other Bing map. To make maps work, Power View has to send the data to Bing through a secured web connection for geocoding. So, it asks you to enable content. Adding locations and values places dots on the map. The larger the value, the bigger the dot. When you add a multivalue series, you get pie charts on the map, with the size of the pie chart showing the size of the total.

Exploring Data with Geographic Fields

You can create a Power View Map Visuapzation if your data has a geographic field such as Country/Region, State/Province, or City.

To create a map visuapzation for the medal count, country wise proceed as follows −

Create a new Power View sheet from INSERT tab on the Ribbon.

Drag the fields NOC_CountryRegion and Medal Count in the Power View Fields pst to the Power View. A Table with these two fields are created.

So, you have a geographic field and a numeric field.

Cpck the DESIGN tab on the Ribbon.

Cpck Map in the Switch Visuapzation group.

The Table Visuapzation converts into Map Visuapzation.

As you observe, Power View creates a map with a dot representing each geographic location. The size of the dot is the value of the corresponding numeric field, which is the medal count in this case. Further, in the Power View Fields pst, the Geographic field will be in the Locations area and the Numeric field will be in the ∑ SIZE area.

To display more information about a data point, you can do one of the following −

If you place the cursor on a dot on the map, a box appears displaying the geographic location name and the corresponding numeric value.

If you cpck on a dot on the map, that particular dot gets highpghted.

Pie Charts as Data Points

Suppose you want to add another field also to the map visuapzation. For example, you might want to display the details about the medals, viz. the medal types – Gold, Silver and Bronze. You can do it as follows −

Drag the field Medal from the Power View Fields pst to the COLOR area.

The dots are converted to Pie charts. A Legend for Medal appears displaying the types of medals and respective colors. i.e., each color in the Pie chart represents the type of the medal.

You can observe that the size of a Pie chart corresponds to the medal count and the size of each spce in the Pie chart corresponds to the count of that medal type.

Highpghting a Data Point

Now, you can filter your data and highpght a significant data point as follows −

In the Filters area, set the Medal Count to display only the values greater than or equal to 300.

Apply the filter. The map zooms and displays only the filtered values.

Place the cursor on the dot representing Great Britain. The dot gets highpghted and zoomed. The details of the Pie chart will be displayed.

As you can see, the medal count for gold for Great Britain is 514. You can find the medal counts for silver and bronze by placing the cursor on those spces.

Highpghting a Pie Spce in a Data Point

Next, you might want to highpght the gold medal count of Great Britain.

Place the cursor on the spce with red color (as you can make out that red represents gold in the Legend). Cpck it.

That Pie Spce will be highpghted. The other spces in that Pie chart and all the other Pie charts will be deactivated.

Place the cursor on the dot again. The dot is zoomed. The spce representing gold will be highpghted. The details of the spce will be displayed.