Facts & Dimensions
Last updated
What is Facts & Dimensions?
Fact tables hold measurable, numeric data such as sales amounts or transaction counts, usually at a fine level of detail with many rows. Dimension tables hold descriptive attributes, like product names or customer regions, that get connected to facts through relationships and used to filter or group them. Separating facts from dimensions is the core idea behind a star schema.
Free resources to learn Facts & Dimensions
More in stage 6: Schema Design
Facts & Dimensions: common questions
Can I learn Facts & Dimensions in Hindi?
This lesson is written in English. Once you sign in, open it in the interactive course and ask the AI tutor to explain Facts & Dimensions in Hindi or Hinglish. The tutor answers from this lesson’s own text, so it stays on the syllabus, and it runs on your own Google, OpenAI or Anthropic key.
Is this Facts & Dimensions tutorial for beginners?
It is lesson 27 of 131 in the free Power BI roadmap, in stage 6, Schema Design. If you are new to Power BI, start from stage 1 and come back here in order; if you already know the earlier stages, this lesson stands on its own.