An Interactive Analysis Suite for Google COVID-19 Mobility Data

I recently completed an interactive analysis suite for Google’s COVID-19 mobility data, to let me (and others) do all kinds of comparisons one simply cannot get close to with those static Google mobility data reports! Unfortunately, you will have to go to the Tableau public site, the platform on which I built it, to see and use it because I cannot embed webpages with JavaScript in the WordPress platform this blog is built on.

The Tableau “viz” analysis suite lets you do things like compare for any time period for which Google gave daily data, and even between two time periods. You can also compare any number of countries, regions, even US counties, with data filters. You can compare habits over the days of the week, or see what mobility behaviors people changed (or didn’t, on individual days in a range days). There are “fair expectations” set for each metric based on average to slightly above performance shown to be attainable over a 6 week period, to give further context to the numbers. There is a population filter to compare countries in select ranges of populations. Finally, there are ranks so you don’t have to memorize any numbers in comparing performance in different places and/or over different times. Lots of stuff you can do all kinds of analytics with, draw conclusions about (though be careful on assumptions), and such!

The Tableau viz will be updated roughly once a week, when Google puts out the latest data set. It doesn’t seem they’ll be too consistent with when they do that, but only varying between Thursday and Friday so far. In that Tableau viz is:

  • A table of content tab (at top of view) outlining what is in each tab;
  • A map of the world showing how countries compare for each of the 6 metrics;
  • Continental maps showing regional breakdowns in each country on the continent (where there is data);
  • Even a US county breakdown map;
  • Graphs showing ranks of countries and regions (US counties were too spotty with incomplete data for me to care and give it its own comparison dashboard);
  • Graphs showing select regions against others, allowing comparisons between countries and smaller regions like states and provinces, for example;
  • Graphs showing results over time;
  • Bundled sets of charts in logical order to produce what would be a good briefing report, without text that someone could write for their region/s if they wanted to; and
  • Lots more!

Please click on the link if you want to test out the analytical suite I built. It’s free! No ads or anything! 🙂

Thanks!