Cloud Data Pipeline (Microsoft Fabric + Python)
Built at an enterprise consulting firm
Overview
Completed a Microsoft Fabric project extracting data from an enterprise operations platform, using Data Pipelines and Python notebooks within Fabric to perform ETL, and writing the transformed data tables to a financial planning system. Also wrote raw SQL for pre-processing before ingestion into Fabric and Power BI.
The Problem
Data from an enterprise operations platform needed to flow into a financial planning tool for budgeting and forecasting, but the transformation logic was complex and manual.
My Approach
Built end-to-end Data Pipelines in Microsoft Fabric. Used Python notebooks for complex ETL transformations. Wrote SQL for pre-processing data tables before ingestion. Configured automated data flow from the source operations system through Fabric into the financial planning tool for reporting.