Challenge
- Customer Production Planning reside on SAP ECC 6.0 which enabled their business plan the manufacturing, sale & distribution of goods.
- Customer was looking to handle volumes of operational and transactional business data, execute transactions & analyze data on real-time. This requires a migration which is expensive to implement & maintain.
- Current standard reporting in SAP ECC 6.0 do not yield the highly customized & complex data reporting need of the customer.
Our Solution
- We set up Data warehouse using Azure SQL Database. Using Azure data factory the raw data was modelled and processed.
- This data was ingested into power BI using direct-query to ensure up-to-date data was always reflected in the report.
- We created various Dashboards and Reports to visualize the raw data based on different user perspective.
- With Power BI, user was able to use natural language to query their data and get business insights and take informed decisions.
Benefits
- 75% Reduction in Total Cost of Ownership.
- Generate real-time reports made available for taking key strategic decision.
- Micro-level analysis of raw data empowered the client to gain profound knowledge of their business.