BI Semantic Layer Generator

SkillAI & models

Generates semantic layer definitions for BI tools from dimensional models

Instructions available. Your AI can read the instructions. Execution depends on the setup they require.

Account requirements not reviewed. Check the skill instructions before use; ahel provides instructions and does not run this skill.

Add ahel to your AI once: Claude, ChatGPT, Cursor, Claude Code or Codex. Then ask it to use this.

Then ask your AI: use the BI Semantic Layer Generator skill

What this skill tells your AI

The instructions your AI receives, as published by a5c-ai/babysitter in library/specializations/data-engineering-analytics/skills/bi-semantic-layer-generator/SKILL.md and read by ahel’s review.

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

Signals

GitHub stars: 2k
Forks: 112
Last commit: Sep 2026

Advanced

Item type: skill
Key: bi-semantic-layer-generator
Source: github.com/a5c-ai/babysitter

github.com/a5c-ai/babysitter