Data and AI Training

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

Tutorial - Analyse NHS England Outpatient Activity

We will use an AI tool to analyse the number of outpatient appointments in England over the past several years by outcome (attended, did not attend etc). The data is in a CSV file - download from here and have a look at it. The original source data is from NHS Digital here.

Suggested Prompts

• Describe the attached dataset (Don’t forget to attach the file)
• Show attendance trends over the years.
• What is the trend in the percentage of patient cancellations? (Possible follow on: Why did this dip in the 2020-21 year?)
• Are there any other insights available from the data?