• Advertise
  • Contact Us
  • About Us
  • Supplier Directory
  • SCB YouTube
  • Login
  • Subscribe
  • Logout
  • My Profile
  • LOGISTICS
    • Air Cargo
    • All Logistics
    • Express/Small Shipments
    • Facility Location Planning
    • Freight Forwarding/Customs Brokerage
    • Global Gateways
    • Global Logistics
    • Last Mile Delivery
    • Logistics Outsourcing
    • LTL/Truckload Services
    • Ocean Transportation
    • Rail & Intermodal
    • Reverse Logistics
    • Service Parts Management
    • Transportation & Distribution
  • TECHNOLOGY
    • All Technology
    • Artificial Intelligence
    • Cloud & On-Demand Systems
    • Data Management (Big Data/IoT/Blockchain)
    • ERP & Enterprise Systems
    • Forecasting & Demand Planning
    • Global Trade Management
    • Inventory Planning/ Optimization
    • Product Lifecycle Management
    • Sales & Operations Planning
    • SC Finance & Revenue Management
    • SC Planning & Optimization
    • Sourcing/Procurement/SRM
    • Supply Chain Visibility
    • Transportation Management
  • GENERAL SCM
    • Business Strategy Alignment
    • Education & Professional Development
    • Global Supply Chain Management
    • Global Trade & Economics
    • HR & Labor Management
    • Quality & Metrics
    • Regulation & Compliance
    • SC Security & Risk Mgmt
    • Supply Chains in Crisis
    • Sustainability & Corporate Social Responsibility
  • WAREHOUSING
    • All Warehouse Services
    • Conveyors & Sortation
    • Lift Trucks & AGVs
    • Order Fulfillment
    • Packaging
    • RFID, Barcode, Mobility & Voice
    • Robotics
    • Warehouse Management Systems
  • INDUSTRIES
    • Aerospace & Defense
    • Apparel
    • Automotive
    • Chemicals & Energy
    • Consumer Packaged Goods
    • E-Commerce/Omni-Channel
    • Food & Beverage
    • Healthcare
    • High-Tech/Electronics
    • Industrial Manufacturing
    • Pharmaceutical/Biotech
    • Retail
  • THINK TANK
  • WEBINARS
    • On-Demand Webinars
    • Upcoming Webinars
  • PODCASTS
  • VIDEOS
  • WHITEPAPERS
Home » Blogs » Think Tank » Minimizing Retail Supply Chain Frustrations With a Strong Data Strategy

Think Tank
Think Tank RSS FeedRSS

Minimizing Retail Supply Chain Frustrations With a Strong Data Strategy

Empty shelf
Empty shelves in a supermarket. Photo: Getty.
May 2, 2022
Mark Van de Wiel, SCB Contributor

Supply chains are a bit like utilities: Nobody notices them until problems arise. Well, there’s no escaping notice these days, as supply chain setbacks grow even worse than last year.

“Many believe the supply chain disruption issues that have been occurring throughout the pandemic will continue well into 2022,” the National Retail Federation says. “In general, demand for goods and materials continues to outpace the supply of everything needed to produce and move those goods through the supply chain.”

While the supply chain crunch puts retailers largely at the mercy of forces outside their control, better use of real-time, consolidated data within retail systems can go a long way toward not only keeping store shelves stocked, but also managing customer expectations for as long as the crisis persists.

Increasing supply chain resilience is the second-highest strategic priority for retailers in the coming months, according to a report by the Economist Intelligence Unit commissioned by the Association for Supply Chain Management. However, more than half of all companies — retailers and others — don’t have enough visibility into their supply chains.

“Companies lack end-to-end visibility, leaving them vulnerable to dynamic or unexpected risks,” the report says. Too often, “the view of supply chains is based on internal data or relies on siloed or outdated data sets. This limits their ability to detect emerging threats or calculate how a disruption will unfold across supply chains and business units.”

Retailers operate multiple planning processes that are often not integrated. Vendor relationships are developed outside of inventory planning and management. Marketing is isolated from financial planning. Supply chain challenges are handled separate from commercial planning. And more often than not, real estate and franchise planning are isolated strategic activities.

That has led to countless systems and databases for storing and managing myriad slices of data, and they’re often not integrated. Enterprise resource planning (ERP) data, for example, is imperative to many supply chains but is often stuck in a silo. It’s isolated from marketing data often available through platforms like Shopify, Magento, Google Analytics, social media and e-mail marketing. Product assortment plans might be stored in spreadsheets. And where is the customer relationship data?

To bust down silos, building out a data warehouse or data lake — consolidating data from multiple inputs — is an obvious start. Such a datastore can provide insights into trends that are invisible to the individual systems. Getting data into a centralized data warehouse and leveraging it as an asset can provide the 360-degree view that retailers need to integrate isolated activities.

For example, an online retailer based in the U.K. found itself with many disparate systems and couldn’t get a holistic view of the entire business, including customers, the supply chain and inventory.

The retailer unsuccessfully tried to get that view with an on-premises data warehouse. Then it decided to look at more cost-effective cloud-based solutions such as a data lake. By moving data from the disparate systems into the cloud and the data lake, the retailer was able to replicate the data in real time and retire its legacy operational reporting services.

Many retailers are at different stages of their analytical maturity. A surprising number of large national chains are still performing analysis and reporting with Excel. Unfortunately, Excel isn’t going to scale or handle the quantity of data accumulated day over day and year over year.

At the other end of the spectrum, there are retailers further into their analytical maturity that use an on-premises data warehouse. And there are those that have fully moved to the cloud and are using cloud-native tools such as retail-specific artificial intelligence (AI) and machine learning routines that can help them reap the benefits of the cloud and facilitate and grow real-time analytics.

One large global online retailer has a core system that holds data about its retail partners and transactions. The company needed a solution that would allow access to this data without putting a heavy load on the system and affecting other business operations. It’s an extremely high-volume system, but today’s technology allows for getting a real-time copy of the data into the cloud for efficient analysis and reporting.

With real-time insight, organizations can better manage their supply chains, maximize revenue and improve efficiencies. They can gain an outside-in picture that enables better understanding, planning and forecasting.

This helps retailers to become not only less vulnerable to supply chain disruptions, but stronger businesses overall.

Mark Van de Wiel is field chief technology officer at Fivetran, an automated data integration provider.

Data Management (Big Data/IoT/Blockchain) Business Strategy Alignment Quality & Metrics Supply Chain Security & Risk Mgmt Supply Chains in Crisis Retail

RELATED CONTENT

RELATED VIDEOS

Wake up to live
“Supply Chains in Crisis”
updates and the latest Supply Chain News!

Subscribe to our Daily Newsletter

Timely, incisive articles delivered directly to your inbox.

Popular Stories

  • INTERIOR OF A CHICKEN FARM, WITH WHITE CHICKENS AS FAR AS THE EYE CAN SEE

    Worst Avian Flu in U.S. History Is Hitting Poultry

    Food & Beverage
  • TWO FINGERS MANIPULATE WOODEN LETTER BLOCKS TO TURN FROM SHOWING THE WORD RECOVERY TO RESILIENCE

    Five Challenges to Supply Chain Resilience in 2023

    Supply Chain Visibility
  • A PERSON HOLDS UP A TABLET COMPUTER IN A WAREHOUSE, SUPER-IMPOSED BY A GRAPHIC SHOWING A COMPLEX WEB OF SUPPLY CHAIN ELEMENTS

    Three Post-Pandemic Actions for Repairing Global Supply Chains

    Data Management (Big Data/IoT/Blockchain)
  • A MAN IN A SUIT SHAKES HANDS WITH A WOMAN IN A HARD HAT, NEXT TO A STACK OF CONTAINERS

    Three Procurement Technology Evolutions for 2023

    Sourcing/Procurement/SRM
  • The blank stare of a child's eye who is standing behind what appears to be a wooden frame

    The Alarming Continued Rise of Modern Slavery in Supply Chains: How Procurement Can Help Reverse the Trend

    Sourcing/Procurement/SRM

Digital Edition

Scb nov 2022 sm

2022 Supply Chain Innovator of the Year

VIEW THE LATEST ISSUE

Case Studies

  • New Revenue for Cloud-Based TMS that Embeds Orderful’s Modern EDI Platform

  • Convenience Store Client Maximizes Profit and Improves Customer Service

  • A Digitally Native Footwear Brand Finds Rapid Fulfillment

  • Expanding Apparel Brand Scales Seamlessly with E-Commerce Technology

  • How a Global LSP Scaled its Security Program and Won More Business

Visit Our Sponsors

Orderful Yang Ming Alithya
Barcoding Blue Yonder BNSF Logistics
CoEnterprise Data Capture Deposco
E2open GAINSystems Generix
Geodis GEP GreyOrange
Here Honeywell Intelligrated IFM
Infor Inmar Keelvar
Kinaxis Korber Lean Solutions Group 2H
Liberty SBF Locus Robotics Logility
LogistiVIEW Lucas Systems MCA Connect
MPO Nvidia Old Dominion
OpenText ORTEC Overhaul
Parsyl PMMI QIMA
Redwood Logistics Ryder E-commerce by Whiplash Saddle Creek Logistics
Schneider Dedicated Setlog Holding AG Ship4WD
Shipwell Tecsys TGW Systems
Thomson Reuters Tive Trailer Bridge
Vecna Robotics Verity
Verusen
  • More From SCB
    • Featured Content
    • Video Library
    • Think Tank Blog
    • SupplyChainBrain Podcast
    • Whitepapers
    • On-Demand Webinars
    • Upcoming Webinars
  • Digital Offerings
    • Digital Issue
    • Subscribe
    • Manage Your Subscription
    • Newsletters
  • Resources
    • Events Calendar
    • SCB's Great Supply Chain Partners
    • Supplier Directory
    • Case Study Showcase
    • Supply Chain Innovation Awards
    • 100 Great Partners Form
  • SCB Corporate
    • Advertise on SCB.COM
    • About Us
    • Privacy Policy
    • Contact Us
    • Data Sharing Opt-Out

All content copyright ©2023 Keller International Publishing Corp All rights reserved. No reproduction, transmission or display is permitted without the written permissions of Keller International Publishing Corp

Design, CMS, Hosting & Web Development :: ePublishing