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

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