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
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
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: 197k | 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 |