I’m a numbers guy. I notice a lot of relations between numbers, in addition to finding them in analysis and such. However, I sometimes miss some for years that when I realize it, I am just stunned as to how I could have missed it. The most shocking example still is the one that has to do with my age when running my first marathon, and which I didn’t realize for like a decade. However, this one about my spending and taxes in recent years comes close.
Oh, those grumpy fools who were constantly whining for most of 2020 for it to end because of the COVID-19 pandemic! What were they thinking, exactly, that 2021 was going to be better? Did they not realize that we would start the year in the middle of Wave 2 that was going to be worse than Wave 1? Or Wave 3, technically, if you were looking at the United States’ numbers. Did they not realize the days would be shorter and darker than when the pandemic really started in March, 2020? Did they not realize the vaccine wouldn’t be out that quickly in terms of everyone wanting one getting it? I don’t know what those people were thinking. I’m an optimistic realist, and that person didn’t see anything close to warranting that optimism. But let’s put that aside and take a good reality check right now.
Do you think there will be more COVID-19 deaths in 2021 than in 2020?
WOW! JUST WOW! I can’t remember being more wowwed and mesmerized by anything on YouTube or any other video platforms! 12.5 minutes super well spent! BRAVO!
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! 🙂
For my learning of Tableau data visualization software, I created an interactive workbook I put on the Tableau Public website with the 2015 Canadian Community Health Survey (CCHS) public data released by Statistics Canada. It essentially translated about 47 thousand lines of aggregate survey data into a comparative report card of dots comparing health related matters among demographics of people in provinces to each other via the Canadian average for their demographic. You can extract all kinds of information and stories without having to look at one number on this thing, although if you mouseover any dot, you’ll see all the stats that come with it that was also used in making comparisons!