Monday, January 29, 2018 as an educational resource: motion charts visualizing World Bank data

High school students extract data from the World Bank dataset and create a motion chart that shows the relationship between life expectancy and expenditure on health in different countries. See discussion in Information Technology Teachers' Mailing List:

A set of instructions for Yr11 Information Technology students:

Thursday, November 30, 2017

Visualizing Google analytics report: motion chart with drilldowns

Below is a motion chart with drilldowns visualizing Google Analytics report for a fictional website. Click and hold on any bubble to see acquisition and conversion details for a specific channel: Direct, Organic Search, Referral, Social.

Why motion charts?

Motion chart allows efficient and interactive exploration and visualization of multi-dimensional data and can make it easier to notice an important trend. Google has done a great job explaining how motion chart can be useful in web analytics and providing a tool for building motion charts based on analytics reports.

Tuesday, November 28, 2017

Interactive charts in online presentations

Earlier this year, we posted a small research on US and Canada immigration patterns. Let's make a simple online presentation from it.


We will be using, which is probably the most flexible and powerful online presentation engine these days. We will re-use all charts from our earlier post without modifications - they are already published and ready to be embedded. The presentation is available here:

A few things worth noting.

1.  All charts are interactive - move mouse pointer over the curves and see.

2. All charts are embedded with style="width:100%" attribute, which makes them scalable: try running the presentation in full-screen mode or resize your browser window - you will see charts changing their sizes accordingly.

A screenshot of the editor with embedded chart:

Other online presentation tools

Are there any other online presentation tools that support HTML embedding from arbitrary sources? Unfortunately, not many. So far I have come up with this list:

  • Emaze - NO
  • Google Slides - NO
  • Haiku Deck - NO
  • Prezi - NO
  • YES
  • Sway - NO
  • Slidebean - NO
  • Visme - YES

Friday, November 24, 2017

Chart background graphics: SVG

We are excited to announce SVG background support. This means that chart authors now can use vector or raster graphics for chart backgrounds. The following example shows gender symbols and generation names behind the population pyramid chart:

This chart uses data from this spreadsheet. Import settings are as follows:

Friday, November 17, 2017

MI, NC, OH, PA congressional elections 1972-2016: district breakdown by % of votes for Democrats

Inspired by Blake Esseltyn's attempt to visualize MI,NC,OH, and PA redistricting results, I copied congressional election results (democratic votes only) in those four states from into a spreadsheet and broke down district results by percentile. For example, for 1972 Michigan congressional elections we have 19 districts with the following votes % for Democrats (in no particular order):

89.08%, 43.57%, 40.24%, 32.75%, 38.14%, 49.36%, 29.89%, 39.93%, 29.83%, 31.63%, 30.05%, 50.82%, 86.54%, 54.86%, 66.68%, 69.58%, 67.15%, 47.38%, 28.93%.

After breaking down buy percentile, we get:
Districts that got between 0% and 10% votes for Democrats: 0 out of 19: 0%
Districts that got between 10% and 20% votes for Democrats: 0 out of 19: 0%
Districts that got between 20% and 30% votes for Democrats: 3 out of 19: 16%
Districts that got between 30% and 40% votes for Democrats: 5 out of 19: 26%
and so on.

The following are four heatmap charts that visualize Democratic votes breakdown for these fours states. Watch districts gravitating towards 30-50 democratic vote percentiles since 2010.

Monday, September 11, 2017

More heatmaps: other types of crime is San Francisco, 2003-2016

This is a follow-up to the earlier post about visualizing SFPD data. Now let's focus on other crime categories: vehicle theft, larceny/theft, burglary, assault.

Animated GIF is not the best way to explore patterns. Check out the original interactive charts for each type of crime below.

SFPD incident database and heatmaps: drug-related incident patterns

San Francisco Police Department provides free access to a great data source: The following couple of charts display drug-related incident distribution by year, weekday, time of day, and district.

Some observations:

  • the notorious "welfare Wednesday" effect is present in early years;
  • incident numbers drop significantly starting 2010, which may be caused by Proposition 215: Wikipedia says "It was not until March 2009 that federal officials announced that they would no longer try to thwart medical marijuana distribution/use in California".
There is a follow-up post focusing on other types of crime in SF using the same data source.

The following are the steps to create the weekday/time heatmap chart using editor.