This project uses real CMS Medicare Hospital Compare data to analyze 30-day hospital readmission rates. I’m building it step by step to strengthen my SQL and Power BI skills in healthcare.
Technologies: SQL Server, Power BI
Current Progress
- Completed: Downloading and importing Medicare data into SQL Server
- Completed: Data cleaning and exploration using SQL
- Completed: SQL aggregate functions and analysis
- In Progress: Learning Window Functions and CTEs
- Next: Building an interactive Power BI dashboard
What I’m Learning
- Working with real CMS healthcare datasets
- Writing clean and efficient SQL queries
- Building an end-to-end analytics workflow from raw data to visualization
📂 SQL Server Series
✅ Part 1 – How to Download Medicare Hospital Readmission Data
✅ Part 2 – Import Data into SQL Server
✅ 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
📈 Advanced SQL (In Progress)
⬜ Window Functions
⬜ Common Table Expressions (CTEs)
⬜ Creating SQL Views
📊 Next Step
Building an interactive Power BI dashboard