Automated Data flow Management with Predictive Data Modeling used for Promotion Effectiveness accelerates ROI in Supply-chain Management

Learn how an America’s largest food and beverage manufacturing company enabled Gen AI to create a predictive model for promotion and campaign effectiveness

Highlights

70%

Improvement in data integration and data flow

80%

Manual effort reduced with automation

30%

Jump in sales & marketing

Faster data visualization and reporting

70%

Time saved with Gen AI compatibility

Client Profile

Bonduelle Fresh Americas is a wholly owned subsidiary of Bonduelle (BON.PA), and home of the ready Pac Bistro brand. The company produces ready-to-use plant-based food products grown on 126,000 hectares and marketed in 100 countries, with revenues of €2,406 M.

Business challenges

Manual and time-consuming processes to fetch and load data from external systems onto Bonduelle database.
Manual processes to ensure data quality, cleansing and monitoring.
Gaps in BI Reporting, future predictions, and forecasting.
No simplified way or a conversational bot chat feature to analyze the reports and infer results from it

Agilisium Solution

Created an automated solution to pull data from external sources and load into Bonduelle DW
Created an automated solution to extract and consolidate data various other internal Bonduelle systems / sources and load them into Bonduelle DW
Created a conversational chat feature to enable users’ direct access to the reporting layer, where in users can get insights on, Promotional activity and timing, Cost Incurred, ROI, Profit margin and Contribution margin, Bonduelle vs competition performance.
Create a predictive model based on the historical data to provide accurate information for future promotional period / products and regions.
Used Amazon S3 for POS files’ storage.
Apache Airflow service used to extract business insights across an organization by combining, enriching, and transforming data through a series of tasks called a workflow.
Used Amazon EC2 for provisioning the data layer, reporting layer and ML layer.
Used Amazon Bedrock in combination with Agilisium’s Gen AI solution called Data Lens which focuses on Sales and Marketing Augmented Insights generation.

Tech-stacks Used

No items found.

Business outcome

Significantly improved the effort and time taken to consolidate data into the Datawarehouse.
Near Real time access to BI reports.
Conversational chat bot feature for business users to get deeper insights to POS and Promotion data.
Enabling Sales and Marketing team to effectively predict the future promotions and campaigns.