Pizza Sales Dashboard
This is a detailed report about a guided project I saw and followed online. In this project, I did the following: Data cleaning and prepping in Power BI, Data analysis and Data Visualization in Power BI
QUICK LINKS :Tutorial, Dataset, Dashboard
TABLE OF CONTENT
1. Introduction
2. Process: Data cleaning, Data prepping & Data visualization
3. Overview of the dashboard
4. Finished Project
5. Insights
6. What I learned
7. Conclusion
Introduction:
This is a guided project that was posted by Data Tutorials on YouTube. The project focuses on a pizza sales dataset where I am tasked to analyze in order to derive insights for the company.
Goal: Learn something new and advance in my knowledge of Power BI
Process:
Data cleaning:
After successfully importing the dataset into Power BI, I decided to glance through the data just to better understand it and then I check for outliers, null values, blanks rows and many more. I also ensured the data type of each column corresponds with the data inputted in it.
Data prepping:
After cleaning the dataset, I focus solemnly on the insights I could derive from the dataset and I did so by asking business related questions like:
· What is the Total Revenue
· What is the Total Average Value
· The Total Pizza Sold
· The Total Orders
· Average Pizza by Order
· Daily Trends for Total Order
· Monthly Trends for Total Order
· Percentage of sales by category
· Percentage of sales by Pizza Size
· Total pizza sold by category
· Top 5 pizza by Revenue
· Bottom 5 pizza by Revenue
· Top 5 pizza by quantity
· Bottom 5 pizza by quantity
· Top 5 pizza by total orders
· Bottom 5 Pizza by total orders
Then I used SQL to retrieve the answer to the questions.
After successfully prepping the data, I decided to visualize the data.
Data visualization:
After successfully prepping the data, I decided to visualize my insights based on the questions I had ask but before I did that, I did a sketch of What I wanted each insights to represent and which charts I should use to represent them. I also did a quick sketch on what the dashboard would look like.
After visualizing the data I did the following things:
· Represented certain information using KPIs
· Visualized the data using charts in Power BI
· Designed the dashboard using Tiled containers and chart.
Overview of the dashboard:
The dashboard includes the following:
· A title
· KPIs
· Filters
· Charts and
· Insight
Finished Project:
Insights:
Below are general insights from this dashboard:
· Orders are its maximum during weekdays Friday/Saturday.
· There are maximum orders January and July.
· Classic pizza has the highest sales and orders.
· The Highest sales by sales is the large size pizza.
· The Thai Chicken pizza has the highest sales by revenue
· The Classic Deluxe pizza has the highest total orders.
· The Classic Deluxe pizza has the highest sales by quantity
· The Brie Carre pizza has the least sales by revenue.
· The Brie Carre pizza has the least total orders.
· Brie Carre pizza has the least sales by quantity.
What I learned:
· Calculating and organizing your KPI’s using SQL and comparing with Power BI
· How to Insert Images
· How to use Text Box
· How to use shapes
Conclusion:
I must say that the guided project was really informative and I really learnt a lot. I think I will be using Text box from now on and I want to thank Data Tutorials for this amazing project, it was definitely easy to follow and exciting.
