📊 Excel Projects – Data Analysis & Data Science Repository

Welcome to my Excel Projects Repository, a collection of real-world Data Analytics and Data Science projects built using Microsoft Excel. This repository is designed to showcase my skills in data cleaning, analysis, visualization, dashboard creation, and business insights generation — all using Excel.

Whether you're a recruiter, data enthusiast, or learner, this repo highlights how Excel can be used to solve business problems through clear analytics and interactive dashboards.

---

📁 What You’ll Find in This Repository

This repository includes Excel projects related to:

✔ Data Cleaning & Preparation

• Handling missing values
• Removing duplicates
• Data transformation
• Formatting and structuring datasets

✔ Exploratory Data Analysis (EDA)

• Summary statistics
• Trend analysis
• Segmentation (Gender, Age, Category, Region)
• Performance comparison

✔ Interactive Excel Dashboards

• Pivot tables & pivot charts
• Slicers (Month, Category, Channel, Region, etc.)
• KPIs & metrics
• Business insights and conclusions

✔ Real-World Business Use Cases

• Sales analysis
• Customer behavior analysis
• Ecommerce performance
• Operational metrics
• Category performance
• Store/region level insights

---

📂 Repository Structure

Each project folder typically includes:

📁 Project Name
   ├── Dataset (Excel)
   ├── Dashboard (Excel)
   ├── Dashboard Preview (PNG)
   └── README.md (Project documentation)

---

🚀 Skills Demonstrated

• Data Cleaning
• Pivot Tables & Pivot Charts
• Dashboard Design
• KPI Reporting
• Business Analytics
• Excel Formulas (IF, VLOOKUP/XLOOKUP, INDEX MATCH, COUNTIFS, SUMIFS, etc.)
• Slicers & Interactive Elements
• Data Visualization
• Problem Solving & Insight Generation

---

🎯 Purpose of This Repository

This repository serves as:

• A portfolio of my Excel-based analytics capabilities
• A reference for real-world business analysis projects
• A space where I will continue to upload future Excel projects
• A showcase of my progress as a Data Analyst & Data Science learner

---

🎓 Who Is This Useful For?

• Recruiters evaluating my Excel skills
• Students learning Excel dashboards
• Aspiring data analysts
• Professionals exploring business analytics
• Anyone looking for practical Excel projects

---

📬 Connect With Me

Muhammed Thaha Uwais 📧 muhammedthahauwais@gmail.com 🔗 LinkedIn: https://www.linkedin.com/in/muhammed-thaha-uwais-5b5444279/

---

⭐ Support

If you find this repository useful, consider giving it a ⭐ Star on GitHub — it motivates me to build and share more projects!