OpenParable
Skip to content
← Back to skills

BI Semantic Layer Generator

Development

BI Semantic Layer Generator is an Agent Skill for development published in the a5c-ai/babysitter repository on GitHub: a SKILL.md instruction file an AI agent can load to do this task.

Generates semantic layer definitions for BI tools from dimensional models

View on GitHub ↗
QUICK START

How to use this skill

Bring this guide into your coding agent with a prompt tailored to the tool you use.

  1. Open your project in Codex.
  2. Copy and paste the prompt below.
  3. Review files and risks before approving any action.
Prompt to paste
Inspect the Agent Skill at https://github.com/a5c-ai/babysitter/blob/HEAD/library/specializations/data-engineering-analytics/skills/bi-semantic-layer-generator/SKILL.md and all supporting files. Report provenance, permissions, scripts, dependencies, and security risks. Propose an exact installation into .agents/skills/bi-semantic-layer-generator, but wait for my approval before writing files or running scripts.

Copying this prompt does not install or run the skill. Review third-party files before use.

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