PowerBI, SQL: Pizza Place
Goals
- The goal of the project was to look at trends in traffic and revenue in the store and find menu items for potential removal to increase efficiency.
Business Needs
- The business wanted to improve their efficiency by looking at data from 2015 and applying the lessons learned in subsequent years.
Dashboards and Charts
Monthly and daily revenue
Average daily revenue by month
Revenue by pizza type
Insights
- The report spans the entire year of 2015.
- Revenue per order was $10 at a minimum, $38 on average, and $444 at the maximum.
- Please consult the plot of revenue from sales of different pizza types to see which pizzas performed above and below the median in terms of revenue.
- A total of $818K was earned in 2015.
- September and October were unusually slow months, with July being the busiest.
- Thursday to Saturday are the busiest days.
- I recommend a promotion to encourage traffic in the store from Sunday to Wednesday, typically the slowest days and, if some low revenue pizzas have high costs to produce, that those pizzas be discontinued.