Revisiting the Healthcare Slopegraph – A Python implementation

Last summer I shared an adaptation of Tufte’s slopegraph using data from the  Institute for Clinical Evaluative Sciences‘ (ICES) 2011 Quality Monitor report in the post Education and Health Care – Using Slopegraphs to Understand Complex Systems.  While this initial visualization involved post-processing (with the hope of exploring code to generate something similar), Bob Rudis (@hrbrmstr) has developed a Python solution to generating slopegraphs and has used the 2011 Health Care slopegraph to serve as an example.  In his post Slopegraphs in Python – Slope Colors Bob has replicated both the slopes and the color coding, which I had used to visually reinforce the direction of the slopes.

Thanks to Bob for his willingness to share his code and for using my adaptation as one of his examples!

Posted in Data Visualization | Tagged , , , , | Leave a comment

Census 2011: Ontario Population Pyramid

Statistics Canada has released the Age and Sex data set for 2011.  A traditional visualization for this kind of data is the population pyramid.   The population pyramid is a modified version of a stacked bar chart with the division between categories centered around 0.   You may notice that this population pyramid for Ontario, using the 2011 census, looks more like a tree than a pyramid.  One of the reasons for this is that the youngest categories have been divided into 5 year ranges whereas the adult ages are divided into 10 year ranges.

Source: Statistics Canada, 2011 Census of Population, Statistics Canada catalogue no. 98-311-XCB2011017 (Canada, Code01)


These ranges are historical categories that have been used to describe Canadian populations as far back as 1921.
Although the difference between age ranges accounts for the narrow neck of the pyramid, the thicker bands in the older age ranges provides a glimpse of the movement of the baby-boomers through the distribution.  The impact of the baby-boomers on the population distribution becomes even more apparent when the historical data sets are presented as an animated time series:

An interactive population pyramid is also available from Statistics Canada that presents the data across smaller age ranges, giving a more detailed and refined view of the changes.  Where the population pyramid at the beginning of this post was created using data reported by the Census, Statistics Canada’s interactive visualization uses data that is “extrapolated using the annual rates of population growth from the Population Estimates Program.”

Posted in Data Visualization | Tagged , , , | Leave a comment

CSSE 2012 – Topics Trending in Education Research (Top-TIER)

This weekend, education researchers from across Canada will be traveling to  Wilfrid Laurier University and the University of Waterloo to participate in the Canadian Society for the Study of Education’s (CSSE) Annual Congress.  As is traditionally the case, Ontario is well represented by research from Universities, Colleges, School Boards, the Ministry of Education and a variety of Education networks and organizations.  Of all the presentations featured in the 2012 program,  22 sessions will be delivered by Ontario School Board and Ontario Ministry of Education researchers.  Twelve sessions will feature the work of the following school boards:

  • Dufferin Peel CDSB,
  • Durham DSB,
  • Grand Erie DSB,
  • Halton CDSB,
  • London District Catholic School Board,
  • London Region School Boards,
  • Ottawa Carleton DSB,
  • Peel DSB,
  • Renfrew County District Catholic School Board,
  • Toronto CDSB,
  • Waterloo Region DSB,
  • York CDSB

Eleven sessions will feature the work of Researchers from the Ontario Ministry of Education.  For a complete list of the presentation titles, presenters and organizational affiliations click here.

The majority of the presentations will be hosted by the Canadian Association for the Study of Educational Administration (8 sessions) and the Canadian Educational Researchers’ Association (6 sessions).

If you are unable to attend, you can follow the twitter hashtag #CSSE12 which will hopefully have a lot of activity given the free wifi that Wilfrid Laurier University and the University of Waterloo will be providing.  For those attending the conference, wifi can be accessed through the network congress2012, using the password bigthinker  (from the CSSE program page 16)

 

Posted in Top-TIER | Tagged , , , , , | Leave a comment

Reshaping the Country

Maps are one of my favorite approaches to presenting information.  However, they are just as vulnerable to abuse, misuse and overuse as every other form of data visualization.  Traditionally, maps employ color ranges, textures, symbols and boundary widths to describe data.  It is, however, easy to be distracted by individual regions that are very large rather than the patterns that emerge from multiple areas that may be smaller.

In this map of Canada the population density from the 2011 Census is described as a blue colour scale.  The largest population is dark blue with lighter shades reflecting smaller populations.  Here we see Ontario has the largest population and Nunavut has the smallest (click on the image for a larger version).

While your eye is drawn to the darker shades of blue the size of the other provinces and territories compete for attention.

An alternative to this approach is the cartogram, which eliminates the distraction of size by modifying the shape of the mapped regions according to regional differences.  In this cartogram of the same 2011 population density data, the boundaries of the provinces and territories are inflated and deflated according each region’s population data.

Resizing and reshaping the geographies of provinces and territories to describe population size provides a startling view of the country.  In this cartogram, high population density, like Ontario and Quebec, is reflected in a dark blue boundary that appears to have been inflated like a balloon.  Low densities, like the Territories, are light blue with deflated or constricted boundaries that look like ribbons.

Cartograms are not restricted to population or frequency data and can be developed using any numeric data that relates to a geographic location.  The green cartogram below presents the provincial and territorial boundaries from the perspective of equalization payments.  Equilization payments are made by the federal government to the provinces in an attempt to address “fiscal disparities.” Regions that receive equalization payments have often been referred to as “Have-not” provinces.  Using information for 2012-2012 shades of green have been used to describe the level of payments each region receives with dark-green representing the largest payments, light green the smallest payments and white representing no payments. Like the last cartogram, the size of the provinces complements the green scale with the largest provinces receiving the largest payments and smaller provinces receiving less.  Here we see that Quebec receives the largest payments with the western provinces and territories receiving nothing.

When considered from the perspective of Tufte’s data-ink ratio, these cartograms may not be as efficient as a series of bar charts.  They do, however, provide a view of Canada that can challenge a viewer’s pre-existing perceptions of the provincial and territorial relationships.  When sharing these maps with others the reaction has often been prefaced with “I hadn’t realized…”.  Tables or bar charts could be used to present this information but here I am finding cartograms are more provocative and memorable.

Data Sources:

Population Density data: Statistics Canada. 2012. Canada (Code 01) and Canada (Code 01) (table). Census Profile. 2011 Census. Statistics Canada Catalogue no. 98-316-XWE. Ottawa. Released February 8, 2012.
http://www12.statcan.ca/census-recensement/2011/dp-pd/prof/index.cfm?Lang=E
(accessed April 3, 2012).

Boundary File: Statistics Canada. Product Number 92-160-XWE. Provincial Boundary File, 2011 Census Ottawa.  Released November 29, 2011.  http://www5.statcan.gc.ca/bsolc/olc-cel/olc-cel?lang=eng&catno=92-160-X  (accessed April 3, 2012).

Equalization Payment data: Department of Finance Canada. 2012. Canada. What is Equalization, Deprtment of Finance Canada.  Ottawa.  Updated December 19, 2011, http://www.fin.gc.ca/fedprov/eqp-eng.asp  (accessed April 3, 2012)

Posted in Data Visualization | Tagged , , , , , , | Leave a comment

John Hattie: Visible Learning in Toronto

On April 18th, John Hattie (Visible Learning) spoke in Toronto.  During his presentation, participants shared resources and links on twitter (#HattieTO).  A compilation of these tweets can be found here.

For those who were unable to attend either the April 18th presentation or the presentation that followed at OISE on the 19th, oakbellUK has made a couple of videos of John Hattie available that you may find interesting:

Part 1: Disasters and below average methods

and

Part 2: Effective methods


Twitter user @kstef2 has also provided an interesting approach to sharing tweets using Storify for the #HattieTO tweets

Posted in Top-TIER | Tagged , , , | Leave a comment