Guzman y Gomez Case Study
Quality food, Quality Reporting!
About GUZMAN Y GOMEZ
Guzman y Gomez is an Australian food chain with a focus on reinventing fast food and delivering quality food. GYG’s growth is well above industry standards and they have been expanding internationally, most recently into the US.
The Challenge
Where is the data?
Steve Orleow is Head of Technology and Insights. His focus: Operational excellence. His brief: to optimise restaurant profitability. His challenge: when he went looking for the data to help him understand the profitability, he couldn’t find it. Initially he started scraping data into Power BI and producing some reports that the users thought were useful. But with 22 datasets that he needed to draw on, he knew this wasn’t a sustainable approach.
The Solution
Beautiful reports built on top of a solid data foundation
Steve started investing in a proper data platform using Microsoft SQL Server and Analysis Services. And adopting the company philosophy of always going with best of breed, he committed to using Power BI as his reporting and dashboard tool and brought in Agile Analytics to help him on his journey.
Report and Dashboards are delivered to both desktop and mobile devices, including smart phones, allowing restaurant managers to monitor business on the move without needing to return to their desk.
The Outcome
Data driven decision making in a quickly changing world.
Restaurant managers can see in how they are performing and benchmark themselves against other restaurants in near real time. The sense of competition motivates staff and fosters teamwork while giving senior leaders visibility of underperforming restaurants and the ability to drill down to understand why and what can be done.
“This is a game changer. We no longer rely on instincts to make decisions. We can make data driven decisions. In a quickly changing world, it is a powerful tool to inform quick decisions. The level of delivery and quality of output by Agile Analytics was exceptional”
Built on Microsoft Platform
SQL Server
Analysis Services
Power BI
