Project Description
The growth insights project
dsm-firmenich is a global, purpose-led, science-based company active in Nutrition, Health, and Sustainable Living. With 150+ years of innovation heritage, the company has employed more than 30.000 people in 50 countries. dsm-firmenich’s scientific expertise and innovation power are answering some of the world’s biggest challenges.
dsm-firmenich started a data science center of excellence where top data scientists discover and act on new business opportunities. Telli van der Lei and Rob den Rooijen are part of the center since its early days. They are the drivers behind a project started in 2020 to use vast amounts of data, to empower the global commercial organization of the Human Nutrition business unit to identify and implement sales opportunities. Due to the project’s size, they asked Conclusion Intelligence to supply additional technical expertise during this project.
Our team of Data Scientists helped create an interactive tool with an intuitive UX in the form of a Power BI dashboard, accessible to all human nutrition Sales and Account Managers across the globe. This dashboard provides users with the latest insights regarding sales opportunities with existing and new customers as well as trends in relevant markets. Within a few weeks, the dashboard helped to discover opportunities that led to a multi-million increase in sales! It is worth noting that the dashboard was ranked as the 3rd most used within the entire company. During the development of this BI tool, our team assisted dsm-firmenich with:
- Data engineering & acquisition
- Data modeling
- Data mining
- Dashboarding with Power BI
Theme
Market Insights
Sector
Chemical industry
Customer
dsm-firmenich
The concept
The idea is to provide Sales and Account Managers worldwide with a tool that harmonizes internal and external data, presents it in a unified way, contains interactive functionalities to enable sales validation, and integrates with existing processes and tools to execute on the validated opportunities. Such a tool reduces the amount of time spent in manually creating one-time reports and analysis, thereby ensuring a higher standard of data quality.
The challenge
Creating this tool for global organizational units was challenging due to varying regional requirements and data. We built a data model to capture key dimensions for each region and developed a dashboard that allows users to explore data at their preferred level of detail. To measure its impact, we connected the tool to their internal CRM, which tracks sales actions, and linked this data back to the dashboard. This setup lets users update the dashboard while using familiar tools. Finally, the tool needed regular updates, data quality checks, and a simple maintenance process for after the project ends.
“Due to the COVID-19 pandemic, this was the first project ever where we never met face to face. The team provided by Conclusion Intelligence was a perfect fit with our experts. Thanks to the proactive attitude, we have been able to deliver in an agile way and enabled sales to achieve great business value.” Telli van der Lei and Rob den Rooijen, dsm-firmenich
Techniques and technologies
The project’s success prompted dsm-firmenich to upscale the Conclusion Intelligence team from two to five Data Scientists. The success stems from a global collaboration between Conclusion Intelligence, dsm-firmenich’s technical experts and Product Owners from various countries. To provide the best possible solution, we have used the following technologies and techniques during the project:
- Redshift
- Python
- Microsoft Flow and PowerApps
- PowerBI
- SQL
Future outlook
dsm-firmenich wanted to actively involve the end-users during the development to get them accustomed to the new data and system before moving on to more advanced topics. Trust has been built and engagement rates are high, so other exciting Data Science functionalities and predictive analytics will be added now. The project has created a fruitful foundation for long-term collaboration. We are excited!
Result
- Together with dsm-firmenich we managed to create an interactive BI tool in the form of a Power BI dashboard that is used worldwide by hundreds of users.
- New businesses worth millions of dollars can be rapidly identified.
- The dashboard was in the top 3 most used dashboards in the company.
- It is fully automated; the refreshes are automated so that DSM-Firmenich can do the maintenance themselves.
- Both Conclusion Intelligence & dsm-firmenich have learned best practices from each other.
- The most exciting part is that we looped everything together. E.g., when users spot an opportunity in the dashboard, they can provide feedback on it, which is then included in the dashboard and their internal systems. It allows the dashboard to provide a measurable added-value.
Want to see more?
OUR SUCCESS STORIES
Need more information?
LET’S TALK!
Unlock the potential of Data & AI to drive smarter decisions, optimize operations, and enhance customer interactions. Whether you like to discuss your idea or need help finding you a solution that fits your needs.
You are currently viewing a placeholder content from HubSpot. To access the actual content, click the button below. Please note that doing so will share data with third-party providers.
More Information