pizza sales | Power BI

We are seeking a skilled Data Analyst to help us gain insights into our business performance by analyzing key indicators from our pizza sales data. The ideal candidate will be responsible for calculating critical metrics and creating visualizations that highlight trends and patterns in our sales.

Responsibilities:

• Total Revenue: Sum of the total price of all pizza orders.
• Average Order Value: Average amount spent per order.
• Total Orders: Total number of orders placed.
• Average Pizzas Per Order: Average number of pizzas sold per order.

We would like to visualize various aspects of our pizza sales data to gain insights and understand key trends. We have identified the following requirements for creating charts:

• Daily Trend for Total Orders: Create a bar chart that displays the daily trend of total orders over a specific time period. This chart will help us identify any patterns or fluctuations in order volumes on a daily basis.

• Monthly Trend for Total Orders: Create a line chart that illustrates the hourly trend of total orders throughout the day. This chart will allow us to identify peak hours or periods of high order activity

• Percentage of Sales by Pizza Category: Create a pie chart that shows the distribution of sales across different pizza categories. This chart will provide insights into the popularity of various pizza categories and their contribution to overall sales.

• Percentage of Sales by Pizza Size: Generate a pie chart that represents the percentage of sales attributed to different pizza sizes. This chart will help us understand customer preferences for pizza sizes and their impact on sales.

• Total Pizzas Sold by Pizza Category: Create a funnel chart that presents the total number of pizzas sold for each pizza category. This chart will allow us to compare the sales performance of different pizza categories.

• Top 5 Best Sellers by Revenue, Total Quantity and Total Orders : Create a bar chart highlighting the top 5 best-selling pizzas based on the Revenue, Total Quantity, Total Orders. This chart will help us identify the most popular pizza options.

• Bottom 5 Best Sellers by Revenue, Total Quantity and Total Orders : Create a bar chart showcasing the bottom 5 worst-selling pizzas based on the Revenue total quantity.

The DAX Measures --->

Avg Order = [Total Revenue]/[Total Orders]
------------------------------------------------------------------------
Avg Pizza Per Order = [Total Pizza Sold]/[Total Orders]
------------------------------------------------------------------------
Total Orders = DISTINCTCOUNT(pizza_sales[order_id])
------------------------------------------------------------------------
Total Pizza Sold = SUM(pizza_sales[quantity])
------------------------------------------------------------------------
Total Revenue = SUM(pizza_sales[total_price])

SQL Queries --->