Back to selected work
POWER BI · BUSINESS PERFORMANCE

KFC Daily Sales
Performance Dashboard

An interactive reporting solution designed to monitor daily sales performance across a restaurant network, analyse trends and compare results across restaurants, franchisees and sales channels.

Power BIDAXPower QuerySQLData ModelingData Visualization
PROJECT PREVIEWSCREENSHOT TO BE ADDED
Daily Sales PerformanceYour original dashboard screenshot will appear here.
01 — OVERVIEW

Make daily performance
easier to understand.

This project brings daily sales and operational indicators into one interactive Power BI reporting experience. It helps stakeholders monitor performance, follow trends and compare results across the restaurant network.

The solution combines SQL data preparation, Power Query transformations, data modeling and DAX measures to turn raw data into decision-ready reporting.

02 — BUSINESS CHALLENGE

One reporting view.
Clearer decisions.

The objective was to centralize daily restaurant performance monitoring in an interactive report and make it easier to identify variations that require further analysis.

01How are daily sales and transaction volumes evolving?
02Which sales channels contribute to performance?
03How do restaurants and franchisees compare?
04How are average ticket and store coverage changing?
03 — KEY PERFORMANCE INDICATORS

KPIs built around
business questions.

Measures designed to support consistent performance monitoring and comparison.

01
SSSG

Same Store Sales Growth

Compare sales performance for a consistent set of restaurants against the previous year.

02
SSTG

Same Store Transaction Growth

Track changes in transaction volumes across comparable restaurants.

03
AVERAGE TICKET

Average transaction value

Understand how revenue per transaction evolves over time.

04
SALES / STORE

Sales per store

Compare sales performance at restaurant level.

05
TRANSACTIONS / STORE

Transactions per store

Monitor transaction activity across the restaurant network.

06
COVERAGE

Store coverage

Keep track of reporting coverage across the restaurant network.

04 — DASHBOARD FEATURES

Explore performance
from different angles.

Interactive filters and breakdowns make it possible to move from a network overview to more detailed analysis.

Time-based filtersYear, month, week and business date
Sales & transaction trendsDaily evolution and year-on-year comparison
Restaurant & franchisee viewsCompare performance across the network
Sales channel analysisBreak down results by channel
05 — TECHNICAL APPROACH

From raw data
to reporting.

A layered workflow separates extraction, transformation, modeling, calculations and visualization.

01SQLData extraction & aggregation
02Power QueryPreparation & transformation
03Data ModelTables & relationships
04DAXKPI calculations
05Power BIInteractive reporting
SQL ASSETSDim_Calendar.sqlDim_Channel.sqlDim_Store.sqlFacts_Daily_aggregate_indicators.sql
Explore the DAX logic

Same Store Sales Growth (SSSG)

SSSG =
DIVIDE(
    [Revenue MDA],
    [Revenue MDA PY]
) - 1

Same Store Transaction Growth (SSTG)

SSTG =
DIVIDE(
    [Transaction MDA],
    [Transaction MDA PY]
) - 1

Average transaction value

TM MDA =
DIVIDE(
    [Revenue MDA],
    [Transaction MDA]
)

Illustrative measure excerpts. The base measures and filter logic are defined in the underlying model.

06 — DASHBOARD GALLERY

The dashboard
in practice.

Original screenshots will be added here later. The placeholders are intentionally labelled and do not represent production dashboard captures.

SCREENSHOT TO BE ADDED
01

Dashboard overview

Main view of daily sales performance and headline KPIs.

SCREENSHOT TO BE ADDED
02

Sales & transactions

Trend analysis for revenue, transactions and average ticket.

SCREENSHOT TO BE ADDED
03

Channel & store analysis

Comparisons by sales channel, restaurant and franchisee.

07 — BUSINESS VALUE

Better visibility.
More focused analysis.

The reporting solution provides a centralized view of daily restaurant performance and helps stakeholders identify variations across the network.

  • Centralized monitoring of daily performance indicators
  • Consistent comparisons across restaurants and franchisees
  • Visibility into channel-level sales and transaction trends
  • Clearer identification of areas requiring operational analysis
Confidentiality note

This portfolio version uses synthetic data for confidentiality purposes. The dashboard structure, KPIs and analytical approach are representative of the original reporting solution developed in a professional environment.

MORE PROJECTS

Explore other work.

Speed Dashboard Restaurant Operations Scorecard
Get in touch