I just added a Tableau Public set of dashboards showing combined 2015 and 2016 year results for the Canadian Community Health Survey (CCHS), which allowed for comparisons and rate calculations at geographies smaller than provincial and territorial levels. These included Census Metropolitan Areas (CMAs) and health areas (units, zones, districts, etc.), as well as combined large, medium and small population centres, and rural areas, within a province or territory. The roughly 680 thousand rows of data, including calculations of statistical significance in differences done by Statistics Canada, allowed for some amazing comparisons… and eye opening results! There currently is nothing else quite like this published by anybody to show CCHS results!
Click on the following link if you just want to use the dashboards directly, without explanations.
And click on the following link if you want the latest version of CCHS results, 2016, but without geographies below the provincial level.
Interactive Public Health Report Cards for CCHS 2015 and 2016, on Tableau Public
If you view it and have any questions or feedback, please leave them there so the discussions can be in one place as much as possible.
The combined year results, with much more granular geographic results, will be explained soon, but are already posted here if you want to look ahead of time. Thank you.
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!