Projects using Microsoft Excel in Uttar PradeshProjects using Microsoft Excel in Uttar PradeshE-Commerce Sales Performance Dashboard 🛒📊
Designed and built an advanced, interactive E-Commerce analytics dashboard to track key online retail metrics, revenue growth, and regional sales distribution.
Key Highlights:
Financial Overview: Monitored Total Sales ($114K), Total Profit ($22.8K), and maintained a strong Profit Margin (20%).
Regional & Category Filters: Integrated dynamic slicers for Categories and Regions (East, North, South, West) to drill down into specific market performance.
Visual Trends: Visualized monthly profit distribution, yearly sales projections, and order quantities through clean pie charts, bar charts, and area graphs.
Built to help e-commerce store owners uncover hidden trends, optimize inventory, and scale their online revenue effectively.