Skip to main content

Client & Scope

Client:

One of the Leader in water treatment service, USA
Client is a leading Corporation that develops and offers services, technology and systems that specialize in water treatment, purification, cleaning and hygiene in a wide variety of applications.

Scope:

  • Data Acquisition from SAP using Azure Data Factory
  • Design & Build EDW in SQL Server Data Processing / Transformation using Azure Analysis Services Building Analytics for User
  • Consumption using Microsoft Power BI

Business Value & Benefits

  • Common source of data for Different Retail clients having similar business.
  • Developing solution on AWS platform leading to reduction in cost of maintaining on premise infrastructures.
  • Leveraging Cloud based scalable services for a on demand service oriented model.

Solution & Technology

  • Configuring various Azure components like Azure Data Factory and Azure Analysis Services and Building KPI reports using Power BI.
  • Building/enhancing/maintaining Tables, retrieving and modifying data using MS SQL Store Procedures.
  • Designed complex queries to transform the extracted data using Azure Data Factory.
  • Designed Ad Hoc and complex reports using Microsoft Power BI.