20 ms·
No-code BI and ETL tools are intended mainly as a replacement for Excel, not a replacement for Python. If you are an accomplished Python programmer, you might
by hermitcrab 5y ago
No-code BI and ETL tools are intended mainly as a replacement for Excel, not a replacement for Python.
If you are an accomplished Python programmer, you might code a solution or (e.g. if you want to do something ad hoc quickly) use a no-code tool.
If you aren't a programmer, your choice is typically: learn Python, use Excel, wait for a programmer to do it for you or use a no-code tool. A no-code tool will often be by far the best solution.
- instad 5y agoYou are completely right. Just wanted to add that Excel is a great product and it can be considered as a BI tool. The only thing it lacks of is data merging. You can easily merge data across sheets but it becomes a challenging task when you need to merge/“join” data from databases, especially huge datasets. This is where the self-service BI tools come into play. TABLUM.IO simplifies data extraction/load/import from files, web and databases. You can load data from postgres, json file and application API, then merge data into a single table, display as a sheet and draw a chart for it. Wheres it is almost impossible with Excel or GoogleSheet.