Book Image

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

By : Abolfazl Radgoudarzi, Reza Rad
Book Image

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

By: Abolfazl Radgoudarzi, Reza Rad

Overview of this book

Table of Contents (19 chapters)
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

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 section of the map and click on the small pop-out icon to maximize the map.

  6. You will see that the sales amount, according to cities, appears on the Bing map view of the world. The sizes of the circles represent the sales amount in each city.

  7. Under the...