Pizza Sales Analysis

Successfully Completed Pizza Sales Analysis Project!

I am excited to share the successful culmination of a data-driven project focused on Pizza Sales Analysis. Leveraging a dataset comprising nearly 50,000 rows from a pizza store, I employed MySQL and PowerBI to extract valuable insights.

Data Exploration with SQL:
I crafted SQL queries to extract key performance indicators (KPIs) and reveal trends over a specified period.

Database Connection:
Effortlessly connected the MySQL database to PowerBI, creating a unified analysis environment.

DAX Magic:
Within PowerBI, I utilized Data Analysis Expressions (DAX) to formulate powerful measures and innovative new columns.

Data Transformation & Cleansing:
Leveraged Power Query for effective data transformation and cleansing, ensuring a high-quality analysis.

Interactive Dashboard Creation:
Developed an interactive dashboard to showcase insightful trends and glean valuable business insights.

Key Insights:

The peak in orders occurs during the weekend, specifically on Fridays and Saturdays.
The highest number of orders is observed in the months of July and January.
The Classic Category accounts for the highest sales and overall order volume.
Maximum sales are attributed to the Large Size Pizza.
The Thai Chicken Pizza contributes to maximum Revenue.
The Classic Deluxe Pizza contributes to the maximum total Quantities.
The Classic Deluxe Pizza also contributes to the maximum Total Orders.
The Brie Carre Pizza contributes to the minimum Revenue.
The Brie Carre Pizza has the minimum total Quantities.
The Brie Carre Pizza also contributes to the minimum Total Orders.