Scribd
Upload
4 views5 pages

SP

The document provides an analysis of sales and profit across various regions, segments, and product categories. Key findings include the East region having the highest sales, the Consumer Segment being the most profitable, and the Chair sub-category contributing the most to sales. Additionally, it highlights that the South region sold the highest number of items, while the Accessories sub-category has the highest profit margin.

Uploaded by

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

SP

The document provides an analysis of sales and profit across various regions, segments, and product categories. Key findings include the East region having the highest sales, the Consumer Segment being the most profitable, and the Chair sub-category contributing the most to sales. Additionally, it highlights that the South region sold the highest number of items, while the Accessories sub-category has the highest profit margin.

Uploaded by

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

1.

Region-wise Sales and Profit:

Create a pivot table to summarize total sales and profit by region.

 Which region had the highest sales?


 Which had the lowest profit?

 East region had the highest sales.


 West region had the lowest profit.

2. Segment-wise Profit:

Create a summary of profit for each Customer Segment

 Which Segment is the most profitable?

 Consumer Segment is the most profitable.


3. Product Category Analysis:

Create a Pivot Table showing Sales by Category and Sub-Category.

- Which sub category contributes the most to sales?

- Chair sub category contributes the most to sales.

4. Monthly Sales Trend:

Group the Date field by Month and find total sales

- Which month had the highest total sales?

- January Month had the highest total sales.


[Link] Performing Products

Use Pivot Table to list Product Name and their total Profit.

- Which 3 Products are most profitable?

6. Quantity Sold by Region:

Summarize Quantity Sold by Region.

- Which region sold the highest number of items?

- South region sold the highest number of items


7. Loss-Making Items:

Filter the Pivot table to show only items with negative profit.

- Which Products incurred a loss?

- Study Table products incurred a loss.

8. Segment Vs Category:

Show total Sales for each Customer Segment by Product Category.

- Who buys more technology items?

- Consumer buys more technology items.


9. Profit Margin by Sub-Category:

Add a calculated field for profit Margin = Profit/Sales

- Which sub-Category has the highest profit margin?

- Accessories has the highest profit margin.

10. Filter by Customer Segment:

Filter the Pivot Table to show only the consumer segment.

- Which Category do consumers spend the most on?

- On Technology Category do consumers spend the most on .

You might also like