Use Case

March 7, 2024

How Walmart Use Supply Chain Analytics

Supply chain analytics allows enterprises to leverage logistics and other data to optimize key processes, predict demand, and make better decisions.

But before we begin, if you're someone who wants to build projects for Data Science Portfolio then keep your tabs on what's happening in the world of Data Science & Businesses, and Hit EARLY ACCESS if you haven't already. 

If you already have Early Access, you can just go ahead and read our Data Story! 😀

Walmart's dominance in the retail sector, holding the title of the world's largest retailer with global sales surpassing even Amazon, is underpinned by strategic investments. Between 2019 and 2020, a significant portion of Walmart's strategic capital expenditures, a whopping 72%, was dedicated to supply chain transformation, amounting to over $11 billion.

This substantial investment has proven pivotal, as evidenced by Walmart's impressive revenue of nearly $612 billion in 2023. The retail giant strategically utilized these funds to enhance its supply chain through the integration of cutting-edge technologies, infrastructure improvements, and a strong focus on ecommerce.

The key to Walmart's success lies in its meticulous attention to the supply chain, ensuring faster, more flexible fulfillment and accurate demand forecasting. With nearly 6,300 international locations operating in 28 countries and over 11,700 retail units globally, Walmart's commitment to supply chain excellence has allowed it to maintain control over its logistics network and streamline fulfillment processes

Keeping the example of Walmart in mind, in this article, we take a closer look at How to use Supply Chain Analytics use case to Improve Supplier & Logistics Performance.

About Dataset

Alright, let's take a closer look at our Superstore dataset.

It's basically an information on our Superstore sales – we've got order IDs, order and shipping dates, details about the shipping mode, customer names, and their locations. Plus, we have all the nitty-gritty details about the products too – their categories, names, and the important numbers like sales amount, quantity, discounts, and profit.

This data is enough for digging into supply chain analysis, sales performance, understanding profitability, and even decoding customer behavior.

With all this information at our fingertips, we can make smarter decisions about supply chain management. By digging into the dataset, we can uncover patterns, trends, and insights that will help us optimize our operations and improve overall efficiency. So, let's roll up our sleeves and start exploring!

Order Details
Row ID Order ID Order Date Ship Date Ship Mode Customer ID Customer Name Segment Country/Reg City State/Province
1 US-2019-103800 1/3/2019 1/7/2019 Standard Class DP-13000 Darren Powers Consumer United States Houston Texas
2 US-2019-112326 1/4/2019 1/8/2019 Standard Class PO-19195 Phillina Ober Home Office United States Naperville Illinois
3 US-2019-112326 1/4/2019 1/8/2019 Standard Class PO-19195 Phillina Ober Home Office United States Naperville Illinois
4 US-2019-112326 1/4/2019 1/8/2019 Standard Class PO-19195 Phillina Ober Home Office United States Naperville Illinois
5 US-2019-141817 1/5/2019 1/12/2019 Standard Class MB-18085 Mick Brown Consumer United States Philadelphia Pennsylvania

Product Details
Postal Code Region Product ID Category Sub-Category Product Name
77095 Central OFF-PA-10000174 Office Supplies Paper Message Book, Wirebound, Four 5 1/2" X 4" Forms/Pg., 200 Dupl. Sets/Book
60540 Central OFF-BI-10004094 Office Supplies Binders GBC Standard Plastic Binding Systems Combs
60540 Central OFF-LA-10003223 Office Supplies Labels Avery 508
60540 Central OFF-ST-10002743 Office Supplies Storage SAFCO Boltless Steel Shelving
19143 East OFF-AR-10000348 Office Supplies Art Avery Hi-Liter EverBold Pen Style Fluorescent Highlighters, 4/Pack

Sales Data
Customer ID Customer Name Product ID Product Name Sales Quantity Discount Profit
DP-13000 Darren Powers OFF-PA-10000174 Message Book, Wirebound, Four 5 1/2" X 4" Forms/Pg., 200 Dupl. Sets/Book 16.448 2 0.2 5.5512
PO-19195 Phillina Ober OFF-BI-10004094 GBC Standard Plastic Binding Systems Combs 3.54 2 0.8 -5.487
PO-19195 Phillina Ober OFF-LA-10003223 Avery 508 11.784 3 0.2 4.2717
PO-19195 Phillina Ober OFF-ST-10002743 SAFCO Boltless Steel Shelving 272.736 3 0.2 -64.7748
MB-18085 Mick Brown OFF-AR-10003478 Avery Hi-Liter EverBold Pen Style Fluorescent Highlighters, 4/Pack 19.536 3 0.2 4.884

Each row in the dataset corresponds to an order made by a customer. We have the following features:

Order Shipment : 
Transaction Information
Field Type Description
Order ID String Unique identifier for each order.
Order Date Date Date when the order was placed.
Ship Date Date Date when the order was shipped.
Ship Mode String Mode of shipment chosen for the order.
Segment String Market segment the customer belongs to.
Region String Region where the order was placed.
City String City where the order was placed.
State/Province String State or province where the order was placed.
Postal Code Integer Postal code of the location where the order was placed.

Product : 
Transaction Information
Field Type Description
Product ID String Unique identifier for each product.
Category String Category of the product.
Sub-Category String Subcategory of the product.
Product Name String Name of the product.
Sales Integer Total sales amount for the order.
Quantity Integer Quantity of the product ordered.
Discount Integer Discount applied to the order.
Profit Integer Profit generated from the order.

Other Feature : 
Transaction Information
Field Type Description
Row ID String Identifier for each row in the dataset.
Customer ID String Unique identifier for each customer.
Customer Name String Name of the customer placing the order.

The SuperStore Dataset contains over 10194 orders and 13 of our Columns have String Data type, 4 of our Columns have Integers Data Type and 2 of the columns have Date Data Type.

How to use Supply Chain Analytics to Improve Supplier & Logistics Performance?

To enhance supply chain analytics and optimize supplier and logistics performance, a systematic approach is crucial. This process begins by focusing on four fundamental aspects of data analysis:

  • 1. Identify the users or stakeholders for the dashboard.
  • 2. Design Empathy Map to define Users' Goals and Challenges or pain points.
  • 3. Identify Metrics or KPIs Matter the Most.
  • 4. Understand the Objectives and Goals.
  • 5. Ask Business Questions

I know it looks a bit overwhelming that’s why in this article, we'll lay the foundation for a top-notch supply chain optimization analysis. 

Step 1: Identify the users or stakeholders for the analysis.

Start by clearly defining the primary users or stakeholders for the supply chain data story. For this discussion, let's consider the role of a Supply Chain Manager as a key user. It's essential to gain a deep understanding of their diverse needs, challenges, and priorities to tailor an effective data narrative.

User Persona : Supply Chain Manager

  • Optimizing supply chain processes to improve efficiency and reduce costs.
  • Managing inventory levels to meet customer demand while minimizing holding costs.
  • Ensuring timely delivery of products to customers.
  • Collaborating with suppliers and logistics partners to streamline operations.
  • Access to comprehensive supply chain data for analysis and decision-making.
  • Tools for inventory management and demand forecasting.
  • Regular updates on inventory levels, order fulfillment, and delivery performance.
  • Balancing inventory levels to avoid stockouts while minimizing holding costs.
  • Addressing disruptions in the supply chain, such as delays or shortages.
  • Ensuring compliance with regulatory requirements and quality standards.

Since, we have defined the User Persona & have mapped the needs, challenges and responsibilities. Our Next step will be to design an Empathy Map which will map the pain points of the user.

Step 2: Design Empathy Map

The next step involves creating an empathy map to deeply understand the experiences and expectations of the Supply Chain Manager. This visual tool provides insights into their emotions, aspirations, and pain points. By empathizing with their perspectives, the aim is to design a data story that not only meets functional requirements but also resonates with the human aspects of their roles.

Empathy Map Components:
  • Say: Articulate the thoughts and expressions of the Supply Chain Manager.
  • Think: Understand their internal thoughts and considerations.
  • Do: Identify the actions and behaviors associated with their role.
  • Feel: Pinpoint the emotional aspects, concerns, and motivations.

Step 3: Identify the Key Performance Indicators (KPI’s)

The heartbeat of any analysis lies in KPI’s and their Metrics. It's crucial to identify the KPIs that matter most to achieving the defined objectives and by focusing on the most relevant metrics, organizations can gain actionable insights into their supply chain operations. 

KPI Name Definition
Profit Margin by Ship Mode Percentage of profit generated compared to sales for each mode of shipment.
Year-over-Year Growth in Same-Day Shipments Percentage change in sales and profit for same-day shipments compared to the previous year.
Lost Sales Opportunities in Underperforming Regions Estimated revenue lost due to underperformance in same-day shipments in 2023.
Category Contribution to Regional Performance Percentage of total profit contributed by each product category in the South region in 2023.
Profitability of Technology Subcategory in Same-Day Shipments Average profit margin and sales growth rate for the Technology subcategory in the South region for same-day shipments in 2023.

Step 4: Understand the Goals & Objectives of User

Now, on the basis of Empathy Map and KPI’s, we need to define our goals and objectives of the Users. So, that it will align with the data story functionalities to ensure decision making. Here are the Key Objectives & Goals : 

Objective : To enhance supply chain efficiency and profitability by analyzing sales, profit, and shipment data to optimize shipping methods, improve same-day delivery performance, maximize regional impact, and optimize technology subcategory performance.

Goals : To Improve supply chain efficiency and reduce costs, enhance customer satisfaction through timely delivery and product availability, strengthen relationships with suppliers and logistics partners and mitigate risks and uncertainties in the supply chain.

Based on the defined goals & objectives, your next step will be to provide actionable insights to make a mark on Business Decisions.

Actionable Insight: Refrain from shipping machines via same-day delivery mode due to their profitability constraints. Allocate machines to more cost-effective shipping methods to mitigate losses and improve overall profitability within the same-day.

Step 5 : Ask Business Questions

Beyond KPI’s, organizations must engage in business-driven inquiry. This involves asking strategic questions that directly align with overarching business objectives. 

Q1) What Are the Sales And Profit By Ship Mode?

Metrics: Total sales amount, total profit generated

Key Analysis: Calculate total sales and profit for each mode of shipment (e.g., standard, express, same-day) to determine the most profitable and efficient shipping methods.

Q2) How Are Sales And Profit Performing Yearly On Same-Day Ship Mode?

Metric: Yearly sales, yearly profit

Key Insight: Evaluate the yearly performance of sales and profit specifically for same-day shipments to identify trends and potential areas for improvement in same-day delivery services.

Q3) Which Region Is Not Performing On Same-Day Mode In 2023?

Metric: Same-day shipment performance by region

Key Insight: Identify the region that is underperforming in terms of same-day shipments in 2023 based on metrics such as sales, profit, and delivery efficiency.

Q4) What Is Category Wise Impact In South Region In Year 2023?

Metric: Sales and profit by product category

Key Insight: Analyze the impact of different product categories on sales and profit in the South region during 2023 to understand which categories contribute the most to performance in the region.

Q5) Technology Subcategory Profit And Sales In South Region Same Day 2023?

Metric: Sales, profit (by category and subcategory by Region)

Key Insight: Dive deeper into the performance of the Technology subcategory specifically for same-day shipments in the South region in 2023 to understand the factors influencing its profitability and sales within the same-day delivery segment.

Explore Supply Chain Analytics Data Story Here👇

Slideshow Demo
Supply Chain Analysis Project

By framing this data story in alignment with business goals, organizations can get deeper insights that drive impactful decisions.


By combining a user-centric approach with data-driven insights and strategic inquiries, organizations can navigate the complexities of their supply chains with confidence and agility. The end goal is not just efficiency but the creation of a supply chain that adapts, evolves, and serves as a strategic asset in a competitive marketplace.

Ready to get started?

Join Data Analysts who use Super AI to build world‑class real‑time data experiences.

Request Early Access