Data-Analytics-2- NHS

Exploratory Analysis using Jupyter notebook and Python programming language following PEP8 best practice coding

Problem:

You are part of a team of data analysts that was contracted by the National Health Services (NHS), a publicly funded healthcare system in England.

Objectives:

NHS’s stakeholders are divided on if capacity should be increased based on current trends in utilisation. NHS would like to understand:

• Primary:

1. Check if current capacity is adequate and resources are sufficient
2. Is there evidences supporting belief that existing infrastructure and resources are sufficient for patients

• Secondary:

3. Profile of missed scheduled appointments

Solution:

1. Current capacity not adequate, since average was used as a metric representing maximum capacity.
2. Infrastructure and resources are being overcome gradually and the rate of appointments is increasing consistently over average number of appointments.
3. Allocation of budget should increase assuming current trajectory, this is excluding the population growth anticipated by NHS prior request of analysis of the data set.
4. Limitation exist within the data sets, there is evidence to suggest a uniform standardization recording observation notably waiting period between reservation & appointment.
5. For future inquires regarding budget allocation, the NHS should consider using a margin of error due to sensitive nature of the data sets. Data recorded based on patient and health treatment need to adhere to highest levels of security to maintain privacy of citizens.