← Back to Projects
BeginnerProject 1
Sales Data Analysis
Analyze retail sales data to identify trends and top-performing products
1
2
3
4
5
Understand
Explore
Analyze
Visualize
Conclude
1
Understand the Business Problem
📋 Scenario
You're a data analyst at RetailCo, an electronics and furniture retailer. The sales director wants to understand:
- • Which product categories are selling best?
- • Are there any seasonal trends?
- • Which products should we stock more of?
- • What's our average revenue per transaction?
📊 Dataset Overview
Records:
12 transactions
Time Period:
Jan - Apr 2024
Categories:
Electronics, Furniture, Stationery
Fields:
Product, Category, Price, Quantity, Date
2
Explore the Data
Sample Data (First 5 Rows)
| Product | Category | Price | Qty | Date |
|---|---|---|---|---|
| Laptop | Electronics | $1,299 | 15 | 2024-01-15 |
| Mouse | Electronics | $29 | 150 | 2024-01-20 |
| Desk Chair | Furniture | $249 | 45 | 2024-02-01 |
| Monitor | Electronics | $399 | 30 | 2024-02-10 |
| Keyboard | Electronics | $79 | 120 | 2024-02-15 |
💡 Initial Observations
- ✓ Data looks clean - no obvious missing values
- ✓ Electronics category appears frequently
- ✓ Prices range from $5 to $1,299
- ✓ Dates span Q1 2024
3
Analyze Key Metrics
Total Revenue
$51,350
Price × Quantity for all products
Avg Price
$244
Mean price across all products
Total Units
1,045
Sum of all quantities sold
Sales by Category
Electronics$36,365 (71%)
Furniture$12,185 (24%)
Stationery$2,800 (5%)
4
Visualize Insights
Top 5 Products by Revenue
Laptop$19,485
100%
Monitor$11,970
61%
Desk Chair$11,205
58%
Keyboard$9,480
49%
Headphones$13,410
69%
5
Draw Conclusions
✓ Key Findings
- • Electronics dominate: 71% of revenue comes from electronics category
- • Top performer: Laptops generate the most revenue ($19,485)
- • High volume items: Mice and pens sell in large quantities (150+ units)
- • Steady growth: Sales increased from Q1 to Q2
💡 Recommendations
- 1. Stock more electronics - especially laptops and monitors
- 2. Bundle deals - combine popular items (laptop + mouse)
- 3. Promote furniture - has potential but underperforming
- 4. Seasonal campaigns - capitalize on quarterly trends
🎯 Next Steps
- • Collect more data (at least 6-12 months) for better trend analysis
- • Add customer demographics to understand buyer personas
- • Track inventory levels to optimize stock management
- • Implement A/B testing for promotional campaigns
🎓 What You Learned
- ✓ How to frame a business problem for data analysis
- ✓ Exploring and understanding sample data
- ✓ Calculating key metrics (revenue, averages, totals)
- ✓ Creating simple visualizations to communicate insights
- ✓ Drawing actionable conclusions from data