Woolworths Group
Built a Loyalty KPI Dashboard for Woolworths Sydney Stores
Executive Summary
As part of my data analytics training at The Data Analytics Institute, I built a Power BI KPI dashboard tracking Woolworths Everyday Rewards loyalty performance across Sydney stores. The project required translating raw loyalty and sales data into store-level KPIs that a retail operations team could act on directly. I designed the data model, the KPI logic and the dashboard layout to surface loyalty engagement and trading performance trends by store. The result is a dashboard framework directly applicable to the retail operations and corporate structure roles I am now targeting.
Context
This was an applied project completed during my time at The Data Analytics Institute, using real Woolworths Group retail data for Sydney stores. The brief was to build a KPI dashboard supporting loyalty programme performance analysis.
Challenge
Loyalty and sales data needed to be modelled into store-level KPIs that were meaningful to a retail operations audience, not just technically accurate. The dashboard needed to surface trading performance trends clearly enough to support commercial decisions.
Strategic Approach
Phase 1
Data Modelling
Structured the underlying loyalty and sales data into a model capable of supporting store-level KPI reporting.
Phase 2
KPI Design
Defined the loyalty engagement and trading performance KPIs most relevant to a retail operations audience.
Phase 3
Dashboard Build
Built the Power BI dashboard, applying the same dashboard design discipline later used in commercial engagements at DashboardWorx.
Quantifiable Outcomes
- Delivered a store-level KPI dashboard covering Woolworths Everyday Rewards loyalty performance across Sydney stores.
- Modelled trading performance trends directly relevant to retail commercial finance.
- Applied the same Power BI dashboard methodology later used in live commercial engagements.
- Built entirely on real Woolworths Group retail data, not a simulated dataset.
Qualitative Achievements
- Directly demonstrates the retail operations expertise stated as a career goal in the professional summary.
- Bridges structured data analytics training from The Data Analytics Institute with hands-on Power BI delivery.
- Reinforced the dashboard design discipline carried into current commercial engagements.
The best way to prove you can do retail commercial finance work is to have already done it, even inside a structured training programme, on real retail data.
This project is the clearest bridge between structured data analytics training and the retail operations ambition stated in the professional summary. It shows the dashboard discipline is transferable, not theoretical.