Pricing & margin analytics
A large AU/NZ hospitality group could not see where price movement and cost leakage were eroding margin across thousands of line items. As sole analyst on the account I built the pricing analysis end to end and turned it into a decision tool for the category managers, presented to the Chief Procurement Officer.
The problem
A multi-venue hospitality group across Australia and New Zealand couldn't see where price movement and cost leakage were eroding margin across thousands of line items and dozens of suppliers.
What I built
As the sole analyst on the account, I built the pricing analysis in Python and SQL across a catalogue of roughly 3,000 to 3,500 items, surfacing price movement and cost leakage down to venue and supplier level, and turned it into a Tableau dashboard the category managers could act on.
The result
Around 30% (roughly A$2M) saved in one of the group's largest categories over a year, with the recommendations presented directly to the Chief Procurement Officer and category leads.
Stack
Interested in work like this?
dhruvnirmal2111@gmail.comOpen to remote data & AI roles — Australia, India, and the Gulf / Singapore.