Scribd
Upload
5 views2 pages

Sales Order Analysis Case Study

The document outlines a case study involving a sales order dataset with various problem statements aimed at analyzing sales data. Key tasks include identifying total products sold, delivery statuses, completed orders, sales per customer, and employee performance. The study emphasizes data queries to extract insights related to sales and customer behavior.

Uploaded by

careerinfo.studyabroad
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
5 views2 pages

Sales Order Analysis Case Study

The document outlines a case study involving a sales order dataset with various problem statements aimed at analyzing sales data. Key tasks include identifying total products sold, delivery statuses, completed orders, sales per customer, and employee performance. The study emphasizes data queries to extract insights related to sales and customer behavior.

Uploaded by

careerinfo.studyabroad
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

Sales Order Dataset - Case

Study
Problem Statements:
1. Identify the total no of products sold

2. Other than Completed, display the available delivery status's

3. Display the order id, order_date and product_name for all the completed
orders.

4. Sort the above query to show the earliest orders at the top. Also display the
customer who purchased these orders.

5. Display the total no of orders corresponding to each delivery status

6. For orders purchasing more than 1 item, how many are still not completed?

7. Find the total no of orders corresponding to each delivery status by ignoring


the case in delivery status. Status with highest no of orders should be at the
top.

8. Write a query to identify the total products purchased by each customer

9. Display the total sales and average sales done for each day.

10. Display the customer name, employee name and total sale amount of all
orders which are either on hold or pending.

11. Fetch all the orders which were neither completed/pending or were handled by
the employee Abrar. Display employee name and all details or order.

12. Fetch the orders which cost more than 2000 but did not include the macbook
pro. Print the total sale amount as well.

13. Identify the customers who have not purchased any product yet.

14. Write a query to identify the total products purchased by each customer.
Return all customers irrespective of wether they have made a purchase or not.
Sort the result with highest no of orders at the top.

Sales Order Dataset - Case Study 1


15. Corresponding to each employee, display the total sales they made of all the
completed orders. Display total sales as 0 if an employee made no sales yet.

16. Re-write the above query so as to display the total sales made by each
employee corresponding to each customer. If an employee has not served a
customer yet then display "-" under the customer.

17. Re-write above query so as to display only those records where the total sales
is above 1000

18. Identify employees who have served more than 2 customer.

19. Identify the customers who have purchased more than 5 products

20. Identify customers whose average purchase cost exceeds the average sale of
all the orders.

Sales Order Dataset - Case Study 2

You might also like