Welcome to my SQL Case Studies repository! This repository contains two comprehensive end-to-end data analysis projects demonstrating advanced SQL skills, including data cleaning, exploratory data analysis (EDA), and complex query writing.
An end-to-end SQL case study focused on analyzing flight operations, passenger booking behavior, and airline revenue.
- Key Skills: Normalization, CTEs, Window Functions, Advanced Joins, Aggregations.
- Highlights: Identified busiest airports, analyzed route profitability, and tracked customer loyalty.
A comprehensive project focused on hospital data management, cleaning raw dimensional data, and consolidating partitioned yearly fact tables.
- Key Skills: Data Cleaning, ETL (UNION ALL), Window Functions, Date/Time Manipulation.
- Highlights: Standardized patient records, analyzed departmental revenue, and evaluated doctor performance based on satisfaction scores.
- Database Engine: MySQL
- Language: SQL (DDL, DML, DQL)
Navigate to the individual project folders to view their specific README.md files, database schemas, and SQL scripts. You can run the included .sql files in your local MySQL environment to recreate the databases and explore the queries!