EXERCISE - 3
Exercise 3.1: Sales by Region
Analyze how much revenue each region generated.
- Rows: Region
- Values: Sum of Total Revenue
Exercise 3.2: Salesperson Performance
Compare how each salesperson performed.
- Rows: Salesperson
- Values: Sum of Total Revenue, Average of Units Sold
Exercise 3.3: Revenue by Category and Product
See which products and categories are generating the most revenue.
- Rows: Category
- Columns: Product
- Values: Sum of Total Revenue
Exercise 3.4: Monthly Revenue Trend
Track revenue trends month by month.
- Rows: Date (Group by Months)
- Values: Sum of Total Revenue
Exercise 3.5: Units Sold by Region and Category
Compare category sales across regions.
- Rows: Region - Columns: Category
- Values: Sum of Units Sold
Exercise 3.6: Average Price per Category
Understand pricing trends.
- Rows: Category
- Values: Average of Unit Price
Exercise 3.7: Top Selling Products
Identify which products are the most popular.
- Rows: Product
- Values: Sum of Units Sold
- Sort: Descending by Units Sold
Exercise 3.8: Product Sales by Salesperson
Who sells what best?
- Rows: Salesperson
- Columns: Product
- Values: Sum of Units Sold
Exercise 3.9: Category Performance Over Time
See how each product category performed over time.
- Rows: Date (Group by Months)
- Columns: Category
- Values: Sum of Total Revenue
Exercise 3.10: Revenue per Unit by Product
See which products are highest in per-unit value.
- Rows: Product
- Values: Average of Unit Price, Sum of Units Sold, Sum of Total Revenue