A sales dashboard answers the everyday commercial questions: how much we sold, where, what, and how the trend looks. This tutorial builds one from scratch on top of the example star schema.
Example workspace: Comércio Aurora Ltda (aurora).
Prerequisites#
- Star schema in place (
vendas+ dimensions). - Core measures Receita (revenue), Pedidos (orders) and Ticket médio (average ticket) (see measures and time comparisons).
Measures used#
Receita = SOMA(valor)
Pedidos = CONT_DISTINTO(vendas.pedido_id)
Ticket médio = DIVIDIR(MEDIDA('Receita'); MEDIDA('Pedidos'))Dashboard layout#
| Block | Visual | Fields |
|---|---|---|
| Top | 3 KPIs | Receita, Pedidos, Ticket médio (with Δ% vs previous period) |
| Left | Horizontal bars | Receita by produtos.categoria (top N) |
| Right | Brazil map | Receita by filiais.uf |
| Bottom | Line | Receita by calendario.mes |
| Filters | Slicers | Period (relative date), filiais.regiao, produtos.marca |
Step by step#
Create the dashboard
In the editor, create a new dashboard (it starts empty, as a draft) and choose the model.
Add the KPIs
Drag Receita, Pedidos and Ticket médio to the top. Turn on "compare" to see Δ% vs the previous snapshot.
Product ranking
Create horizontal bars of Receita by
produtos.categoria; limit it to the top N with grouping/binning or sorting.Map by state
Add the map visual and use
filiais.uf(marked as a geographic category in the model).Monthly trend
Add a line of Receita by
calendario.mes.Filters
Add a relative dates slicer ("last 30 days") and region and brand slicers scoped to the dashboard (see Filters and interactions).
Interactions
In the interactions editor, set "clicking a category filters the map and the line".
Publish
Review the draft and publish it (see Tutorial: publish and share).
Expected result#
- Clicking a category bar slices the map and the line (cross-filter).
- The "last 30 days" slicer moves forward on its own every day.
- The KPIs show the change vs the previous period.
Best practices#
- Start with the KPIs: they answer "is it going well or badly?" at a glance.
- Use drill-down on the monthly line (year → month → day) instead of cluttering the page with many visuals — see Filters and interactions.
- Save an "executive" view and a "detailed" one as bookmarks.
Common mistakes#
- Summing the amount without excluding returns: handle this in the measure (
CALCULAR/FILTRAR) or in the transformation layer, not in the visual. - Map without a geographic category: mark
filiais.ufas a state (UF) in the model, otherwise the map won't color anything.
Related#
Last reviewed: 2026-09-08.