Build a SQL Healthcare Portfolio Project from Scratch | Data Analyst Guide

Want to become a Data Analyst? This is the BEST way to build a real SQL portfolio project. In this video, I walk you through a complete end-to-end SQL project using a real healthcare dataset from Kaggle, just like what you would do in a real job. You’ll learn how to: ✅ Clean real-world messy data using SQL ✅ Use CTEs and window functions (ROW_NUMBER) ✅ Calculate KPIs like total discharges & length of stay ✅ Perform data analysis using GROUP BY & aggregations ✅ Analyse healthcare trends by age, gender, and time =========================================================== 📊 Project Overview This dataset contains 14,000+ hospital admissions with patient demographics, medical history, and lab results. What We Cover in This Project: * Data Preparation: Using CTEs and ROW_NUMBER() to identify and remove duplicates. * Calculating Discharges: Filtering outcomes to find total patient volume. * Advanced Metrics: Calculating Average Daily Discharge Rate and Average Length of Stay (ALOS) using CAST and DECIMAL for precision. * Demographic Analysis: Categorizing patients into Age Groups (Paediatric, Adult, Senior Citizen) using CASE statements. * Trend Analysis: Using DATEPART and FORMAT to find discharge distributions by the day of the week. ========================================================= 🧠 SQL Concepts Covered GROUP BY Aggregate functions (SUM, COUNT) CASE WHEN logic Subqueries CTEs (Common Table Expressions) Window functions (ROW_NUMBER) Data cleaning techniques 💼 Why This Project Matters ============================================================ This is the type of project you can: Add to your portfolio Talk about in interviews Use to land a Data Analyst job =========================================================== [Project GitHub/Resources] 📂 Dataset: https://www.kaggle.com/datasets/ashishsahani/hospital-admissions-data/data?select=HDHI+Admission+data.csv 💻 SQL Scripts: https://github.com/RaheemYusuf/AutoCareHospital #SQLportfoliproject #sql #data #dataanalytics #dataanalysis #database #portfolioproject #portfolioprojects #healthcare #healthcareanalytics #ctetutorial #datacleaning #sqlviews #sqlforbeginners #sqlfordatascience #hospitaladmissionanalysis #alos #lenghtofstay #hospitaldischarge #SQL #DataAnalysis #HealthcareAnalytics #PortfolioProject #SQLTutorial #DataAnalyst #Kaggle 🚀 Subscribe for more: Data Analyst tutorials, SQL projects, Power BI dashboards & career tips.