Skip to main content

Metric, Entity, Grain: the contract before the chart

Translate a dashboard request into a metric, an entity, and a grain before designing the view.

business-intelligence5 min read

Good BI starts with a contract, not a chart. The request underneath the request When a stakeholder asks for a dashboard, they usually name an output, not a definition. "Show active customers by region" sounds clear until you ask what counts as active, whether region means billing or sales territory, and whether the number should be daily, weekly, or monthly. The semantic model exists to surface those hidden choices before they are buried in workbook formulas. The semantic model sets the nouns A semantic model defines the business objects you can safely use: entities, dimensions, and time dimensions. That matters…

Read the full lesson

Sign up free: one personalized lesson every day, matched to your role and goals.

← Back to library

Contact us