HEALTHCARE CLAIMS ANALYTICS
Claims
KPI
Dashboard
End-to-end pipeline · Python · PySpark · Databricks · AWS S3 · Power BI
500 claims
Jan 2023 – Dec 2024
5 regions
4 plan types
● LIVE DATA
All Regions
Northeast
Southeast
Midwest
Southwest
West
All Plans
PPO
HMO
EPO
HDHP
All Types
Medical
Pharmacy
Dental
Vision
Behavioral
Total Claims
—
Across all sources
Approval Rate
—
—
Denial Rate
—
—
Total Billed
—
All claim types
Avg Processing
—
Days per claim
Payment Ratio
—
Paid / Billed
Monthly claim volume
Jan 2023 – Dec 2024 · all types
Claim status breakdown
Approved · Denied · Pending · Under review
Approval rate by claim type
% approved per type
Claims by region
Volume distribution
Processing time distribution
Days to process a claim
Billed vs paid by claim type
Average amounts per type ($)
Denial reasons
Top reasons for claim denial
Claims by plan type — detail view
Approval rate · volume · avg paid · status
Plan Type
Total Claims
Approved
Denied
Approval Rate
Avg Billed
Avg Paid
Status