Awesome Chocolates

The dataset contains a diverse set of Chocolates sales transactions in diffrent geographical regions,various salespeople from different locations and products details,and it targets the revenue produced and the quantity of products sold in each case.

Objective

• To understand sales performance, product popularity, and regional trends.
• To answer some business related questions that may arise

Tools used:

MySQL Workbench

Approach Used:

Exploratory Data Analysis (EDA): - Data cleaning,Data analysing,Data visualising in tabular form Exploratory data analysis is done to answer the following business questions that may arise:

1. Sales details where amount>10000
2. Sales details where Products to be sold in gegraphical location G1
3. Sales details with amount>10000 and SaleDate on or after 2022-01-01;
4. Sales details with amount>10000 and year as 2022
5. Sales details for boxes upto 50
6. Sales details where amount 2,000 and count of boxes<100
7. Sales details in January 2022
8. Sales details when the product shipment on fridays
9. People details which team is of Delish or jucies
10. People details whose name start with letter B
11. People details who has y anywhere in their name
12. Creating a category column for amount if amount<1000 as "Under 1k",if amount<5000 as "Under 5k",if amount<10000 as "Under 10k",others as ">=10k"
13. Print details of shipments (sales) where amounts are > 2,000 and boxes are <100?
14. How many shipments (sales) each of the sales persons had in the month of January 2022?
15. Which product sells more boxes? Milk Bars or Eclairs?
16. Which product sold more boxes in the first 7 days of February 2022? Milk Bars or Eclairs?
17. Which shipments had under 100 customers & under 100 boxes? Did any of them occur on Wednesday?
18. What are the names of salespersons who had at least one shipment (sale) in the first 7 days of January 2022?
19. Which salespersons did not make any shipments in the first 7 days of January 2022?
20. How many times we shipped more than 1,000 boxes in each month?
21. Did we ship at least one box of ‘After Nines’ to ‘New Zealand’ on all the months?
22. India or Australia? Who buys more chocolate boxes on a monthly basis?

Findings

• More number of products sold in Canada (1293)and least in USA(1242)
• The most customers needed the product named "After Nines"(60324)
• More sales on January and less in November
• There is a total of 12,32,947 customers in which $53,218,646 revenue earned
• Most revenue made from Almond choco
• Boxes count ranging from 335 to 355
• Gunar Cockshoot is the person who sold more number of products
• Most revenue made when the products are sold by Wilone O'Kielt