Data Training Courses

Home | Power BI | Excel | Python | SQL | Generative AI | Visualising Data | Analysing Data

In these exercises we inspect public datasets provided by the NHS and discuss:

• Is the data in tabular format?
• What is the grain of each table i.e. what does each row represent?
• Is the table designed well?
• If we were the provider of the data how would we improve it so that people can analyse the data more easily?

Diagnostic Imaging Dataset

The Diagnostic Imaging Dataset is sourced originally from Table 1 on this page. You can also download from here.

It contains a tab named ‘Provider’ tab with two tables.

GP Patient Survey Dental Statistics Dataset

The GP Patient Survey Dental Statistics (January to March 2024, England) dataset is sourced originally from this page. The direct link to the spreadsheet is here. You can also download from here.

This spreadsheet contains several tabs and most of these contain a table.

TfL Bike Hire Dataset

In this exercise, bin the bike hire data so that we can see the distribution of the number of bikes hired each day. Use whatever software and techniques that you prefer.

Links to the dataset and some details are here.