
How to build dashboards on ClickHouse data
How to build dashboards on ClickHouse: how to connect a BI tool, the FINAL gotcha that makes results wrong, materialized views vs raw tables, and when not to.
This page is available in Français.
This page is available in Español.
This page is available in Português (Brasil).

How to build dashboards on ClickHouse: how to connect a BI tool, the FINAL gotcha that makes results wrong, materialized views vs raw tables, and when not to.

A report is a static, detailed snapshot for a set period. A dashboard is a live view of key metrics. Here is how the two differ and when to use each one.

Snowflake acquired Sisu Data and discontinued its standalone product. Learn what happened to the decision-intelligence platform and which alternatives fit its workflows.

Decision intelligence is the discipline of connecting data to the decisions and actions it should drive. Here is a plain definition and a working framework.
“We evaluated Omni and other BI tools, but the speed to insight with Basedash is unmatched.”
Greg Demoge
Co-founder & CPO · FullEnrich
Read case study →
“For a security-conscious company like ours, Basedash instantly clicked. Reports that took weeks are ready in hours.”
Claudio Godoy
AI Agents Lead · Taxfyle
Read case study →

A weekly business review is a short recurring meeting where a team reviews its core metrics against plan to catch changes early. Here is how to run one.

A practical guide to slowly changing dimensions: the SCD types, a decision framework for choosing one, SQL and dbt patterns, and point-in-time reporting.

The managed Redash service shut down in 2021, while open-source Redash continues. Learn the difference and the best cloud and self-hosted alternatives.

Analytics engineering turns raw warehouse data into clean, tested, documented models BI tools can trust. Learn what the role does and when you need it.

How to build real reporting dashboards on your Supabase data: connection options, read replicas, the row-level security gotcha, and which BI tools fit.

A practical analytics maturity model for lean teams: the 5 stages, how to diagnose which one you're in, and the single move that gets you to the next.

Chartio shut down after Atlassian acquired it. Learn what happened to the visual SQL BI platform and which modern alternatives can replace its dashboards.

A data contract is an agreement on a dataset's schema, semantics, and quality. Learn what one includes, why dashboards break without them, and when to use them.

DataGPT, the conversational AI data analyst, has shut down. Here's what happened to the company and the best DataGPT alternatives for teams that still need natural language analytics.

Ad hoc analysis is how you investigate a specific, unplanned data question. Learn a repeatable six-step workflow, with SQL examples and mistakes to avoid.

A data mart is a subject-focused slice of a data warehouse built for one team. Learn the types, how it differs from a warehouse, and when to build one.

Data storytelling means structuring data so it drives a decision. A four-part framework for turning dashboards and reports into stories people act on.