Skills
.Work. You
Rest

obt-design

Community

Design fast, wide, pre-joined OBTs for BI.

Data & Analytics#analytics#dbt#data-modeling#dimensional-modeling#data-mart#obt#one-big-table
Authornrakow
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This skill helps analytics teams design and implement One Big Table (OBT) models that reduce BI-layer joins by presenting a single denormalized dataset for self-service analytics.

Core Features & Use Cases

  • Pre-joined OBT models that join a fact with its relevant dimensions to yield a wide, business-friendly table.
  • Clear governance: grain declarations, column naming conventions, and documentation for business users.
  • Use Case: executives and analysts needing rapid, join-free access to metrics from dashboards and self-service tools.

Quick Start

Create an OBT by declaring the grain and joining the fact to current dimensions to produce a single wide table for dashboards.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: obt-design
Download link: https://github.com/nrakow/ae-skills-dev/archive/main.zip#obt-design

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.