Metabase

Metabase is the BI tool that doesn't feel like enterprise software, which is both its greatest strength and its limitation. The visual query builder lets anyone create reports without writing SQL, and the dashboards are genuinely beautiful — charts, funnels, cohort analysis, all presented in a clean, readable format. The self-hosted free version has unlimited users and questions, which is remarkably generous. What makes Metabase special is how it empowers non-technical team members to explore data independently. The "Ask a question" interface is intuitive enough that your marketing team can build their own reports without pestering engineers. The SQL editor is available for power users who need more control. The trade-off is that for complex analytical workloads, you'll eventually want something more powerful like Apache Superset. But for most teams, Metabase hits the sweet spot between simplicity and capability.

Good first choice if you want a practical tool without spending the afternoon reading developer docs.