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 · Intermediate

Dimensional Modeling

A data modeling technique that organizes analytic data into facts (measurable events) and dimensions (descriptive context).

Definition

Kimball's four-step process is: choose the business process, declare the grain, identify the dimensions and identify the facts. Dimensional models are intuitive for users and efficient for BI engines.

Exam tip

Always declare the grain before choosing facts and dimensions; mixed grain is a modeling error.

Related terms