Case Study: KMG Chemicals, Inc. achieves faster financial insights and streamlined reporting with Microsoft Corporation

Chemical manufacturer seamlessly blends data from 11 systems with Excel

KMG Chemicals, Inc., a global manufacturer with multiple ERP systems after several mergers, needed a faster way to reconcile financial data from disconnected sources and answer complex “why” questions without relying on manual reporting. Microsoft Corporation helped KMG use Microsoft Excel, Azure SQL Database, Office 365, Power BI, and Excel Get & Transform to streamline ad hoc analytics and centralize data access.

Microsoft Corporation implemented a cloud-based data flow from KMG’s ERP systems into Azure SQL Database, with Excel used to import, transform, and analyze the data and Power BI for visualization and security. The results included shorter problem-resolution cycles, a press release deck that now takes 30 minutes instead of three weeks to prepare, and sales teams saving two weeks a year on reporting while improving year-over-year sales by 10% to 15%.

KMG Chemicals, Inc

Khaled Chowdhury

Financial Planning and Analysis Manager