In support of their development and growth across Canada, Lindt recognized the need for improved business intelligence and data-driven decision-making and became an IBM Cognos customer over 20 years ago. Although Lindt’s usage of Cognos has significantly evolved over the years, they have primarily focused on developing analytics solutions for their sales and marketing functions. After a recent review of their use of analytics throughout the organization, it was clear that the supply chain team had been underserviced. John Walter, IT Director at Lindt Canada says, “the supply chain team was using legacy reporting tools that required them to gather data from various sources, drop it into a big Excel spreadsheet and manually slice and dice it to produce some form of analytics.”

The supply chain team had ultimately created their own data warehouse in a massive Excel file, filled with complex calculations and lookups. In addition to the time and effort involved in maintaining such a file, this siloed approach to data management resulted in a number of problems, including the inability to easily share and visualize insight across the organization, minimal integration with other data sources, limited data quality and governance controls and a lack of automation.

Lindt saw an opportunity to collaborate with key stakeholders on the supply chain team to identify key priorities and then migrate some of their solutions out of the legacy applications and move them to a modern analytics tool set. This would provide the supply chain team with their own dashboards and analytics and their own data sets while leveraging the same Business Intelligence (BI) platform used by the rest of the organization.

Knowing the scope of the project, Lindt immediately selected Newcomp Analytics as their preferred partner. John says, “We’ve worked with Newcomp for many years. They are a trusted provider for us, for both resources and solutions.” John goes on to describe his consideration factors when selecting third-party advisors for analytics projects. “Having CPG experience, technical abilities, and communication and collaboration skills are all the hallmarks of a good consultant. Newcomp has a team of qualified consultants and is successfully able to recruit, retain and develop professional services resources that do this type of work.”

Newcomp’s approach for this analytics project involved working with the existing technology stack at Lindt, including IBM Cognos Analytics, Microsoft SQL Server, and Microsoft Server SSIS. While Lindt’s existing technology relied heavily on legacy Transformer cubes, the proposed solution involved leveraging more modern Cognos Analytics 11 functionality, including Data Modules and the Dashboarding Tool.

The solution deployed by Newcomp Analytics was successful in helping the supply chain team reduce their reliance on Excel for managing and consuming data and minimizing the time and effort required to work with the data. The data ingestion process has significantly improved data quality and governance. Data quality has also improved through the introduction of automation, designed to eliminate user error in manually merging and preparing calculations. The consolidated view of data that is now available through the enterprise data warehouse and Cognos, has dramatically increased the speed to insight and the ability of the supply chain team to share and visualize high level KPIs from their own dashboards and data sets.

“Giving the supply chain team the ability to drill in and better understand their data will allow them to make key business decisions that will have a positive impact on the Lindt business.” Building on the success of this project, Lindt continues to work with Newcomp to improve their supply chain analytics with a project focused on designing a new planning and reporting process leveraging IBM Planning Analytics and IBM Cognos Analytics. John reflects on Lindt’s long-term partnership with Newcomp; “What keeps us going back? It’s about trust. It’s about doing what you say you’re going to do. It’s about delivering value and ultimately, getting things done. Consistently.”