Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide

Time for action – geographical data visualization using Power View

In this example, we will create data visualization based on sales territory information such as country, state, and city, and we will reveal the potentials of the Map visualization item in Power View. To do this, refer to the following steps:

1. Open another Power View tab, using the first three steps of the previous example.
2. In the Power View tab, replace the title of Internet Sales with Geographical Info.
3. From the Power View Fields pane under Geography, check City. Under Internet Sales, check Sales Amount.
4. Click on the grid generated in the report pane. Under the Switch Visualization menu bar section, click on Map.
5. A map will appear instead of a grid; hover on the right-top-hand side ...