Overview:
An interactive e-commerce analytics dashboard designed to analyze total revenue metrics, customer acquisition, and multi-category product performance. This dashboard aggregates high-volume transaction data to highlight sales trends, top-selling inventory, and average order values for retail growth optimization.
Key Features & Metrics Tracked:
Core KPI Header: Top-level summary tiles displaying Total Revenue ($7.99M), Total Orders (8,500), Average Order Value ($939), and Total Unique Customers (3,534).
Revenue by Category: Horizontal bar chart illustrating revenue distribution across distinct product lines.
Monthly Revenue Trend: Line chart tracking revenue fluctuations and seasonality patterns over multi-year operational cycles.
Top Products Ranking: Ranking visual highlighting best-selling individual items by total sales volume.
Tools & Skills Used:
Microsoft Excel, Data Analytics, Dashboard UI Design, Data Visualization, E-commerce Reporting, KPI Analysis. 🚀