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.

© 2024 Fanny Guan

bottom of page