Order ID Order Date Customer Name Region Salesperson Name Product

O001 23-Apr-2025 Megha S South Neha Sharma Printer

O002 28-Apr-2025 Naveen South RIYA GUPTA Office Chair
O003 07-Mar-2025 Sahil North srikanth verma Mobile
O004 14-Feb-2025 Maya West Neha Sharma Mobile
O005 20-Feb-2025 Ramesh K North Srikanth Verma Laptop
O006 03-Mar-2025 Arjun Reddy East Anita Joseph Laptop
O007 11-Apr-2025 Priya West RAHUL NAIR Printer
O008 19-Mar-2025 Deepa Menon South Neha Sharma Mobile
O009 25-Feb-2025 Manju S East Laptop
O010 07-Feb-2025 Anita Joseph South Anita Joseph Office Chair
O011 03-Apr-2025 Kamal North Neha Sharma Desk
O012 17-Feb-2025 Sunil West Rahul Nair Printer
O013 02-Mar-2025 Aditya East Neha Sharma Mobile
O014 13-Apr-2025 Priya West Neha Sharma Mobile
O015 08-Mar-2025 Suresh South RAHUL NAIR Laptop
O016 21-Feb-2025 Ritu North RIYA GUPTA Office Chair
O017 29-Mar-2025 Kishore East srikanth verma Desk
O018 02-Apr-2025 Arun Kumar West Neha Sharma Laptop
O019 05-Mar-2025 Tanvi South ANITA JOSEPH Printer
O020 12-Apr-2025 Gita North Rahul Nair Mobile
O021 24-Feb-2025 Neetu South Neha Sharma Desk
O022 09-Mar-2025 Rohit West RIYA GUPTA Office Chair
O023 15-Apr-2025 Kiran East Neha Sharma Printer
O024 18-Feb-2025 Dinesh South Anita Joseph Mobile
O025 20-Apr-2025 Sakshi North RAHUL NAIR Desk
O026 01-Mar-2025 Vagdevi West Neha Sharma Laptop
O027 11-Feb-2025 Mahesh East srikanth verma Desk
O028 04-Apr-2025 Shalini S South ANITA JOSEPH Printer
O029 14-Mar-2025 Neha North RAHUL NAIR Mobile
O030 27-Feb-2025 Bhavana West Neha Sharma Office Chair
O031 30-Mar-2025 Ramesh South RAHUL NAIR Laptop
O032 06-Feb-2025 Arun K East RIYA GUPTA Printer
O033 22-Mar-2025 Sameer West Neha Sharma Mobile
O034 10-Apr-2025 Asha South Anita Joseph Desk
O035 16-Mar-2025 Veena Varma North Neha Sharma Printer
O036 05-Apr-2025 Sunita East RAHUL NAIR Mobile
O037 26-Feb-2025 Prakash South Neha Sharma Laptop
O038 08-Mar-2025 Kavita West Anita Joseph Office Chair
O039 17-Feb-2025 Ram North RIYA GUPTA Desk
O040 01-Apr-2025 Anil South Neha Sharma Mobile
O041 11-Feb-2025 Maya West RAHUL NAIR Printer
O042 03-Mar-2025 Jaya East neha sharma Mobile
O043 29-Mar-2025 Anita North Srikanth Verma Laptop
O044 06-Apr-2025 Praveen South ANITA JOSEPH Office Chair
O045 23-Feb-2025 Nikita West RAHUL NAIR Mobile
O100 27-Feb-2025 Ankit West RAHUL NAIR Printer
O046 31-Mar-2025 Kavya East Neha Sharma Printer
O047 14-Feb-2025 Sahil North RAHUL NAIR Laptop
O048 28-Feb-2025 Meena South RIYA GUPTA Desk
O049 21-Mar-2025 Sandhya West Neha Sharma Mobile
O050 05-Mar-2025 Suman East Anita Joseph Laptop
O051 12-Apr-2025 Naveen South neha sharma Mobile
O052 25-Apr-2025 Prashant West RAHUL NAIR Printer
O053 08-Feb-2025 Deepa Menon East Anita Joseph Mobile
O054 19-Mar-2025 Kumar South Neha Sharma Desk
O055 02-Mar-2025 Lakshmi West RIYA GUPTA Office Chair
O056 09-Apr-2025 Neha Sharma North RAHUL NAIR Mobile
O057 17-Feb-2025 Suresh South Neha Sharma Printer
O058 20-Feb-2025 Sunil West Anita Joseph Laptop
O059 24-Mar-2025 Vikram East RAHUL NAIR Desk
O060 13-Feb-2025 Kamal South Neha Sharma Mobile
O061 02-Apr-2025 Rohit North Anita Joseph Printer
O062 15-Apr-2025 Priyanka West RAHUL NAIR Laptop
O063 27-Feb-2025 Gaurav East Neha Sharma Mobile
O064 10-Mar-2025 Rekha South RAHUL NAIR Office Chair
O065 18-Apr-2025 Sahil North neha sharma Printer
O066 04-Apr-2025 Megha West Anita Joseph Mobile
O067 22-Feb-2025 Kishore East RIYA GUPTA Desk
O068 03-Mar-2025 Arjun Reddy South RAHUL NAIR Laptop
O069 07-Apr-2025 Suman West Neha Sharma Printer
O070 16-Feb-2025 Jagdish South ANITA JOSEPH Mobile
O071 30-Mar-2025 Asha North Neha Sharma Desk
O072 11-Apr-2025 Bhavesh East RAHUL NAIR Mobile
O073 05-Mar-2025 Manju S West neha sharma Laptop
O074 26-Feb-2025 Ritu South Srikanth Verma Office Chair
O075 08-Apr-2025 Kunal North RAHUL NAIR Printer
O076 14-Mar-2025 Bhavana East NEHA SHARMA Mobile
O077 19-Feb-2025 Shweta West Anita Joseph Desk
O078 01-Apr-2025 Sahil South RAHUL NAIR Printer
O079 24-Mar-2025 Aditi North Neha Sharma Laptop
O080 29-Apr-2025 Sunaina East RIYA GUPTA Office Chair
O082 21-Apr-2025 Arjun Reddy South neha sharma Laptop
O083 06-Mar-2025 Pooja West RAHUL NAIR Desk
O084 17-Mar-2025 Shiv North Neha Sharma Printer
O085 12-Feb-2025 Ananya East RAHUL NAIR Mobile
O086 28-Feb-2025 Ramesh South Anita Joseph Office Chair
O087 04-Apr-2025 Pranav West neha sharma Laptop
O088 09-Mar-2025 Deepak East RAHUL NAIR Printer
O089 31-Mar-2025 Suman North ANITA JOSEPH Mobile
O090 23-Feb-2025 Ragini South Neha Sharma Desk
O091 02-Apr-2025 Nikita West RAHUL NAIR Printer
O115 05-Apr-2025 Asha East neha sharma Mobile
O080 29-Apr-2025 Sunaina East RIYA GUPTA Office Chair
O092 11-Mar-2025 Santhosh East neha sharma Mobile
O093 07-Feb-2025 Sahil North RAHUL NAIR Laptop
O094 20-Apr-2025 Meena West Neha Sharma Office Chair
O095 25-Mar-2025 Ashok South ANITA JOSEPH Printer
O096 16-Apr-2025 Arun Kumar West Neha Sharma Laptop
O097 05-Feb-2025 Bhavya East RAHUL NAIR Mobile
O098 15-Mar-2025 Vinod South Neha Sharma Desk
O099 18-Apr-2025 Pratik North Anita Joseph Office Chair
O100 27-Feb-2025 Ankit West RAHUL NAIR Printer
O101 08-Apr-2025 Sahil South Neha Sharma Mobile
O102 22-Feb-2025 Shalini S East ANITA JOSEPH Desk
O112 1/4/2025 Priya West Neha Sharma Printer
O103 01-Mar-2025 Deepa Menon West ANITA JOSEPH Mobile
O104 04-Mar-2025 Megha S North RAHUL NAIR Printer
O105 10-Mar-2025 Naveen South neha sharma Office Chair
O106 14-Feb-2025 Sahil West RAHUL NAIR Laptop
O107 30-Mar-2025 Kumar East neha sharma Mobile
O108 26-Feb-2025 Ramesh K North Srikanth Verma Laptop
O109 09-Apr-2025 Tejaswini South Anita Joseph Printer
O110 03-Feb-2025 Bhavana West RAHUL NAIR Desk
O111 19-Mar-2025 Neha East NEHA SHARMA Mobile
O113 12-Feb-2025 Arjun Reddy South RAHUL NAIR Desk
O114 24-Mar-2025 Pradeep North Anita Joseph Laptop
O116 15-Feb-2025 Maya South RAHUL NAIR Printer
O117 21-Apr-2025 Neha Sharma West ANITA JOSEPH Desk
O118 02-Mar-2025 Dinesh North Neha Sharma Office Chair
O119 07-Apr-2025 Suresh East RAHUL NAIR Mobile
O120 16-Feb-2025 Ramesh South Neha Sharma Printer
O121 11-Mar-2025 Aditi West RAHUL NAIR Laptop
O122 22-Feb-2025 NoteDate South Neha Sharma Mobile
O123 02-Apr-2025 Pranav North Anita Joseph Desk
O124 08-Mar-2025 Gita West RAHUL NAIR Printer
O125 17-Feb-2025 Sahil East Neha Sharma Mobile
 Payment
Quantity Unit Price Discount % Net Revenue Revenue Month
Status
2 12000 5 Paid
2 7500 6 Paid
6 18000 8 Pending
6 18000 8 Pending
1 55000 8% Pending
2 55000 6 Paid
3 12000 5 Paid
4 18000 7 Paid
3 55000 5 Unpaid
2 7500 8 Paid
1 9500 3 Paid
1 12000 4 Paid
6 18000 8 Paid
5 18000 0 Paid
1 55000 7 Paid
3 7500 5 Paid
2 9500 6 Paid
7 55000 1 Unpaid
2 12000 5 Paid
4 18000 8 Paid
3 9500 6 Paid
4 7500 4 Pending
2 12000 5 Paid
3 18000 6 Paid
5 9500 2 Unpaid
1 55000 5 Paid
2 9500 6 Paid
3 12000 5 Paid
7 18000 4 Paid
2 7500 6 Paid
2 55000 6 Paid
1 12000 3 Paid
3 18000 5 Paid
4 9500 7 Pending
2 12000 6 Paid
3 18000 5 Paid
2 55000 7 Paid
1 7500 4 Paid
2 9500 3 Pending
4 18000 8 Paid
3 12000 5 Paid
5 18000 6 Unpaid
2 55000 5 Paid
2 7500 6 Paid
4 18000 8 Paid
2 12000 6 Paid
2 12000 5 Paid
5 55000 7 Paid
3 9500 4 Paid
6 18000 5 Paid
1 55000 6 Paid
5 18000 3 Paid
1 12000 5 Paid
6 18000 8 Paid
2 9500 6 Paid
6 7500 5 Pending
4 18000 6 Paid
2 12000 4 Paid
3 55000 6 Paid
1 9500 3 Paid
2 18000 5 Paid
3 12000 5 Paid
1 55000 6 Paid
2 18000 4 Paid
3 7500 5 Pending
4 12000 7 Paid
6 18000 8 Pending
2 9500 6 Paid
1 55000 6 Paid
2 12000 3 Paid
3 18000 5 Paid
4 9500 7 Paid
5 18000 6 Paid
2 55000 5 Unpaid
1 7500 3 Paid
1 12000 4 Paid
2 18000 6 Paid
3 9500 6 Paid
4 12000 5 Paid
1 55000 6 Paid
2 7500 5 Paid
2 55000 6 Paid
1 9500 3 Paid
2 12000 5 Paid
3 18000 4 Paid
2 7500 4 Paid
3 55000 5 Paid
2 12000 6 Paid
4 18000 8 Paid
2 9500 5 Paid
3 12000 5 Paid
4 ₹ 18000 6 Pending
2 7500 5 Paid
2 18000 3 Paid
4 55000 7 Paid
3 7500 6 Pending
2 12000 5 Paid
7 55000 1 Paid
2 18000 5 Paid
1 9500 3 Paid
4 7500 4 Paid
2 12000 6 Paid
3 18000 5 Paid
4 9500 6 Paid
3 12000 5 Paid
6 18000 8 Paid
2 12000 5 Paid
2 7500 4 Paid
5 55000 7 Paid
3 18000 5 Paid
1 55000 8% Pending
2 12000 5 Paid
2 9500 4 Paid
4 18000 6 Paid
2 9500 6 Paid
2 55000 5 Paid
3 12000 4 Paid
2 9500 5 Paid
1 7500 6 Paid
5 18000 7 Pending
3 12000 6 Paid
1 55000 5 Paid
2 18000 4 Paid
3 9500 6 Paid
2 12000 5 Paid
6 18000 8 Paid
List 3 issues (anomalies) you found in Questions
the dataset and explain how it affects the
analysis
- Net Revenue = Quantity × Unit Price × (1 − Discount%)
-Create
Revenue = Quantity
a pivot × Unit Price
table showing Net Revenue for each Region. Mention the Region with
highest Net Revenue
Calculate the Total Revenue (Answer using formula)
What
3. percentage
Mention which of total orders
month are Unpaid
and which productorrecorded
Pending?the
(Answer using
highest formula)
total quantity
sold based on the summary.
Determine whether higher discounts lead to higher revenue? Explain your conclusion
using supporting numbers or statistics from the data.
Answers