Ed Ledea's Portfolio

Practical healthcare data analysis showcased through SQL, Excel, and Tableau projects.

Healthcare Analytics

Projects

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

Excel

Edgard Ledea

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

Tableau

Edgard Ledea

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

SQL

Edgard Ledea

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

Tableau

Edgard Ledea

About Me

My name is Ed Ledea

I’m Ed Ledea, a healthcare data analyst focused on turning messy numbers into clear stories that help people make better decisions. I enjoy digging into claims, patient experience scores, and operational data to find what actually moves results.

Before analytics, I spent years in sales and patient outreach. That background taught me how to communicate clearly, understand what people need, and translate complex ideas into something anyone can act on. It also gave me a strong appreciation for the impact good data can have on patient care and business performance.

Outside of work, I’m big on fitness, learning new skills, and staying curious. I like building projects that are practical, easy to understand, and useful for teams who rely on real insights, not buzzwords.

Phone

346-218-8370

Email

EdgardLedea@gmail.com

Ed Ledea's Portfolio

Projects

Denial Management Dashboard

Cost & Utilization Dashboard: Healthcare Claims Analysis

National HCAHPS Patient Experience Dashboard

Emergency Room Visits Dashboard

About Me

Phone

Email

Connect