📊 Excel Data Analytics & Business Intelligence Portfolio

Welcome to my Excel Portfolio! 🚀

This repository is a collection of end-to-end data analysis projects where I transform raw, fragmented data into interactive dashboards and strategic business insights. I specialize in leveraging Excel's advanced engine—Power Query, Pivot Modeling, and Complex Formula Logic—to solve real-world problems.

---

🛠️ Excel Mastery Tech Stack

• Advanced Formulas: XLOOKUP, INDEX/MATCH, SUMIFS, Nested IFs, TEXT logic.
• Data Modeling: Power Query (M), Pivot Tables, Calculated Fields, and Data Normalization.
• Visualization: Dynamic Dashboards, Slicers, Timelines, 3D Maps, and Pareto Charts.
• Optimization: Data Validation, Conditional Formatting, and Automated Reporting.

---

📂 Featured Projects

1. ☕ Coffee Shop Sales & Operations

Focus: Retail Analytics & Revenue Optimization

• Objective: Audit daily operations to identify peak traffic hours and high-margin product bundles.
• Key Insight: Identified a 40% traffic surge during morning peak hours, leading to optimized staff scheduling recommendations.
• Tools Used: Pivot Tables, Slicers, and Trend Analysis.

2. ⚠️ Road Accident Safety Report

Focus: Risk Mitigation & Geospatial Intelligence

• Objective: Analyze historical accident logs to pinpoint high-risk "hotspots" and environmental correlations.
• Key Insight: Correlated 30% of major accidents to specific low-visibility windows, identifying 5 key "Danger Zones."
• Tools Used: 3D Maps, Severity Profiling, and Data Sanitization.

3. US Sales Market Intelligence

Focus: Regional Growth & Market Performance

• Objective: Evaluate sales velocity across four US geographic regions to identify underperforming territories.
• Key Insight: Applied the Pareto Principle (80/20 rule) to isolate the top 20% of SKUs driving 70% of national revenue.
• Tools Used: Time Intelligence, Regional Benchmarking, and KPI Scorecards.

---

🏗️ Repository Structure

Excel_Portfolio/
│
├── 📁 coffee_shop_analysis/     # Retail & Customer Behavior Analysis
├── 📁 road_accident_report/     # Safety Metrics & Geospatial Hotspots
└── 📁 us_sales_data_analysis/   # National Sales & Market Intelligence

---

🚀 How to Use

1. Clone the Repo:

   git clone [https://github.com/Nitesh8750/Excel_Projects.git](https://github.com/Nitesh8750/Excel_Projects.git)

2. Software: Ensure you have Microsoft Excel (2019 or later recommended) to support Slicers, Maps, and Power Query features.
3. Explore: Open the .xlsx file within each project folder to view the interactive dashboards.

---

🤝 Contact & Connect

Nitesh Kumar

📧 Email: nk7003361@gmail.com
📱 Mobile: +91 8750993046
🔗 LinkedIn: Nitesh Kumar
💻 GitHub: Nitesh8750

---

“Turning rows of data into paths for business growth.” 📈✨