We’re ready to work with you.
Our team will reach out soon to connect you to what you need.
Explore these resources to get ready:
03 The Journey to Intelligence Everywhere
04 Architecting an Enterprise Solution
05 Solution Architecture for an Intelligent Enterprise
06 Data and Analytics in Action
08 Success Strategies for Enterprise Analytics
Investing in a data-driven strategy helped Sainsbury’s transform its analytics into a competitive advantage—ensuring it understands the needs of its customers better than anyone else.
Sainsbury’s adopted a holistic acquisition and consolidation strategy to address the rapid modernization of the retail marketplace, maintain its leadership position, and adapt to evolving customer expectations around the shopping experience. Its various brands leveraged dozens of disparate systems and hundreds of siloed analytics solutions—resulting in accuracy and consistency challenges.
Sainsbury’s boldly embraced change and implemented a unified data and analytics (D&A) strategy to establish a trusted data fabric fit to serve its entire organization. At the nexus of its D&A ecosystem, it leveraged MicroStrategy to build a scalable and governed data model and deliver robust reporting requirements. Ultimately, Sainsbury’s deployed a comprehensive suite of applications that deliver best-in-class analytics experiences to 12,000+ colleagues across its business, powered solely by Snowflake, AWS, and the MicroStrategy Cloud.
Today, colleagues across Sainsbury’s leverage over 30 custom analytics applications to drive everyday decision-making on the store floor, across corporate functions, in the C-suite, and beyond—all deployed with a single cloud analytics platform.
colleagues using apps across stores, depots, and offices
weekly report views across the organization
manhours saved annually by democratizing D&A access
custom analytics applications
enterprise BI platform
To read the complete case study, sign in or create a free MicroStrategy account.
Sainsbury’s has been committed to offering delicious, great quality food at competitive prices since John James and Mary Ann Sainsbury opened their first store on London’s Drury Lane in 1869. For over 150 years, Sainsbury’s has enjoyed market leadership throughout the UK through its steadfast commitment to helping everyone eat better.
With two-thirds of the population having shopped at Sainsbury’s over the last year, today it is the second largest grocery retailer in the UK, claiming a 15% share of the overall market. The Sainsbury’s portfolio also boasts a robust online presence with over 1 billion online visits annually through Argos, the third most visited retail website in the UK. Between these flagship brands, the company offers both online and Click & Collect shopping experiences, garnering tens of millions of transactions each week.
Sainsbury’s is driven by a passion for food and commitment to providing superior service to every customer. As a longtime partner and now owner of Nectar, the UK’s largest loyalty program serving over 18 million shoppers, Sainsbury’s enhances customer value by allowing shoppers to collect and spend points across hundreds of brands.
Sainsbury’s corporate stewardship initiatives also support a variety of service programs by donating funds and surplus food, supplies, and services to community causes. As a champion for sustainability, Sainsbury’s has implemented a variety of initiatives aligned to the United Nations’ Sustainable Development Goals that champion the environment and will ultimately allow it to achieve Net Zero greenhouse gas emissions for its operations by 2035. Sainsbury’s is also the Principal Supermarket Partner of COP26, the United Nations Climate Change Conference, recently held in Glasgow, Scotland.
As a leading retailer, Sainsbury’s has traditionally embraced change and evolving technology. This is no surprise for an organization that recently celebrated its 150th birthday. With a rapidly evolving market landscape in an industry that demands daily decision-making and streamlined processes, Sainsbury’s knew that it needed to make bold moves to stay on the cutting edge.
The strategic approach Sainsbury’s took, represented in its ASPIRE initiative, is a textbook success story about how visionary leadership and goalsetting can quickly transform an organization. Sainsbury’s reimagined its business model, democratized its data, and operationalized analytics—empowering its colleagues to use trusted insights to make informed business decisions and work smarter each day.
Through ASPIRE, Sainsbury’s sought to facilitate its digital transformation by establishing a unified data fabric for its organization with as few technologies as possible, relying on a select few best-in-breed cloud data and analytics (D&A) technologies to make access as “ubiquitous and easy as breathing oxygen” across its organization. Its simplified yet powerful solution stack leverages the MicroStrategy Cloud at its foundation, which is supported by an underlying AWS infrastructure packaged directly into the solution. The powerful semantic graph offered by MicroStrategy centrally stores and manages Snowflake data with a high degree of customizable governance to ensure that information leveraged by each colleague, no matter their role or location, is the right data needed to inform the best possible business decisions based on Sainsbury’s single version of the truth.
Initially launching a completely reimagined and fully optimized mobile app for store operations, Sainsbury’s took bold strokes to ensure its store-based colleagues and regional managers had the insights needed to make real-time decisions that help improve sales, reduce waste, and minimize shrink due to inventory loss—ultimately achieving high user adoption and exceeding 150,000 views each week for this application alone. Building on the success of its store reports app, Sainsbury’s migrated more data to Snowflake and adopted an agile development model that allowed it to continuously roll out new analytics apps and enhancements designed to serve the unique needs of 12,000+ users.
Sainsbury’s embraces a cloud-first strategy toward corporate technology investment. Its enterprise analytics solution needed to seamlessly integrate with its preferred cloud data vendor, maintain superior security, and easily scale to serve thousands of users.
The Sainsbury’s team chose the MicroStrategy Cloud, connected to Snowflake data stores, as the best-fit foundation for its enterprise D&A mission based on a comprehensive list of selection criteria.
Chief Information Officer
One of Europe’s earliest enterprise-wide adopters of cloud-based D&A technologies, Sainsbury’s recognized that delivering unified information across its business could have a transformative impact while helping it deliver the best value to customers.
Sainsbury’s sought out a single analytics platform to complement a single cloud data warehouse for its technology stack, confident that the best technical solution for engraining D&A in its everyday business processes and enabling its people would result from a simplified but powerful architecture comprised of select best-in-breed solutions. Dissatisfied with its legacy on-premises DWHs, Sainsbury’s determined that MicroStrategy could best integrate with its preferred cloud DWH for the future and deliver on the myriad of analytical needs of the thousands of users it planned to serve across its business. MicroStrategy, with its long history as a key analytics partner in certain aspects of Sainsbury’s business, partnered with Snowflake on a 1-day technical proof-of-concept leveraging retail finance data. This POC demonstrated the superior performance, security, and scalability MicroStrategy delivers, further providing Sainsbury’s the confidence it needed to make the bold decision and adopt an entirely new centralized, cloud-powered D&A architecture.
Furthermore, MicroStrategy demonstrated how its enterprise semantic layer offered superior data governance and performance at scale, helping Sainsbury’s develop and deploy an entirely new way of empowering store colleagues with on-the-go analytics with Bring Your Own Device (BYOD) and company-issued mobile devices. Ultimately, MicroStrategy became the sole analytics solution for facilitating its enterprise D&A vision: helping Sainsbury’s modernize its solution suite, expand trusted analytics to 12,000+ users across its organization, and increase employee engagement and customer satisfaction—all by setting itself apart with a pervasive culture of data.
Sainsbury’s overcame several pervasive challenges in data and analytics to establish a scalable and sustainable data-driven culture at the foundation of its business.
Head of Data Visualisation
To further its ASPIRE initiative, Sainsbury’s partnered with MicroStrategy Consulting to optimize its data model performance and security while facilitating scalability and growth.
D&A experts conducted a custom 10-day Analytics Advisory engagement to help Sainsbury’s explore and visualize its data object relationships in an interactive Dossier, identifying a variety of model modifications to improve performance both within the MicroStrategy semantic layer and their Snowflake data warehouse. Once implemented, these enhancements helped Sainsbury’s establish a powerful and sustainable data foundation to build upon for years to come.
Chief Technology Officer
Sainsbury’s colleagues across all 1,400+ stores rely on this store-centric operational reporting app to access powerful business performance insights everyday—enabling managers to make real-time product, merchandising, and staffing decisions directly from the store floor.
The first D&A application Sainsbury’s actively reimagined as it modernized its approach by adopting best-in-breed cloud technologies was its Store Reports app for managing sales, waste, and shrink (SWS). This apps allows store and category managers to monitor, manage, and actively address critical retail KPIs in near real-time by providing managers with aggregate and drill-down views of performance metrics spanning product and category inventory, sales, turnover, budgeting, revenue, and other indicators that help direct colleague actions to improve the retail shopping experience for customers. Furthermore, by embracing agile development practices, Sainsbury’s regularly releases new Dossier chapters as app enhancements designed to help store colleagues align their activities to achieve goals related with corporate initiatives.
Built with a modular approach, this dynamic solution also features context-sensitive links that connect an array of dashboards together into one seamless experience. In addition to providing insights into topline KPIs, this also allows business users to view new chapters and reports published to support tactical initiatives—strategic focus areas that store colleagues focus on for designated time periods to affect a specific customer experience change, enhancement, or new service introduction.
Gaining near real-time insights into the experience of its shoppers is a critical pillar for helping Sainsbury’s achieve its strategic goal of being a place where people love to work and shop. That’s why it leverages Nectar, its loyalty points program, to incentivize customers to share feedback that it can integrate into decision-making.
Through Lettuce Know, one of Sainsbury’s key customer feedback initiatives that offers bonus Nectar points to participants, shoppers submit information about their recent shopping experiences online using unique identifiers printed on each receipt. Sainsbury’s then leverages a Python-enriched ETL process to aggregate and tag this data in Snowflake, which is in turn organized and visualized for user analysis in MicroStrategy.
Analysts leverage this application, which features a custom text-based search widget with natural language query (NLQ) functionality, to examine customer feedback, identify trends, drill-down on key findings, and share near real-time recommendations for improving the customer shopping experience with store managers.
Leveraging the unified data fabric it established across its business, Sainsbury’s rapidly innovated to meet the complex needs of the COVID-19 pandemic—using its robust D&A strategy to best serve and protect colleagues and customers.
In early 2020, businesses worldwide rapidly reacted to the myriad of challenges presented by the emerging public health crisis. Relying on its agile D&A operating model to do so, Sainsbury’s rapidly innovated to help it grapple with store operations interruptions, supply chain shortages, staffing challenges, public health concerns, and other complexities.
Within just one week, Sainsbury’s piloted a new analytics app that helped its store and regional leadership allocate resources to address staffing and supply chain shortages. Within two weeks, it had developed enhancements based on store feedback from its pilot group, and deployed a comprehensive app to colleagues across every store. This app enabled users to overcome a variety of challenges during the lockdown and subsequent stages of the pandemic response, including identifying optimal adjustments to store hours to address shifted customer shopping patterns, prioritizing shipping and stocking of essential supplies, using geospatial analyses to redeploy colleagues while minimizing travel requirements, operating store hours designated for vulnerable customers and National Health Service (NHS) workers, and much more.
Value Index App: Leverages product, sales, and business hierarchy data to analyze the price competitiveness of Sainsbury’s brands and third-party products—informing local, regional, and overall product pricing strategies.
Ordered Items App: Conducts market basket analyses and predicts future ordering and bulk buying patterns to help Sainsbury’s define its buying and merchandising strategy and proactively stock stores to meet demand.
Retail Priorities App: Aggregates dozens of insights about store, product, customer service, and digital performance to identify success measures for key retail priorities and help align Store and Customer Manager activities.
Front End App: Shares process and performance insights for SmartShop, a self-scan shopping app available on customers’ mobile devices, to help streamline the shopper experience and drive customer participation—contributing to increased customer checkout process satisfaction rates.
Slot Availability App: Analyzes existing orders, staffing levels, delivery time availability, and peak season purchasing patterns to recommend when specific stores should offer more timeslots to meet demand—optimizing scheduling to help Sainsbury’s fulfill 850,000+ online orders per week while sales grew.
Pick Progress and Root Causes Apps: Delivers live insights into store colleague progress while “picking” online order items off the shelves and enables Digital Retail Operations Managers to address constraints—increasingly important since online grocery sales more than doubled to over 17% of all purchases in 2020.
Financial Management: Provides trusted and consistent financial insights to key stakeholders across various departments through streamlined interfaces and automated distribution—replacing highly disconnected and manual reporting processes built on legacy BI tools that yielded contrasting numbers.
Supply Chain Operations: Supports the vital processes that ensure availability of products in stores and monitors shifting patterns in demand to maintain supply chain health—providing a reliable and satisfactory shopping experience for customers, even during the challenges posed by the global pandemic.
Other ASPIRE Applications: An array of other apps that analyze core business functions like HR, Operations, Buying, Merchandising, and Customer Loyalty—and even unique solutions aligned to industry initiatives and corporate values, such as enabling Sainsbury’s to monitor and manage agricultural welfare.
Sainsbury’s expects the D&A investments from its ASPIRE initiative to continue driving business value. Here is how it plans to enhance its solution suite in the coming months.
Embrace change openly to ensure you’re positioned to take advantage of the myriad of D&A advancements offered by best-in-class technologies and techniques.
Focus on users’ needs today, not legacy frameworks, and boldly realign teams, restructure processes, and redesign solutions to best serve them.
Model a governed data fabric that ensures everyone in your enterprise arrives at the same insights from your analytics.
Invest in fewer, complementary technologies to take advantage of leading capabilities and create skillset synergies for empowering your colleagues.
You’ve looked at D&A with fresh eyes to set your strategy and chart your course—carry on knowing that big business impacts will materialize.
Chief Information Officer