Case Study

Certas Energy – Enabling a data-driven pricing approach to achieve greater yield and maximization on Azure



CERTAS ENERGY UK LIMITEDstarted trading in 2001 and pride themselves on excellent customer service and providing a range of energy products and services. They have an extensive and reliable delivery network compromising of more than 130 depots, over 900 tankers and 2,300 employees.

CertasEnergy's parent company, DCC, is an ambitious and entrepreneurial business, operating in 20 countries, and supplying products and services used by millions of people every day throughout Europe. It is headquartered in Dublin and is listed on the London Stock Exchange. DCC reported £14.8 billion in revenues and an impressive operating profit of £494.3 million in FY 2019-20.


The aim is to grow in a fiercely competitive market and a new approach to pricing is one of the key stands of the strategy.


  • Maximisation of margin with ongoing client sustainability
  • To create a whole operating model that improves:

Increased Quote to Order conversion rates

Long-term improved wallet share

Increase in material margin

Reduce client churn


Success would be to maximise yield and increase market share across this competitive market landscape.


Certas engaged with Mindtree to lead the collaboration with stakeholders and subject matter experts within Certas and Microsoft to provide consulting services on their Customer Segmentation Model catering to Price Optimisation, and subsequently to client demand.


  • Needed to be convinced of success factors, methodologies, analysis and illustrations of datasets. Overall, the output needed to be articulated within the stakeholder community, agreed and formalised within the final Scope of Work.
    • Analytical approach from the stated business problem had to be defined
    • The right techniques to use for the given analytical problem had to be identified
    • ML algorithms to solve the business problem needed to be employed
    • Azure tools had to be used effectively to prepare data for analysis
    • Coordination with the internal and external project stakeholders
    • Knowledge of one or more scripting language (Python) and big data analytics had to be demonstrated.
  • Needed the ability to weave a business problem from understanding it to solving it to EDA output walkthrough, model walkthrough and interpretation. Finally, decisions had to be suggested.
  • Improved in-house knowledge required in the task of transitioning to Azure
  • Knowledge transfer provided within 1-2-1 training and structured shadow-based learning interaction to allow Certas to become self-sufficient


The whole process was periodically reviewed, defined, and directed by the Certas SME, in conjunction with the Mindtree Consultants to achieve the desired business outcome which included:

  • To own the data science solution definition in a segmentation exercise, which caters to price optimisation in a manner that creates value for Certas through innovative model conceptualisation. This included:
  • Segmentation of customers and comparison with existing clusters
  • Customer profiling within the segments based on their behaviour
  • Refreshed clusters on the latest data available using the exact same variables used to re-create the legacy model
  • Implementation of the clustering model in the provided environment
  • Providing a summarized roadmap in the price optimisation journey
  • Providing notebooks and additional documents to support knowledge transfer and training. Focus on helping the Certas team acquire knowledge all the way through the process to leave them in a position to be able to continue building themselves
  • To position as a Hands-on-Data Science Advisor to Certas, and advising on various aspects of the solution by bringing in domain knowledge, familiarity of various techniques and expertise in a data-driven knowledge discovery exercise that creates the most appropriate and differentiated value
  • The outcome had to be efficient and effective at various levels of abstraction in communication. It needed to have the ability to relate to Certas’ business problems, playing it back to them to for verification, and ensuring that there is uniform understanding across stakeholders and teams. Additionally, the ability to present the findings of the assignment in a manner which is understandable to all, thereby laying the foundation for customer trust and knowledge transfer was needed
  • To provide data science solution leadership in the area of specialisation

Download Case Study to read more

Get in touch

Thank you for your submission. We'll be in touch.