Data platform · Storage & Modeling

What is a star schema?

Mediumstar schemafactsdimensionsmodeling

Interview question

What is a star schema in analytics modeling?

How to answer

The short answer

A is a warehouse modeling style with a central fact table of measurable events and surrounding dimension tables that describe those events.

Output
        dim_customer
             \
dim_date --- fct_orders --- dim_product
             /
        dim_store

Facts

  • Many rows, numeric measures (amount, quantity)
  • to dimensions
  • Grain statement: "1 row per order" or "1 row per order line"

Dimensions

  • Descriptive attributes (customer_name, product_category)
  • Used for filters and group-bys in BI

Why interviewers ask

Stars are simple for BI tools, fast for aggregates, and force you to clarify grain.

Interview tip: Always state the fact grain first. Confusing order-level and line-item-level facts is a classic modeling bug.