Case Study: Novartis achieves streamlined integration of retailer sales and forecast data with Astera Software (Centerprise Data Integrator)

Novartis Uses Centerprise to Transform and Integrate Sales and Forecast Data From Retail Partners

Novartis, a Fortune 100 pharmaceutical and consumer-products company, needed to receive, validate and transform forecast and actual sales data from numerous retail partners (Walmart, Target, CVS, RiteAid, etc.). Retailers delivered Excel files in widely varying formats—different sheets, product- or territory-based layouts, and periods in headers—creating data-quality and normalization challenges for reporting and the data warehouse.

Novartis selected Astera Centerprise Data Integrator for its robust pivot/unpivot and transformation capabilities and strong string/date handling. Centerprise automated normalization, applied data-quality rules to detect and correct inconsistencies, and increased productivity while reliably feeding cleaned sales and forecast data into management reports and the enterprise data warehouse.

Novartis