Laying out the project goal to define a roadmap will help you better understand the scope of the information you are creating a visualization for. In this Excel tutorial, Chris Dutton presents the three steps of his project roadmap you will use to visualize where accidents occur most frequently.
- Okay, so before we dive in, let's lay out…a Project Road Map.…And the goal is going to be, use the geographic information…in our raw data to visualize where each type of accident…occurs most frequently.…To do that, we need to take a few steps.…First, we'll clean and standardize the location fields.…Second, we'll use PivotTables to sort and filter the data…based on accident type and location.…Third, we'll import that data into Power Map…to create out geospatial visualizations.…And finally, we'll seamlessly integrate those map images…into our current tool.…
- 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