Modern BI tools like Apache Superset promise quick insights through interactive, no-code dashboards. However, they often fail to deliver due to the unsatisfactory performance and limited capabilities of the query engines that power them. This session will explore the essential capabilities query engines must possess to achieve the BI performance everyone hopes for, but few often get, including:

• Fast and flexible Ad-hoc Queries: Run complex SQL queries on the fly without extensive pre-computation for interactive data analysis.
• On-demand query acceleration: Enable your underlying engine to add pre-computations on demand without manual SQL rewriting.
• Support for open formats: Integrate with open formats to simplify your data pipeline while improving data governance.

See all of these in action with a demo using Preset (powered by Apache Superset) and CelerData (powered by StarRocks).

---

About the author:

Sida Shen is a contributor to the StarRocks project and a product manager at CelerData. As an engineer with a background in building machine learning and big data infrastructures, he oversees the company’s market research while working closely with engineers and developers across the analytics industry to tackle challenges related to data lakehouse analytics.