Skip to content

a5c-ai/babysitter / library/specializations/data-engineering-analytics/skills/bi-semantic-layer-generator

BI Semantic Layer Generator

Verified

Generates semantic layer definitions for BI tools from dimensional models

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

  1. Provide complete dimensional model definition
  2. Specify target BI platform
  3. Include business glossary for consistent naming
  4. 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
slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack."Stars: 197kUpdated Claude CodeCodexVerifiedInstall
ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read.Stars: 194kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report.Stars: 194kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt.Stars: 194kUpdated Claude CodeCodexVerifiedInstall