Bi semantic layer generator

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

Generates semantic layer definitions for BI tools from dimensional modelsFrom its SKILL.md

Install

npx -y skills add a5c-ai/babysitter --skill bi-semantic-layer-generator

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

SKILL.md

1.9 KB, 314 tokens by cl100k_base, as published. Nobody here has run it

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

What ships with it: 1 file

500 B alongside SKILL.md

README.md500 B