Management Dashboard with data from multiple ERP solutions, multiple continents

Need : Our client is large plastic products manufacturer based in Europe and operating worldwide. Since independent ERP solutions were used in different countries, the management was unable to get a comprehensive view of the business.

Solution : Key parameters required for management were identified like stock status, sales reports, top-selling products country-wise etc. Then we went about identifying the right tool to extract data from each of the ERP solutions from each country. Specific ETL tools were used to extract and store data from SAP and other ERP solutions to a common Data WareHouse. This data was then bound with BI Tool to create insightful reports for the management. These reports were converted to PDF formats and scheduled at specific intervals for each of the stake holders. The management was able to view comprehensive reports on stock status, sales order etc, with country wise or product wise break up.

Benefits to client :
>>> Single dashboard to view key business indicators across continents.
>>> Decision making time improved significantly since single data view was available for all stake holders.
>>> Right data at the right time helped to manage stock better, thereby increasing RoI.

Technologies Used : SAP Data Services, PowerBI, Chartio, INFOR, MS-SQL, Azure Database.