Success Story: Manufacturing Sector
General Context.
Ingredion is a leading multinational company in ingredient solutions. Dedicated to manufacturing sweeteners, starches, nutritional ingredients, and biomaterials that customers use in everyday products, from food and beverages to paper and pharmaceuticals.
Challenge.
Across different areas of the business, the need arose to integrate multiple sources of information, such as: finance, production, quality, safety, maintenance, and utilities, to name a few. All of these areas reported from different information systems to be consolidated into Excel reports. This consolidation had to be done manually by some members of the team, which could take them many hours each week to accomplish. In that regard, an integrated solution capable of consolidating the information automatically was needed.
From data to action.
CepoBIA built a value chain that carries raw data all the way to the decision: from the IT domain (data extraction and governance) to the business domain (knowledge and action).
IT Domain
-
Data
Automated extraction, selected at the source.
SAP BW · Excel · Access
+25 queries · +20 Excel · +1 Access · +3 flows
-
Information
A governed and unified warehouse: a single point of data entry.
Data warehouse · ETL
+4 sources · +10 M rows/month
Business Domain
-
Knowledge
Validated business rules; KPIs and dashboards by domain.
Cubes · KPIs · Dashboards
3 cubes · +50 KPIs · 9 dashboards
-
Action
Self-service and data-driven decisions across the region.
Scorecards · Scalability
+8 countries · +50 users
Results
- −85%less manual data processing
- 5 → 3days for accounting close and consolidation
- +8countries decide on a single source of truth
- +50users on self-service