PROJECT OVERVIEW
A comprehensive analysis of product sales (car sales) from 2003 to 2005. It includes key metrics like total sales, profit margins, top-selling items, quantity ordered, and product performance by year and category It presents an interactive Power BI dashboard designed to analyze historical sales data across various product lines and time periods. It helps uncover trends in product performance, monitor business KPIs, and identify areas of improvement or opportunity.
OBJECTIVES
- Visualize total sales, profit margins, and product-wise performance
- Identify top and bottom selling products based on sales and quantity
- Analyze year-over-year performance (2003–2005)
- Understand customer demand via quantity ordered
- Enable filtering by year, city, employee, and product line
KEY FEATURES
- ✅ Interactive Filters: Slice data by year, city, employee, and product line.
- 📈 KPI Cards: Track total sales, profit margin %, and actual profit.
- 🏆 Top & Bottom Products: Visualize best and worst-performing items.
- 📊 Product Line Analysis: Sales and quantities segmented by product category.
- 📅 Yearly Trends: View changes in sales performance over time.
- 📦 Quantity Insights: Compare ordered quantities across products and years.
- 🎯 Goal Tracking: Sales goal performance shown with variance percentage (e.g., 2004 vs target).
DASHBOARD
Main Dashboard Overview
Detailed Product Line Breakdown
KPIs SUMMARY
| Metric | Value |
|---|---|
| Total Sales | $13.74M |
| Profit Margin % | 40.87% |
| Profit Margin Value | $5.61M |
| Sales in 2004 | $0.40M (12.69% above target) |
CONCLUSION
This Power BI dashboard effectively transforms raw sales data into actionable insights. It allows users to monitor performance trends, identify high and low-performing products, and make data-driven decisions with confidence. Whether you're exploring historical trends or setting future sales strategies, this dashboard serves as a valuable tool for performance analysis.