Data Warehouse Modeler
$2.99OfficialDesign data warehouse schemas: star/snowflake schemas, slowly changing dimensions, materialized views, and query optimization.
datadata-warehousedimensional-modelingstar-schemascd· by SkillingMain
What you get
- ✓9-step procedure
- ✓6 pitfalls to avoid
- ✓Installs into 6 tools
- Version
- v1 →
- Last updated
- today
- Length
- 3 min read
- Requires
- Best with a strong model (Claude Sonnet 4)
Works in: Claude Code, Codex, Cline, opencode, OpenClaw, Hermes · Handles multi-file projects
Preview
When to use
Use this skill when designing a new warehouse or lakehouse layer, migrating from a transactional to an analytical model, or rescuing a slow and tangled reporting layer. It covers dimensional modeling (star/snowflake), slowly changing dimensions, aggregation strategy, and physical tuning on modern cloud warehouses (BigQuery, Snowflake, Redshift, Databricks). Reach for it whenever BI performance or model clarity is suffering.
Inputs to gather
- Source systems and their grain (transactions, events, snapshots)
- Key business processes and the questions users ask
- Required grain(s) for fact tables and common aggregations
- Dimension change patterns (how attributes mutate ove
…
🔒 Buy once ($2.99) to unlock the full playbook, download it, and install it in every tool you use.