2015
Lynda
Chris Dutton
0:37
English

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.

Introduction
Welcome
What you should know before watching this course
Using the exercise files
1. Getting Started
Heat map overview
Reviewing the dataset
Defining the project goal and creating a roadmap
2. Standardizing Location Data
TRIM and PROPER
IF and CONCATENATE
3. Creating a New Source Data
Creating our pivot table
Applying our pivot table
4. Data Visualization with Power Map
Intro to Power Map
Power Map by accident type
Creating Power Map images
5. Option 1: Populating Map Images with INDIRECT
Using named ranges
Using IF map references
Using INDIRECT
6. Option 2: Linking to Map Images with HYPERLINK
Removing INDIRECT
Using IF tab names
Using the HYPERLINK function
7. Wrapping-Up
Accident analytics with Power Map
Conclusion
Next steps

lynda.com/Excel-tutorials/Visualizing-Geospatial-Data-Power-Map/441604-2.html

Download File Size:191.48 MB

---