End-to-end data architecture. Senior-level delivery.

The Gold Layer, Built First.

A complete data modeling engine. From business requirements and logical models to production-grade Medallion ETL and optimized BI semantic layers.

View TemplatesLet's Talk
The Method

Structure before visuals.

Most dashboard projects fail in the data layer, not the design layer. Every engagement starts at Bronze.

BRONZE

Understand what exists.

Raw source, untouched. Before a single model is built, we map the data — where it lives, what it means, and where it breaks.

SILVER

Build the foundation.

Typed, cleaned, validated. Schema standards, metadata columns, and incremental refresh patterns. The layer everything else depends on.

GOLD

Deliver what the tool needs.

Metric-ready, BI-optimized. Pre-computed KPIs, domain-prefixed fields, and schemas designed for Power BI or Qlik — not adapted after the fact.

Services

What I deliver.

Three tools. One principle. The Gold layer gets built before the dashboard layer.

build_gold_layer.py
# goldframe/pipelines/build_gold_layer.py
 
from pyspark.sql import functions as F
 
def build_gold_metrics(df):
return (
df
.withColumn("GPT_Days",
F.datediff("ISSUED_DATE", "APP_RECEIVED"))
.withColumn("Within30Flag",
F.when(F.col("GPT_Days") <= 30, 1)
.otherwise(0))
.drop("_ingest_ts", "_source_file")
)

Blueprinting & Architecture

The conceptual foundation.

  • —Business Requirements Documents (BRDs)
  • —Conceptual & Logical Data Modeling
  • —Entity Relationship Diagrams (ERDs)
  • —Metric definitions & grain mapping

Data Engineering (Medallion)

Bronze to Gold ETL pipelines.

  • —Databricks Medallion architecture
  • —PySpark & SQL transformations
  • —Incremental refresh patterns
  • —Unity Catalog & RBAC governance

Semantic Layer & BI

Tool-agnostic optimization.

  • —Star schema fact/dimension design
  • —DAX measure & set analysis libraries
  • —JSON canvas themes & branding files
  • —Production-ready .pbit templates
Templates

Production-ready starting points.

Pre-built intellectual property. Skip the boilerplate with our standardized conceptual models, ETL scripts, and BI templates.

View all →
—
Preview coming soon
Architecture

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 →
—
Preview coming soon
Databricks

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 →
—
Preview coming soon
Power BI

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 →
—
Preview coming soon
Power BI

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 →
Contact

Let's scope it properly.

Tell me what you're working on. I'll tell you if it's a good fit and what the right approach looks like.

Prefer to talk? Book a call →