A hands-on SQL exploration project analysing restaurant orders to uncover menu performance, customer behaviour, and order patterns using MySQL.
The restaurant had raw order data, but no structured way to understand menu performance, spending patterns, or order volume across time.
I explored the menu and orders tables with SQL, joined the data, and extracted insights that could support reporting and operational decisions.
I used SQL to understand the structure and pricing of the menu, comparing item counts, categories, and Italian dishes.
I reviewed order volume and ordering patterns to understand how customers interacted with the menu over time.
After the basic exploration, I joined the tables to identify item popularity, category trends, and high-spend orders.
The final output is not only SQL practice. It is a business-focused analysis that supports reporting and decision-making.