Modernizing infrastructure and creating a centralized data lake
Nestlé USA client spotlight
Deloitte and Nestlé collaborated on a modernization program to develop and maintain a data lake in the cloud, tearing down siloes and providing reusable data assets that can be used by all business functions.
Collaborating to tear down siloes and provide reusable data assets
Nestlé USA, a division of Nestlé S.A., the world’s largest food and beverage company, had multiple on-premises and siloed systems to store and manage its data. These unintegrated systems and all business functions operated in siloes, which led to multiple versions of duplicate data and non-standard key performance indicators and measures for reporting. The arrangement hampered collaboration between business functions and created an environment for multiple “versions of the truth.” Plus, Nestlé found it difficult to build an advanced analytical engine or unified reporting because of the additional effort needed to constantly aggregate data from the siloed systems.
Since December 2018, however, Deloitte and Nestlé have collaborated on the Nestlé USA modernization program to develop and maintain a Microsoft Azure Data Lake in the cloud, tearing down siloes and providing reusable data assets that can be used by all business functions, subject to data confidentiality rules.
Deloitte, a key collaborator in our data and platform modernization program, has guided us with a data lake vision, strategy, and roadmap. Bringing in a best-in-class cloud talent pool, Deloitte has helped Nestlé USA set up its data lake and implement a scalable cloud analytics solution that empowers our business to make data-driven decisions and become an insight-driven organization.
– Rosana Rodrigues, Business Intelligence & Analytics Leader, Nestlé USA
The wins
- Successfully transitioned 800+ sales representatives to use the SRE app for prioritizing store visits based on recommendations from the engine built by Deloitte. Nestlé drove 3% additional sales in their major customers through the SRE.
- Successfully integrated structured and semi-structured and unstructured data from 10+ sources into Nestlé USA’s data lake to drive SKU assortment performance by analyzing changes in pricing, volume, competitor pricing and promotions.
- Migrated legacy logistics reporting platform to the Nestlé data lake to create advanced self-serve BI Platform for generating key reports (3PL) for 1,000+ third-party vendors for on-time delivery of Nestlé products from warehouse to shipping partner.
- The Nestlé data lake is the cornerstone for 400+ operational reports serving 800+ sales users by integrating 15+ data sources. The dashboards include the summarized reporting for executive leadership and detailed reporting for analysts.
- Strong CI/CD, DevOps, and MLOps processes (including automated data testing, code review, security vulnerability checks) are in place to minimize platform failures and decrease time to production.
By the numbers
50% faster
The data ingestion solution, backed with multiple utilities such as an ingestion framework with built-in audit capabilities, significantly decreased the time needed to ingest data sets and enabled rapid development.1,500 personnel
2,000+ user adoption increase
The centralized data lake implementation led to smooth onboarding of business users from the sales, supply chain, and e-commerce functions.
17 siloed systems decommissioned
Several siloed systems decommissioned as a result of the migration from legacy systems to a centralized data lake. This includes SQL Server/Oracle DB.
$200+ million in business value generated
In the last four years, an estimated cumulative $200+ million worth of business value has been generated through projects and programs in the data lake.
