Pizza-saless

Problem Statement:

There are four csv files (order details, orders, pizza type, pizzas). Our goal is to merge those four files and get insights from this dataset.

Insights derived from the data:

• Classic is most selling category where as chicken is less selling category.
• Customer are prefer L size of pizza most.
• The Classic Deluxe Pizza is the top selling pizza where as The Brie Carre Pizza is least selling.
• The average selling price of pizza is 37$ with quantity of 2 pizzas.
• Customers prefer to eat pizza on Fridays, but not on Sundays.
• The peak order time of pizza is 12:00 to 13:00