TDS Archive

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

What is ESG Reporting?

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

--

An illustration of Environmental, Social, and Governance (ESG) reporting, showing three icons representing each component. The environmental section features a globe, the social section depicts hands holding people, and the governance section shows a group of people in front of a building. At the top is a circular ESG logo, symbolizing the integration of these three areas in corporate reporting. The image emphasizes the importance of data science in supporting companies’ ESG efforts.
What is ESG Reporting — (Image by Author)

Environmental, Social, and Governance (ESG) reporting is a method by which companies disclose their governance structures, societal impacts, and environmental footprint.

As a Data Scientist, how can you support your organization in improving its ESG score with analytics?

As stakeholders increasingly demand corporate social responsibility (CSR), ESG reporting has become critical to companies’ long-term strategies.

A visual representation of the three pillars of ESG. Each pillar is displayed in a separate colored house-shaped section. The “Environmental” pillar covers carbon footprint reduction, climate change strategy, waste reduction, and energy efficiency. The “Social” pillar emphasizes fair living wages, equal job opportunities, health and safety, responsible suppliers, and respecting labor laws. The “Governance” pillar focuses on corporate governance, risk management, compliance, ethical business.
ESG Pillars Presentation — (Image by Author)

In this article, we will delve into the details of ESG reporting to highlight its associated challenges and explore how data analytics can improve its accuracy.

Summary
I. Understanding ESG Reporting
1. What is ESG Reporting?
2. ESG Reporting supported with Data
II. Advanced Analytics for ESG Reporting
1. Lack of Standardization
2. Accuracy and Reliability of ESG Data
3. Fighting Greenwashing with Data Science
III. Data Science as a Game Changer
1. Sustainable Sourcing
2. ESG-Friendly Budget Planning
3. Supply Chain Network Optimization
4. Circular Economy for Fashion Industry
IV. Conclusion
Open the window on Business Intelligence and Sustainable Development Goals
1. Business Intelligence to Automate the Process
2. Beyond ESG, Towards Sustainable Development Goals (SDGs)

Automate ESG Reporting with Data Analytics

What is ESG Reporting?

ESG reporting is a form of non-financial reporting where organisations communicate their environmental performance (E), social responsibility (S), and governance structures' strength (G) to their stakeholders.

These three dimensions provide an in-depth understanding of a company’s sustainability and ethical impacts.

This image shows a high-level overview of ESG (Environmental, Social, Governance) reporting. Three sections are represented: the environmental section shows an icon representing the planet, the social section with an icon representing people, and the governance section with an icon of a building representing corporate governance. The ESG ($) indicator is shown in the middle, implying financial significance or considerations in relation to ESG factors.
Example of Reporting Categories — (Image by Author)

For instance, a company might report the

  • Carbon emissions of its supply chain (E)
  • Initiatives for community development (S)
  • Diversity of its board members (G)

Let’s look at this reporting from the data analytics point of view.

You are a data scientist in a fashion retail company.

ESG Reporting Supported with Data

We can consider a hypothetical global fashion retailer: I&N.

I&N is a fast fashion retailer that produces garments, bags, and accessories in factories located in Asia.

The diagram illustrates a supply chain flow, starting with product creation, followed by delivery to stores, collection of used items, and the recycling process. Recycled items return to the production process, completing the loop.
Supply Chain Network of I&N — (Image by Author)

Stores (located in Europe) are delivered from local warehouses that factories directly replenish.

I&N is committed to sustainable practices (circular economy, renewable energy) and aims to build trust with its stakeholders through transparency.

Therefore, it regularly discloses its ESG performance in its annual sustainability report.

In its latest report, I&N discloses several key ESG metrics.

I&N ESG Metrics — (Image by Author)

(E): For the environmental segment, I&N reports

  • The total greenhouse gas emissions (kg CO2eq)
  • The percentage of energy usage from renewable sources (%)

These indicators, which require advanced data processing, allow stakeholders to understand

  • The environmental footprint of the products sold.
  • The efforts to transition to cleaner energy sources.

How do measure these environmental indicators?

Product Life cycle assessment (LCA) is a data-driven methodology for evaluating environmental impacts from a product's perspective.

The idea is to analyze each process, from raw material extraction to product disposal.

A diagram that outlines the product lifecycle assessment (LCA) stages, from raw material extraction to product disposal, highlighting the environmental impacts. It includes stages such as cotton farming, manufacturing, transportation, warehouse storage, retail, and final product use and disposal. Each stage is accompanied by red downward arrows symbolizing energy or resource consumption, leading to environmental indicators like waste and CO2 emissions.
Life Cycle Assessment — (Image by Author)

For each process, we have a look at the

  • Consumption of natural resources, raw materials and energy
  • Emissions of pollutants and CO2
  • Waste generated

💡 For more details about these analytics solutions,

What about the social score?

(S): For the social component, the company details

  • The number of community development initiatives it has launched
  • An average employee satisfaction score indicates the well-being of its workforce.

How does our company disclose the average employee satisfaction score?

Organizations traditionally rely on surveys to obtain this metric, which can often yield subjective and biased results.

Therefore, I&N decided to use Natural Language Processing (NLP) and Social Sentiment Analysis to analyze text data from employee reviews on platforms like Glassdoor or internal communication channels.

Social Media Sentiment Analysis — (Image by Author)

It can also be used on social media.

ESG sentiment analysis is a valuable tool used by investors to track stakeholders' attitudes toward ESG issues and understand how these factors may impact a company’s stock price.

There are tools in the market that perform audits on social media and job platforms.

They employ advanced NLP techniques to obtain customers' and employees' perspectives on critical company topics.

(G): For the Governance domain, I&N discloses

  • The number of independent board members
  • The percentage of female representation on its board.

This helps auditors and investors assess the I&N’s commitment to fair and responsible governance.

Board Composition Analysis is a data-driven evaluation of board members' and management's diversity and experience.

This could be done by analyzing data linked to selected managers who are considered key to the company's strategy.

A table displaying a summary of five board members’ demographics, including Name, Age, Gender, Ethnicity, Tenure, and Background. The board members consist of three males and two females, with diverse ethnicities such as Caucasian, African, Hispanic, and Asian, and a range of backgrounds in Finance, Technology, and Legal.
Example of dummy data for Board Composition Analysis — (Image by Author)

For instance, visuals can be built to analyze workforce diversity using ethnicity distribution.

A donut chart representing board composition by gender, with percentages of 32% for male and 68% for female representation for the governance part of the ESG reporting.
Ethnicity Distribution Example — (Image by Author)

If I&N wants to promote gender equality, we can analyze the department distribution of male and female managers.

A bar chart comparing the distribution of male (blue) and female (orange) managers across different departments, with a larger representation of females in departments such as Technology, while Finance has a higher proportion of males.
Gender Distribution Example — (Image by Author)

These visuals help identify potential areas of improvement and make a strong case for diversity and inclusion, which is a key aspect of good governance.

In the next section, we will see how advanced analytics can help companies overcome the challenges of ESG reporting.

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

Advanced Analytics for ESG Reporting

ESG reporting can be complex due to the lack of standardization in reporting practices and the difficulties in ensuring data accuracy.

How can you support this effort?

Lack of Standardization

The first is the lack of standardized reporting frameworks, which can lead to inconsistencies in how different companies report their ESG performance.

For example, two companies may measure their environmental impact in completely different ways

  • Company 1 is a plastic toy manufacturer
  • Company 2 sells fresh fruits in convenience stores

These two companies report plastic usage reduction

  • -55% for company 2 by using carton packaging for some items
  • -10% for company 1 by changing the design of toys

Can you evaluate the effort and impact while the first company uses plastic as a raw material for its products?

No, we need standardization.

💡 How can data analytics support standardization?

  • Governmental entities can use databases of companies by industry and the environmental aspect of their products.
  • Automated data pipelines can extract, process and deploy standardized reports using data from different sources.

How do we ensure that data is reliable?

Accuracy and Reliability of ESG Data

Maintaining quality can be arduous, with data coming from many sources.

Business Intelligence (BI) provides capabilities to process and analyze large volumes of data from different systems to support ESG reporting.

  • Flat files from external suppliers, utility bills or operational files
  • Manufacturing data from factories’ management systems
  • Logistics and retail operations data from ERPs, WMS and TMS
A diagram illustrating the data flow for ESG reporting. At the center is a “Data Lake” receiving data from multiple sources: factory systems (production management, utilities bills, waste inventory), suppliers (quantity of cotton purchased, energy usage, emissions), and freight forwarders (routing data, fuel consumption). Data such as production output, energy and water usage, emissions, and waste generation are fed into the data lake, which produces reports and API outputs for further analysis.
Analytics Capacitibilities Needed for Life Cycle Assessment — (Image by Author)

In the example above, this data architecture is used to extract, process and store data to perform a Life Cycle Assessment.

The idea is to estimate the impacts of an item sold by

  • Linking production outputs quantity with energy and resource usage
  • Estimating CO2 and pollutant emissions from production to transportation
  • Including additional non-financial indicators from suppliers and logistic operations

The ultimate goal is to automate the calculation of ESG indicators along the life cycle of products from raw materials extraction to disposal.

💡 Additional Insights
This can also support the traceability of the data used for your report.

For instance, I have implemented a system using file hashing to prove that a data source (from a freight forwarder) has not been modified in the process of CO2 emissions calculations.

As you may be audited, it is important to show data sources and prove that results have yet to be manipulated.

What about companies that conduct fraud?

Fighting Greenwashing with Data Science

Greenwashing is making misleading claims about a product's environmental benefits to communicate a false image of sustainability.

Five sins of greenwashing — (Image by Author)

Organizations use this dishonest practice to create a false impression of environmental responsibility.

However, data analytics can be a significant boost to automate fraud detection by using

  • Publicly available data in sustainability reports, social media
  • Advanced analytics models, including NLP, forecasting or statistical models for fraud detection

💡 For more details about data analytics,

We can bring harmonization and detect frauds with analytics.

Can we support companies’ transformation?

Data Science as a Game Changer

Beyond measuring and reporting, these technologies can help your organization use the data generated by systems to get

  • Prescriptive insights to support decision-making: select a supplier, budget allocation, supply chain network design
  • Predictive analytics to help firms anticipate and mitigate future ESG risks

Have you heard about linear programming?

Example 1: Sustainable Sourcing

This is the process of integrating social, ethical and environmental performance factors when selecting suppliers of products or services.

Three factories compared on three environmental factors: water usage, waste management, and CO2 emissions. Each factory is rated with stars on each factor, with one to five stars used for evaluation. The visual represents sustainable sourcing considerations for supply chain optimization, highlighting differences in supplier environmental performance used for sustainable sourcing with Python.
Use Data to Assess Your Suppliers — (Image by Author)

For each supplier, I&N has a set of scores measuring

  • Usage of natural resources (water, cotton)
  • Pollutants and CO2 emissions
  • Social and governance compliance

With advanced analytics, you can automate the full process of

A simplified flow of collecting, auditing, and selecting suppliers based on environmental and social performance metrics. Key metrics include CO2 emissions, water and energy usage, and waste generation. The diagram also shows auditing processes and supplier selection criteria based on performance scores used for sustainable sourcing.
Select a supplier in three steps — (Image by Author)
  • Collection of data from suppliers
    Example: sustainability KPIs (CO2, natural resources, Environmental Footprint), social and governance indicators
  • Suppliers' assessment based on ESG and business indicators
    Example: fixed and variable costs, quality, social responsibility
  • Decision-making using linear programming
    Example: decide the set of suppliers that minimize the profit while respecting minimum levels of ESG scores

This is a real game changer as it can help procurement teams align their sourcing strategy with the company's ESG roadmap.

💡 For more details about analytics for sustainable sourcing,

Help the decision-making with linear programming.

Example 2: ESG-Friendly Budget Planning

Linear programming can also help you direct your investments in projects that will help support the company’s ESG roadmap.

Let us imagine the budget allocation scenario of an international logistics company.

A Regional Director receives budget applications from 17 warehouse managers for projects impacting the next three years.

Table comparing four logistics projects (electric trucks, voice picking, space rental, and rack sprinkler) with amortization costs over three years, direct ROI, and non-financial benefits such as CO2 cuts, productivity, business opportunities, and regulatory compliance. The image highlights project costs, ROI, and alignment with the company’s long-term strategy for CAPEX decision-making.
Example of Budget Planning for a Logistics Company — (Image by Author)

For each budget application, the manager includes

  • A description of the project (equipment purchase, renovation, …)
  • Yearly budget for the next three years
  • Return On Investment = (Cost Reduction + Additional Turnover) — (Total Cost)
  • Additional benefits impacting business development, productivity or ESG indicators

Our director must decide which project(s) to allocate her budget based on the financial aspect (ROI) and ESG criterion.

How to maximize the Return On Investment while meeting ESG requirements?

With linear programming, we can automate selecting the projects that will maximize the ROI while respecting constraints on CSR, HSE or sustainability.

Diagram comparing financial and non-financial objectives in budget planning. Financial objectives include maximizing ROI through increased revenue and controlled CAPEX costs. Non-financial objectives cover areas like health and safety, corporate social responsibility, operational excellence, business development, digital transformation, and sustainable development. The image emphasizes balancing financial returns with broader company goals.
Decision-Making Process — (Image by Author)
  • Parameters: boolean values for each project (1: selected, 0: not selected)
  • Constraints: business development and ESG benefits
  • Objective function: maximize the ROI

By putting the ESG targets set by the top management, our director can ensure that the projects selected will support the company’s long-term strategy.

💡 For more details about ESG-friendly budget planning,

Do you need a supply chain optimization app?

Example 3: Supply Chain Network Optimization

A great way to improve your ESG score is to boost your green and ethical transformation.

Sustainable supply chain optimization is an exciting approach that combines cost-effectiveness with sustainability.

A global map showcasing market demand (Units/Month) in regions like Brazil, USA, Germany, and India, alongside low and high capacity manufacturing sites. The diagram includes environmental footprints such as CO2 emissions, water usage, and waste generated for each country. It highlights the balance between cost efficiency and sustainability in supply chain optimization. The user is prompted to start with data input.
Sustainable Supply Chain Optimization Problem — (Image by Author)

You have,

  1. Demand for each market location in (Units/Month)
  2. A set of potential manufacturing sites with different production costs, environmental impacts, social and governance scores
  3. Constraints on environmental footprint per unit, social and governance scores

What is the most sustainable (and economically viable ) combination?

With advanced analytics, you can design a tool to test several scenarios

  • What if I want to minimize costs?
    Can I meet my ESG targets?
  • What if I want to minimize CO2 emissions?
    Can I keep my profitability level?
A global supply chain diagram illustrating three objective functions: minimizing total costs (fixed, variable, and freight), minimizing emissions (production and transportation), and minimizing resource usage (water, energy, and waste). Three maps show potential production routes depending on the objective selected, with a progress bar directing towards results analysis and solutions.
Compare different scenarios — (Image by Author)

I have implemented such a model on a web application deployed online:

  1. Upload your market demand data (Units) per Market
  2. Add your manufacturing footprint data: factories by location with (costs, CO2 emissions, resources Usage and Social Scores)
  3. Select the objective function: minimize the cost, CO2 emissions or resource usage
Three maps compare an initial solution for supply chain optimization with additional constraints for energy and water usage, and CO2 emissions. Each solution is shown alongside a Sankey diagram visualizing the distribution of products per country. The solutions with added constraints show a 12% and 18% increase in costs respectively, emphasizing the trade-offs between sustainability and cost for sustainable supply chain optimization.
Three scenarios with different objective functions — (Image By Author)

You can quickly switch from one objective to another to decide the most viable solution.

💡 If you want to try this tool, I have shared a POC accessible online

Sustainable Supply Chain Optimization App — (Image by Author)

Have you heard about circularity? Reuse or rent instead of wasting.

Example 4: Simulation of a Circular Economy

A circular economy is an economic model that aims to minimize waste and maximize resource efficiency.

A diagram showing a rental process for fashion items. On the left, a garment is displayed, and on the right, the process is depicted in a timeline. Day 1 indicates the start of the rental, with the item being collected from a store. Day 14 marks the return of the garment by the customer. The circular economy model focuses on renting garments to reduce waste.
Subscription model of a circular economy — (Image by Author)

Some companies have implemented a subscription model where customers pay a regular fee to access a product or service for a specific period.

A customer would like a dress for 2 weeks

  • The dress can be picked up at a store
  • The item is used for two weeks
  • The customer returns the item that is then collected
  • After collection, the item is inspected and cleaned before shipping it back to the store
A diagram representing the parameters of a circular economy model for fashion. Number of stores are shown, receiving leadtime clothing items from a central warehouse. The returned items are cleaned and inspected, then redistributed for further rentals, representing the reuse and recycling process to minimize waste.
Parameters for the case study — (Image by Author)

Thus, a dress manufactured 1 time can be used by several customers.

By how much can we cut CO2 emissions using this model?

I developed a simulation model based on sales data that estimated the CO2 savings for different rental periods.

A bar chart comparing CO2 emissions reductions for different rental periods (2, 7, 14, and 28 days). The green portion of the bars represents the emissions from circular (reused) garments, while the red represents new items. The line graph superimposed shows a decline in total emissions as the rental period increases.
Results of the study — (Image by Author)

The results are astonishing,

  • -75% of reductions for short rental periods
  • Long rental periods affect the efficiency of the network

💡 For more details about this study,

These examples gave you an idea of how data analytics can help you improve ESG reporting and reach the targets fixed by your top management.

Conclusion

As ESG reporting becomes increasingly prevalent, the role of data analytics in enhancing its accuracy and efficiency is set to grow.

The future may see the development of advanced solutions tailored specifically for ESG reporting.

How can you automate data collection and processing?

Business Intelligence to Automate the Process

Business Intelligence is a process that leverages software and services to transform data into actionable intelligence supporting decision-making.

A visual representation of the Business Intelligence (BI) process in five steps for automating data collection and processing for ESG reporting. Each step is symbolized by icons above the steps: Step 1 shows data input, Step 2 involves data storage, Step 3 features data processing and validation, Step 4 focuses on reporting and analytics, and Step 5 depicts data sharing and communication of the results. This visual aims to demonstrate the systematic approach of using BI for efficient ESG report.
Business Intelligence in 5 Steps — (Image by Author)

These solutions could automate the ESG reporting process, from data collection to analysis and decision-making.

💡 For more information

By leveraging these tools, companies can improve their ESG reporting and gain valuable insights to drive their sustainability strategies.

Beyond ESG, Towards Sustainable Development Goals (SDGs)

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

Illustration of the five categories of Sustainable Development Goals (SDGs) established by the United Nations. The icons represent various aspects such as social equality, environmental sustainability, economic growth, peace and justice, and partnerships for the goals. These categories are linked to data-driven strategies for sustainable initiatives.
17 goals that can be grouped into 5 categories — (Image by Author)

Integrating these goals into our operational frameworks is a moral imperative and a great opportunity to boost innovation and efficiency.

Visualization highlighting five data analytics methodologies: Geo-Data visualization for demand hotspots, Graph Theory to analyze supply-demand connections, Network optimization using linear programming, Routing for truck allocation, and Last-mile delivery cost optimization. Each methodology is associated with sustainability goals in logistics and supply chain management
Advanced Analytics Tools for People-Oriented Initiatives — (Image by Author)

With data analytics, we can support the design and implementation of initiatives that support these 17 goals and will boost your ESG score.

To dive into my insights about how Data Analytics can support it,

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.

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

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

--

--

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.

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