About the Customer
The client is an FMCG major with three different categories of products: Food & Refreshments, Beauty & Personal Care, and Home Care. The client is one of the oldest multinational companies with sales in over 190 countries and a brand portfolio of over 400 brands. The annual turnover in 2019 was 52 billion Euros.
The Challenge
Inspired by UN’s Sustainable Development Goals, the client wanted to adopt and drive this transformational change in their business practice. The goal was to achieve sustainable business growth but not at the expense of the planet and its people.
Focusing on the immediate problems faced by the society such as climate change and plastic pollution, the client charted out three goals in the areas of Plastic Footprint and Recyclability as part of their sustainability initiatives. These include:
- To reduce the consumption of virgin plastic to 50% of their 2019 actuals by 2025
- To achieve 100% recyclability for all plastic consumed by 2025
- To use at least 25% PCR (Post Consumer Resin) as part of their plastic consumption by 2025
To proactively monitor these goals and take corrective action, a go-to dashboard was required to track all metrics in a snapshot view. In the as-is process, the KPIs were manually tracked, which was a tedious activity requiring multiple checks and validations. The objective was to automate this process and reduce the time taken in crunching the numbers by automating the KPI computation logic and standardize reporting for different business stakeholders.
The dashboard was expected to track high level metrics and generate insights in terms of identifying best performers by region (markets), category, and brand. The audience for this dashboard was the supply chain planning committee, for their quarterly review. Region and category teams were provided access to monitor performance for their respective segments.
The client was looking for an experienced partner for a swift upgradation of their Identity and Access Management (IAM) infrastructure where they could meet the business requirements for identity and access management, user provisioning/de-provisioning, managing privileged accounts, and providing updates using automated solutions or self-servicing capabilities with minimal intervention from the Identity and Access Management (IAM) support team.
Solution
As part of the engagement, Mindtree worked with the client to define the roadmap and delivered the dashboard built using Microsoft Power BI. The key challenge was to access authentic data to capture the recyclability metrics. It was decided to rely on the sales volume data to back-track and compute the corresponding plastic footprint and its associated recyclability metrics.
The recyclability data was cleansed and transformed by the R&D team and hosted on Azure cube. The Power BI dashboard was then connected to the Azure cube to source the base data.
The second challenge was KPI definition. Computation logic for the metrics was built and finalized in consultation with the client’s R&D team. Working with the business teams, the target definition for tracking performance was developed across categories and regions.
In terms of data security, role-based access was introduced. Users can only access data based on their role, as defined by the business.
In terms of the dashboard, it captured the following data points:
- Virgin Plastic Footprint
- Actual and Technical Recyclability Metrics
- PCR Consumed
Power BI’s in-built AI capabilities were utilized to generate insights on understanding the recyclability metrics better. For instance, the ‘Key Influencers’ feature helped in drawing out insights on packaging materials vs the recyclability percentage metric.
