Skip to content

MySQL-based data analytics project using complex queries to analyze and forecast pizza sales trends, helping optimize inventory and marketing strategies.

Notifications You must be signed in to change notification settings

KumarGosala24/pizza-sales-forecasting

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

5 Commits
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

Pizza Sales Analytics

Alt Text

πŸ“ Overview

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.

πŸ“Š Dataset

β€’ Source: Order_details, Orders, pizza_types, pizzas

β€’ Contains information about order details, orders, pizza types, pizzas.

🎯 Key Objectives

β€’ Calculate total revenue

β€’ Identify most popular pizza categories and sizes

β€’ Find peak sales days and hours

β€’ Rank pizzas by revenue per category

πŸ“Œ Conclusions

β€’ 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.

About

MySQL-based data analytics project using complex queries to analyze and forecast pizza sales trends, helping optimize inventory and marketing strategies.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published