From the introduction, I can see a list of backend technologies. But do they have a high level architecture diagram? I don't know what I really need for production setup.
Apache Superset
181–190 of 201 posts
Re: Apache Superset
#182Earlier quoted context omitted.
I love Grafana but Grafana doesn't really support non-time-series visualization that well.
Why is that, though? I'd think that there'd be some plugins/extensions for Grafana that could do this. Grafana could then become the next PowerBI/Tableau/Superset killer eventually.
Different audience / use case. I've noticed that products often lean towards speaking to app builders (full stack swe's) or data builders (data analysts / scientists / data engineers). They require different mental models I feel.
Grafana I sense is culturally focused on observability visualization (aka needs of full stack devs). Culture is very hard to change!
Re: Apache Superset
#183Can this work to give end-users/customers the ability to create their own reports/charts, respecting data access visibility etc?
I am in need of a "dashboarding" feature in our SaaS, but it seems there's a gap between PowerBI/Tableau/Metabase/Superset and various charting libraries. The former are too much "turn key" and the latter require a ton of work to setup all the chart-building UI and features...
Re: Apache Superset
#184Is 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.
I'll say PowerBI has the potential to be more powerful, but you need to love the whole M and DAX languages eco system. And the integration with python and R it's not that bad.
But if your vis are with the scope of native Tableau capabilities, then Tableau it's more friendly and gets less in the way of you and your work.
Re: Apache Superset
#185From the introduction, I can see a list of backend technologies. But do they have a high level architecture diagram? I don't know what I really need for production setup.
I wanted the same info, sadly lacking.
AFAICT needs a db (MySQL/Postgres) and a cache (Redis/Memcached) and one (or more?) web workers.
Then optionally also Celery workers (for "async queries" i.e. slow running)... not sure how optional that is though.
Re: Apache Superset
#186Earlier quoted context omitted.
The lack of a semantic layer and join limitations are what made me pass on superset, but that was a couple years ago so maybe those features have been added. I built my own semantic layer instead. I use this in production in my company but obviously use at your own risk as it's a one-man show. https://github.com/totalhack/zillion
This looks interesting for me, but I'd really like more detail about the architecture and deployment in the docs. There is this: > A final SQL query against the combined data from the DataSource Layer > The Combined Layer is just another SQL database (in-memory SQLite by default) that is used to tie the datasource data together and apply a few additional features such as rollups, row filters, row limits, sorting, piv…
Or from a comment elsewhere in this thread about Superset:
> Superset lets you join tables within the same database. If you want to do cross-DB joins, we have a new (beta) in-memory meta-DB that lets you do this
...is it this?
Re: Apache Superset
#187I wonder why so few BI software support Pi databases. They are pervasive and mission critical in commodity industries, but there only seems to be proprietary options available.
Re: Apache Superset
#188Earlier quoted context omitted.
They were also more specifically authored by the same individual!
Maxime, the original author of Airflow/Superset, is also the CEO of Preset (where I work), so he/we are still working on Superset every day :)
Oh that's awesome! Must be awesome to work on that. We've been using Airflow in production for 6 years at this point with various clients and it's been great, and we're trying to sell people on Superset now as well.
Re: Apache Superset
#189We use metabase heavily at work. However where it seems like all these tools fall down is organization around the hundreds of dashboards and questions. I wish it had like a built wiki or something to build out more navigation. Anyone know of any good ways to do that?
Maybe take a look at https://datahubproject.io/integrations ? I only heard about it today, but it looks pretty promising. Spun out of LinkedIn, open source, lots of integrations, including Metabase
Re: Apache Superset
#190Can this work to give end-users/customers the ability to create their own reports/charts, respecting data access visibility etc? I am in need of a "dashboarding" feature in our SaaS, but it seems there's a gap between PowerBI/Tableau/Metabase/Superset and various charting libraries. The former are too much "turn key" and the latter require a ton of work to setup all the chart-building UI and features...
Have a look at Embeddable.
It’s still pretty new but build by an experienced team.
It’s commercial software though.