skills.rest
cornmanwtf
cornmanwtfCOMMUNITY
Explore all skills by this author →
GitHub

data-warehouse-designer

Design star and snowflake schemas with fact tables and dimensions.

Updated Jan 16, 2026
Search Tags:#database design#analytics#data warehouse#data architecture#dimensional modeling#fact table
One-click install
npx skills add https://github.com/cornmanwtf/ABANG-COLEK --skill data-warehouse-designer
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: data-warehouse-designer
Source: https://github.com/cornmanwtf/ABANG-COLEK/tree/main/skills/data-analytics/data-warehouse-designer
Command: npx skills add https://github.com/cornmanwtf/ABANG-COLEK --skill data-warehouse-designer

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill helps users design dimensional models and fact tables for data warehouses, ensuring efficient and structured data storage for analytics.

Core Features & Use Cases

  • Dimensional Modeling: Design star or snowflake schemas.
  • Fact Table Design: Define measures and grain for fact tables.
  • Use Case: A retail company wants to build a data warehouse to analyze sales performance. This Skill can be used to design the dimensional model (e.g., dimensions for Product, Time, Store, Customer) and the fact table (e.g., Sales Fact) to track key metrics.

Quick Start

Use the data-warehouse-designer skill to design a dimensional model for analyzing customer purchase history.

Frequently Asked Questions about data-warehouse-designer

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I design a dimensional model for a data warehouse?▼

To design a dimensional model, you define star or snowflake schemas by structuring fact tables, measures, dimensions, and grain to ensure efficient data storage and analytical querying.

What is the difference between star and snowflake schemas in dimensional modeling?▼

Star and snowflake schemas are dimensional modeling approaches where star schemas use denormalized dimension tables for simplicity, while snowflake schemas normalize dimensions into multiple related tables to reduce data redundancy.

How do I define measures and grain for a fact table?▼

Defining measures and grain for a fact table involves specifying the level of detail captured per record, such as individual sales transactions, and identifying the quantitative metrics to track for analytical purposes.

Can I use this approach to address performance and compliance in data architecture?▼

Yes, designing dimensional models and fact tables for data warehousing addresses requirements for performance, security, and compliance directly within the underlying data architecture structure.

When should I use a data warehouse for analytics instead of a transactional database?▼

You should use a data warehouse for analytics when you need structured, historical data storage with dimensional models to track key metrics, separating analytical workloads from operational transactional databases.

Related Skills

Explore More Data & Analytics Skills→
qa-amanqa-aman
19

data-dictionary

Generate a data dictionary documenting entities, fields, and business rules.

Community
Advanced
BlackkadderBlackkadder

databricks-dbsql

Enable procedural SQL, stored procedures, and recursive CTEs in Databricks SQL.

Community
Advanced
pluginagentmarketplacepluginagentmarketplace
1

data-warehouse

Design scalable data warehouse architectures with star schemas and ETL patterns.

Community
Advanced
mdnaimul22mdnaimul22
2

database-schema-designer

Design relational database schemas and migrations from functional requirements.

Community
Advanced