dataflow-gen2

Synthetic Microsoft Fabric demo showing how a manual Excel-based month-end finance reconciliation can be moved into a controlled lakehouse workflow using Dataflow Gen2, notebooks, and bronze/silver/gold layers.

A full-stack data engineering and analytics project built on Microsoft Fabric, transforming raw ECDC Covid-19 data into an interactive Power BI dashboard using industry-standard Medallion Architecture.

End-to-end analytics platform on Microsoft Fabric — metadata-driven pipelines, incremental loading, SQL Warehouse, semantic model, Power BI

End-to-end retail analytics project built in one day with Microsoft Fabric, SQL, PySpark and Power BI.

Migrated legacy ETL workflows to Microsoft Fabric, improving automation, data quality, and runtime efficiency

Retail & E-Commerce Sales Analysis built with Microsoft Fabric and Power BI. Includes Dataflow Gen2 ingestion, Lakehouse-based dbo/Silver/Gold layers, Fabric pipeline orchestration, semantic modeling, DAX, RLS, incremental refresh, scheduled refresh, and interactive business reporting.

A clean, decision-focused HR dashboard to understand why employees leave and who is most at risk. Built using Dataflow Gen2 for a governed ETL pipeline, with smart segmentation, field parameters, and enterprise-style architecture.

"Power BI dashboard analyzing HR attrition drivers across department, salary, and age — built on a Microsoft Fabric pipeline (Dataflow Gen2 → Lakehouse → Semantic Model)."

End-to-end data engineering pipeline on Microsoft Fabric: Incremental watermark ingestion implemented from MySQL, PostgreSQL & Google Sheets through Bronze/Silver/Gold medallion architecture to a star schema warehouse, through the Dataflow Gen2.

End-to-end Microsoft Fabric data platform using Medallion Architecture, integrating ADLS Gen2, SQL Server and GitHub. Implements metadata-driven ingestion, PySpark, Dataflow Gen2, incremental loading, data cleansing and a Gold star schema, exposed through Direct Lake for Power BI reporting.

End-to-end banking analytics platform (SQL Server → Fabric → Power BI) processing 49,615+ transactions worth ₹302M across 10,000 customers with 10 SQL-driven insights powering cross-sell, failure detection, and branch prioritization.

Rebuilding the same KNIME transformation logic in Microsoft Fabric using Dataflow Gen2, SQL and Python.

Microsoft Fabric DP-700 Hands-On Labs

MCP server for developing Microsoft Fabric notebooks and Dataflow Gen2 via the Fabric REST API

End-to-End Microsoft Fabric Analytics Platform implementing Medallion Architecture, Lakehouse, Warehouse, Semantic Modeling, and Executive KPI Reporting using Power BI.

Solved HR attrition analytics problems using Microsoft Fabric and Power BI, analyzing 1,470 employees to identify key attrition drivers including overtime, travel, compensation, and tenure, with secure reporting for sensitive payroll data.