MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Visualizing Geospatial Data with Power Map in Excel

Course Summary

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.


  • +

    Course Syllabus

    1. Getting Started
    2. Standardizing Location Data
    3. Creating a New Source Data
    4. Data Visualization with Power Map
    5. Option 1: Populating Map Images with INDIRECT
    6. Option 2: Linking to Map Images with HYPERLINK
    7. Wrapping-Up
    Conclusion


Course Fee:
USD 19.99

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Data & Information Management Community

Related Posts:

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top