BI platformSample
Apache Superset
Apache Software Foundation
An open-source BI platform first built at Airbnb, with SQL Lab for exploration and a large library of chart types.
Licence
Open source
Built by
Analysts
Languages
SQL, Jinja templates
Runs on
Self-hosted, Managed services
Scores
Out of 5. The tick marks the average for BI platforms in the library.
- Ease of use
- 3
- Visual control
- 3
- Interactivity
- 3
- Sharing
- 3
- Governance
- 3
- Low cost
- 5
- Data scale
- 4
Strengths
- Free, under the Apache 2.0 licence
- Connects to almost any SQL database
- Queries run in the database, so it scales with the warehouse
Limitations
- Installing and upgrading takes engineering effort
- Dashboards feel less polished than commercial tools
- A thin semantic layer
Best for
- Engineering-led data teams
- Open-source data stacks
Other BI platforms
Power BI
Microsoft
Microsoft’s BI platform: model data in Power BI Desktop, publish interactive reports to the Power BI service and share them across Microsoft 365.
FreemiumDAXPower Query M
Tableau
Salesforce
A visual analytics platform built around drag-and-drop exploration, known for polished and highly interactive dashboards.
CommercialCalculated fieldsLOD expressions
Qlik Sense
Qlik
A BI platform built on Qlik’s associative engine: every selection shows at once which values are related, and which are not, across the whole dataset.
CommercialQlik load scriptSet analysis