In case you didn't know, open-source BI is here, and prepping to take over the BI world. Herein, we'll explore how to optimize slow BI dashboards, exploring solutions from caching and sampling to precomputed aggregations. We'll explore practical examples using Trino, Postgres, and Apache Superset, targeting sub-π-second query response times.