top of page

Hospital Stay Analytics: Identifying Prolonged Stays by Diagnosis

Project Overview

The Length of Stay Dashboard is an interactive Tableau tool that compares hospital stay durations across three hospitals, filtered by MS-DRG codes. It highlights how each diagnosis group’s length of stay compares to the Medicare average, helping administrators identify inefficiencies, optimize resources, and improve patient flow.

Project

Tableau, SQL, Data Analysis

Tech Stack

Understanding how hospitals perform relative to national LOS benchmarks helps identify inefficiencies and supports data-driven improvements in patient care.

Why It Matters

We built a visual dashboard comparing hospital LOS to Medicare means across MDCs, making it easier to spot outliers, trends, and improvement areas.

Solution

Embedded Tableau

Tableau

bottom of page