📊 Data Analysis Portfolio — Mahad Khan

Welcome to my Data Analysis Portfolio!
I’m a self-taught data analyst with a background in web development, now focusing on SQL, Excel, Power BI, and Python to uncover insights from real-world data.

---

🧹 SQL Projects

1️⃣ Data Cleaning Project

Cleaned a messy housing dataset using SQL:

• Removed duplicates and nulls
• Standardized inconsistent values
• Prepared the data for analysis

🧾 Files:
data_cleaning.sql, raw_dataset.csv, cleaned_dataset.csv

---

2️⃣ Exploratory Data Analysis — World Layoffs

Performed EDA to explore global layoffs trends:

• Analyzed layoffs by year, industry, and company
• Identified top companies and peak periods
• Used advanced SQL queries like CTEs, WINDOW functions, and aggregates

🧾 Files:
eda_world_layoffs.sql, README.md

---

🛠️ Tools & Skills

• Languages: SQL, Python (learning phase)
• Databases: MySQL
• Data Tools: Excel, Power BI (next focus)
• Other: GitHub, Data Cleaning, EDA, Query Optimization

---

🌱 Next Steps

Currently learning Excel for Data Analysis and preparing to move into Power BI dashboards.

---

📫 Let’s Connect:

• LinkedIn: (https://www.linkedin.com/in/mahad-khan-85683025a/)
• GitHub: (https://github.com/MforMahad/)