Visualizing Geospatial Data with Power Map in Excel

Author

Released

12/4/2015

Take your data analysis skills (and your data visualizations) to the next level with Power Map, Excel's tool for exploring map and time-based data in 3D. This course takes the project you created in Excel Workshop: Building a Dynamic Heat Map and shows how to reconstruct the visualization using Power Map. First you'll learn how to prepare and standardize your data, using IF and CONCATENATE to combine fields. Then find out how to add a PivotTable to create a new or supplementary data source. Then you will get right down to it and build a Power Map image to visualize geospatial data: accidents in different seasons and locations. In the final chapters, author Chris Dutton provides two options for linking data to the map images, using the INDIRECT and HYPERLINK functions.

Topics include:

Reviewing the dataset

Standardizing location data

Creating a new data source in a PivotTable

Creating new Power Map images

Populating Power Map images with INDIRECT

Linking to map images with HYPERLINK

Skill Level Intermediate

37m 35s

Duration

73,480

Views

Show MoreShow Less

- [Voiceover] Hi, I'm Chris Duttonand welcome to Visualizing Geospatial Data with Power Map.In this course,we'll expand on the Building Excel Heat Maps courseand use Power Map to plot accident locationsbased on latitude and longitude data,all within Excel.We'll start by analyzing a heat map,identifying the geospatial variables in our data set,and laying out a project road map.I'll show you how to use text functionslike TRIM, PROPER, and CONCATENATEto standardize data fields and combine themto create new values.

We'll then use pivot tables to sort and filterby accident type and location,and import that data into Power Mapto visualize exactly where accidents most frequently occur.Finally, we'll explore two creative waysto integrate the maps into our toolusing the INDIRECT and HYPERLINK functions.Ready to get started?Let's dive inwith Visualizing Geospatial Data with Power Map.