Portfolio

Case Studies

Case studies that explain the delivery, architecture, and business context behind selected portfolio work.

These summaries focus on architecture, modeling, delivery choices, and business outcomes.

Featured Case Study

Azure Cost Analytics in Microsoft Fabric / Power BI

Azure cost analytics pipeline built with dbt, Dagster, DuckDB, and Microsoft Fabric to turn raw billing, price, discount, and resource metadata into governed marts, semantic models, and optimization reporting.

Power BI Microsoft Fabric dbt Dagster SQL Tabular Editor

Featured Case Study

AI-Powered BI Delivery with Lightdash

dbt and Lightdash MVP that turns Azure pricing and amortized-cost logic into curated marts, MotherDuck-hosted semantic tables, and decision-ready dashboard exploration.

Lightdash dbt Data Agents DuckDB MotherDuck AI-Assisted Development

Case Study

Cloud Migration Metadata Workflow

Metadata-driven analytics pipeline designed to standardize infrastructure inputs, produce migration-ready datasets, and generate repeatable Excel deliverables.

Power Query SQL Java dbt Data Agents Excel

Case Study

QlikView Sales Classification Pipeline

Legacy QlikView pipeline where chained applications, QVD storage, and rule-based classification created a governed reporting workflow for sales classification and decision support.

QlikView QVD SAP BW CRM Scripting Data Governance

Featured Case Study

Real-Time Weather Streaming on Azure and Microsoft Fabric

WeatherAPI streaming project that moved lightweight scheduled ingestion from a Databricks prototype to Azure Functions, then routed events through Event Hubs, Fabric Eventstream, Eventhouse/KQL, Power BI, and Data Activator email alerting.

Azure Functions Event Hubs Microsoft Fabric Eventhouse / KQL Power BI Databricks