Layoffs_Proyect

Data Analysis and Cleaning Portfolio

This repository contains SQL scripts and a dataset used for data cleaning and exploratory data analysis (EDA) as part of a data analytics project. The goal is to demonstrate skills in handling real-world data, identifying trends, and preparing the data for further modeling and analysis.

Project Overview

This project includes:

1. Data Cleaning
   The SQL script Data_Cleaning.sql focuses on cleaning raw data, ensuring consistency, handling missing values, and preparing the data for exploratory analysis.

2. Exploratory Data Analysis (EDA)
   The SQL script Exploratory_Data_Analysis.sql provides insights into the dataset through summary statistics, trend analysis, and data visualization using SQL queries.

3. Layoffs Dataset
   The dataset layoffs.csv contains data related to layoffs in different sectors. This data is used in both data cleaning and exploratory analysis scripts.

Files

• Data_Cleaning.sql: SQL script for cleaning and transforming the dataset.
• Exploratory_Data_Analysis.sql: SQL script performing exploratory data analysis (EDA).
• layoffs.csv: Raw dataset containing information on layoffs.

How to Use

1. Clone the repository: git clone https://github.com/gonzagustin10/Layoffs_Project.git

2. Import the dataset into your database.

3. Execute the SQL scripts in your SQL environment (e.g., MySQL, PostgreSQL).

Technologies SQL: Used for data cleaning and analysis. CSV: Raw data format used for the analysis.

License This project is licensed under the MIT License. Feel free to use the code and dataset for your own projects.

Author Sosa Gonzalo Portfolio LinkedIn Email