Using transaction data from a restaurant in New York City, I used SQL to discover insights into their data and provide surface-level information about their products.

Exploring raw data with SQL was the best option, and usually the fastest option with tight deadlines, to return quick insights into their menu items to identify the top performers and items toward the bottom of the list. Rather than providing data visualizations and dashboards, this project was only interested in answering simple questions about food items and their customers to begin conversations of menu changes and delivery offerings.

A few example questions were:

• What was the least and most ordered items? What categories were they in?

• Which customer spent the most money?

• Which customers order more than 10 things at a time?

If you’re interested in running these queries, you can download the dataset and db file here, note, you must have MySQL installed or be familiar in SQL to run this data.