I built a full Sales KPI Dashboard for Cephasia Electronics Company to help track performance and make data-driven decisions.
KEY FEATURES:
- Tracked Total Revenue: $34,492K
- Identified Top Product: MacBook Pro Laptop with $8,038K revenue
- Identified Most-Purchased Product: USB-C Charging Cable with 21,903 units sold
- Revenue Breakdown by 9 Cities: San Francisco led with $8.2M
- Monthly Sales Trend Analysis: Peak in December at $4,643K
- Product Ranking: Ranked all products by 2019 revenue
- Order Volume by City and by Month
KEY INSIGHTS DELIVERED:
1. MacBook Pro Laptop is the main revenue driver
2. San Francisco outperformed all other regions
3. December is the peak sales month
TOOLS USED: Excel, Data Cleaning, Pivot Tables, Data Visualization, Business Intelligence
RESULT: Leadership can now see what product sells, in which city, and in which month in one glance.
