Excel Data Analysis 简明教程

Exploring Data with Power View Maps

你可以使用地图在地理环境中显示你的数据。Power View 中的地图使用必应地图磁贴，因此你可以像使用其他任何必应地图一样进行缩放或平移。为了使用地图，Power View 必须通过一个安全网络连接向 Bing 发送数据，以便进行地理编码。因此，它会要求你启用内容。添加位置和值会在地图上放置点。值越大，圆点越大。当你添加一个多值系列时，你会在地图上获得饼图，其大小显示总大小。

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

如果你的数据含有一个地理字段，如国家/地区、州/省或城市，则你可以创建一个 Power View 地图可视化。

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

要按国家/地区对奖牌数量创建一个地图可视化，请执行以下操作：

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

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

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

exploring data with geographic fields

然后，你有一个地理字段和一个数字字段。

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

  1. Click the DESIGN tab on the Ribbon.

  2. Click Map in the Switch Visualization group.

表视觉效果转换为地图视觉效果。

The Table Visualization converts into Map Visualization.

map visualization

正如您观察到的那样，Power View 创建了一个地图，圆点表示每个地理位置。圆点的尺寸是相应数字字段的值，在这种情况下是奖牌数量。此外，在 Power View 栏位列表中，地理栏位将位于“位置”区域，而数字栏位将位于“∑ 大小”区域。

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 list, 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 −

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

  2. If you click on a dot on the map, that particular dot gets highlighted.

Pie Charts as Data Points

假设您还希望在地图视觉效果中添加另一个字段。例如，您可能希望显示奖牌的详细信息，例如奖牌类型——金牌、银牌和铜牌。您可以按以下方法进行操作：

Suppose you want to add another field also to the map visualization. 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 −

  1. Drag the field Medal from the Power View Fields list 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.

medals

您可以观察到，饼图的大小与奖牌数量相对应，而饼图中每个扇区的大小与该类型奖牌的数量相对应。

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

Highlighting a Data Point

现在，您可以过滤数据并突出显示重要数据点，如下：

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

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

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

highlighting data point

将鼠标光标放在代表大不列颠的圆点上。圆点会被突出显示和放大。饼图的详细信息将显示。

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

cursor represents great britain

正如您所看到的，大不列颠的金牌数量为 514。您可以通过将鼠标光标放在那些扇区上找到银牌和铜牌的数量。

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 slices.

Highlighting a Pie Slice in a Data Point

接下来，您可能需要突出显示大不列颠的金牌数量。

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

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

该饼图扇区将被突出显示。该饼图中的其他扇区和所有其他饼图都将停用。

That Pie Slice will be highlighted. The other slices in that Pie chart and all the other Pie charts will be deactivated.

highlighting pie slice

再次将光标放在点上。点被放大。代表金牌的部分将被突出显示。该部分的详细信息将被显示。

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

slice details