Scribd
Upload
3 views1 page

Questions

The document outlines a series of data analysis tasks aimed at extracting insights from transaction data. Key analyses include calculating total transactions and sales by state, region, and product category, as well as identifying top products and customers. The insights will support business performance evaluation and customer segmentation strategies.

Uploaded by

chinachinaa9650
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
3 views1 page

Questions

The document outlines a series of data analysis tasks aimed at extracting insights from transaction data. Key analyses include calculating total transactions and sales by state, region, and product category, as well as identifying top products and customers. The insights will support business performance evaluation and customer segmentation strategies.

Uploaded by

chinachinaa9650
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

Get following insights from given data

1. Calculate Total Transaction by each State


2. Calculate Total Transaction by each State as well as Product Category
3. Calculate total quantity Sold by Region
4. Calculate total quantity Sold by Region as well as Product name
5. Calculate the average sales amount of each state
6. Calculate the average sales amount of each state as well as Product name
7. Calculate Each city max sales.
8. Find the total sales amount generated by each product category across all regions.
→ Helps identify which category contributes most to total revenue.
9. Calculate the total quantity sold by each customer.
→ Useful for customer segmentation and loyalty tracking.
10. Identify the top 5 products by total sales amount in each region.
→ Determines regional product preferences.
11. Calculate total and average sales amount per month.
→ Enables time-series trend analysis.
12. Find which state has the highest total quantity sold and highest total revenue.
→ Helps detect top-performing states.
13. Calculate total revenue and average quantity sold per product category within each region.
→ Combines product and regional insights.
14. Determine the product that has the maximum average price per unit in each category.
→ Identifies premium products.
15. Find total sales amount and total quantity sold by each city.
→ Useful for local-level business performance analysis.
16. Calculate how many transactions occurred per region and per product category.
→ Helps measure activity volume in each segment.
17. Identify the customer who generated the highest total revenue overall.
→ Useful for customer relationship management (CRM) insights.

You might also like