Healthcare Risk Management
Category: Data Analytics & Alerts
Converting a large dataset into a simple dashboard to help manage third-party healthcare costs.
Objective: Use a live dataset to give healthcare customers better security by giving insights into their upcoming costs ahead of official quarterly reports.
Approach: Set up ETLs to gather data and display clear (near-live) dashboards with KPIs and trigger alerts when anomalies are detected.
Tools/Tech: Dataflow and PBI
Client/Industry: Healthcare, 3k records/day
Game Highlights
- Anomaly dashboard and alerts
- Monthly email with key stats showing monthly savings
- Quarterly data analysis sent email with opportunities for significant savings