Production-ready starting points.
Pre-built intellectual property across the full data lifecycle. ERDs, Medallion pipeline scaffolds, DAX measure libraries, Power BI themes, and Qlik load scripts. Drop in your catalog and go.
Enterprise Star Schema ERD
Grain-mapped fact/dimension template with SCD-aware columns, metadata standards, and relationship annotations. Delivered as an annotated draw.io canvas.
Download →Medallion Pipeline Scaffold
Ten sequenced notebooks: schema discovery, Bronze profiling, Silver DDL generation, KPI staging, and BI export. Swap catalog and schema — the structure stays the same.
Download →Silver Layer Profiler
Seven-phase engagement kickoff notebook. Null rates, distinct counts, date-spine detection, join validation, and Silver DDL stub generation — configured by changing four constants.
Download →DAX KPI Measure Library
40+ production-verified measures: CALCULATE, DIVIDE, and VAR/RETURN patterns for utilization rates, mismatch detection, regional breakdowns, and what-if scenario parameters.
Download →Dark Executive PBI Theme
Dark canvas theme with semantic color tokens, curated dataColors palette, and Segoe UI typography stack. Drop into any .pbix for an immediate executive finish.
Download →Professional Light PBI Theme
Enterprise light theme with a 16-color palette, Roboto font stack, and textClass hierarchy for title, header, callout, and label. Built for stakeholder-facing delivery.
Download →Section Access RLS Scaffold
Row-level security template with Entra ID / SAML NTNAME pattern, ADMIN/USER role split, column OMIT support, and a secured QVD load reference for production.
Download →Calendar Dimension & Load Script
Master calendar with fiscal year support, week-ending logic, and domain-prefixed date key formatting ready for fact table joins.
Download →