top of page
All Posts


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 19, 20252 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 19, 20252 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 19, 20252 min read


Emergency Room Visits Dashboard
A quick, clear look at ER utilization, wait times, and patient experience. Project Overview Built an interactive Tableau dashboard analyzing 9,216 ER visits to uncover patterns in wait times, patient demographics, and referral trends . Designed for hospital operations and population health teams. View Interactive Dashboard Key Insights (What Matters) Average Wait Time: 35.26 minutes. Which is stable across months, but spikes early mornings (6–8 AM) . Average Satisfaction
Edgard Ledea
Nov 18, 20251 min read
bottom of page
