How a Restaurant Management Group was Empowered for Loss Prevention at Scale with Advanced Analytics

Print Friendly and PDF

Client Profile & Challenge

Our client is a $600 Million Restaurant Management Group operating 700+ locations across nine concepts.

Challenge:

Without timely insights to data, loss prevention at scale was becoming increasingly difficult and was ultimately eroding profitability for our client. Rapid expansion meant more stores to monitor, making it increasingly difficult to catch and deter fraud within the stores. There was no way to quickly evaluate stores and detect suspicious outliers in key areas; therefore, most malicious activity went unchecked.

Solution Overview

By integrating data across all concepts and visualizing it in Power BI to deliver critical insights, Messina was able to help our client isolate suspicious activity within stores. The ability to quickly compare and determine unusual metrics in areas like inventory and discounts helped the client investigate and take action on improper activity.

Solutions:

Advanced Analytics, Data Visualization, Data Integration

Technology Used:

Microsoft Azure, Power BI

“AFTER” BUSINESS VALUE CREATION

By integrating timely, accurate data across the entire portfolio of stores for each concept, our client was able to quickly spot suspicious outliers in a custom-built Power BI Application tailored for Loss Prevention tactics.

This dashboard focused on critical areas such as inventory padding, discounts, and cash variances, establishing normal thresholds for each concept/region/district, then exposing significant outliers or questionable trends.

Within just a month of go-live, our client was alerted to several hundred thousand dollars in fraud at a single location.

We use cookies to ensure you get the best experience on our website.

For more information, read our Cookies Policy.