Book a call

EPOS data analysis

Excel analysis and reporting for a busy restaurateur

We helped a US-based restaurateur understand their KPI performance and the effectiveness of their sales promotions.

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 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.

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.

Ready to join the dots?

Talk to us about your business challenges.

Book a call