A personal healthcare analytics portfolio documenting my journey from raw CMS data to interactive Power BI dashboards.
This project uses real CMS Medicare Hospital Compare data to analyze 30-day hospital readmission rates. Through this project, I practiced importing, cleaning, analyzing, and visualizing real CMS Medicare healthcare data using SQL Server and Power BI.
Technologies:
- SQL Server
- Power BI
- CMS Hospital Compare Dataset
Current Progress
- ✅ Downloaded and imported CMS Medicare Hospital Compare data into SQL Server
- ✅ Cleaned and validated the dataset using SQL
- ✅ Explored hospital readmission data using SQL queries and aggregate functions
- ✅ Built an interactive Power BI dashboard
- 🔄 Continuing to expand SQL skills with Window Functions and CTEs
What I’m Learning
- Working with real CMS healthcare datasets
- Writing SQL queries for healthcare data analysis
- Building an end-to-end analytics workflow from raw data to Power BI dashboards
📂 SQL Server Series
✅ Part 1 – How to Download Medicare Hospital Readmission Data
✅ Part 2 – Understanding the Medicare Readmission Dataset with SQL
✅ Part 3 – Clean Medicare Data with SQL
✅ Part 4 – Exploring Medicare Hospital Readmission Rates with SQL
✅ Part 5 – Filtering Healthcare Data with WHERE and HAVING
✅ Part 6 – Connecting Power BI to SQL Server
✅ Part 7 – Building an Interactive Healthcare Dashboard with Power BI
📈 Future Series
⬜ Window Functions
⬜ Common Table Expressions (CTEs)
⬜ Creating SQL Views
📊 Next Step
Continue expanding my healthcare analytics portfolio by learning advanced SQL techniques, developing additional Power BI projects, and exploring Azure-based analytics.