A more comprehensive analysis of UK COVID-19 statistics

A more comprehensive analysis of UK COVID-19 statistics

Last week, I posted an article with a Power BI report that allowed you to compare the progress of COVID-19 between different regions of the UK. Since then, and over the Easter weekend, I’ve updated my report to provide some other interesting features of the statistics:

  • 7-day moving average case incidences and deaths
  • cases and deaths per 1000 of population

I’ve also reproduced the existing Public Health England cumulative report to demonstrate that my dataset matches that of PHE.

The 7-day moving average charts represent a useful way of checking media reports that the UK is either beyond or approaching the “peak”. They also help to eliminate variations in reporting rates over a week – there tend to be fewer deaths reported at the weekends because some weekend deaths are not reported by hospitals to PHE until the middle of the following week.

The cases and deaths per 1000 of population analysis helps demonstrate those areas of the country which are more severely affected by COVID-19 in terms of population density.

Feel free to browse the report below:

In my next post I’ll be returning to the Springwater end-to-end case study.

Leave a Reply