Apache Superset: BI Analytics on an Open Platform

Apache Superset: BI analytics on an open platform

Everyone needs reports, but not everyone wants to pay for each BI user. Apache Superset delivers enterprise dashboards on an open platform with no per-user licence fees. RBC Group implements it on top of your ERP, EPM and data warehouse.

In brief

  • Apache Superset is an open data exploration and visualisation platform under the Apache 2.0 licence: there are no per-user licence fees.
  • Dashboards, a chart builder and SQL Lab come out of the box, and access rights are set by role.
  • Data stays in your databases and inside your perimeter. Superset connects to them directly.

What Apache Superset is

Apache Superset describes itself as an open-source modern data exploration and visualization platform. The project is developed under the Apache Software Foundation. Out of the box you get:

  • more than 40 pre-installed visualisation types plus custom plug-ins;
  • a no-code builder for charts and tables;
  • SQL Lab for analysts who need their own query;
  • dashboard filters, cross-filtering and drill to detail;
  • data caching so dashboards load fast;
  • connections to dozens of databases, including PostgreSQL, MySQL, Snowflake, BigQuery and Trino.

Why companies choose open BI

  • No per-user licence fees. A report can go to a hundred employees or a thousand. The budget goes to infrastructure and implementation, not to seats.
  • Data inside your perimeter. Superset works with your existing databases and needs no separate ingestion layer.
  • No lock-in to a single vendor. Open code, an open API and a large developer community.

A fair caveat: an open platform does not mean free and automatic. You need servers, security configuration, a data model and people who own the result. That is the part we take on.

How Apache Superset fits into your systems

How Apache Superset fits into your systems

What RBC Group does

  • data source audit and design of the metrics model;
  • Superset deployment in your infrastructure or in the cloud;
  • connection to Oracle JD Edwards, IBM Planning Analytics, RBC HCM Solutions and the data warehouse;
  • dashboards for finance, manufacturing, sales and HR;
  • roles, access rights and integration with corporate sign-in;
  • user training;
  • support and further development.

How implementation works

  1. Assessment. Which reports the business needs and where the data lives.
  2. Pilot. One business area, a few key dashboards, the first users.
  3. Data model and security. Shared metric definitions, roles, access.
  4. Scaling. New departments, training, support.

Frequently asked questions

Is Apache Superset free?

The Apache 2.0 licence requires no usage fees. The costs that remain are servers, implementation and support.

Can we move from another BI system?

Yes, step by step: we start with the most used reports and switch the old system off once users have moved.

Where is the data stored?

In your databases. Superset connects to them and does not copy data into a separate store.

Let us talk about your reporting

RBC Group works in Kazakhstan, Uzbekistan, Ukraine and Azerbaijan. We will show Apache Superset on your data and propose a pilot plan.

Contact usmarketing@rbc-grp.solutions, +7 727 258 1712

Sources