Part 5 – Filtering Healthcare Data with WHERE and HAVING
In this project, I’m learning how to filter data effectively using the WHERE and HAVING clauses. Instead of working with […]
⭐ Healthcare Analytics Projects, 1. Healthcare Knowledge Base
1. Healthcare Knowledge Base
⭐ Healthcare Analytics Projects, 1. Healthcare Knowledge Base
4. Exploring Medicare Hospital Readmission Rates with SQL
Now that the Medicare Hospital Readmission dataset is clean, it’s time to explore the data. In this post, we answer
⭐ Healthcare Analytics Projects, 1. Healthcare Knowledge Base
3. Cleaning Medicare Hospital Readmission Data with SQL
Now that the raw Medicare data has been imported into SQL Server, the next step is to clean and prepare
⭐ Healthcare Analytics Projects, 1. Healthcare Knowledge Base
2. Understanding the Medicare Readmission Dataset with SQL
Objective Now that we have downloaded the raw Medicare data, we need to understand what’s inside the file before we
⭐ Healthcare Analytics Projects, 1. Healthcare Knowledge Base
1. How to Download Medicare Hospital Readmission Data
Objective :The first step of any analysis is getting the right data. In this post, I will show you exactly
⭐ Healthcare Analytics Projects, 1. Healthcare Knowledge Base, Uncategorized
30-Day Hospital Readmission Analysis
This project uses real CMS Medicare Hospital Compare data to analyze 30-day hospital readmission rates. I’m building it step by
⭐ Healthcare Analytics Projects, 1. Healthcare Knowledge Base, 2. 📊 Power BI for Healthcare Analytics, 3. SQL for Healthcare Analytics, 4. Excel for Data Analyst
Healthcare Analytics Dashboard: From Excel to SQL Server to Power BI
This series documents the complete process of building a healthcare analytics dashboard using Excel, SQL Server, and Power BI. As I continue learning and building this project, I’ll update each step—from preparing the data to creating dashboards and presenting business insights.
1. Healthcare Knowledge Base, 2. 📊 Power BI for Healthcare Analytics
KNIME → Python
Simple Comparison: Concept In KNIME In Python (what we’ll do) Data Loading CSV Reader node pd.read_csv() Target Column You set
1. Healthcare Knowledge Base, 3. SQL for Healthcare Analytics, Uncategorized
SQL Study Notes: Recognizing Patterns Instead of Memorizing Syntax
Today’s SQL practice reinforced an important lesson: writing SQL is less about memorizing commands and more about recognizing common patterns.
1. Healthcare Knowledge Base, 3. SQL for Healthcare Analytics
SQL Data Cleaning Techniques
Why Data Cleaning Matters Data analysts spend a significant amount of time cleaning data before performing analysis. SQL provides many