I chose 'AdventureWorksLT2019.bak' and 'AdventureWorksLT2017.bak' data for analysis & visualization. The query editing was done in 'Microsoft SQL Server Management Studio' and the visualization part was using 'Microsoft Power BI'. Also for analysis, I used MS Excel and PowerBI's query tool.

This project demonstrates a complete data migration validation workflow using SQL Server and Excel. It validates post-migration data integrity by comparing source and target databases through record count checks, schema validation, key-based missing and extra record detection, value-level data comparison, and data integrity checks.

SQL Syntax SQL Select SQL Select Distinct SQL Where SQL And, Or, Not SQL Order By SQL Insert Into SQL Null Values SQL Update SQL Delete SQL Select Top SQL Min and Max SQL Count, Avg, Sum SQL Like SQL Wildcards SQL In SQL Between SQL Aliases SQL Joins and all topics are covered in this repo.

A Project By Harsh Dubey On Data Analytics using PowerBI & Sql.