TessyAfoma/Health-Insurance-Eye-care-Dashboard

This project analyzes the financial burden of eye care services in Nigeria, focusing on the gap between clinic prices and insurance coverage. It uses real-world-inspired data to highlight patient out-of-pocket payments for essential eye services like refraction, cataract surgery, and prescription glasses. # Health-Insurance-Eye-care-Analysis ## Project Overview This project analyzes the financial burden of eye care services in Nigeria, focusing on the gap between clinic prices and insurance coverage. It aims to provide insights for the average Nigerian on the out-of-pocket costs for essential eye services like refraction, cataract surgery, and prescription glasses. ### Data Sources NHIS Profession Fee-For-Service Price List, AXA Mansard Health Plans, Aman HMO Benefits ### Tools - Excel (Charts, Conditional formatting, KPIs) ### Exploratory Data Analysis - What is the Average Patient Payments - What is the Average Insurance Coverage Rate - What service has the Highest Coverage Gap ### Key Insights - Patients pay **₦28,550** on average out-of-pocket for eye care. - Insurance covers only **23.4%** of service costs. - **Cataract surgery** has the highest financial gap with **83%** of costs falling on patients. - **60%** of patients pay fully for glasses despite having insurance. ### Recommendations Based on the analysis, I recommend the following actions - Patient education on coverage gaps - Improved Health Insurance Plans ### Limitations I used a tiny dataset, so the accuracy of my conclusions may not be exact. ### Use Case - Health policy analysts exploring financial equity - NGOs or startups designing affordable vision care programs in Nigeria ### Author Created by **Tessy Afoma**, an optometrist and data analyst committed to making health data more transparent and actionable. ### Preview ![Dashboard Preview]