An interactive Excel-based dashboard designed to streamline inventory tracking and analysis across multiple warehouses and suppliers. This project focuses on delivering real-time insights for supply chain optimization using core Excel features.
- 📦 Tracks stock levels by item, warehouse, and supplier
- 📈 Real-time visualization using PivotTables and PivotCharts
⚠️ Highlights low-stock items using conditional formatting- 📊 Reorder status monitoring (below reorder vs. sufficient)
- 🧹 Cleaned and structured data for accurate analytics
- 🖱️ Interactive slicers for dynamic filtering by category or supplier
- Microsoft Excel
- PivotTables & PivotCharts
- Conditional Formatting
- Slicers & Filters
- Data Cleaning Techniques
Ideal for small-to-medium businesses or inventory analysts who need a quick, flexible, and automated view of stock performance across suppliers and locations without complex software.
- Reduced manual analysis time by 30%
- Improved decision-making for inventory restocking
- Delivered a professional-grade Excel dashboard for non-technical stakeholders
- Excel Dashboard Design
- Data Visualization
- Inventory Analytics
- PivotTables & Slicers
- Conditional Formatting
Author: Ayesha Banu
Status: Completed | June 2025
License: For educational and portfolio use