Dimension

In depth

Dimensions enable you to 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 — your CRM, your billing platform, your 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.

Your data team will typically organize these into a structured model — often a star schema or semantic layer — where dimensions sit alongside fact tables that hold your numeric measures. That architecture is what makes querying fast and reliable at scale.

Either way, what matters most is consistency: using the same name for the same thing everywhere, and making sure everyone is working from the same definitions. That's what keeps your numbers trustworthy; whether in dashboards, AI chat, or the flow of work.

Pro tip

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

Why dimensions matter

Dimensions give your metrics meaning. They let you see the why behind the numbers, revealing patterns, trends, and outliers. By slicing revenue, customer counts, or operational costs across relevant dimensions, teams can gain comprehensive, actionable insights that drive better decisions.

Dimensions in practice

• A marketing manager segments campaign performance by channel and region to optimise ad spend and identify high-performing combinations.
• A finance lead tracks quarterly revenue by product line to forecast budgets and spot growth opportunities.
• A sales director filters the deal pipeline by sales rep and stage to identify bottlenecks and coach underperforming teams.
• A product manager compares feature adoption rates across user segments and cohorts to prioritise roadmap decisions.

Dimensions and PowerMetrics

In PowerMetrics, dimensions can be assigned to metrics and made available to end-users for segmenting and filtering. Raw dimension field names can also be renamed to ensure consistency and user-friendly labels across your organisation. This keeps everyone working from the same definitions and prevents confusion when exploring data through dashboards or the AI Assistant.