Skip to content

Automatic translation — the Portuguese version is the reference. View in Portuguese

Updated on 2026-09-08

Tutorial: sales dashboard

Build a sales dashboard with KPIs, a product ranking, revenue by region and the monthly trend.

On this page (8)

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#

Measures used#

code
Receita = SOMA(valor)
Pedidos = CONT_DISTINTO(vendas.pedido_id)
Ticket médio = DIVIDIR(MEDIDA('Receita'); MEDIDA('Pedidos'))

Dashboard layout#

BlockVisualFields
Top3 KPIsReceita, Pedidos, Ticket médio (with Δ% vs previous period)
LeftHorizontal barsReceita by produtos.categoria (top N)
RightBrazil mapReceita by filiais.uf
BottomLineReceita by calendario.mes
FiltersSlicersPeriod (relative date), filiais.regiao, produtos.marca

Step by step#

  1. Create the dashboard

    In the editor, create a new dashboard (it starts empty, as a draft) and choose the model.

  2. Add the KPIs

    Drag Receita, Pedidos and Ticket médio to the top. Turn on "compare" to see Δ% vs the previous snapshot.

  3. Product ranking

    Create horizontal bars of Receita by produtos.categoria; limit it to the top N with grouping/binning or sorting.

  4. Map by state

    Add the map visual and use filiais.uf (marked as a geographic category in the model).

  5. Monthly trend

    Add a line of Receita by calendario.mes.

  6. Filters

    Add a relative dates slicer ("last 30 days") and region and brand slicers scoped to the dashboard (see Filters and interactions).

  7. Interactions

    In the interactions editor, set "clicking a category filters the map and the line".

  8. 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.uf as a state (UF) in the model, otherwise the map won't color anything.

Related#


Last reviewed: 2026-09-08.

Related links