Projects

Electron desktop app that generates production React dashboards from natural-language prompts against Fabric semantic models. Architected a primitive-based ECharts composition system (8-phase migration cut a 3,374-line monolith to 870 lines across 47 modules) and published via the Fabric Items REST API with updateDefinition — a non-obvious workaround for XPress9 / JSZip blockers in conventional .pbix import paths. Multi-provider (Anthropic / OpenAI / Gemini / Groq / local Phi-4-mini), incremental Refine + Replace modes, and one-click Publish to Power BI.

Streamlit app that compares a source dataset (raw / upstream / app extract) against a target dataset (curated / warehouse / report extract) — file-level CSV / XLSX inputs up to 200 MB, with a Validator pass and a Mismatch Explorer for row-level drill-down. Built for the moment analysts and BI engineers need a fast, no-storage sanity check during ETL handoffs or report-vs-warehouse reconciliations. Public live demo is gated by a private access code — ping me for one.

Public Microsoft Fabric reference implementation: a fictional mid-market apparel retailer with a full medallion-architecture pipeline (Bronze → Silver → Gold, 14 fact and dimension tables). 306 / 306 generator tests passing, production Fabric infrastructure across three workspaces and two service principals, CI via GitHub Actions. Addresses a community need: realistic, license-free retail datasets with intentional data-quality issues for teaching and tool benchmarking.

Dependency-analysis and CI/CD gating for Power BI PBIP / TMDL semantic models — an area where Microsoft tooling provides no equivalent. Phase 1 ships a custom DAX parser, blast-radius analysis, and snapshot-determinism guarantees suitable for pull-request gating. 84 / 84 tests passing.

Open-source educational repo that teaches SQL through narrative storytelling rather than abstract schemas. Progressive curriculum where each chapter advances a story while introducing joins, window functions, CTEs, and performance considerations in realistic business scenarios.