chertBI
العربية Request a demo

Self-hosted business intelligence · English & Arabic

From raw data to decisions. Every question, one governed platform.

chertBI connects to the databases you already run, turns their tables into trusted metrics, and lets everyone answer their own questions — with a point-and-click explorer, a full SQL workbench and interactive dashboards. Embed any dashboard inside chertERP, keep every byte on your own servers, and work in English or Arabic.

Request a demo Follow a question
Lifecycle stages
10
Platform components
24
Chart types
40
Languages
2

Three ways in

Whoever asks the question, there is a seat for them

Leaders read the business from dashboards. Analysts go as deep as SQL lets them. ERP owners put the answers where work already happens.

I run the business

Open a dashboard, set the region and the period, click a slice to filter every other chart, and drill into the rows behind any number — in Arabic or English.

I analyse data

Write SQL with autocomplete, or build charts by pointing and clicking. Define metrics once, certify them, and publish answers the whole company can trust.

I run chertERP

Put BI screens inside ERP menus. Viewers never need a chertBI account, tokens live for five minutes, and every tenant sees only its own rows.

The analytics lifecycle

Every answer follows the same path. chertBI covers all of it.

Ten stages, from a database connection to a governed, embedded dashboard. Select a stage to see what happens — and which parts of chertBI make it work.

Stage 01 / 10

Connect

Point chertBI at your data

Add a database with a standard driver — PostgreSQL works out of the box — choose what SQL users may see and do, or upload CSV and Excel files into an allowed database.

Powered by

Stage 02 / 10

Model

Datasets, metrics, meaning

Register tables as datasets or write a virtual dataset in SQL. Define metrics and calculated columns once, describe and format them, and certify the ones people should trust.

Powered by

Stage 03 / 10

Query

Ask in SQL

A multi-tab SQL workbench with a schema browser, autocomplete and query history. Save the query, download the result, or turn it straight into a dataset or a chart.

Powered by

Stage 04 / 10

Explore

Ask without code

Pick a dataset, drop in metrics, dimensions, filters and a time grain; the query engine writes the SQL for your database's dialect and the result appears beside the chart.

Powered by

Stage 05 / 10

Visualise

The right picture for the question

More than forty chart types — trends, comparisons, distributions, flows, hierarchies and maps — with number formats, colour schemes and annotation layers.

Powered by

Stage 06 / 10

Assemble

Dashboards people actually use

Drag charts onto a grid with tabs, rows, headers and markdown. Publish when ready, mark favourites, and share a permalink that remembers the filters.

Powered by

Stage 07 / 10

Filter & drill

From the headline to the row

Native filters for values, ranges and time; click any slice to cross-filter the whole dashboard; drill by another dimension or drill to the detail rows behind a number.

Powered by

Stage 08 / 10

Accelerate

Fast the second time — and the hundredth

Chart results, filter state and explorer state are cached in Redis, so a busy morning does not hit the database a hundred times. Force a refresh whenever you need fresh numbers.

Powered by

Stage 09 / 10

Share & embed

Answers where the work is

Export to CSV, Excel, image or PDF, or embed the dashboard itself inside chertERP: the ERP backend asks for a short-lived guest token and the embedded view renders bare, in the ERP's own screen.

Powered by

Stage 10 / 10

Govern

The right people, the right rows

Roles decide who can view, explore or write SQL; database and dataset permissions decide what they can reach; row-level security decides which rows they ever see.

Powered by

Interactive architecture

Every layer of an analytics platform — and the chertBI component that runs it

Select any component to learn what it does, or play a journey and watch a question travel through the platform.

Select a component or play a journey.
01

People & channels

Where questions are asked and answers are read.

02

Analytics workspace

Everything people build: charts, dashboards, queries.

03

Engines

Meaning, SQL generation, speed and memory.

04

Your data

Your databases stay where they are; chertBI reads them.

S

Security & governance

Who sees what — down to the row.

O

Operations

Self-hosted, backed up, rebuilt from source.

Details appear in the panel above the diagram.

Every function, at a glance

Everything a data-driven company needs — already in the product

No per-seat licences and no modules to bolt on. Every capability below shares one semantic layer, one permission model and one cache.

Dashboards

  • Drag-and-drop grid with tabs, rows and markdown
  • Native filters: value, range, time, time grain
  • Cross-filtering between charts
  • Draft / published, favourites, permalinks

No-code exploration

  • Point-and-click chart builder
  • Metrics, dimensions, filters, time grain
  • Switch chart type, keep the question
  • Results and samples beside every chart

SQL workbench

  • Multi-tab editor with autocomplete
  • Schema and table browser
  • Query history and saved queries
  • Any result → dataset or chart

Visualisation library

  • 40+ chart types
  • Trends, distributions, flows, hierarchies
  • Country maps, including Saudi Arabia
  • Formats, colour schemes, annotation layers

Drill & interact

  • Drill to detail — the rows behind a value
  • Drill by another dimension
  • View the query behind any chart
  • Full-screen charts and dashboards

Semantic layer

  • Physical and virtual (SQL) datasets
  • Reusable metrics and calculated columns
  • Certified datasets and metrics
  • Descriptions and number formats

Data connections

  • PostgreSQL ready out of the box
  • MySQL, SQL Server, Oracle, ClickHouse, Snowflake, BigQuery, Trino…
  • CSV and Excel upload
  • Per-database SQL, DML and timeout controls

Export & share

  • Chart data to CSV or Excel
  • Dashboards to image or PDF
  • Permalinks that keep filter state
  • Import / export assets between environments

Embedded analytics

  • Embed SDK for any host page
  • Guest tokens, 5-minute expiry, auto-refresh
  • Tenant row filters inside the token
  • Allow-listed embedding origins

Security & governance

  • Roles: Admin, Alpha, Gamma, SQL Lab
  • Database, dataset and dashboard permissions
  • Row-level security filters
  • Action log of who did what

Performance

  • Redis cache for chart data (up to 1 h)
  • Cached filter and explorer state
  • Force-refresh on demand
  • Async queries & scheduled reports (worker tier)

Bilingual & branded

  • Full Arabic interface, right-to-left
  • Language switch in the navbar
  • chert identity: coral theme, logo, favicon
  • No third-party telemetry

The chart library

More than forty ways to see your data

A selection from the library. Every chart is built in the explorer, filtered by the dashboard and cached by the same engine.

Trends & comparisons

  • Big number + trend
  • Line
  • Area
  • Bar
  • Mixed
  • Waterfall

Parts & hierarchies

  • Pie & donut
  • Treemap
  • Sunburst
  • Funnel
  • Gauge
  • Radar

Distributions & flows

  • Histogram
  • Box plot
  • Scatter & bubble
  • Heatmap
  • Sankey
  • Calendar heatmap

Tables & maps

  • Table
  • Pivot table
  • Country map
  • World map
  • Word cloud
  • …and more

Embedded in chertERP

BI screens inside the ERP — without a second login

chertERP and chertBI remain two separate systems, integrated. The ERP keeps its menus, titles and right-to-left shell; chertBI renders the dashboard inside it, scoped to one tenant.

  • No chertBI accounts for ERP viewers
  • Tenant isolation by row-level security
  • Only allow-listed ERP origins may frame it
  • Locale handed off; the ERP shell owns RTL
In the ERP screen
import { mountChertBI } from "./embed-chertbi.js";

await mountChertBI({
  containerId: "chertbi-container",
  embeddedDashboardUuid: "<dashboard-uuid>",
  locale: document.documentElement.lang,
});
// guest token ← chertERP backend:
//   1 dashboard · tenant RLS · 5 min, auto-refresh

One platform, many engines

One workspace in charge. Proven open-source engines underneath.

chertBI is built from Apache-2.0 open-source code and compiled from its own source tree. Each engine below does one job well and runs on your server — none of them is exposed to the internet.

The workspace

chertBI Workspace

Dashboards, explorer, SQL workbench, datasets and administration — bilingual, right-to-left in Arabic, in any modern browser.

app.chertbi.com

Embedding

chertBI Embed

The embedded SDK and guest-token flow that put live dashboards inside chertERP — or any host app you allow.

chertERP

Query engine

chertBI Query

Writes dialect-correct SQL from every chart, applies row-level security, enforces limits and timeouts.

Internal engine · never exposed

Semantic layer

chertBI Datasets

Datasets, virtual datasets, metrics and calculated columns — certified once, reused in every chart.

Internal engine · never exposed

Visualisation

chertBI Charts

More than forty chart types on a modern charting engine, with formats, colour schemes and annotations.

Internal engine · never exposed

Cache · Redis 7

Cache & rate limits

Holds chart results, filter state and explorer state, and backs per-user rate limiting.

Internal engine · never exposed

Metadata · PostgreSQL 16

Metadata store

Users, roles, connections, datasets, charts, dashboards and saved queries — dumped every night.

Internal engine · never exposed

Workers · Celery

Background tier

Async queries, scheduled reports and alerts — included, and enabled when a workload calls for it.

Optional tier · enable when needed

Gateway · Nginx

HTTPS & routing

Terminates TLS with auto-renewing Let's Encrypt certificates and routes chertbi.com and app.chertbi.com.

Internal engine · never exposed

Why chertBI

Enterprise analytics, on your own ground

One meaning for every number

Metrics are defined once in the semantic layer and certified — the board pack, the ops screen and the ERP widget all say the same "revenue".

Arabic and English, equally

A complete right-to-left Arabic workspace, a language switch on every page and the chert identity throughout.

Self-hosted and sovereign

The workspace, metadata, cache and backups run on your servers. Your databases are queried in place. No per-seat licences, no telemetry.

ERP-native, not ERP-bound

Built to live inside chertERP with guest tokens and tenant isolation — and just as useful on its own at app.chertbi.com.

Governed by design

Roles, per-database and per-dataset permissions, row-level security, secure sessions and an action log — from day one.

Open source underneath

Built from Apache-2.0 code with licences intact and compiled from source — no lock-in to a vendor's roadmap.

Your next decision can start in chertBI.

Tell us where your data lives today — we will set up a walkthrough with your tables, your metrics and your chertERP screens.

Request a demo Open the workspace