thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Foundational

Star Schema

A dimensional model with a central fact table joined directly to denormalized dimension tables, forming a star shape.

Definition

Star schemas minimize joins (one hop from fact to each dimension), are easy to understand and are the recommended design for Power BI semantic models. Each dimension has a one-to-many relationship to the fact table.

Example

FactSales joined to DimDate, DimProduct, DimCustomer and DimStore.

Exam tip

PL-300 strongly favors star schemas; flattening a snowflaked dimension back into one table is a common correct answer.

Don't confuse it with

Related terms