3 ms·
Such a huge landscape of BI and data visualization tools. Are there any clear open source leaders? Apache Superset?
by xnx 3y ago
Such a huge landscape of BI and data visualization tools. Are there any clear open source leaders? Apache Superset?
- noughtme 3y agoAlso Metabase, which I found easier to deploy and use.
- dacort 3y agoMetabase 47 also has new serialization features in paid editions that allow for git-based workflows. https://www.metabase.com/learn/administration/git-based-workflow https://www.metabase.com/learn/administration/git-based-work...
- RedShift1 3y agoRight now I'm heavily into Grafana but when it comes to BI it kinda falls flat, I regularly have to fall back to using the Plotly plugin to create the charts (but it's getting better, at least you can do a normal scatter or bar chart out of the box since version 8. Labeling the axes is still a problem though). Navigation is also problematic, like jumping to a source table takes a lot of effort to make (basically you have to create a new dashboard and do some hyperlinking instead of there being a ready to go "view source data" button). I feel like there's a lot of friction to get Grafana to do BI, but I've also invested so much time in it I'm afraid to jump ship...
- amcaskill 3y agoSuperset and metabase are definitely the OSS leaders. I work on an open source code-based BI tool called Evidence, which might be of interest to you. It's effectively a static site generator aimed at building automated reports and analysis. https://github.com/evidence-dev/evidence https://github.com/evidence-dev/evidence Previous discussions on HN: https://news.ycombinator.com/item?id=28304781 https://news.ycombinator.com/item?id=28304781 - 91 comments https://news.ycombinator.com/item?id=35645464 https://news.ycombinator.com/item?id=35645464 - 97 comments
- cvalka 3y agoThere's redash as well.
- dingdong33 3y agoIt is a dead project
- Jgrubb 3y agoI really, really like your idea with Evidence. I long for a mode in Metabase that’s like a “notebook mode”, where the main focus is narrative and it’s ornamented with viz, rather than the other way around. I want to be able to publish this notebook when I’m done and then be able to hand that around, the same concept that you’ve built Evidence around. I think that’s a very good idea, so thanks. The main thing keeping me from switching is that Metabase’s query builder and visualizations are too good for 95% of my work. It’s hard to picture going back to writing _all_ the SQL.
- amcaskill 3y agoThank you! I hear that. We're making a lot of progress on reducing the amount of sql you need to write, keeping it DRY etc. Making the dev experience really buttery and high leverage is definitely a priority. Here are a few of the things we're working on in that regard: 1. Making our components issue their own queries so that you don't need to write full sql expressions, just fragments when you're defining the chart you want. 2. Improving intellisense -- right now you get "slash commands" and snippets in our vscode extension to invoke components (which are really sweet), but we're aiming to get to a full intellisense type of experience. 3. Supporting external metrics layers where it makes sense. We've got some users using Cube, we're interested in Malloy, and the dbt semantic layer, those types of things. One of our team members is very keen on building something he calls "Evidence studio", sort of a wsywig you could invoke during development for generating basic queries, setting up charts etc. that syncs the components into their text representation. That'd be further off though :)
- doctorpangloss 3y agoWhat do people use for an "analytics.js" for reporting events with common items like campaign data, user device and user profile measurements, and related from browsers and devices?
- FridgeSeal 3y agoI’d advise metabase over superset. Superset looked good, but operating superset quickly runs into the same Python issues all Python software suffers from. Sometimes it would just break for no apparent reason. Configuring it was a nightmare of magic Python code and unclear settings. Trying to use plugins was equally painful: due to the poor boundary separating the applications dependencies from the plugins dependencies, adding a db connector could just bork the whole application.
- PetahNZ 3y agoOr like not being able to delete a user without running some SQL: https://github.com/apache/superset/issues/13345 https://github.com/apache/superset/issues/13345 Almost instantly run into this issue setting up a test instance of Superset. And the issue has been around for years.
- xnx 3y agoVery sound advice. I started the setup process for Superset, and it's even worse on Windows. Contrast that to Superset which is a single .jar file and worked instantly.
- amarshall 3y agoOne of those “Superset” seems wrong.