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.