EPOS Data Analysis in Microsoft ExcelProduction of KPI reports from EPOS data exports for restaurateur.
EPOS data analysis in Microsoft Excel
Improved business insight
Time and cost saving
“Always great to work with, does a fantastic job every time! Will definitely order again in the future. Thank you.”
EPOS reporting in Excel
A US based restaurateur wanted to understand the effectiveness of their sales promotions.
The existing EPOS system did not provide their desired data analysis functionality and the client was faced with a costly EPOS upgrade or replacement.
Automated reporting from EPOS .csv and .txt files
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.