PowerMap strikes again

First day of school animation
Animation of the first day of school in districts across the U.S. created with PowerMap for Excel 2013.

Microsoft’s John Gagnon is back with a new PowerMap animation of MCH‘s first day of school data. This post on the Clickz blog features regional shading to distinguish school districts in different states. John’s focus this time around is on the added value of visualizing data using the new Microsoft tools:

Visualizing the data on a map and over time drives home many insights. One key insight: A nationally targeted campaign won’t allow you to differentiate your ad copy to cities or states which are already in school. If Los Angeles’ 640,000 students go back to school on August 13, you’d have to have the same ad messaging and bids until New York City’s 1.1 million students go back on September 9. So switching from a nationally targeted campaign to a region-specific campaign makes more sense.

Our CEO, Peter Long, and I had the opportunity to visit Microsoft headquarters last week to meet with several representatives of the PowerMap, PowerBI, and Office 365 teams. We were also interviewed on camera for a video that will be part of an upcoming product release. I’ll be sure to share that with you when it hits the internet.

AsI mentioned in my previous PowerMap post, MCH has a database of school district calendar dates available for license. Contact me at kirkc@mchdata.com for more information. We’re just about to load the latest updates to complete the database for the 2013-2014 school calendars.