SELF-GUIDED BA PRACTICE Packages available · Access after confirmed paymentSee packages ↗

Business analysis glossary

Dimension Table

What it is

A dimension table holds descriptive attributes used to filter, group and label facts, such as a product table with name, brand and category, or a date table with day, month, quarter and financial year. Each dimension row has a unique key that the fact table refers to.

Why it matters

Dimensions make reports readable and flexible: the same sales fact can be sliced by region, product or month. A proper date dimension is especially important for time comparisons and Indian financial years starting in April. Analysts specify which attributes each dimension needs from the questions users ask.

Example

For the clinic dashboard, the analyst asks for a date dimension with the financial year starting in April, a doctor dimension with department and speciality and a patient dimension with age band but no names. Managers can now compare no show rates by department and quarter without seeing personal details.

Used in these guides

CHECK BEFORE CONTINUING

Keep your work safe