This project involves cleaning and analysing a dataset of layoffs using SQL. The project is divided into two main parts:
- Data Cleaning: Cleaning raw layoff data to ensure consistency and accuracy.
- Data Analysis: Performing various analyses to summarise and rank the layoff data by different categories such as company, industry, country, and date.
- LayoffsDataCleaning.sql: SQL script that performs data cleaning operations on the raw layoffs data.
- LayoffsDataAnalysis.sql: SQL script that conducts data analysis on the cleaned dataset.
- layoffs.csv: Excel file that contains the original dataset.