A global company that develops and produces crop protection products, with an annual turnover of $1billion and 2,200 employees, was struggling to gain insights from purchased external market data. Despite the strategic importance of this data, the process for data collation, manipulation and distribution involved prolonged manual effort.
Its analysts were handling data from different countries, formats and languages largely manually, which was time-consuming, ran the risk of human error and provided little valuable insight. The few automated processes they did have were fragile and unreliable.
Concentra enabled them to automatically load market intelligence data into a data warehouse so their analysts could use their time on identifying meaningful patterns to gain a competitive advantage, rather than preparing the data.
Building on DataPlus, Concentra's flexible metadata-driven data warehouse accelerator, we were able to extract data automatically from complex and changeable Excel sources. The next stage involved matching multilingual and variable quality text to a common taxonomy of active ingredients as well as a directory of organisations. This "fuzzy matching" component worked on a combination of machine-generated suggestions and user-defined mappings, so that the system learned the correct matches and user intervention was only required for new unmatched elements. Finally, the data was structured into a best-practice data warehouse architecture to support the suite of reports required as well as allowing for ad hoc analysis.
Concentra created an externally hosted analytics solution for the company to input, store, access and analyse data - with zero impact on the existing IT estate. Their analysts were then trained to take ownership of the administration of the platform as well as the development of reports.