Transforming Food Supply Chain Operations with Power BI

Updated: Mar 27, 2021

In today’s fast-paced digital marketplace, Retailers and Food Service companies are rapidly adopting technology as a key to optimize their supply chain operations. And JJ Food Service, UK’s leading Food Service specialist, has always been at the forefront of leveraging cutting-edge technologies in everything it does. Recently, the company utilized Microsoft Power BI to create a Business Intelligence environment, with a goal to empower its operations team, mobile workforce, and food-delivery personnel with information essential to make intelligent decisions on-the-fly.


JJ Food Service supplies a range of food items and non-food products to restaurants, cafes, caterers, schools, and Delis in the UK. It manages the entire supply chain operations in-house—from taking the customer order to the delivery of items to the customer’s kitchen. Delivering items to several customers involves keeping track of different routes, field workforce & assets in order to make each delivery a success. It has a fleet of delivery vehicles customized with temperature control sensors to manage successful delivery of perishable food-items. JJ Foods has the ability to control complete supply chain operations, which demand high-quality delivery of 4500+ varied products to more than 30,000 customers, from 11 distribution centers using 125 delivery trucks.


The Challenges


“Today, JJ’s entire operations starting from procurement, route, and stock management to order processing and inventory management run on ERP..”

It stores enormous volumes of discrete data coming in from multiple data sources like delivery drivers’ mobile app, backend processes, customer information system, etc. But the company had no means to consistently tap into this gold mine of data to streamline.


  • Absence of insights into various activities of drivers, such as time-taken for delivery, longest hours, maximum mileage, vehicle halt period, items damage incurred during transit, etc. These insights would help the teams to understand the performance of drivers and provide necessary trainings to overcome their challenges.

  • No single view of freezer & chiller temperature data obtained from the fleet of delivery vehicles. If it could, then it would track & identify the optimal threshold pattern for the delivery of high-quality food items.

  • Tracking all items available in the warehouse manually was a tedious task. There was no real-time visibility of stock availability and list of undelivered items available for re-usage. If it could, it would stock-up inventory before it is unavailable.

  • Unified data view on the go from any device for health monitoring of the business was an impossible task.

  • No consolidated data view at a single point of time to get a 360-degree view of the business. If it could, it would make the right decisions at right time.

  • No means to track and monitor customers that show abnormal behavior; who order items, but changes their decision at the delivery time and rejects the items.

  • To keep a watch on the list of damaged products and the quantity pertaining to it in real-time was cumbersome.



>> Read more....

8 views0 comments

Recent Posts

See All