Case Study: KMG Chemicals, Inc achieves seamless consolidation of 11 ERP systems and faster, actionable financial insights with Microsoft Power BI

Chemical manufacturer seamlessly blends data from 11 systems with Excel

KMG Chemicals, Inc., a multinational chemical manufacturer, faced the challenge of reconciling financial data across 11 disparate ERP systems after a series of mergers. To avoid time-consuming manual data wrangling and enable fast ad hoc analysis, the finance team adopted a cloud-based stack using Azure SQL Database to centralize data, Excel’s Get & Transform and Power Pivot for data preparation, and Microsoft Power BI for visualization and sharing.

Using Microsoft Power BI alongside Excel and Azure SQL Database, KMG automated data flows from ERPs into a single, secure dataset (with row-level security), created shared Excel/Power BI templates for what‑if and predictive analysis, and cut infrastructure costs versus an $80,000 on‑prem server. The outcome: much faster, proactive reporting—CEO deck prep fell from three weeks to 30 minutes, sales teams saved two weeks a year and saw sales rise 10–15% year‑over‑year—and a single version of the truth that speeds problem detection and forecasting.

KMG Chemicals, Inc

Khaled Chowdhury

Financial Planning and Analysis Manager