Assignment Brief
You are taking on the role of a healthcare data analyst for a GP based in Bahrain. The dataset provides a snapshot of electronic healthcare records. The head data analyst from the GP practice has nominated you to use the dataset provided in order to analyse the data and extract relevant insights that should help management in decision making.
First, you will have to clean the dataset, identify all errors and discuss how to remedy each one of these. You should discuss generic issues that can be encountered with datasets and how to remedy these followed by the specific issues in the dataset.
Next, you should start carrying out the following types of analysis on the dataset given:
1.
Carry out descriptive statistics analysis on the key factors and discuss their distribution
2.
Use pivot tables and/ or charts to show insights in the dataset on:
-
patient age, gender and diagnosis;
-
diagnosis and medication prescribed
-
diagnosis and billing amount
-
billing amount and insurance status
-
age and doctors’ notes
3.
Analyse Insurance Status and High Billing Amounts to check if uninsured patients have higher costs.
4.
Carry out regression analysis on:
-
impact of diagnosis on billing amount
-
impact of age on billing amount
Based on the insights extracted from the analysis above, provide recommendations for the GP practice on how to improve its operations with the use of data analytics. Discuss new systems or updated functions of systems that could be used for the GP practice.
Discuss healthcare data ethics, secure handling of data principles and how these should be applied to the GP practice.
Suggested structure:
•
Title Page
•
Executive summary
•
Table of contents
•
Introduction to the report
•
Outline of generic and specific issues with the data set and how to remedy these
•
Analyse the data based on the above instructions, present the data using visuals ( tables, graphs, charts), and discuss key insights emerging from the analysis
•
Recommendations on how to improve the use of data analytics in the GP practice
•
Discuss ethical principles on secure data handling and how they should be applied in the GP practice.
•
Conclusion
•
References
•
Appendix (optional)
