Cloud Data Pipeline (Microsoft Fabric + Python)
Built at an enterprise consulting firm
Overview
Completed a Microsoft Fabric project extracting data from Vista Viewpoint (construction management), using Data Pipelines and Python notebooks within Fabric to perform ETL, and writing the transformed data tables to Vena (financial planning). Also wrote raw SQL for pre-processing before ingestion into Fabric and Power BI.
The Problem
Data from a construction management 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 Vista Viewpoint through Fabric into Vena for financial planning and reporting.