Getting Visualized: Transforming Data from Opaque to Immersive with Power Map for Excel

Getting Visualized: Transforming Data from Opaque to Immersive with Power Map for Excel

Rate This
  • Comments 5

Guest post by Kirk Chritton, Director of Product Innovation, MCH Strategic Data

At MCH Strategic Data we’ve specialized in capturing, segmenting, and applying education and healthcare marketing data for our clients since 1928. In the early days, our “database” of school principals consisted of metal Addressograph plates sorted into long trays. “Visualizing our data” meant looking at the green cabinet where the plates were stored.

The days of “dog tag data” are long gone, but our modern database of teachers at schools, doctors at hospitals, and the bazillions of data elements that describe them can be just as opaque as that Addressograph cabinet.

Modern data visualization tools are the key to bringing the bits and bytes into view. Hidden patterns transform into revealing animated images that quickly convey meaning and insight.

These tools breathe life into our data just as CGI has revolutionized Hollywood animation. If MCH’s old Addressograph plates were the equivalent of stacks of hand-drawn animation cels used to generate the earliest cartoons, then the impact of visualized data is like James Cameron immersing us in a 3-D IMAX movie.

MCH has been involved in data visualization in various forms for about a decade. We have provided geo-enabled data for homeland security and emergency preparedness mapping applications. We’ve integrated Bing mapping technology into products like MCH Infinite Access, our education-focused business intelligence tool.

But now the power of data visualization is arriving on our desktops for everyday office use.

We were introduced to Power Map by Bing Ads Evangelist John Gagnon, who needed data for an article about how back-to-school dates can be leveraged to create more effective digital marketing campaigns. John illustrated his piece with a compelling Power Map animation and encouraged us to learn more about the Power BI capabilities.

“Power Map brings data to life,” John said, “But you have to start with fantastic data. When I saw MCH’s education data set, it was across so many rich dimensions. I plugged it into Power Map, and was immediately struck with the geographic pattern that schools go back in session. I’m using it to help marketers completely rethink their back-to-school campaigns.”

MCH was just as impressed as John’s audiences, and we have now started to apply Power BI and Power Map ourselves. The tools allow us to combine datasets and share insights with our clients like never before. We now produce videos that, for example, vividly display the geographic distribution of wealth in school systems. Our next step: integrate MCH’s data elements with our clients’ proprietary information to reveal trends and develop strategies that propel their sales and marketing strategies in new directions.

We’re also pleased to have subsets of our data available for Power BI users. You can find datasets on Massachusetts hospitals, Ohio school districts, and Philadelphia emergency preparedness services in the Power BI data catalog, accessed through Power Query for Excel's "Online Search" capability.

By bringing data visualization to the desktop, Power BI and Power Map are opening a window into MCH’s data unlike any we’ve had before. It’s as if we’re an 85-year-old company seeing ourselves in the mirror for the very first time.

Find out more about MCH Strategic Data at, then explore Power Map and other new data visualizations in Excel and Office 365 at You can download the Power Map Preview for Excel to start visualizing and tells stories with your own geospatial data.”

Leave a Comment
  • Please add 6 and 5 and type the answer here:
  • Post
  • Power Map is incredible (and of course so it MCH Data).  It's hard to understand unless you see it in action, so I put 2 animations together - something I've used in my articles.

    Power Map Visualization:

    Back-to-School Data:

  • Really nice stuff, it works well.  One HUGE stumbling block to see adoption outside the USA, is mapping.  Mapping of areas in the UK e.g. equivalent of US states, just does not work *grumpy face*.  If we had support for shape files, eg geographical data held in SQL server (subtle hint).  I know l would be very happy 8-> UK postcodes can a hit or miss, no always confident it will match correctly.

    On the upside l love the potential of this product, it just not ready for a market outside of the USA.  I just hope this is something that is being addressed?

  • Hi Power BI team , i want you to establish good communication path with you as i am planning to have lots of session in Power BI in my upcoming user group event , Please mail me your address as soon as possible.  

  • Power Excel Software

    Power Excel is an Excel add-ins which is a time and money saving excel utility to make Excel more powerful and more valuable. The installation process is very easy and fast. There is no need to apply extra efforts to attach this utility with excel. It will attach with excel sheet as Power Excel ribbon itself. Over 100+ Command sets are available with this Excel add-ins. It can be used as Excel duplicate remover, can used for excel remove spaces and to clean data in excel. For more  detail visit our website:

  • Power BI Team - From the aspect of a Lead Architect for SharePoint and heavily involved in Data Management/BI in a very large corporate secure conscious environment, when are there going to be changes to the add in to support most corporate connectivity setups? The specific example - Use with authenticated proxies. I love this product and use the entire gambit of SharePoint BI Tools in the enterprise and would love to introduce this as our market is global!

Page 1 of 1 (5 items)