top of page
Excel


Denial Management Dashboard
This project analyzes claim denials across a sample of two thousand encounters to help identify the top drivers of revenue loss and workflow delays. The dashboard summarizes denial volume, denial dollars, and denial rate trends with simple filters for payer, service line, and CPT code. I built this tool to help revenue cycle teams understand where denials are coming from and how they impact financial performance. The layout highlights the most important answers first so leade
Edgard Ledea
Nov 192 min read
Â
Â
Â


Cost & Utilization Dashboard: Healthcare Claims Analysis
This dashboard analyzes a synthetic but realistic healthcare claims dataset that includes medical, pharmacy, and utilization records. Users can explore total cost, PMPM, service category spend, chronic condition impact, ED utilization, and high-cost member patterns. Filters for Region, Plan Type, and Risk Tier allow customized population views. I built this project to practice SQL and Tableau together and to show how claims data can be turned into a clear population story usi
Edgard Ledea
Nov 192 min read
Â
Â
Â


National HCAHPS Patient Experience Dashboard
This dashboard analyzes nationwide HCAHPS (Hospital Consumer Assessment of Healthcare Providers & Systems)  survey data. Users can view any hospital in the United States, compare its scores against peer facilities, and filter results by State  and Hospital Size  to customize the comparison group. I built this tool to help quickly understand how a hospital performs relative to its cohort using clean visuals, custom branding, and interactive drill-downs. View Interactive Dashbo
Edgard Ledea
Nov 192 min read
Â
Â
Â
bottom of page
