Metric, Entity, Grain: the contract before the chart
Translate a dashboard request into a metric, an entity, and a grain before designing the view.
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…
Sign up free — one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in