Restaurant Order Analysis - What are people ordering?

The Context

Taste of Word Cafe unveiled its refreshed menu at the beginning of the year. As a Data Analyst, I was tasked with delving into the customer data to discern the performance of various menu items. The objective was to identify the top-performing dishes and those that might need attention, while also gaining insights into the preferences of our most valued customers.

The Data

Our analysis centres around two key tables—the Menu Item table, comprising a comprehensive list of menu items along with their corresponding prices

And the Order Detail table, housing various bits of order information, including the order dates.

Customer Behaviour - Joining the Tables

To delve deeper into customer behaviour, a pivotal step involves performing a join operation on the two tables. This enables us to seamlessly integrate information from the Menu Item table and the Order Detail table, providing a consolidated view that is instrumental in unravelling patterns and insights related to customer preferences and ordering trends.

Customer behaviour - Findings

• The menu item "Chicken Tacos" within the Mexican category registered the lowest number of orders, while "Hamburgers" emerged as the frontrunner, boasting the highest order frequency.
• Order_Id 440 emerged as the most prolific, commanding the highest number of orders, closely trailed by Order ids (2075, 1957, 330, 2675).
• Among these top 5 order ids, the Italian category stood out as the most favoured, with a cumulative expenditure of 430.65, showcasing a distinct preference among these 5 customers.

I have provided screenshots of the SQL code used to gather these findings