Skip to content

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

ingestia.bi — BI module documentation

On this page (5)

ingestia.bi is the dashboards and analytical modeling layer of the ingestia.io platform — datalake + BI + AI for Brazilian small and mid-sized businesses in the cloud, in the Brazil region (São Paulo). These pages cover the semantic model, the editor, the visuals, filters/interactions, the data modes (Import and DirectQuery) and export/distribution.

Viewing and editing are different states

Opening a dashboard enters Viewing; Edit is an explicit action (?modo=editar). Print preview is the report page, not the viewing mode. See View a dashboard.

Contents#

  1. Semantic model — tables, relationships, cardinality, calculated columns, hierarchies, calendars, filter direction (bidirectional), relationship roles (role-playing), M:N bridges.
  2. Measures, formulas and KPIs — central measures library, formula language (DAX-like, in pt-BR), calculation groups, parameters, KPIs, grouping/binning.
  3. Editor, pages, layouts and themes — canvas, drag and drop, undo/redo, autosave, versions, draft×published, pages, layout per device, themes.
  4. Visuals — the certified catalog of 46 data visuals + 4 layout elements, families, capabilities and how to validate each one.
  5. Filters and interactions — 8 slicer types, cross-filtering, drill-down/up, drill-through, tooltips, bookmarks, relative dates, sync across pages.
  6. Data modes: Import, DirectQuery and cache — snapshot (Import), live DirectQuery, managed cache, incremental refresh, cost guard.
  7. Export and distribution — XLSX, CSV, PNG, PDF, printing, public links, TV link, embed, email/WhatsApp subscriptions.
    • Read a dashboard — filters, pages, cross-filtering and each chart's menu (Focus mode, See records, CSV, image, Notes).
    • Dashboard header actions — Refresh now, Print preview, Excel, PDF, PPT and More actions.
    • TV link — the dashboard on the big screen, rotating through pages.
    • Subscriptions and alerts — scheduled delivery by email/WhatsApp and alerts on a chart.

How to read this documentation: the template (8 fields)#

Every documented feature is described by 8 fixed fields. This keeps the docs honest and comparable across pages.

The 8 fields

  1. What it is — a one-sentence definition.
  2. When to use it — the business problem it solves.
  3. How it works — the mechanism, in product language.
  4. Prerequisites — what needs to be configured first.
  5. How to validate — step by step to confirm it works in your workspace.
  6. Limits and caveats — what it does not do, and where there's a condition or gap.
  7. Sample data (synthetic) — a fictitious sample to reproduce.
  8. Evidence — the nature of the proof behind the claim (deterministic suite, frozen reference test suite with an identical result on every run).

About parity with Power BI#

Where we compare with Power BI, we compare capability by capability, with evidence. We don't claim "everything Power BI has" or full parity — ingestia.bi has specific advantages (Brazil maps, formulas in Portuguese, WhatsApp, FinOps per query) and specific gaps (connectivity, a VertiPaq-scale engine, ecosystem). Each page points out what's equivalent and what isn't.

Demo account used in the examples#

All examples use a fictitious, synthetic workspace, the same one as the Getting started guide:

  • Company: Comércio Aurora Ltda (segment: Retail).
  • Workspace: Aurora Varejo · dataset prefix aurora (prd_aurora_bronze / prd_aurora_silver / prd_aurora_gold).
  • Example tables: vendas (fact), produtos, clientes, filiais and the time dimension calendario.
  • People: maria@example.com (owner), joao@example.com (admin), ana@example.com (analyst).

No real data, credentials or personal documents appear in this documentation.


Certified visuals count: 46 data visuals + 4 layout elements = 50 items in the single visuals catalog. The "50+" marketing claim only holds when counting the 4 layout elements (text, shape, image, button). See the full list in Visuals.

Related links