a5c-ai/babysitter / library/specializations/data-engineering-analytics/skills/bi-semantic-layer-generator
BI Semantic Layer Generator
VerifiedGenerates semantic layer definitions for BI tools from dimensional models
SKILL.md
View on GitHub---
name: BI Semantic Layer Generator
description: Generates semantic layer definitions for BI tools from dimensional models
version: 1.0.0
category: BI Tools
skillId: SK-DEA-009
allowed-tools:
- Read
- Write
- Edit
- Glob
- Grep
- Bash
graph:
domains: [domain:data-engineering]
specializations: [specialization:data-engineering-analytics]
skillAreas: [skill-area:data-analytics, skill-area:data-warehouse-modeling]
roles: [role:analytics-engineer, role:data-analyst]
workflows: [workflow:data-pipeline-deployment]
---
# 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
```json
{
"dimensionalModel": "object",
"targetPlatform": "looker|tableau|powerbi|cubejs|dbt",
"businessGlossary": "object",
"securityRules": ["object"]
}
```
## Output Schema
```json
{
"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
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| 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: 198k | Updated | Claude CodeCodex | Verified | Install |
| 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: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| 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: 194k | Updated | Claude CodeCodex | Verified | Install |