This project focuses on analyzing pizza sales data to uncover business insights like most popular pizza sizes, revenue by category, peak order times, and more. The goal is to support business decisions using data analytics techniques.
β’ Source: Order_details, Orders, pizza_types, pizzas
β’ Contains information about order details, orders, pizza types, pizzas.
β’ Calculate total revenue
β’ Identify most popular pizza categories and sizes
β’ Find peak sales days and hours
β’ Rank pizzas by revenue per category
β’ Large-sized pizzas are in highest demand.
β’ Weekends drive more sales.
β’ Vegetarian pizzas perform well in all categories.
β’ Business can benefit by promoting high-margin items in peak hours.