Re:Insights – Open-Source Self-Hosted Business Intelligence ...
by salsakran on Monday February 17, 2020 @02:46PM
(#22350104)
I work on Metabase and wanted to say congrats on putting all this together. Excited to see more open source options for BI.
Just as a point of fact - that blog post you linked to is 3.5 years old at this point.
Even at that time we had implicit joins (for things like top grossing countries if you had an FK in your transactions back to a table w/ the country field).
We've had joins in our notebook mode for a while now (https://www.metabase.com/docs/latest/users-guide/custom-ques...)
Re:Insights – Open-Source Self-Hosted Business Intelligence ...
by mariusandra on Monday February 17, 2020 @03:20PM
(#22350369)
Ah, my apologies! Thanks for clearing this up!
Regarding Metabase, Insights has full blown first class support for joins... so we don't have to write blog posts like this [1]. My research shows Metabase works great with normalised tables (like a CSV file? normalised NoSQL table, etc)... but falls short when you need to visualise relations between tables. You can look at for example all your orders, think "I wonder what's the highest grossing country" and have the results at your fingertips.
Regarding Redash, which seems to be a nice SQL editor, in Insights you don't need to know any SQL to get answers. Thus "business stakeholders" can get dirty with the data with minimal training.
Regarding Superset, I'm unfortunately not familiar with its latest features. Please somebody reply with an overview! :) Last time I checked it (many years ago), it was pretty complicated to get it installed (some python issues?) and I'm not sure if you could explore data without knowing SQL. Insights in comparison is super easy to install (npm install -g insights) and get going with.
[1]: https://www.metabase.com/blog/Joins/