- 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
- [Voiceover] Hi, I'm Chris Dutton and welcome to Visualizing Geospatial Data with Power Map. In this course, we'll expand on the Building Excel Heat Maps course and use Power Map to plot accident locations based 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 functions like TRIM, PROPER, and CONCATENATE to standardize data fields and combine them to create new values.
We'll then use pivot tables to sort and filter by accident type and location, and import that data into Power Map to visualize exactly where accidents most frequently occur. Finally, we'll explore two creative ways to integrate the maps into our tool using the INDIRECT and HYPERLINK functions. Ready to get started? Let's dive in with Visualizing Geospatial Data with Power Map.