Google Ratings
Provides visibility into restaurant ratings and customer perception through Google Ratings.
POWER BI · OPERATIONS · DATA AUTOMATION
KFC Restaurant Operations Performance Scorecard
Power BI · DAX · SQL · Alteryx · Python · Data Modeling · Weighted Scoring · Performance Analytics
PROJECT PREVIEWRESTAURANT OPERATIONS PERFORMANCE SCORECARD
KFC Restaurant Operations Performance ScorecardPower BI · DAX · Weighted scoring · Restaurant and franchisee rankings
01 — OVERVIEW
Overview
This project focuses on the development of an internal restaurant operations performance scorecard used by KFC consultants and coaches who support franchisees and restaurant supervisors in monitoring and improving restaurant performance.
The Power BI report acts as the central analytical and scoring layer of the reporting process. It consolidates operational performance measures from multiple sources and applies the required business rules to calculate KPIs, aggregated measures, weighted averages, performance scores and restaurant rankings.
The Power BI report is therefore a key step upstream of the final Excel reporting process. Once the calculations and rankings have been produced in Power BI, the results are used as inputs for a Python-based automation process, which generates standardized Excel scorecards for restaurants and franchisees.
This workflow separates the analytical and scoring process from the final report generation, ensuring that the same business rules and calculations are consistently applied across the network.
02 — BUSINESS OBJECTIVE
Business Objective
The objective was to provide KFC consultants and coaches with a centralized analytical tool to evaluate restaurant performance and support operational discussions with franchisees and restaurant supervisors.
The solution enables users to:
01Evaluate the overall performance of each restaurant
02Rank restaurants across the network
03Compare franchisee performance
04Identify operational strengths and weaknesses
05Understand the factors contributing to a restaurant's overall score
06Monitor MTD and YTD performance
07Identify specific operational areas requiring improvement
08Use standardized performance scores as a basis for operational coaching and follow-up
03 — OPERATIONAL PERFORMANCE MEASURES
Operational Performance Measures
The solution brings together multiple operational indicators covering different aspects of restaurant performance, including:
Customer Complaints
Provides visibility into customer complaints and complaint-related performance, helping identify restaurants or operational areas requiring further attention.
ROCC Operational Standards
Monitors restaurant performance against ROCC operational standards and highlights areas where operational execution may require improvement.
Customer Satisfaction
Provides an overview of customer satisfaction performance and enables comparison of results across restaurants and reporting periods.
Mystery Visits
Analyzes restaurant performance based on Mystery Visit results, providing an additional perspective on operational execution and customer experience.
Training
Monitors restaurant training performance and provides visibility into training-related measures at restaurant level.
Obsession Measures
Consolidates key operational KPIs into a 360° view of restaurant performance, helping identify strengths, weaknesses and areas requiring attention.
04 — SCORE & RANKING
Score & Ranking
One of the key purposes of the Power BI solution is to transform multiple operational KPIs and performance measures into a standardized restaurant performance score.
Power BI is used to perform the calculations required to produce the final restaurant scores, including:
Aggregate operational KPIs and performance measures.
Apply weights across performance dimensions and calculate weighted averages.
Apply KPI scoring rules to calculate the overall restaurant performance score.
Rank restaurants and aggregate performance at franchisee level for comparison.
Calculate current-period and year-to-date performance indicators.
STANDARDIZED PERFORMANCE SCORING
From operational indicators to a consistent score
This allows operational indicators with different scales and characteristics to be combined according to defined business rules and weighting methodologies.
The result is a standardized performance score and ranking for each restaurant, providing consultants and coaches with a clear view of restaurant performance and the areas that require attention.
05 — DASHBOARD FEATURES
Dashboard Features
The internal Power BI report enables KFC consultants and coaches to:
Evaluate Restaurant PerformanceReview the overall score and individual operational measures for each restaurant.
Rank RestaurantsIdentify top- and bottom-performing restaurants based on their overall operational score.
Benchmark FranchiseesAggregate and compare restaurant performance at franchisee level.
Monitor Operational PerformanceView multiple operational measures within a single reporting solution.
Analyze MTD & YTD PerformanceTrack current-period and year-to-date performance.
Identify Performance GapsMove from the overall score to the individual operational dimensions contributing to the result.
Support Operational CoachingUse the results to identify areas requiring attention and support discussions with franchisees and restaurant supervisors.
06 — TECHNICAL APPROACH
Technical Approach
The Scorecard is part of an end-to-end reporting workflow combining data preparation, analytical modeling, scoring and automated report generation.
Data Preparation & ETL
Operational data is sourced from multiple systems and prepared for analytical use.
Alteryx is used for specific data preparation workflows, including Training data and part of the Customer Complaints data.
These workflows help transform, standardize and integrate the required datasets before they are incorporated into the analytical model.
Trainee ETL Alteryx Workflow
IMAGE TO BE ADDEDTrainee ETL Alteryx Workflow/images/projects/restaurant-scorecard/05B4DBE3-5479-4E2B-921D-1FF664430347.png
Complaints ETL Alteryx Workflow
IMAGE TO BE ADDEDComplaints ETL Alteryx Workflow/images/projects/restaurant-scorecard/FD2528D4-56AD-4645-85DA-223D9D09B47E.png
Power BI — Analytics & Scoring Engine
Power BI acts as the central analytical and scoring engine of the solution.
The Power BI data model and DAX calculations are used to:
- Aggregate operational performance measures
- Calculate KPIs
- Apply business rules and weighting methodologies
- Calculate weighted averages
- Generate standardized restaurant scores
- Rank restaurants and franchisees
- Produce MTD and YTD performance indicators
IMAGE TO BE ADDEDPower BI Data Model/images/projects/restaurant-scorecard/image.png
Python — Automated Excel Reporting
Once the analytical calculations, scores and rankings have been produced in Power BI, the results are passed to a Python-based automation process.
Python is used to generate standardized Excel scorecards containing the final restaurant and franchisee performance results.
These Excel reports are then used as the operational reporting deliverables for franchisees and restaurant teams.
Automated Excel Reporting & Scorecard Generation
End-to-End Workflow
01Multiple Data SourcesOperational data from multiple systems
02Data Preparation / AlteryxTransform, standardize and integrate datasets
03Power BI Data ModelAnalytical model and DAX calculations
04KPI Aggregation & ScoringWeighted averages, scores and rankings
05Python AutomationAutomated generation of Excel scorecards
END-TO-END WORKFLOW
Multiple Data Sources → Data Preparation / Alteryx → Power BI Data Model → KPI Aggregation → Weighted Averages → Scoring → Restaurant Ranking → Python Automation → Excel Scorecards
Workflow architecture
This architecture allows Power BI to serve as the analytical and scoring engine, while Python handles the automated generation of the final operational reporting files.
07 — PROJECT GALLERY
Project Gallery
The images below have reserved locations. Add the corresponding image files later to public/images/projects/restaurant-scorecard/, using the filenames shown in the placeholders.
IMAGE TO BE ADDEDGoogle Ratings/images/projects/restaurant-scorecard/Google-Rating.png
01
Google Ratings
Provides visibility into restaurant ratings and customer perception through Google Ratings.
IMAGE TO BE ADDEDCustomer Complaints/images/projects/restaurant-scorecard/Claims.png
02
Customer Complaints
Provides visibility into customer complaints and complaint-related performance.
IMAGE TO BE ADDEDROCC Operational Standards/images/projects/restaurant-scorecard/Audit.png
03
ROCC Operational Standards
Monitors performance against ROCC operational standards.
IMAGE TO BE ADDEDCustomer Satisfaction/images/projects/restaurant-scorecard/Satisfaction.png
04
Customer Satisfaction
An overview of customer satisfaction across restaurants and reporting periods.
IMAGE TO BE ADDEDMystery Visits/images/projects/restaurant-scorecard/Visit-Mystere.png
05
Mystery Visits
Mystery Visit results provide another perspective on operational execution and customer experience.
IMAGE TO BE ADDEDTraining/images/projects/restaurant-scorecard/Formation.png
06
Training
Restaurant-level training performance and training-related measures.
IMAGE TO BE ADDEDObsession Measures/images/projects/restaurant-scorecard/Obession-Measure.png
07
Obsession Measures
A consolidated overview of key operational measures across different dimensions of restaurant operations.
IMAGE TO BE ADDEDScorecard Ranking/images/projects/restaurant-scorecard/Scoercard-Ranking.png
08
Scorecard Ranking
Standardized restaurant and franchisee scores and rankings.
IMAGE TO BE ADDEDAlteryx — Training ETL Workflow/images/projects/restaurant-scorecard/05B4DBE3-5479-4E2B-921D-1FF664430347.png
09
Alteryx — Training ETL Workflow
Alteryx workflow for Training data preparation.
IMAGE TO BE ADDEDAlteryx — Complaints ETL Workflow/images/projects/restaurant-scorecard/FD2528D4-56AD-4645-85DA-223D9D09B47E.png
10
Alteryx — Complaints ETL Workflow
Alteryx workflow for part of the Customer Complaints data preparation.
IMAGE TO BE ADDEDPower BI Data Model/images/projects/restaurant-scorecard/image.png
11
Power BI Data Model
The Power BI data model supporting KPI calculations and score aggregation.
IMAGE TO BE ADDEDMain Scorecard Preview/images/projects/restaurant-scorecard/pr2_6B28DD6F14CFD51BDFB0.png
12
Main Scorecard Preview
Main project view of the KFC Restaurant Operations Performance Scorecard.
08 — BUSINESS VALUE
Business Value
The solution provides KFC operational teams with a standardized framework for evaluating restaurant performance across multiple dimensions.
By centralizing KPI calculations, weighted scoring and ranking in Power BI, the solution ensures that restaurants are evaluated using consistent business rules.
The resulting scores provide consultants and coaches with a clear starting point for operational discussions, while the automated Python workflow transforms the analytical results into standardized Excel scorecards for restaurant and franchisee use.
This combination of Power BI analytics and Python automation improves consistency, reduces manual reporting effort and provides a scalable approach for distributing performance information across the network.
Confidentiality note
This portfolio demonstration uses synthetic data. The structure and analytical approach are representative of the original internal solution; no real operational or identifiable data is displayed.
MORE PROJECTS
Get in touch