Skip to content

Latest commit

 

History

History
95 lines (72 loc) · 2.67 KB

README.md

File metadata and controls

95 lines (72 loc) · 2.67 KB
Raw

Hello There!

This is an End-to_End PowerBI Report, where I dived deep into data modelling, created relationships and crafted a comprehensive report using a fascinating dataset.

My First Power BI Project: Pizza Sales Dashboard 🍕

I'm thrilled to share my very first Power BI project, where I dived into data modeling, created relationships, and crafted a comprehensive report using a fascinating dataset.

🍕PROJECT OUTLINE:

Importing Raw data:-

  1. Data Pre-Processing in MySQL
  2. Data-Analysis in MySQL
  3. Connecting and shaping the Data in Power BI
  4. Creating Data Model
  5. Calculating Measures with DAX
  6. Visualising data with Dashboard
  7. Drawing Conclusions

🍕KPI Requirements :-

We need to analyze key performance indicators for pizza sales data to gain insights into our business performance. Specifically, we want to calculate the following metrics :- 🔶Total Revenue : $817.86 K 🔶Average Order Value : 38.307 🔶Total Pizza Sold : 49,574 🔶Total Orders : 21,350 🔶Average Pizza per Order : 2

🍕Sector-wise Analysis :-

🔶What is the revenue of pizza across different categories ? 🔸Chicken 🔸Classic 🔸Supreme 🔸Veggie

🔶 What is the revenue of pizza across different sizes ?

🔸L - 375318.70 🔸M - 249382.25 🔸S - 178076.49 🔸X - 14076 🔸XXL - 1006.60

🍕Seasonal Analysis :-

🔶Which days of the week have the highest no. of orders?

  • Friday

🔶At what time do most orders occur?

  • Mid-Afternoon

🔶Which month has the highest revenue?

  • July

🍕Customer Behavior Analysis :-

🔶Which pizza is the favorite of customers (most ordered pizza)?

  • The Classic Deluxe Pizza

🔶Top 5 pizzas by revenue :-

🔸The Thai Chicken Pizza 🔸The Barbeque Chicken Pizza 🔸The California Chicken Pizza 🔸 The Classic Deluxe Pizza 🔸 The Spicy Italian Pizza

🔶Which pizza had the most orders over the past year of business at the Pizza Restaurant?

  • The Classic Deluxe Pizza

🍕Pizza Analysis :-

🔶 Pizza with the least price?

  • The Pepperoni Pizza

🔶Pizza with the highest price?

  • The Greek Pizza

🔶Which ingredients does the restaurant need to make sure they have in hand to make the ordered pizzas?

🔸Garlic 🧄 🔸Tomatoes 🍅 🔸Red Onions 🧅 🔸Red Peppers 🌶️🫑 🔸Chicken 🍗 🔸Mushrooms 🍄

This project has been a fantastic learning experience, and I can't wait to continue exploring the world of data analytics and visualization with Power BI.

#PowerBI #DataAnalysis #PizzaSales #powerbiDashboard #DataVisualization #Analytics #DataModeling #github #githubrepository

Thank You!

Contributors:

Rashmi Singh