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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |