Client & Scope
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.
- 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.