hospital-analytics-data-analysis-using-sql
This is a SQL-based data analysis project from Maven Analytics that explores hospital encounters, costs, and patient behavior trends. The project covers encounter insights, cost & coverage analysis, and patient readmission patterns using SQL queries to answer real-world healthcare analytics questions.
https://github.com/rishi71095/hospital-analytics-data-analysis-using-sql
Science Score: 44.0%
This score indicates how likely this project is to be science-related based on various indicators:
-
✓CITATION.cff file
Found CITATION.cff file -
✓codemeta.json file
Found codemeta.json file -
✓.zenodo.json file
Found .zenodo.json file -
○DOI references
-
○Academic publication links
-
○Academic email domains
-
○Institutional organization owner
-
○JOSS paper metadata
-
○Scientific vocabulary similarity
Low similarity (8.3%) to scientific vocabulary
Repository
This is a SQL-based data analysis project from Maven Analytics that explores hospital encounters, costs, and patient behavior trends. The project covers encounter insights, cost & coverage analysis, and patient readmission patterns using SQL queries to answer real-world healthcare analytics questions.
Basic Info
- Host: GitHub
- Owner: rishi71095
- License: mit
- Default Branch: main
- Size: 6.93 MB
Statistics
- Stars: 0
- Watchers: 0
- Forks: 0
- Open Issues: 0
- Releases: 1
Metadata Files
README.md
I recorded my full project walkthrough and uploaded it on YouTube which is great if you want to follow along with my thought process and hopefully make some suggestions. Watch it here.
Project Description:
This is a data analysis project using SQL, created by Maven Analytics, called Hospital Analytics. The goal of this project is to analyze hospital patient encounters, costs, and behavior trends to gain insights into hospital operations and patient care patterns.
The project is divided into three main objectives, each focusing on a different aspect of hospital data:
🔹 Objective 1 – Encounters Overview
We will analyze the encounters table to understand how patients interact with the hospital.
- Total encounters per year
- Percentage of encounters by class (ambulatory, outpatient, wellness, urgent care, emergency, inpatient)
- Percentage of encounters lasting more than or less than 24 hours
🔹 Objective 2 – Cost & Coverage Insights
We will analyze the encounters table to understand how patients interact with the hospital.
- Encounters with zero payer coverage and their percentage
- Top 10 most frequent procedures and their average base cost
- Top 10 procedures with the highest average cost and their frequency
- Average total claim cost per encounter by payer
🔹 Objective 3 – Patient Behavior Analysis
We will study patient behavior and readmissions to track hospital usage patterns.
- Unique patient admissions by quarter
- Patients readmitted within 30 days of a previous encounter
- Patients with the highest number of readmissions
This project is perfect for practicing SQL skills, as it requires writing queries to aggregate, filter, and analyze data across tables. It simulates real-world healthcare analytics tasks, making it a great addition to a data analytics portfolio.
📌 The dataset and project are provided by Maven Analytics to their subscribers for learning and portfolio-building purposes.
License
MIT
Owner
- Name: Vimaljeet Singh
- Login: rishi71095
- Kind: user
- Repositories: 1
- Profile: https://github.com/rishi71095
Citation (citation.txt)
Jason Walonoski, Mark Kramer, Joseph Nichols, Andre Quina, Chris Moesel, Dylan Hall, Carlton Duffett, Kudakwashe Dube, Thomas Gallagher, Scott McLachlan, Synthea: An approach, method, and software mechanism for generating synthetic patients and the synthetic electronic health care record, Journal of the American Medical Informatics Association, Volume 25, Issue 3, March 2018, Pages 230–238, https://doi.org/10.1093/jamia/ocx079
GitHub Events
Total
- Push event: 3
- Create event: 2
Last Year
- Push event: 3
- Create event: 2