How to Build a Dashboard Without a Separate BI Tool

To build a dashboard without a BI tool, you create indicators and charts directly on the records your team already works in. There is no export, no modelling layer, and no delay between an operational change and the number moving.

Why the BI layer often creates more work than it removes

A separate reporting tool means the data has to leave the operation, be reshaped, and come back as a picture.

  • Exports scheduled nightly, so numbers are always a day behind
  • A modelling layer only one or two people understand
  • Dashboards that disagree with the operational system
  • Requests for a new chart queued behind other priorities

What belongs on an operational dashboard

ElementWhat it does
Simple indicatorA single figure straight from a field, like total revenue
Composite indicatorA calculation across variables, like an approval rate
ChartsDistribution, trend, and comparison across variables
GaugeProgress against a target
Formula blockA complex metric configured directly on the panel

How to configure it in Jestor

  1. Open the app in Jestor and press B to enter build mode.
  2. Add an indicator and point it at the field you want summarized.
  3. Choose the chart type that fits the variable you are showing.
  4. Drag in a formula block when the metric needs a calculation rather than a field.
  5. Apply filters so the panel answers the question you actually have.

Why choose Jestor for operational reporting?

Jestor treats dashboard building as assembly rather than a project — the comparison the team uses internally is Lego. Blocks are dragged in, configured, and live immediately.

Because indicators read the same records the operation runs on, there is no reconciliation between "the system" and "the report". They are the same thing.

Frequently Asked Questions

Do I need to export data first?

No. Indicators read the operational records directly. See jestor.com.

Can I build a complex metric?

Yes, using a formula block on the panel.

How long does an indicator take to create?

A revenue indicator can be configured in seconds.

Video Tutorial: Step by Step

Check out other practical tutorials on the Jestor YouTube channel.

Get to know Jestor

With Jestor, you can automate workflows, connect teams, and build internal systems your way — all without code and powered by AI. Discover Jestor at jestor.com and see how to take your company's operations to a new level of efficiency and control.

Read more