Skip to main content

Business Intelligence Platforms

Summary: A BI platform is a self-serve layer for querying, visualizing, and governing access to data that already lives in one place — it doesn't extract, transform, or move data itself.

At a glance​

QuestionAnswer
What is it?A self-serve tool for querying, visualizing, and sharing data that's already consolidated
Why does it matter?Clarifies what BI tools do (and don't do) relative to ETL/ELT tools
When do I use it?Data is already centralized in a warehouse and needs to be explored or shared

How it works​

  • Query: run SQL or use a no-code editor against connected sources.
  • Visualize: turn query results into charts.
  • Dashboard: combine charts, add filters, share with others.
  • Semantic layer: curated, reusable table definitions (e.g. Superset "datasets", Metabase "Models").
  • Alerting/reporting: scheduled emails, threshold alerts.
  • Access control: row-level security, role-based permissions.
  • Caching: store query results for fast dashboard loads.
  • Each query against a BI platform typically targets one connected source at a time — it does not merge data from multiple sources the way ETL/ELT tools do.

Example​

Superset, Metabase, and Looker are common BI platforms. Each connects to a warehouse already populated by an ETL/ELT pipeline, then layers query, dashboard, alerting, and access-control features on top of it.

Remember​

  • "Visualization tool" undersells it — query, dashboard, alerting, and access control are equally core.
  • A BI platform doesn't consolidate data from multiple sources; that's ETL/ELT's job.
  • ETL And ELT - the layer that consolidates data before a BI platform can query it