SQL Server to Azure Data Lake ETL & Power BI Reporting

Boris Keckarovski

0

Data Visualizer

Data Analyst

Data Engineer

Azure

Microsoft Power BI

SQL

• 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
0

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

0

Views

0

Tags

Data Visualizer

Data Analyst

Data Engineer

Azure

Microsoft Power BI

SQL

Databricks & Power BI Implementations
Databricks & Power BI Implementations
End-to-End Sales Report Development
End-to-End Sales Report Development