This repository contains two interactive Excel Dashboards designed to demonstrate how powerful and professional data visualizations can be within Microsoft Excel — breaking the stereotype that Excel is "just for spreadsheets."
Dark_theme_Excel_dashboard.xlsx– E-commerce sales performance dashboard with a sleek dark UI.Excel_Warehouse_analysis_dashboard.xlsx– Warehouse supply chain and stock tracking dashboard.
A visually stunning dashboard focused on sales performance and growth analysis for an e-commerce company.
- 📈 Total sales & growth comparison (YOY)
- 🛒 Orders vs Offers vs Products Sold
- 🔝 Top 10 customers and their contribution
- 🎯 Product-wise sales & performance
- 📉 Sales drop/growth insights
- 📌 Slicers & interactivity
A clean, functional warehouse management dashboard showing inventory, purchase data, and geographic stock movement.
- 📦 Stock quantity and value trends (2019–2024)
- 📊 Purchase vs sold quantity/value comparison
- 🗺️ Regional distribution & performance (map-based)
- 🔍 Filters for sub-category, brand, and price bucket
- 🧠 Business logic for profitability by type and location
- Microsoft Excel (Pivot Tables, Power Query, Slicers, Data Modeling)
- Data Cleaning & Merging
- KPI Metrics & Dashboard Design
- Business Intelligence Reporting
- Visual Storytelling & UX-focused layout
Perfect for:
- Stakeholders who need visually clean reports with insights
- Excel-based analysts building BI reports without Tableau/Power BI
- Data Analysts creating reports from scratch using real-world logic
- Leveraged Excel for advanced BI reporting.
- Practiced Power Query for data merging & modeling.
- Designed dashboards with executive-ready layouts.
- Improved storytelling through data.
- 🔗
- 🐙
- 📧
Stay tuned — this repository will be updated with more Excel BI dashboards covering HR, Finance, and Marketing domains!