Global Biopharmaceutical Company

This project changed a manual, multi-hour sales data analysis process across 16+ spreadsheets into a 4-minute automated workflow, improving data quality and saving up to 80% of computing resources.

Challenge

• With data scattered across numerous spreadsheets, it was difficult to know which file contained the most up-to-date or accurate information, leading to conflicting reports
• The manual process was not scalable and error prone. Adding new products, markets, or data sources would have exponentially increased the workload and complexity

Solution

• A user-friendly, point-and-click application was developed using Foundry Workshop to automate and simplify the workflows
• The overall data model was redesigned to adapt to a more intuitive data structure, cleaner calculations and improving reporting and analytics options

Business Impact

• Performance & Efficiency: Saves up to 80% of computing resources compared to the previous model; Algorithm build time went from 35 minutes to 4 minutes
• Data Quality & Usability: Fixed critical data gaps, Automated alerts for data inconsistencies.
• Reduced Risk & Better Governance: Secure, simplified methods for editing large datasets. Full edit history and change logs provide transparency.