What is a dimension?

In depth

Dimensions let you see your data from different perspectives. Unlike measures (numeric values you calculate, such as sales or costs), dimensions define the structure of your analysis by:

• Grouping data: Break down total revenue by region, department, or customer segment.
• Filtering data: Focus on a specific country, product category, or team.
• Labelling data: Assign user-friendly names to records for easier interpretation.

Dimensions usually come from the systems your business already uses, such as your CRM, billing platform, or product database. They're the descriptive columns in those systems: the country attached to a customer, the category attached to a product, the status attached to an order.

Larger organizations often arrange dimensions into a structured model, such as a star schema or semantic layer. In that model, dimensions sit alongside fact tables that hold the numeric measures.

Whatever the setup, consistency matters most: use the same name for the same thing everywhere, and make sure everyone works from the same definitions. That keeps your numbers trustworthy across dashboards, reports, and meetings.

Pro tip

Use simple, consistent naming for dimensions. Avoid overly granular attributes (high cardinality) unless they serve a specific purpose. Too many dimensions can overwhelm dashboard users and slow query performance.

Why dimensions matter

Dimensions give your metrics meaning. They show the why behind the numbers by revealing patterns, trends, and outliers. When you slice revenue, customer counts, or operating costs by the right dimensions, you can see what changed, where it changed, and what to do next.

Dimensions in practice

• Marketing: A marketing manager segments campaign performance by channel and region to decide where to shift ad spend.
• Finance: A finance lead tracks quarterly revenue by product line to set budgets and spot growth opportunities.
• Sales: A sales director filters the deal pipeline by sales rep and stage to find bottlenecks and decide where to coach.
• Product: A product manager compares feature adoption across user segments and cohorts to prioritize the roadmap.

What to consider when choosing dimensions

Choose dimensions that match the decisions your team makes. Define each one once, name it clearly, and apply it the same way across every metric so a "region" in one report means the same thing in another.