Maven Pizza Analysis - Power BI Project🎊🍕

Welcome to the Maven Pizza Analysis project! This repository contains a Power BI report that showcases an in-depth analysis of the annual sales figures of Plato's Pizza Mania, providing valuable insights into the business.

1️⃣ Project Overview

The objective of this project was to analyze the sales data provided by Maven Analytics available in Kaggle and uncover patterns, trends, and key performance indicators (KPIs) to better understand the success of Plato's Pizza Mania. The data includes details such as order timestamps, pizza types, sizes, quantities, prices, and ingredients, which were meticulously analyzed to gain meaningful insights.

2️⃣ Tools and Techniques Used

• Power BI: Leveraged the power of Power Query and DAX functions to transform and model the raw data into actionable insights.
• Power Query: Employed data transformation techniques, including conditional columns, calculated measures, and modeling, to uncover hidden patterns and trends.
• DAX (Data Analysis Expressions): Utilized DAX functions to perform calculations and create custom measures for analyzing the data.
• SQL Server Management Studio (SSMS): Ensured data integrity and reliability by verifying the analysis results through in-depth querying, subqueries, joins, and aggregations.

3️⃣ Key Questions Addressed

Throughout the analysis, the project sought to answer several key questions, including:

1. Daily, monthly, and hourly sales trends: Unveiling the patterns that contribute to the success of Plato's Pizza Mania.
2. Peak hour order influx: Identifying the busiest hours with the highest number of orders.
3. Best performing pizzas: Determining the pizzas that excel in terms of sales.
4. Average order value: Calculating the average value of customers' orders.
5. Sales across categories and sizes: Understanding how sales are distributed among different pizza categories and sizes.
6. Popular ingredients: Discovering the most frequently used ingredients loved by pizza enthusiasts.

4️⃣ Repository Contents

1. Power BI Report: The complete Power BI report showcasing interactive visuals and captivating insights derived from the data analysis.
2. Data Folder: Contains the raw data provided by Maven Analytics for reference.
3. SQL Queries: Includes SQL queries used in SSMS for further data verification and integrity checks.

5️⃣ Screenshot

Feel free to explore the Power BI report and delve into the intriguing world of Maven Pizza's sales analysis🎇🎇.