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#
- Semantic model — tables, relationships, cardinality, calculated columns, hierarchies, calendars, filter direction (bidirectional), relationship roles (role-playing), M:N bridges.
- Measures, formulas and KPIs — central measures library, formula language (DAX-like, in pt-BR), calculation groups, parameters, KPIs, grouping/binning.
- Editor, pages, layouts and themes — canvas,
drag and drop, undo/redo, autosave, versions, draft×published, pages,
layout per device, themes.
- The editor ribbons — every button on Insert, Data, Page, Tools, Visual, Format and Relationships.
- The visual pane — the Data, Format and Interactions tabs, section by section.
- Fields, measures and variables — search, "Add as…", calculated column, Measures and Variables.
- The right-click menu — Position, Size, Arrange and the card's "…" menu.
- Layout per device and TV mode — desktop, tablet, phone, TV and the TV link.
- Visuals — the certified catalog of 46 data visuals + 4 layout elements, families, capabilities and how to validate each one.
- Filters and interactions — 8 slicer types, cross-filtering, drill-down/up, drill-through, tooltips, bookmarks, relative dates, sync across pages.
- Data modes: Import, DirectQuery and cache
— snapshot (Import), live DirectQuery, managed cache, incremental refresh,
cost guard.
- Migrate visuals to the Import model — assisted migration, with before and after and undo.
- 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
- What it is — a one-sentence definition.
- When to use it — the business problem it solves.
- How it works — the mechanism, in product language.
- Prerequisites — what needs to be configured first.
- How to validate — step by step to confirm it works in your workspace.
- Limits and caveats — what it does not do, and where there's a condition or gap.
- Sample data (synthetic) — a fictitious sample to reproduce.
- 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 prefixaurora(prd_aurora_bronze/prd_aurora_silver/prd_aurora_gold). - Example tables:
vendas(fact),produtos,clientes,filiaisand the time dimensioncalendario. - 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.