Where is the money going by Mwanahamisi JumaWhere is the money going by Mwanahamisi Juma

Where is the money going

Portfolio project
Mwanahamisi Juma
Where is the money going — and what is actually driving healthcare claim costs?
I analyzed 4,500 healthcare insurance claims worth 22.56M using SQL, Python, and Power BI to identify cost drivers, provider performance patterns, and inefficiencies in claims processing.
A few things stood out. Pediatrics accounted for 4.9M in claims, making it the largest expenditure driver among provider specialties. Outpatient services had the highest claim volume, while a small number of diagnosis codes accounted for a disproportionate share of total costs. Claim spending also peaked in November 2023.
I then tested whether patient demographics, provider specialty, and claim type were actually driving claim amounts or claim outcomes. The statistical tests found no significant associations, suggesting that clinical and operational factors may matter more than demographics alone.
Based on the findings, I recommended monitoring high-cost diagnoses and specialties, investigating the November spending spike, improving the handling of pending and denied claims, increasing electronic claim submission, and incorporating clinical and operational variables into future predictive models.
I built interactive Power BI dashboards covering executive KPIs, patient demographics, provider performance, and claims activity — giving healthcare teams a clearer view of where costs are concentrated and where operational problems need investigation.
Tools: SQL · Python · Power BI · Excel

0 likes · 0 views · Sep 8, 2026

Where is the money going — and what is actually driving healthcare claim costs? I analyzed 4,500 healthcare insurance claims worth 22.56M using SQL, Python, ...

Tags