I chose Metabase because has a nice visual interface, it is intuitive (I never had to check the documentation), and had all the features I required like being able to export in CSV, XLSX, JSON, and the scheduled reports that can be sent to a list of recipients according to a schedule, and finally being able to invite the non-technical team members to use the tool safely with groups & permissions. This time I wanted to try something open-source and there are several very good options like Redash, Superset, Lightdash or Metabase. There are a lot of Business Intelligence tools on the market, but from my experience they are either too limited or too complex or too expensive (e.g. Then, I would have to create a Web UI with filters that will call the API endpoint and also create a scheduled job that will send the report on the expected date/time. Usually to do that I have to create a new API endpoint that will do authentication, execute a complex SQL query against the database and transform the results to CSV. Last week, one of our startup customers (e-commerce) contacted me to create a new database query, apply a lot of special conditions, make it available in their dashboard and send it on the last day of each month to the company's accountant. A roles & permissions system for inviting your colleagues.The ability to subscribe to dashboards and receive them on a schedule by email or slack.A ton of visualization options (and it's possible to customize a lot of things though the UI, too!).Once you connect Metabase to your existing database (PostgreSQL, MySQL, MongoDB, SQL Server, SQLite, Redshift, BigQuery and others. It's the kind of tool you can't wait to start using barely 5 minutes after you start to see the demo! I tried it for the first time 3 weeks ago, and I have already deployed it for multiple large customers and added it to Elestio's catalog. Metabase is one of the simplest and most powerful business intelligence tools I have tried in the last few years.

Mongodb metabase