O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Time for action – data visualization with Power Map

In this example, we will work on a sample data file named Dallas Utility Demo.xlsx, which shows information of houses in Dallas, such as the size and year they were built. It also has information such as the KWH power consumed for the house. So, we use this source file to perform visualization of the data based on the year it was built and its power consumption by executing the following steps. You can download the file from the code bundle of this book:

  1. Open Dallas Utility Demo.xlsx and have a look at the data rows. You will see geospatial information such as latitude and longitude, year built, condition, and kwh power consumption.
  2. Go to the Insert tab in Excel, and under Map, select Launch Power ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required