Data Training from Zomalex

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

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.