How are you using Redash?
-
@robi Yeah, I set it up as you suggested, but confusion/difficulty around permissions and the requirement of SQL to build queries brought be back to Metabase. I've played with Apache Superset before, the other of the "big 3" in this space (if we keep Grafana separate; imo not in the same category) though I don't remember a ton about it by comparison. Either way, pointing it at the databases was the easy part.
-
Most useful thing for me with any of these apps is building pivot-tables, which sadly is an enterprise feature in Metabase. Not played with Redash yet but if anyone knows if it does pivot-tables, that would be a huge win for creating self-service reporting tools.
-
@robi Yeah, if it's automatic or nearly automatic "here's some interesting things" you want, it's worth getting the data model set up with some added detail in the Metabase Admin, which is easy enough (it does a pretty good job of inferring common conventions), and then browsing through the data and doing different visualizations is dead easy, plus it'll try to do some automatic "X-Rays" as it calls the auto-generated dashboards. Here's an example of a table that I haven't customized the data model on at all, but it did a good job with, as an example:
Edit: Ugh, no GIFs allowed. Here's a sequence of static shots:
I'd suggest playing with both - there's necessarily going to be a fair bit of preference at play here.
-
@marcusquinn https://redash.io/help/user-guide/visualizations/pivot-table-visualizations
Accessible from the in app help under Visualizations
-