PIZZA SALES ANALYSIS REPORT
Introduction
Who don’t love pizza?
It is known that the Italian owns pizza before other start adapting to it due to its taste, sweetness and many more interesting parts of it from the mouth to the stomach.
Let now dive into the sales of how pizza has doing with the data provided by Maven analytics.
I got my data from the past challenge done on maven analytics, with the link below Maven Pizza Challenge | Maven Analytics. the challenge was done in September 2022 to October 2022.
About the Analysis
The analysis was carried out using powerBi with some insight given. Here is the insight below
Data Analysis Process
To make sense of any available data, a set of procedures must be completed. Identifying these procedures is essential as each stage is crucial in ensuring that the data is appropriately processed in a bid to offer useful and actionable information. Here are the steps I took in this process:
- Data Gathering
- Data Assessment and Cleaning
- Data Model
- Insight Given
- Data Visualization
- Recommendation
Data Gathering
As we know that no challenge given by maven analytics that there will be not a data given.
Our data was provided by maven analytics, where four different data was provided from the data, price data, quantity data and product data.
Data Assessment and Cleaning
It is no new fact that most of the time spent on an analytical process is spent on Data Cleaning. Good for us, our data is okay with just a few cleanings needed. Here are my overview of my data using power query.
Here is our overview of our data where I carefully check for data type, duplicate values, missing values and many more.
A Date table was also created to make my trends more appropriate and simpler using my Dax (Data Analysis Expression) code
The result
Data Model
To make relationship, reduce bias and variance, enhance decision making and facilitate integration, we need Data model to make our four data insight driven.
Insight Given and worked on
- KPIs
- How are our sales doing by Quarter?
- what time do we have our most sales
- How are our sales doing monthly/weekly?
- How are our sales doing monthly
- what size is been ordered most?
KPIs
Get Abiolajoshua’s stories in your inbox
Join Medium for free to get updates from this writer.
As we know that every company has a target from the beginning of the Year, month, weeks and days.
The is where key performance indicator (KPIs) come into play, we have our total sales to be 818,000 from 49,574 quantity of pizza sold.
Is our sales doing well? let dive further to know?
How are our Sales doing by Quarter?
As we all know that there are quarter of the year ranging from January to December, we want to track our sales from the beginning of the year to know how well they are doing.
It is seen that Quarter 2 was the only quarter we had an increase by 1.5% and for the remaining quarter it dropped, even during festival quarter.
what time do we have our most sales
Anything sales, it is okay we understand our customers, so as to know when to produce in large quantity and know when customers are buying at that time to improve other days and time
It seen in our data that people don’t love eating pizza in the morning around 09:00AM — 10:59AM, likewise when sunny around 01:00PM — 02:59PM and also in the night starting from 07:00pmPM — 08:59PM and 09:00PM — 10:59PM.
How are our sales doing monthly/weekly?
It is also good to track our monthly sales per week also to see how they are doing
It is seen that January, March, May, July, August, October and December are the month doing fine in our, where February is the worst so far.
For the week, Only Thursday tends to do well in our sales, where Sunday has the worst sales so far.
How are our sales doing monthly
We can see that the rate of sales being drop is very bad even at August and September, it was back-to-back, where December dropped so badly with -8.1%
what size is been ordered most?
Due to the size available, it will be good to see which size of pizza is being ordered most often.
It is seen people tends to eat large, medium and small size where the Xtra are lagging behind
Data Visualization
For visualization, I exported my final csv file to Power BI and I created a dashboard to better display my findings and communicate the analysis.
Recommendations
- Quarter 3 and Quarter 4 should be looked into and know why there is a drop in sales.
- Marketing strategy should be put in place for morning and night sales and check after a while if there is increase
- During the weekdays, other days should be looked into except Thursday which we make more sales. most especially we should check location of our sales
- For our monthly trends, especially December, Discounts and gifts should be encouraged to drive people to order, as we all know we love free and sweet things
- Size of pizza of the large, medium and small should produce more, likewise know who buy them also maybe single or married, to know how to target our sales and location depending on the baby.
- Survey should be run across our customers to know our customers mind and also get a well-nourished data of family, married status, country, location, while they like pizza, what time do they love to eat it and what they love to eat with it.
With this Recommendation, a great change can happen in that great company in our sales.
