SQL Server to Azure Data Lake ETL & Power BI Reporting

• Queried data stored in SQL Server using SSMS to retrieve and analyze datasets. • Created and configured an Azure Storage Account to store data from SQL Server in Parquet format. • Developed an Azure Synapse Analytics pipeline to automate data movement from SQL Server to Azure Data Lake, using Copy Activity and ForEach Activity with parameterized table handling. • Loaded transformed data into Power BI, building an extensive report leveraging DAX measures, calculated columns, data modeling, and advanced visualizations in the Power BI Service