SQL Data Cleaning and Analysis Project

📌 Overview

This project focuses on cleaning and analyzing raw employee data using SQL. The dataset contained inconsistencies such as missing values, duplicate records, and formatting issues.

🧹 Data Cleaning Steps

• Removed extra spaces using TRIM()
• Standardized text using LOWER() and UPPER()
• Handled NULL values using IFNULL()
• Fixed invalid salary values (negative values)
• Removed duplicate records using self join

📊 Analysis Performed

• Department-wise average salary
• City-wise employee distribution
• Highest salary identification
• Salary categorization using CASE statement

📈 Key Insights

• Department 1 has higher average salary compared to others
• Majority of employees are located in MUMBAI
• Data cleaning improved data consistency and reliability

🛠 Tools Used

• MySQL
• Git & GitHub