Hospital Data Exploratory Analysis
This project involves using SQL queries to provide stakeholders with insights regarding operations.
BACKGROUND
​
For this project with the Data Analytics Accelerator program, I was tasked with using SQL to explore hospital data and provide stakeholders with insights regarding operations.
​
THE DATA
​
The data consisted of two tables, each with 101766 rows of data:
-
Demographics
-
Health - 101766 rows of data
​
Once the schema and tables were created and filled with records, it was time to start analyzing.
​
PATIENT STAY LENGTH
​
Stakeholders were initially curious to see how long the majority of patients stayed in the hospital. This is important because we want to have beds available for patients and ensure we aren't spending money on patients that don't need a long stay at the hospital. Based on the query, majority of patients spend at least 7 days in the hospital.
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
TREATMENT BASED ON RACE
​
When asked if patients were treated differently based on their race, I looked at the number of procedures a patient received and broken it down by race. Based on the results, there is nothing to indicate that a patient is treated differently based on race.
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
WHICH MEDICAL SPECIALTY PERFORMS THE MOST PROCEDURES?
​
Since procedures are costly to hospitals, a stakeholder was curious to learn which medical specialty was performing the most procedures on average. They were interested to see which specialty specifically had at least 50 patients or more. Based on the query, Cardiology performs the most procedures.
​
​
​
​
​
​
​
​
​
​
​
​
​
​
EMERGENCY PATIENTS SUCCESS STORY
​
Stakeholders wanted to see if there were opportunities when a patient came in as an emergency patient but ended up leaving the hospital faster than the average rate. The average time in hospital was 4.3 days. To provide insights for this, a CTE was used to give the hospital a success story.
​
​
​
