Click here to view as PDF

Synopsis

My firm has been hired to analyze one year’s worth of sales data for a fictional pizza restaurant.

Dataset

Pizza Place Sales from Maven Analytics (12 fields, 48,620 records)

https://maven-datasets.s3.amazonaws.com/Pizza+Place+Sales/Pizza+Place+Sales.zip

Analyses

• Customer Buying Behavior
• Menu Analysis and Evaluation

Tools

• SQL server 2008
• SQL Server Mangement Studio (SSMS)
• ChatGPT*

Skills

• T-SQL
• Complex Queries (Multiple Joins, Subqueries, Aggregation, CTEs, CASE, PIVOT, GROUPING SETS, CROSS APPLY)

Presentation

This report is not meant to be a presentation layer, but rather a display of the analysis conducted and notes regarding observations and recommendations.

*ChatGPT helped me utilize restaurant industry lingo in my recommendations and showed me how to use CROSS APPLY to transpose a result set.