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.