Home | Prices | Contact Us | Courses: Power BI - Excel - Python - SQL - Generative AI - Visualising Data - Analysing Data
This is a group exercise. Each group should choose one a dataset to visualise. There are several public datasets listed below but groups can use an in-house or other dataset if they prefer.
Groups decide on the dataset they want to use. Each group makes a short visualisation to the class explaining which visualisation was chosen and why.
Each group then builds a visualisation highlighting a story in (a subset of) the data.
Groups can explore and visualise the dataset using any tool, for example:
Groups make a presentation to the class to show their visualisation and explain:
The list below provides a few example datasets. There is usually a way to extract the data e.g., an option to save as a CSV file.
The Bank Of England’s Bank rate time series Bank Rate history
The Office for National Statistics (ONS) Historical Baby Names Dataset from 1996 to 2021 Baby names in England and Wales
The number of London daily bike hires in the last decade Number of Bicycle Hires - London Datastore
Transport for London (TfL) Journeys by type - the number of passenger journeys each month on TfL by type (bus, underground, DLR and 4 others).
Public Transport Journeys by Type of Transport - London Datastore
Triathlon Data - men’s triathlon results from the 2008 Olympics Mens’ Triathlon at the 2008 Summer Olympics - Wikipedia
The ONS provide the inflation rate time series from 1989 to current
Census - Population Change by area (and sometime broken down by sex and age group) between the 2011 and 2021 censuses Phase one - Census 2021 first results
The average amount of alcohol consumed by adults - by year, country and by alcohol type Power BI dashboard at World Health Statistics data visualizations dashboard - Harmful use of alcohol
Longevity Data - projected lifespan of men and women born in 2010 and 2030 in 25 rich countries. Longevity in rich countries, The Economist