Case Study: US-based investment bank achieves accurate pesticide sales forecasts from NOAA weather data with Evalueserve

US - Based Investment Bank - Customer Case Study

US - Based Investment Bank’s sell-side analysts in the agrochemicals sector wanted to use freely available NOAA meteorological data to improve pesticide sales forecasts but lacked the people, programming and analytics expertise to collect and process the vast data set (~39 million data points across 150 locations over 10 years). Evalueserve was engaged to provide an end-to-end data and analytics service, including automated data collection, cleansing, database management and forecasting.

Evalueserve automated downloads with a web crawler, cleansed and structured the ~39 million NOAA records into an SQL-backed database with an Excel interface, and developed a regression model linking weather, crop growth and pesticide demand. The work produced accurate, repeatable sales forecasts, enabled monthly updates (~0.4M new records/month), unlocked a previously untapped free data source and proved the value of customized alternative-data analytics for the client.