Live data from Hacker News

Apache Superset

superset.apache.org

151–160 of 201 posts

Re: Apache Superset

#151
post #94

Is Superset a decent tool if you're just a single person doing data analysis? Say I have a handful of sqlite databases, and just want to be able to develop some queries / charts. I was looking into Tableau / Power BI / Superset, and all of them seemed pretty heavyweight for a single user, and none of them seemed super easy to get setup locally. Any recommendations for a good piece of software for the single user case…

Tableau is the best, most powerful, most mature of the three, most feature complete and easiest of the three. I think they give you a 30 day trial. This is a single user application, unless you make it part of your built application.

Superset isn't a single user application?

Re: Apache Superset

#154
post #114

Earlier quoted context omitted.

They are doing pretty well that it is even clear what the project is really even about. Good luck figuring that out within 30 seconds of hitting the average Apache project homepage.

There seem to be dozens of Apache "Big Data" projects that all look kinda the same unless you are a Big Data person.

Even if you are a data person. The ASF doesn't mind overlap between projects [1], it spreads its bets and lets the market choose the winners.

1. https://www.apache.org/foundation/how-it-works/#incubator

Re: Apache Superset

#155
post #7
post #2

> Superset is fast, lightweight, intuitive, and loaded with options that make it easy for users of all skill sets to explore and visualize their data, from simple line charts to highly detailed geospatial charts. I tried Superset a few years back, and maybe it's changed since then, but intuitive is about the last thing I'd use to describe it. Things which I could figure out in a few minutes on any other BI tool liter…

I also found Superset unintuitive to use and setup as well. I settled on standing up Metabase because it was so simple to get started with trying it since it can be launched as a single jar. The business users loved it and so did I and administration with a Postgres backend instead of the internal h2 database was a breeze.

My experience with Superset was the opposite. It's easy to install using containers. You can have it up and running and connected to ClickHouse in a few minutes. I also found the internal design pretty intuitive--the SQL query lab is much easier than Grafana's editor.

I like Grafana too, but there's basically no isolation between your query and the SQL database at least in the Altinity Grafana plugin for ClickHouse which is the main one I use.

Re: Apache Superset

#156
post #94

Is Superset a decent tool if you're just a single person doing data analysis? Say I have a handful of sqlite databases, and just want to be able to develop some queries / charts. I was looking into Tableau / Power BI / Superset, and all of them seemed pretty heavyweight for a single user, and none of them seemed super easy to get setup locally. Any recommendations for a good piece of software for the single user case…

If you are doing data analysis I don't think any of the 3 pieces of software you mentioned are going to be that helpful.

I see these products as tools for data visualization and reporting i.e. presenting prepared datasets to users in a visually appealing way. They aren't as well suited for serious analytics.

I can't comment on Superset or Tableau but I am familiar with Power BI (it has been rolled out across my org), the type of statistics you can do with it are fairly rudimentary. If you need to do any thing beyond summarizing (counts, averages, min, max etc). It is not particularly easy.

For data analysis I use SAS or R. This software allows you do things like multivariate regression, timeseries forecasting, PCA, Cluster analysis etc. There is also plotting capability.

Both these products are kind of old school, I've been using them since early 2000's, the "new school" seems to be Python. Pretty much all the recent data science people in my organization use Python. Particularly Pandas and libraries like Seaborn (https://seaborn.pydata.org/).

The "power" users of Power BI in my organization tend to be finance/HR people for use cases like drill down into cost figures or Interactively presenting KPI's and other headline figures to management things like that.

Re: Apache Superset

#158
Tried installing it, locally in a Python Virtual Env.

Apparently installation will not work with Python 3.12, dur to deprecation of distutils.

Does anyone have any method to install this?

Re: Apache Superset

#160
post #7

Earlier quoted context omitted.

I also found Superset unintuitive to use and setup as well. I settled on standing up Metabase because it was so simple to get started with trying it since it can be launched as a single jar. The business users loved it and so did I and administration with a Postgres backend instead of the internal h2 database was a breeze.

I had the same experience. Featurewise Superset looked better, but after wasting a couple of hours trying to install it, I just gave up. Instead I installed Metabase in 5 minutes tops: spin ec2 instance, whether and java -jar . I've never looked back. The only thing that turns me off I'd that it's implemented in an obscure language. At one time I wanted to add some custom postprocessing to an api (given an sql query,…

Clojure is not particularly obscure
Post reply on HN