Skills
.Work. You
Rest

Schema Evaluation

Community

Design optimal data warehouse schemas.

Data & Analytics#schema design#data modeling#data warehouse#SCD#star schema#data contracts#data vault
Authordtsong
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill helps you design and evaluate data warehouse schemas, ensuring they are efficient, scalable, and meet analytical needs.

Core Features & Use Cases

  • Schema Design: Supports Star, Snowflake, Data Vault, and OBT patterns.
  • Grain Definition: Clearly defines what each row in a fact table represents.
  • SCD Strategy: Implements Slowly Changing Dimension strategies (Type 1, 2, 3, 6).
  • Data Contracts: Establishes clear agreements between data producers and consumers.
  • Use Case: Design a new star schema for an e-commerce platform to track customer orders and product sales, ensuring efficient querying for monthly revenue reports.

Quick Start

Evaluate and design a data warehouse schema for an e-commerce domain, focusing on order and customer data.

Dependency Matrix

Required Modules

None required

Components

references

💻 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: Schema Evaluation
Download link: https://github.com/dtsong/claude-code-windows-setup/archive/main.zip#schema-evaluation

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.