Industry
Hospitality & Leisure
Project
Loss Prevention
Function
Data Analytics For Finance
Tools Used
Qlik Sense
Integrations
NCR Aloha epos
Whilst the POS system is able to provide the raw transactional data we have really felt the benefit of using Qlik by being able to create easy to interpret visualisations. This helps us quickly identify the outliers and respond whilst any issues are still present.
Objectives
Burger King wanted to be able to quickly identify financial discrepancies at a transactional level. They needed a solution that would allow them to look closely at data such as cash and card sale percentages and average refund amounts, so their team could quickly and easily hone in on any areas where things didn’t look right.
Solution
Using transaction data taken from the NCR Aloha epos system and stored in a Microsoft SQL Server data warehouse, we built Burger King an auditing application in Qlik Sense. Their loss prevention team were able to identify suspicious activity by looking for outliers in the data. With built in capabilities to filter by store, employee and time period, they were able to gain deeper insights into staff behaviour.
Results
- Increased monitoring capabilities of staff performance and behaviour
- Identified areas where additional training was needed
- Provided evidence for more serious action where necessary
