__STYLES__
Tools used in this project
Pizza Place Sales

About this project

Goal

  • 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 Need

  • The business wanted to improve their efficiency in subsequent years.

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 pizza be discontinued.

Technology used

  • First, I performed and ELT (extract, load, transform) operation to acquire the table into a PostgreSQL schema.
  • To do this I wrote CREATE TABLE, COPY, and INSERT INTO...FROM...
  • Then, I wrote SQL queries to answer the questions that generated the insights using SELECT.
  • Finally, I made the visual report by querying the data with the SQL queries imported into Power BI to make the plots.

Additional project images

KPIs, daily revenue, and monthly revenue.
Average revenue by day during selected month.
Popularity of pizzas by revenue.
SQL query for revenue by pizza type.
SQL query for average revenue by month and day of week.
SQL query for daily revenue trend.
Discussion and feedback(0 comments)
2000 characters remaining
Cookie SettingsWe use cookies to enhance your experience, analyze site traffic and deliver personalized content. Read our Privacy Policy.