Embiro BI

From raw data to decisions, in one platform

Embiro BI is built on proven open-source analytics technology used by thousands of organizations worldwide, and run for you as a service, with the features growing businesses need on top.

Connect data

Use the data you already have

Connect a Google Sheet or a database in a few clicks. Embiro BI reads your data where it lives and never asks you to move it.

  • Google Sheets, PostgreSQL, MySQL, Google BigQuery, Trino and more
  • Databases on private networks through an SSH tunnel
  • A fixed outgoing address you can allow-list in your firewall
  • Datasets with your own metrics, so everyone uses the same definitions
The datasets list in Embiro BI
Charts

Build charts without writing code

Choose a dataset, drag in what you want to measure and how to break it down, and pick from more than forty chart types: bars, lines, tables, pivot tables, maps, funnels, gauges and more.

  • Time comparisons and rolling averages
  • Conditional colours on tables
  • Export to CSV, Excel or image
The chart builder in Embiro BI
Dashboards

Dashboards your whole team understands

Arrange charts, numbers and notes on a dashboard and share it. Filters for date, region or product apply to every chart at once, and clicking a chart filters the rest.

  • Dashboard filters and cross-filtering
  • Tabs, notes and headings to tell the story
  • Each chart can also have its own date range
A programme reach dashboard: beneficiaries reached against target by district and programme
SQL Lab

A full SQL editor for analysts

Write SQL with autocompletion, browse tables and columns, and turn any result into a chart. Long queries run in the background, so you can keep working.

  • Query parameters for reusable queries
  • Saved queries and query history
  • Download results as CSV
SQL Lab in Embiro BI
Alerts & reports

Know when something changes

Set an alert on any number and get an email when it crosses a line. Or send a dashboard to your managers every Monday morning.

  • Alerts on a schedule you choose
  • Scheduled reports as PDF or image
A budget against actual dashboard with variance by department

Embed dashboards anywhere

Put live dashboards in your own website or customer portal. Visitors see only the dashboard you choose, filtered to what they may see.

An API for your developers

Organization API keys to run queries, fetch results and manage content from your own systems.

Teams and security

Each organization's data is kept separate, and you decide who sees what.

Roles and groups

Super Admin, Admin, Analyst and Business User roles, and groups that limit people to the dashboards and data meant for them.

Single sign-on

Sign in with Google, or with your company's own identity provider (OpenID Connect or SAML), with automatic user provisioning through SCIM.

Your own address

Every organization has its own address, like yourcompany.embirobi.com. Enterprise customers can use their own domain.

Activity log

See who signed in, ran queries, exported data or changed settings, and export it.

Your data stays yours

Connection passwords are encrypted, and Embiro BI blocks connections to internal network addresses.

Built on open source

A proven, transparent open-source analytics engine at the core, actively maintained by a large community.

Try Embiro BI free for 14 days

Register your business in a minute, connect your data and share your first dashboard today.