📊 Excel Analytics Projects

This repository contains two Excel-based analytics projects — Sales & Customer Analysis and Financial Analysis Dashboard.
Both projects demonstrate real-world data modeling, KPI reporting, and interactive dashboard design using Advanced Excel features.

---

🚀 1. Sales & Customer Analysis Dashboard

Objective

Analyze customer performance, product sales, and market trends to identify top products, loyal customers, and opportunities for business growth.

Key Features

• Customer & market performance reports
• Top 10 product analysis
• KPI dashboards comparing targets vs actuals
• Interactive charts and pivot tables

Technical Skills

Power Pivot | Power Query | DAX | Pivot Tables | Charts

Links

• 🎥 Demo Video: Watch on YouTube
• 📊 Live Report: View Dashboard
• 💼 LinkedIn Post: View Post
• 📂 Project Repository: Sales & Customer Analysis

---

💼 2. Financial Analysis Dashboard

Objective

Analyze company financials and generate automated Profit & Loss (P&L) reports by month, market, and fiscal year for strategic decision-making.

Key Features

• P&L statements by fiscal year, month, and market
• Gross Margin (GM%) analysis
• Time intelligence using fiscal months & quarters
• Interactive dashboards for finance teams

Technical Skills

Power Pivot | Power Query | DAX | Time Intelligence | Financial Reporting

Links

• 🎥 Demo Video: Watch on YouTube
• 📊 Live Report: View Dashboard
• 💼 LinkedIn Post: View Post
• 📂 Project Repository: Financial Analysis

---

🧰 Tools Used

Microsoft Excel | Power Pivot | Power Query | DAX | Pivot Tables | Charts