[go: up one dir, main page]
Scribd
Upload
16 views5 pages

Exercise 3

ghgfghfh

Uploaded by

nithishkgm
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
16 views5 pages

Exercise 3

ghgfghfh

Uploaded by

nithishkgm
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 5

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

You might also like