Babysitter BI Semantic Layer Generator

Generates semantic layer definitions for BI tools from dimensional models

install

source · Clone the upstream repo

git clone https://github.com/a5c-ai/babysitter

Claude Code · Install into ~/.claude/skills/

T=$(mktemp -d) && git clone --depth=1 https://github.com/a5c-ai/babysitter "$T" && mkdir -p ~/.claude/skills && cp -r "$T/library/specializations/data-engineering-analytics/skills/bi-semantic-layer-generator" ~/.claude/skills/a5c-ai-babysitter-bi-semantic-layer-generator && rm -rf "$T"

manifest: library/specializations/data-engineering-analytics/skills/bi-semantic-layer-generator/SKILL.md

BI Semantic Layer Generator

Overview

Generates semantic layer definitions for BI tools from dimensional models. This skill automates the translation of dimensional models into platform-specific semantic definitions.

Capabilities

LookML generation (Looker)
Tableau data model generation
Power BI semantic model creation
Cube.js schema generation
dbt metrics layer integration
Calculation and measure definitions
Hierarchy generation
Security filter generation
Join path optimization

Input Schema

{
  "dimensionalModel": "object",
  "targetPlatform": "looker|tableau|powerbi|cubejs|dbt",
  "businessGlossary": "object",
  "securityRules": ["object"]
}

Output Schema

{
  "semanticModel": "object",
  "calculations": ["object"],
  "hierarchies": ["object"],
  "securityFilters": ["object"],
  "documentation": "string"
}

Target Processes

Metrics Layer
BI Dashboard Development
Data Warehouse Setup

Usage Guidelines

Provide complete dimensional model definition
Specify target BI platform
Include business glossary for consistent naming
Define security rules for row-level filtering

Best Practices

Maintain consistency between semantic layer and source models
Use business glossary terms for user-facing labels
Implement hierarchies for drill-down analysis
Configure appropriate caching strategies
Document calculation logic for maintainability