EPOS data analysis and reporting with Excel for a busy restauranter
We helped a US-based restaurateur understand their KPI performance and the effectiveness of their sales promotions.
The brief
The existing EPOS system did not provide the restaurant with the desired data analysis and functionality to enable them to grow their business. The client also faced the prospect of a costly EPOS upgrade or replacement.
Improved Business Insight
By compiling daily EPOS exports into useful tables of information we were able to create detailed reports on the effectiveness of restaurant promotional activity.
Time and cost saving
The owner avoided having to pay for a costly company-wide EPOS upgrade by working with OnlyExcel to get more out of their existing data.
Fast turnaround
Building on our library of existing VBA modules meant that we could quickly produce a system that was easy for the restaurateur to use.
The result
Data exports were available from the existing EPOS system in the form of .txt and .csv files so we created a user-friendly interface for importing and managing these files.
Using Excel’s programming language, VBA, the system compiles the daily exports into organised tables with useful KPI’s saving the client time and money and giving them the desired analysis.
Featured case studies
We saved time and improved efficiencyfor AIM Group – a busy steel and pipefabrication company in Falkirk, Scotland.
Excel modelling helped us to create ahighly effective web app, enabling ourclient to grow from startup to £5m+.