top of page
romain-chollet-3bdXRhUdYtw-unsplash.jpg

Pizza Shop Sales PowerBI Dashboard

PROJECT

Title: Pizza Shop Sales PowerBI Dashboard

By: Fanny Guan

Updated: February 12th, 2024

SCENARIO

This project focuses on the development of a dynamic Power BI dashboard tailored for analyzing pizza sales data within a pizza business. The primary objectives of this dashboard are to provide comprehensive insights into sales performance, identify trends, and facilitate data-driven decision-making to optimize business operations and drive growth.

TOOLS

PowerBI

MS SQL

SQL Queries

Queries for data integrity checks while creating dashboard.

Type: pdf
Size: 138 KB

PowerBI Dashboard

powerbi dashboard mockup 2.png
powerbi dashboard mockup 1.png

KPI's

KPI's for quick overview are pinned to the top of the dashboard. Included metrics are:

Total Revenue
Average Order Value
Total Pizzas Sold
Total Orders
Average Pizzas Per Order

kpis.png
powerbi videos kpi.gif

Values are dynamically updated as the user interacts with the dashboard.

bottom of page