How rishabhsm2004/sql-project works
This small SQL analysis project turns a layoffs dataset into cleaned staging data, then uses exploratory queries to surface company, location, industry, and time-based trends. The README documents the cleaning and analysis stages and MySQL as the database technology; source excerpts were not provided, so relationships are limited to those documented there.
Main entry points: world_layoffs - EDA.sql Layoffs analysis · world_Layoffs- Data Cleaning.sql Data cleaning · layoffs.csv Raw layoffs data
Components 6
Data preparation
- Raw layoffs data
layoffs.csv - Data cleaning
world_Layoffs- Data Cleaning.sql - Cleaned staging data
world_Layoffs- Data Cleaning.sql
Exploratory analysis
- Layoffs analysis
world_layoffs - EDA.sql - Trend insights
world_layoffs - EDA.sql
Other components
- Analyst
Connections 5
- Raw layoffs data → Data cleaning: cleans
README.md - Data cleaning → Cleaned staging data: creates
README.md - Cleaned staging data → Layoffs analysis: analyzes
README.md - Analyst → Layoffs analysis: explores
README.md - Layoffs analysis → Trend insights: identifies
README.md