Data Analytics and Visualization using Power BI & Azure Data Lake


  • 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.


  • 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.