A plumbing, heating and industrial supplies company implements automated QA validation process for their modern data warehousing solution using Azure Synapse Analytics & Power BI

Our team started with the understanding of the data validation process, the challenges and limitations, and the future use cases which to be catered. Post the discovery sessions, the team proposed a dynamic data validation built in Azure Synapse and digitization of the excel reports using Power BI. All the data exports challenges including 1 month at a time exports, validation logics and rules, and output data ready for comparison was created and driven with the help of metadata tables and SQL stored procedures. The process was generalized to add future cases and was simplified for ease of maintenance and support. The process execution was handled by ADF and email notifications were set up using Azure Logic Apps. Validation reports were created in Power BI to automate and digitize the existing reports and data comparisons were made available to the users for all cases. During the whole project, our team provided all appropriate deliverables including Solution Design, Development logics, unit testing, UAT test case and results, performance and regression testing, user trainings and manuals at appropriate stages of the project.