Dodo Pub Co.
THE CLIENTS
Dodo Pub Co. is a chain of pubs which promotes local neighbourhood themes and flavours. The organization currently operates 9 locations across South West and Central England and is in swift expansion mode.
THE PROBLEM
The client had to wait 3-4 weeks to pull up financial reports, because they did not possess an effective system for tracking their finances and maintaining their accounts. Using Excel spreadsheets on local systems and sharing them over email did not give them the means to reconcile their accounts properly and verify their financial statements on a regular basis.
THE IMPACT
Shareholders benefited from the improved clarity and accountability for all relevant KPIs. The business is able to understand the key drivers of revenue growth along with time-specific trends such as best products of the week/month. The business is able to plan promotions such as Happy Hours based on these insights into costs and sales potential, maintaining optimal gross margins while generating cash flow.
OUR SOLUTION
Virgate leveraged technology platform PowerBI and utilized a set of APIs to implement a comprehensive integration across the client’s business. This allowed seamless data flow across various parts of the client organization, and full transparency in the data.
A data warehouse was set up to pull in and manage data from the individual ePoS machines, inventory management and the Rota software (for employee shift management). A customized PowerBI deployment enabled in-depth reporting at a much faster pace, highlighting key metrics and providing valuable insights according to the customer’s immediate needs.
RESULTS DELIVERED
The solution eliminated the need for Excel spreadsheets and the risk of version mismatch across various stakeholders. In alignment with Virgate’s 10 day pledge, the client gets their monthly reports in 10 days or less after closure.
GET YOUR FREE COPY OF THIS CASE STUDY