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.
Apache Superset
151–160 of 201 posts
Re: Apache Superset
#152Re: Apache Superset
#153Re: Apache Superset
#154Earlier 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.
1. https://www.apache.org/foundation/how-it-works/#incubator
Re: Apache Superset
#155> 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.
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
#156Is 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…
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
#157[1] https://blog.adnansiddiqi.me/create-your-first-sales-dashboa...
Re: Apache Superset
#158Apparently installation will not work with Python 3.12, dur to deprecation of distutils.
Does anyone have any method to install this?
Re: Apache Superset
#159https://phabricator.wikimedia.org/T169452
Back then, I used this to generate some custom statistics
Re: Apache Superset
#160Earlier 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,…