Pizza Sales Tableau Dashboard

This project involved analyzing a pizza restaurant with one year of data divided into four different tables. To explore the data, I first used SQL to join the tables and gain insight into the numbers. Tableau was then used to visualize the data and see trends. (See additional images to view SQL code)

The company was seeking insight into the following questions:

How many customers do we have each day? Are there any peak hours?
How many pizzas are typically in an order? Do we have any bestsellers?
How much money did we make this year? Can we identify any seasonality in the sales?
Are there any pizzas we should take of the menu, or any promotions we could leverage?

My goal with the dashboard was to make it accessible and easy to read for the stakeholder. I wanted the answers to their questions to be easily identified in the static image of the dashboard.