data-warehouse-design

name	data-warehouse-design
description	Designs a data warehouse structure by selecting star or snowflake schema, defining fact tables and dimension tables, specifying grain for each fact table, and producing the entity-relationship description. Outputs a complete warehouse schema specification. Use when the user asks to design a data warehouse, build a dimensional model, create fact and dimension tables, or plan an analytics schema for reporting. Do NOT use for operational database schema design (use data-schema-design), ETL pipeline logic (use etl-pipeline-design), or dashboard layout (use bi-dashboard-spec).
license	Apache-2.0
metadata	{"author":"foundry-skills","version":"1.0.0","tags":"data-science sql planning","category":"data-analysis","subcategory":"data-engineering","depends":"","disclaimer":"none","difficulty":"advanced"}

Data Warehouse Design

When to Use

Use this skill when:

• User asks to design a data warehouse or analytical data store
• User wants to create a dimensional model with fact and dimension tables
• User needs to decide between star schema and snowflake schema
• User wants to restructure an existing analytics schema for better query performance
• User asks about grain, slowly changing dimensions, or conformed dimensions

Do NOT use when:

• User wants to design an operational (OLTP) database schema (use data-schema-design)
• User wants to design the ETL pipelines that load the warehouse (use )