TDS Archive

An archive of data science, data analytics, data engineering, machine learning, and artificial…

Leveraging Data Analytics for Sustainable Business Transformation

Samir Saci
TDS Archive
Published in
12 min readMar 22, 2023

--

A hierarchical diagram displaying obstacles to sustainability in four key areas of organizations: Structure and Governance, Process and Metrics, Culture and Leadership, and Method and Skills. Each section includes a related quote, such as ‘Sustainability is not in our agenda’ and ‘We don’t have the tools to measure and reduce our footprint.’ At the top, a symbol represents the overarching challenge of integrating sustainability.
(Image by Author)

Financial regulations now push companies to commit to carbon reduction roadmaps by 2030.

How can data analytics help organizations overcome sustainable supply chain management obstacles?

However, scaling green initiatives and achieving sustainability goals can be challenging for organizations.

A diagram illustrating a sustainable supply chain workflow. The diagram shows the interaction between the factory, warehouse, and store. It depicts how data flows between replenishment orders, sales data, and delivery orders. The factory sends replenishment orders to the warehouse, which then prepares the order for delivery to the store. Sales data is transmitted back from the store to the warehouse and factory.
Defining a supply chain as multiple parties exchanging material and information flows — (Image by Author)

The main challenge is that Supply Chain Management is at the core of a complex system involving manufacturing and logistics teams.

An illustration showing various roles in the supply chain, including workers at the factory, warehouse, and store, as well as transportation personnel. The image highlights the interconnected teams working together across different parts of the supply chain, from manufacturing to logistics to retail distribution.
Different teams focused on optimizing their operational scope within the supply chain — (Image by Author)

Since these teams are only sometimes accustomed to working together towards a common goal, many companies are stuck at the beginning of their green transformation.

How do we unlock these situations using data analytics?

The Harvard Business Review article “How Sustainability Efforts Fall Apart?” delves into companies' common challenges when implementing sustainability initiatives.

This article will explore how data analytics can help overcome these challenges by focusing on the four “hidden enemies” of your supply chain sustainable transformation.

Summary
I. How Sustainability Efforts Fall Apart?
1. The "Four Hidden Enemies"
2. Support of Supply Chain Analytics
II. Leveraging Data Analytics
1. Hidden Enemy 1: Structure and Governance
Solution 1: Descriptive Analytics
2. Hidden Enemy 2: Processes and metrics
Solution 2: Adapted Optimization Models
3. Hidden Enemy 3: Culture and Leadership
Solution 3: Diagnostic Analytics to Address Cultural Barriers
4. Hidden Enemy 4: Methods and Skills
Solution 4: Workforce Training
III. Conclusion
1. Data is your best ally
2. Drive an ESG-led Business Transformation

How Sustainability Efforts Fall Apart?

The “Four Hidden Enemies” of the Green Transformation

Sustainability has become a critical aspect of business operations as companies face mounting pressure to address environmental and social issues for their ESG reporting.

However, implementing a roadmap for carbon footprint reduction and effective sustainability initiatives is often easier said than done.

The article “How Sustainability Efforts Fall Apart” sheds light on the key barriers that companies face in their pursuit of sustainability, focusing on four “hidden enemies”:

  • Structure and Governance: Siloed sustainability limits influence.
  • Processes and Metrics: Unsustainable metrics hinder progress.
  • Culture and Leadership: Old mindsets challenge transformation.
  • Methods and Skills: Traditional tools obstruct change.
A diagram showing the four key barriers, labeled as “hidden enemies,” that obstruct green transformation efforts in businesses. The diagram highlights four categories: “Structure and Governance,” “Processes and Metrics,” “Culture and Leadership,” and “Methods and Skills,” each represented with a corresponding icon. The diagram emphasizes that sustainability challenges include siloed sustainability efforts, unsustainable metrics, outdated mindsets, and traditional tools that hinder carbon reducti
The Four Hidden Enemies of Your Green Transformation — (Image by Author)

Have you heard about Supply Chain Analytics?

Support of Supply Chain Analytics for Sustainable Initiatives

A Supply Chain can be defined as several parties exchanging flows of material and information to fulfil a customer request.

A supply chain flowchart illustrating the journey from production planning to delivery at a store. The process begins with production planning at the factory, continues through the warehouse with replenishment orders, and concludes with the delivery to the store. The chart uses icons of factories, warehouses, trucks, and stores, accompanied by digital document icons representing the flow of data (e.g., production planning, replenishment orders, sales data, delivery orders).
Defining a supply chain as multiple parties exchanging material and information flows — (Image by Author)

In a previous article, Supply chain Analytics was introduced as a set of tools that help companies use systems-generated data to gain insights and optimize their operations.

What are the different types of analytics?

A horizontal flowchart illustrating a process with four categories, each represented by an icon. The categories are: “Data Collection” (represented by a bar chart), “Data Analysis” (magnifying glass over gears), “Data Visualization” (a graph icon), and “Data Validation” (a checklist icon). Each step represents a different stage in leveraging data analytics for decision-making, with the goal of supporting sustainability initiatives.
Discover the four Types of Supply Chain Analytics — (Image by Author)

It can also be a great support to address the obstacles listed above:

  • Descriptive Analytics by providing visibility with a single source of truth across the supply chain
  • Diagnostic Analytics by deploying automated incident root cause analysis processes
  • Predictive Analytics by supporting the forecast of customer demand, supply capacity and CO2 emissions volumes
  • Prescriptive Analytics by helping the decision-making process towards resource optimization

In the following sections, we’ll explore each ‘hidden enemy’ in detail and explain how data analytics can help overcome these challenges.

🏫 Discover 70+ case studies using data analytics for supply chain sustainability🌳and business optimization 🏪 in this: Cheat Sheet

Leveraging Data Analytics for a Green Transformation

Hidden Enemy 1: Structure and Governance

The siloed nature of organizational structure can prevent effective collaboration for sustainability.

Indeed, sustainability has often been relegated to a separate company department, leading to its isolation from key corporate functions.

This restricts sustainability from transforming the entire organization and limits its power and relevance within the company.

A flowchart with icons of supply chain roles: a factory worker next to a factory, a warehouse worker by a warehouse, a transport worker with a truck, and a store worker by a store. It represents the stages of the supply chain from production to store delivery, highlighting the involvement of different teams
The impact of siloed optimization on sustainability efforts in supply chain management — (Image by Author)

An operational manager will always focus on her scope of operations:

  • Store managers keep low quantities per order (and increase the frequency) to minimize their inventory
  • Supply planners push for more production batches (with low quantities per batch) to get enough flexibility
  • Finance managers always encourage inventory reductions
  • Commercial teams advocate for high inventory coverage to avoid lost sales due
  • Warehouse operations have to deal with these constraints

Who is in charge of CO2 emissions reductions? Everybody should be, but in reality no one.

This lack of collaboration significantly impacts the efficiency of transportation and production planning, hindering the progress of sustainability efforts.

What if we optimize the collaboration between sales and supply chain?

For more details, you can check

Example of Green Inventory Initiative — (Image by Author)

Therefore, sustainability is seen as a nice-to-have or a marketing tool that affects the performance of each team.

First, let’s measure the actual performance of the entire value chain.

Solution 1: Descriptive Analytics

An end-to-end approach is needed to be more efficient and find the right balance that will lead to a minimal environmental footprint.

Numbers don’t lie, people do.

— Ernie Lindsey

By connecting to the different systems (ERP, WMS, CRM, …), descriptive analytics solutions can build a central source of truth across the supply chain.

📊 Example 1: Life Cycle Assessment

A flowchart showing resources used (electricity, fuel, materials) at different stages of the supply chain, such as production, transportation, storage, delivery, and store sales. Below each stage, there are icons indicating waste generated and CO2 emissions at each step, highlighting the environmental impact of the entire product life cycle.
Evaluating the environmental impact of products throughout their life cycle — (Image by Author)

Life cycle assessment (LCA) is a method of evaluating the environmental impacts of your products over their entire life cycle.

A diagram connecting various business systems (PMS, WMS, TMS, ERP & CRM) to stages in the product life cycle, such as production, material extraction, transportation, storage, delivery, store sales, product usage, and disposal. Arrows represent the flow of data, such as master data, logistics, and sales information, across systems and life cycle stages.
Type of data used — (Image by Author)

In our example, it can be used to estimate the footprint of your products considering end-to-end supply chain processes.

A flowchart showing the different environmental impacts at each stage of a product’s life cycle, including cotton cultivation, production, transportation, and usage. Each stage is represented by icons, with associated energy, water, fuel usage, and CO2 emissions indicated by symbols for each environmental factor.
Analyzing emissions and resource usage across the supply chain for sustainability insights — (Image by Author)

And identify hotspots to provide data-backed diagnostics across the supply chain to break silos and promote collaboration.

  1. Total CO2e emissions per unit become a common KPI for all teams.
  2. This KPI can be included in all managers' performance reviews.

Store Manager: If I reduce my order frequency, the transportation team can optimize truck loading.

This will encourage collaboration to support cross-functional initiatives led by sustainability teams.

If you can’t measure it, you can’t manage it.

— W. Edwards Deming

Because these metrics are built from a trusted data source, managers will be more proactive in reducing emissions.

We can set a common objective of emissions reductions for the whole supply chain department.

A flowchart illustrating CO2 emissions reductions through supply chain optimization. The top section shows increasing quantities per order and reducing order frequency as key strategies. The middle section displays supply chain stages: fewer production runs (reducing CO2 emissions from production) and better truck filling rates (reducing CO2 emissions from transportation). The final section combines these efforts, indicating global CO2 emissions reductions as a result of these optimizations.
Implementing data-driven collaborative actions for sustainable supply chain transformation — (Image by Author)

For example,

  1. We want to reduce the overall CO2 emissions per unit produced by 20%
  2. 45% of emissions are coming from transportation and production
  3. Store managers will cut their order frequency by two
  4. Supply planners will increase their replenishment order quantity and reduce the frequency
  5. Transportation teams must provide adapted truck sizes
  6. Manufacturing teams will reduce the number of production runs

If you need an example of the application of this methodology, 👇

Great! What’s next?

While descriptive analytics can help break down silos, traditional processes and metrics may still represent significant obstacles.

This leads us to the next hidden enemy.

Hidden Enemy 2: Processes and Metrics

Sustainability is rarely integrated into companies’ core business processes.

They were designed in an era where profit was the primary concern, and environmental and social factors were not considered.

A simple illustration showing the stages of a supply chain: a factory, a warehouse, a delivery truck, and a retail store. Each icon represents a key stage in the production and delivery process, from manufacturing to final store delivery. The image supports a discussion on how traditional business metrics often prioritize cost over sustainability efforts.
Common business and operational KPIs in supply chain management — (Image by Author)

Indicators used to assess business performance are usually linked with cost, profit, market share or earnings per share.

An Operation manager to the sustainability team: “How could I help you to reduce the CO2 footprint?! I am already struggling to minimize my transportation costs.”

Therefore, traditional metrics can neutralise sustainability initiatives by prioritising short-term financial gains over long-term environmental benefits.

What if we switch the objectives functions?

From minimising costs to minimising CO2eq emissions.

Solution 2: Adapted Optimization Models

By incorporating sustainability metrics into existing business processes, companies can develop balanced optimization models considering financial and non-financial objectives.

With the help of optimization tools, continuous improvement engineers can improve processes towards optimal solutions that balance profit with sustainability.

What is the optimal factory network to balance costs and sustainability?

The objective is to find the correct parameters to optimize a specific metric considering external and internal constraints.

Global map illustrating market demand, supply capacity, and environmental sustainability by country. Icons represent manufacturing sites, market demand in units per month, and the environmental footprint for each country, including CO2 emissions, waste generated, and energy usage. Text at the bottom asks what is the best combination of manufacturing sites to meet demand at the lowest cost with a limited environmental impact.
Sustainable Supply Chain Network Problem Statement — (Image by Author)

📊 Example 2: Sustainable Supply Chain Network Optimization
Supply chain optimization uses data analytics to find an optimal combination of factories and distribution centres to meet customers' demands.

Should we produce in Brazil or Portugal to minimize water usage?

In this classic linear programming problem, your model will select the correct set of production facilities.

  • Respect the demand constraints: factories' supply should meet the market’s demand.
  • Minimize the total costs of producing and delivering products

This will usually select factories in remote areas where production costs are lower, considering the weight of transportation costs.

What if we want to minimize the total CO2 emissions?

Two global maps showing the flow of products from manufacturing sites to markets. One map focuses on minimizing production and transportation costs, while the other focuses on minimizing emissions. Constraints such as market demand and production capacity are considered. The objective is to minimize costs or emissions.
Comparing cost-based and CO2-based supply chain optimization approaches — (Image by Author)

On the right, we propose to use the same model with an adapted objective function that minimises total carbon emissions.

Two global maps representing different supply chain routes for low-carbon solutions. Green and red lines connect factories to retail stores, highlighting the flow of goods and the reduction of CO2 emissions for more sustainable supply chain routes.
Supply Chain Network Designs for low-cost solution versus low carbon solution — (Image by Author)

With this simple change, we have entirely transformed the network.

The low-carbon solution pushes for the localization of production by adding factories to the European market.

A balanced approach is possible to keep business competitiveness.

You can adapt your objective function or add constraints to keep costs under a certain threshold.

I have implemented this approach in a ready-to-use application, 👇

However, as discussed in the following hidden enemy, old mindsets and habits can still be significant barriers to change.

Hidden Enemy 3: Culture and Leadership

Old mindsets and habits can be significant barriers to change.

When the leadership and operational teams are not aligned with sustainability and green transformation goals, efforts can be met with resistance or indifference.

Three images representing different stages of pallet handling for clothing items. The first image shows a full pallet with boxes stacked in layers. The second image depicts the removal of a portion of the pallet, showing clothing items placed for shipment. The third image illustrates the pallet wrapped and ready for shipping, with a pallet jack and stretch wrapper machine. Icons of clothing, including T-shirts, are used to symbolize the packed products.
The unloading process of heterogeneous pallets and its environmental impact — (Image by Author)

Across the organization, we can find misaligned values that can hinder the adoption of green supply chain practices.

For example, here is an example seen in a project with a FMCG company

  • Factories are sent to the warehouse pallets with multiple references inside (heterogeneous pallets) because it’s easier for them.
  • The warehouse receiving team has to remove the plastic film, sort the items, repalletize them, and wrap them again.

This creates additional work, increases film consumption and generates waste.

Therefore, fostering a supportive organizational culture and strong leadership committed to sustainability is crucial.

Solution 3: Diagnostic Analytics to Address Cultural Barriers

Diagnostic analytics focuses on identifying the causes of specific past events or trends.

It involves examining historical data to determine the factors contributing to a particular outcome.

The sustainability team to factory’s logistics manager: “According to our diagnostic tool: we have 2 tons of additional film consummed per year because you mix items in the same pallet.”

These tools can help your organization understand the reasons behind failures using an objective external assessment.

📊 Example 3: Supply Chain Control Tower
A supply chain control tower is traditionally defined as a set of dashboards connected to various systems using data to monitor critical events across the supply chain.

A timeline comparison of the actual process with yellow checkpoints against a maximum lead-time process with green checkpoints. The top timeline shows various stages of a process happening on the same day, extending over two days, while the lower timeline shows the maximum allowed lead time with fewer checkpoints.
Utilizing a supply chain control tower for efficient distribution network management — (Image by Author)

If you take the example of the monitoring of a distribution network for a fashion retail company,

  • The performance metric is On-Time-In-Full, also called OTIF
  • Diagnostic algorithms conduct root cause analysis to understand who is responsible for delays
A comparison of an actual timeline against a target timeline. The actual timeline has yellow, red, and green checkpoints indicating process delays, with red circles representing critical delays, while the target timeline has white checkpoints with no delays.
Late delivery root cause analysis process using data analytics— (Image by Author)

The idea is to compare the actual lead time per process and the targets set by service level agreements.

For more details,

Can we implement a sustainability control tower?

This approach can be easily adapted to environmental footprint monitoring

  1. Choose the metric to follow: for instance, CO2 emissions
  2. Set a target of emissions per process: for example, 160 (g CO2e/unit) for warehouse replenishment from factories
  3. Compare the actual emissions versus the target using the LCA approach

Root Cause Analysis process to spot the deviations, but additional analyses will be required to find the root cause.

Coming back to our wrapping film example, we would have

  1. A deviation in the consumption of wrapping film in the warehouse
  2. Explanations of the operational teams: “It is due to the depalletization of heterogeneous pallets.”
  3. The final root cause is the palletization method of factories

Having addressed the cultural barriers, we can focus on the methods and skills needed to drive a green transformation.

Hidden Enemy 4: Methods and Skills

Traditional tools and skill sets need to be improved to manage the complexity of sustainability initiatives.

A lack of expertise in using analytics can hinder organizations from leveraging data to optimize supply chain processes and make data-driven decisions for sustainability and green transformation.

Solution 4: Workforce Training

It’s not directly tied to a specific type of analytics but indicates the need to equip employees with the necessary skills to leverage data analytics in their roles.

Companies can build a workforce prepared to drive sustainability initiatives by providing access to analytics tools with training programs.

For example, I share my experience learning Python and VBA for Supply Chain Analytics in this short tutorial. 👇

What’s next?

I hope this quick review of the hidden enemies and the solution against them convinced you about the power of data to drive green transformations.

Conclusion

Data is your best ally.

Data analytics can be a powerful ally in overcoming the “hidden enemies” that block sustainability initiatives.

For each enemy, we found solutions using data analytics.

These different types of supply chain analytics can help corporations to break down silos to ensure that all departments move towards footprint reductions.

A green infographic showing four types of supply chain analytics for sustainability: Descriptive, Diagnostic, Predictive, and Prescriptive. Descriptive asks ‘How much CO2 emissions last year?’ with 72k Ton of CO2. Diagnostic asks ‘Why emissions increased by 20%?’ with the answer being Air Freight Transportation increased. Predictive asks ‘What will emissions be next year?’ with a 10% increase predicted. Prescriptive asks ‘What should we do?’ with a suggestion to deliver US customers from Canada.
Four type of Supply Chain Analytics for Sustainability — (Image by Author)

For more case studies of data analytics used for supply chain sustainability, you can have a look at this article 👇

impact of your initiatives?

Drive an ESG-led Business Transformation

All these initiatives can positively impact your ESG score.

The environmental, social, and governance (ESG) reporting method discloses companies' governance structures, societal impacts, and ecological footprint.

Image showing the three pillars of ESG: Environmental, Social, and Governance. The Environmental pillar includes carbon footprint reduction, climate strategy, waste reduction, and energy efficiency. The Social pillar features fair wages, equal opportunities, health and safety, responsible suppliers, and labor law compliance. The Governance pillar covers corporate governance, risk management, compliance, ethical business practices, and accounting transparency.
ESG Pillars Presentation — (Image by Author)

These three dimensions provide an in-depth understanding of a company’s sustainability and ethical impacts that can be improved with data-driven initiatives.

A breakdown of the ESG components: Environmental, Social, and Governance. The Environmental icon shows Earth with a downward arrow symbolizing reduced carbon emissions. The Social icon displays hands holding people, representing social equity. The Governance icon depicts a boardroom with people, signifying corporate governance and ethical oversight.
Example of Reporting Categories — (Image by Author)

Considering that these reports are strategic, convincing your top management to invest in green initiatives is an effective way.

How do we use analytics to generate this report?

I propose several tools and methodologies to extract and process data to generate this scoring in the article linked below.👇

Why do we do that? […]

Have you heard about Sustainable Development Goals?

The Sustainable Development Goals (SDGs) are a set of 17 objectives established by the United Nations to address global challenges.

The image depicts four icons representing key aspects of sustainable development. The first icon represents a diverse group of people, symbolizing social inclusion. The second is a globe, signifying environmental protection. The third is a chart with rising arrows and money, symbolizing economic growth. The fourth shows a dove, representing peace, and the fifth a handshake, illustrating partnerships. This aligns with the United Nations’ Sustainable Development Goals (SDGs).
5 categories of Sustainable Development Goals — (Image by Author)

As a data scientist, how can you help your company contribute to these goals?

Look at my insights about how Data Analytics can support the United Nations’ Sustainable Development Goals in this article,

About Me

Let’s connect on Linkedin and Twitter. I am a Supply Chain Engineer who uses data analytics to improve logistics operations and reduce costs.

For consulting or advice on analytics and sustainable supply chain transformation, feel free to contact me via Logigreen Consulting.

If you are interested in Data Analytics and Supply Chain, look at my website.

💡 Follow me on Medium for more articles related to 🏭 Supply Chain Analytics, 🌳 Sustainability and 🕜 Productivity.

💌 New articles straight in your inbox for free: Newsletter
📘 Your complete guide for Supply Chain Analytics: Analytics Cheat Sheet

References

  • “How Sustainability Efforts Fall Apart?”, Harvard Business Review, Elisa Farri, Paolo Cervini, and Gabriele Rosani

--

TDS Archive
TDS Archive

Published in TDS Archive

An archive of data science, data analytics, data engineering, machine learning, and artificial intelligence writing from the former Towards Data Science Medium publication.

Samir Saci
Samir Saci

Written by Samir Saci

Top Supply Chain Analytics Writer — Case studies using Data Science for Supply Chain Sustainability 🌳 and Productivity: https://bit.ly/supply-chain-cheat