Title: Visualizing Retail Business Trends with Excel: A Sales & Profit Deep Dive (2018–2019)
Tool: Microsoft Excel
Theme: Business Intelligence with Pivot Dashboards
This project explores how a simple tool like Excel can deliver powerful business intelligence. I created a dashboard that analyzes an online retail store’s performance from 2018 to 2019, breaking down trends in sales, profit, delivery modes, and product sub-categories.
Goals:
Compare sales and profit growth across years
Highlight top-performing cities and states
Identify sub-categories driving or dragging performance
Visualize delivery mode trends and quarterly seasonality
Key Insights:
Sales dipped slightly at -0.12%, but profits rose by 0.85% — suggesting improved margins
Cities like San Antonio and San Diego showed >10% sales growth
Sub-categories like Chairs and Phones had the most volatile profit trends
Top 10 states each crossed $500K in sales, dominating overall revenue
Tools Used:
Excel PivotTables & PivotCharts
Conditional formatting for visual KPIs
Slicers for interactivity
Manual layering for layout and navigation flow
Audience:
Retail managers tracking growth and loss regions
Marketers spotting product category winners
Ops teams planning for delivery seasonality
Analysts looking for profitability levers
Demo available here: Watch here