SQL Server to Azure Data Lake ETL & Power BI Reporting
Boris Keckarovski
• 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
Like this project
Posted Feb 3, 2025
I built an ETL pipeline from SQL Server to Azure Data Lake using Synapse, then modeled and visualized the data in Power BI with DAX and advanced reporting
Likes
1
Views
7
Timeline
Sep 1, 2024 - Nov 1, 2024
