The Largest US based Food Services company utilizes Cloud-enabled Sales Analytics platform to gain business insights and increase operational efficiency

About the Client

Founded in 1950, our client is one of the world's largest Food & Beverage companies. Based out of Boston, US, the company has over 9000 retail stores in more than 35 countries with reported revenue of over US$828.9 Million in 2016. Their coffee & baked food chain products include bagels, donuts, and a variety of other baked goods along with various cold and hot beverages.

Our Results

Our Cloud-enabled Sales Analytics platform can support 36 Million data records per day collected from 9000 stores and generate intuitive reports for intelligent actions. This Business Intelligence solution helps the company to gain real-time business insights from critical data to boosts its sales and optimize labor costs.

Read More

Business Need

Food & Beverage companies are creating competitive advantage by exploiting innovative ways to utilize their data. Understanding sales operations, customer behaviour and labor costs is easier when it comes to one store. But this becomes a mammoth task with thousands of stores, varied products line, and aggressive competition. To understand the sales process at each store, the client used an on-premises business intelligence (BI) solution. The solution took a long time to generate reports & there were numerous data silos. The existing system derived reports with a downtime of about 12 hours. In addition, the reports were restricted to one view of single dimension only such as sales, labor, discount, etc.

Each day, the store manager analysed the reports to take decisions regarding product discounts, markdowns, promotions, and labour costs individually. The single dimension view of the report made it practically impossible to take decisions for all of them at one go. As part of the reorganization process, the client had to work towards boosting sales as well as cutting costs. Upgrading the existing BI system wasn’t the answer. The company wanted a flexible solution which can provide exclusive report on sales pattern, eliminate downtime and provide intuitive reports at multi-dimensional level for intelligent decision making. They required a high-performance Business Intelligence solution that could aggregate data, generate reports and present them for access via Web application. This is where Saviant has stepped-in as a Data Analytics consulting partner to architect the solution.

Technology Solution

Azure Data Factory, Azure Blob Storage, Azure SQL Database, Azure Data Lake Analytics & Power BI

Our Food Service and Analytics expertise has helped the team to architect the Business Intelligence solution that can help client to gain insights and boosts sales. Azure Cloud services such as Azure Data Factory, Azure Blob Storage, Azure SQL Database and Azure Data Lake Analytics were leveraged by our analytics consultants to build this solution. Once the store’s POS data - store name, product name, sales price, staff name, etc., is made available, the solution processes these data records, aggregates them and presents the reports. Azure Blob Storage stores the POS data files and Azure Data Factory activity consisting of U-SQL Job reads the files & processes them. The output then gets stored in the Blob, where another activity processes the data and puts it in Azure SQL Database. Here, the staggering data volumes are refreshed in near-real time, which is then made available for presentation via Power BI.

Cloud-enabled Sales Analytics solution provides the sales pattern for each store and analysis with respect to each item sold. This helps the sales team to identify the favourite item that is being sold at that particular store. The BI solution delivered by Saviant, a Power BI partner, also provides labor cost analysis with respect to sales in order to determine the labor expense in accordance with sales per store. With Power BI tool, the sales teams can drill down analytics into hourly, weekdays, weekend, festivals, holidays, seasons by store & department. Although the new analytics platform is yet still in the PoC stage, our client is already seeing many impressive results.

Food services data analytics solution architecture

A Glimpse of the Power BI Dashboard

Food services data analytics Power BI Dashboard

Cloud-based Smart Metering & Data Analytics solution

A fast-growing Manufacturing & Utility service provider deploys Azure driven Smart Metering Solution that handles data from 500,000 IoT based smart meters and processes more than 250 million transactions per year.

Customer Success Story

8 Major benefits of Microsoft Power BI you must know

Business intelligence tools are expected to be game changers for asset-intensive and field-force driven enterprises, such as Utilities. Read this blog to understand few valued competences of Microsoft Power BI tool.

Read what experts say

Bring your unused data to life with our Data Analytics solutions

Connect with Analytics consultants

Saviant at a glance

Saviant is the preferred Data Analytics & Intelligent Solutions partner for leading Asset-intensive and Field-force driven Enterprises across industries like Energy, Utilities, Logistics & Construction. We are the trusted Technology Advisors and Implementation Partners for their strategic initiatives around Data Analytics, IoT, Cloud & Mobility. Our teams enable intelligent actions & accelerated business outcomes for our customers across the globe, by defining their Technology Roadmap & Implementation Strategies.
Saviant is a Microsoft Gold Partner for Cloud Platform, Data Analytics, Application Development & Xamarin Premier Consulting Partner.

Read More