10 ms·
Apache Superset
- rglullis 3y agoAnyone that worked it and could compare with Redash?
- skadamat 3y agoWell Redash got acquired so development stopped, biggest difference between Superset & Redash. Preset.io supports Superset still
- rglullis 3y agoRedash development slowed down for sure, but it's not looking abandoned. It's just that I've been using it for some time now, I'm wondering if is anything feature-wise that could justify the switch.
- marcinzm 3y ago> 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 literally took me hours of searching. It didn't help that they decided to rename core concepts at some point so half the online documentation made no sense anymore. Others at those companies who tried it at the time said similar things.
- fayten 3y agoI 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.
- c0brac0bra 3y agoYep, we've really liked Metabase for embedding in our platform.
- datadrivenangel 3y agoMetabase is great. It truly is a BI tool. Superset is more of a visualization platform, which works great if you have engineers building reports. Less good if you expect more junior analysts to be super productive.
- sumoboy 3y agoWe ran into the same exact issue with Superset not being intuitive, just for a different audience that is more technical. Also went with Metabase which is good, easy to use, lacks some a few chart types but overall the past year has seen quite a few changes and bug fixes consistently happening.
- fuzztester 3y agoI just took a look at Metabase. https://www.metabase.com/demo https://www.metabase.com/demo Demo is nice.
- deleted 3y ago[deleted]
- xtracto 3y agoI 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, get some python/pandas postproc command from a sql comment and execute it in the returned table), but the used language is just not for me (some lisp dialect)
- NoThisIsMe 3y ago
- bushbaba 3y agoIt’s more intuitive than the open source alternatives but is not as intuitive as tableau and others.
- marcinzm 3y agoMetabase is more intuitive. Also, being unintuitive isn't great but not the worst thing. A project not even realizing that (and thinking the exact opposite) is much much worse. Unintuitive can be fixed with PRs over time. Delusional project leadership cannot.
- codeduck 3y agoI've just been playing with superset. I'd have to agree. Things which are easy in SQL are... disturbingly hard or nonobvious in superset. And the documentation is sparse at best.
- staticautomatic 3y agoLet’s be honest, intuitive is the last word we’d use to describe most Apache projects.
- pseudosavant 3y agoThey 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.
- slyall 3y agoThere seem to be dozens of Apache "Big Data" projects that all look kinda the same unless you are a Big Data person.
- dzamo_norton 3y agoEven 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 https://www.apache.org/foundation/how-it-works/#incubator
- atombender 3y agoAre there better alternatives?
- FridgeSeal 3y agoIt wasn’t fast either when I used it. What it was though, was riddled with dozens of Python runtime errors and innumerable glitches. Metabase is where it’s at.
- mritchie712 3y agoHad a similar experience with Superset. A few others have mentioned Metabase and I agree it's better, but if you're looking for a different approach to data, check out Definite (https://www.definite.app/ https://www.definite.app/). It's a "data stack in a box". A few things we're doing differently: 1. Built-in data warehouse - We spin up a duckdb database for you to load data to 2. 500+ connectors - You don't need to buy a separate ETL and you can pull in all your data (e.g. Postgres, Stripe, HubSpot, Zendesk, etc.) automatically 3. Semantic layer - Define dimensions, measures, and joins in one place. We have pre-built models for all the sources we support (e.g. the Stripe model already has measures for MRR, churn, etc.) 4. Simple BI - Build a table with the data you want and generate visuals off that table I'm mike@definite.app if you have any questions.
- cogman10 3y agoThis looks like grafana, right? Why would I use this instead of grafana?
- pachico 3y agoThe fundamental difference is that Grafana isn't great at cross referencing data in different data sources. (I love Grafana and I pay for the Cloud version.)
- peterleiser 3y agoI found that running TrinoDB in a docker container and adding the trino plugin to grafana was very straightforward. TrinoDB feels magical sometimes, except that the SQL syntax they use seemed awkward IIRC. Also, there are inexplicable performance problems with certain queries that require trying subtlety different SQL queries until it snaps out of it.
- prpl 3y agoYou can’t trivially plug grafana in front of any SQL database, and grafana is more about graphing/plotting (usually time series).
- xyzzy_plugh 3y agoYou can actually plug grafana in front of any SQL database, but I'm not sure it's a good idea.
- samuell 3y agoMuch more focused on interactive slicing and dicing of data, rather than mostly following a few pre-defined time-series, as is the focus of Grafana. As such, closer to an open source replacement for PowerBI.
- bfung 3y agografana is built more for operational and timeseries data, but not so optimal for complex analytical queries. Ex: up-to-second data on cpu load on a host. superset is the flip side of grafana; not good for up-to-second updates, but good for complex queries. Also, non-time series stuff. Ex: Which customer groups bought which products for all time? <— that type of BI stuff.
- rongenre 3y agoWe use this at my ginormous employer in order to give devs limited access to production data.
- rusackas 3y agoMaybe you can't say who, but I'm sure curious. Add yourself to this page if you can: https://github.com/apache/superset/blob/master/RESOURCES/INTHEWILD.md https://github.com/apache/superset/blob/master/RESOURCES/INT...
- adlpz 3y agoHas anyone tried both this and Metabase? I've used Metabase in a few projects and I find it very nice. This seems more powerful, perhaps? Is it worth it for BI on small datasets?
- CalRobert 3y agoYes, I am at a company using Metabase, but I have a decent amount of experience with Superset (albeit from many years ago). The reason we chose Metabase was that it had table joins, while Superset doesn't (unless it has added them since I used it). It also looks a bit sleeker. But I strongly prefer Superset; I found that with Metabase I had to turn a lot of things off to make it usable (Let me see "the_table" not "The Table"!), I was constantly annoyed at the opacity around models vs "questions", etc. and every time I wanted to change a question Metabase insisted on creating a new one instead. The real issue here was when we wanted to swap out the data source for a lot of questions but there was no clean way to do so without MB just creating new questions. Also, Metabase doesn't have serialization unless you pay them AND you self-host, (if I'm self hosting then what exactly am I paying for?) and that's pretty annoying. https://www.metabase.com/docs/latest/installation-and-operation/serialization https://www.metabase.com/docs/latest/installation-and-operat.... But it does let you join tables. Sometimes that's enough to make MB worth dealing with.
- noduerme 3y agoThe "model" vs "question" thing is really annoying as there's no real difference from the user's perspective, and it's easy to accidentally convert a model back to a question without noticing when you publish something. You notice when you try to drill into the chart. There's a lot of annoying manual labor in metabase, e.g. I want to filter something into 10 different charts and I need to duplicate it 10 times and change a filter on each one. Still yeah joins are nice. A non-bugged aggregate count/sum as a window function would be nicer.
- itsoktocry 3y ago>I was constantly annoyed at the opacity around models vs "questions" Yeah, somewhere along the line Metabase decided to get opinionated on "self-serve". I imagine it works well for some teams and companies, but for the tech-oriented, it's annoying. I prefer my BI tools to be platforms that make for easy charting and cross-filters, while I build and control the models behind the scenes with a tool like dbt.
- ldjkfkdsjnv 3y agoI remember using Superset in 2017 or so, was forced to by a manager that would not pay for off the shelf software. I also did a few open source contributions to fix some bugs, it was a disaster. A huge rats nest of python. Might have changed in the last few years, am surprised its still active
- jimvin 3y agoIt's definitely come a long way since 2017! It's improved markedly in terms of functionality and performance. It looks much prettier now as well.
- Maro 3y agoI love Superset. I've been running it in production since 2017, at two jobs, the current one a big corporation. Best general-purpose, database-backed dashboarding system out there. I would never pay for Tableau or PowerBI. Same for Airflow.
- atlas_hugged 3y agoSame for Airflow? I’m not sure I understand what you mean.
- luccasiau 3y agoThey were both made by Airbnb and then open-sourced, which is the similarity I assume they meant
- jerrygenser 3y agoThey were also more specifically authored by the same individual!
- rusackas 3y agoMaxime, 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 :)
- dang 3y agoRelated. Others? Open source Business intelligence platform made with Python - https://news.ycombinator.com/item?id=29368664 https://news.ycombinator.com/item?id=29368664 - Nov 2021 (49 comments) Apache Superset 1.1 - https://news.ycombinator.com/item?id=27439939 https://news.ycombinator.com/item?id=27439939 - June 2021 (28 comments) The Apache Software Foundation Announces Apache Superset as a Top-Level Project - https://news.ycombinator.com/item?id=25905277 https://news.ycombinator.com/item?id=25905277 - Jan 2021 (1 comment) Apache Superset is an enterprise-ready business intelligence web application - https://news.ycombinator.com/item?id=21133931 https://news.ycombinator.com/item?id=21133931 - Oct 2019 (7 comments)
- throwaw12 3y agoanyone knows how does it compare to Looker?
- skadamat 3y agoNo built-in thick semantic layer, compared to Looker. I wrote about Superset's semantic layer here: https://preset.io/blog/understanding-superset-semantic-layer/ https://preset.io/blog/understanding-superset-semantic-layer... One popular option is to use dbt or Cube for the semantic layer and pair with Superset: https://preset.io/blog/announcing-presets-ui-integration-with-dbt-cloud/ https://preset.io/blog/announcing-presets-ui-integration-wit... and https://preset.io/blog/open-source-looker-cube-superset/ https://preset.io/blog/open-source-looker-cube-superset/
- totalhack 3y agoThe 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 https://github.com/totalhack/zillion
- anentropic 3y agoThis 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, pivots, and technical computations. But it leaves me with questions - how/when does this get populated? What other options are there besides in-memory SQLite? (I presume that's just a convenience for development and would use something else in production?) Or is it just what Superset calls a 'metastore' i.e. data about the data, and the queries are run against the data source layer?
- noduerme 3y agoSo it's irritating to me that this is ranking #1 on HN (why is it, btw?) I just pulled the trigger on a large data gathering project using Metabase, and feel a bit hampered by the limitations in terms of charts and plugins... but I considered Superset first, and after a lot of thought I decided that almost everything I've ever worked with that was run by the Apache foundation turned out to be semi-abandoned disasterware over time. In fact I wasn't even sure if Superset was still an active project or if it just looked like one, in the way e.g. no one bothered to pull the OpenOffice website offline. So now that I picked Metabase, Superset is topping HN for no apparent reason. Why?
- hasty_pudding 3y ago> Everything I've ever worked with that was run by the Apache foundation turned out to be semi-abandoned disasterware over time. Amen brother.
- swalsh 3y agoYeah, I'm in a similar thought process. I've been burned multiple times by Apache, will not touch ever again.
- lars_francke 3y ago> almost everything I've ever worked with that was run by the Apache foundation turned out to be semi-abandoned disasterware over time Can you name a few examples?
- bombcar 3y agoHere's the list: https://projects.apache.org/projects.html?name https://projects.apache.org/projects.html?name OpenOffice is probably the most famous (it still has the name, but it is dead, LibreOffice is the real "active" fork). And the things in the "Attic" are officially dead - https://projects.apache.org/committee.html?attic https://projects.apache.org/committee.html?attic and many more projects should be there.
- lars_francke 3y ago
- indymike 3y agoCan vouch for Superset. I use it in a couple of my companies and love it.
- lars_francke 3y agoWe've built a Kubernetes Operator for Apache Superset at Stackable: https://github.com/stackabletech/superset-operator/ https://github.com/stackabletech/superset-operator/ It's part of our Open Source Data Platform and it's one of the few open source BI tools out there and there are not a lot of alternatives in this space. We generally like it.
- adeptima 3y agoHad a very good experience with Superset. Superset allowed us to replace Tableau and not looking back Took me a while figure out how to embed it into my app using Superset Embedded SDK. Superset Embedded SDK - "Embedded SDK allows you to embed dashboards from Superset into your own app, using your app's authentication. Embedding is done by inserting an iframe, containing a Superset page, into the host application." https://github.com/apache/superset/tree/master/superset-embedded-sdk https://github.com/apache/superset/tree/master/superset-embe... Superset is based on very high quality and well maintained chart library eChart https://echarts.apache.org/examples/en/#chart-type-linesG https://echarts.apache.org/examples/en/#chart-type-linesG Community Roadmap https://github.com/apache/superset/projects?query=is%3Aopen https://github.com/apache/superset/projects?query=is%3Aopen Huge respect to Preset.io and its team for contributing to the project and keep it in a great shape https://preset.io/blog/ https://preset.io/blog/ Superset source code is very easy to read and understand, and as a result it's possible to implement some advanced caching techniques reduce the load on charts. No BI is perfect. Watching Superset for years gives me confidence the project will work as supposed down the road, and eventually some of its packages can be reusable for all kind of visualizations and data hacking. Our main approach to visualisation is to start with eChart and simple Reactjs wrapping and spin off Superset on subdomain for power users, and later see which one works better. Same look gives a very pleasant experience.
- boyka 3y agoI have no experience with Superset. Can you elaborate on a few points where you see it excel beyond Tableau?
- adeptima 3y agoI dont want to start a rant against Tableau. It's a powerhouse. It's a great superior software. But when it comes to optimizing cost and comparing the total cost of ownership and opportunity to stop paying for Tableau server license we voted in favor of Superset and mix of Reactjs+Echarts widgets. https://www.tableau.com/products/server https://www.tableau.com/products/server If you have money, dedicated team of data analytics who are already familiar with Tableau - no need to torture them with other tools.
- paddy_m 3y agoI wish more projects had guided tour videos that demonstrated the power of the tool in the hands of an expert user. Not "get started" but "why should I care". Wes McKinney used to have an excellent 5 minute introduction to pandas in this genre.
- skadamat 3y agoThis might be what you're looking for: https://www.youtube.com/watch?v=kGfUIOK87V8 https://www.youtube.com/watch?v=kGfUIOK87V8
- paddy_m 3y agoI saw that video on the website. It isn't narrated or captioned as to what the users is trying to accomplish
- rusackas 3y agoYou can check this out. This is a Preset Demo, but shows quite a bit of Superset within Preset (which offers multiple instances of Superset as "Workspaces") https://www.youtube.com/watch?v=V0HwGnC1rU8 https://www.youtube.com/watch?v=V0HwGnC1rU8
- vfclists 3y agoGenerally what you get when VentureCapital/PrivateEquity buys out Redash.io, messes up end users in the process and spits it out a few years later, leaving users confused as to where it stands in the BI tools landscape.
- mikpanko 3y agoDoes anybody know why Superset started trending today? Is there a major release?
- remram 3y agoIs there more than this single HN submission?
- rusackas 3y agoThere is a major release on the horizon (4.0) and there were just a couple of patch releases for the 3.x variants. I'm surprised to see it trending too, but I'm happy about it. More people need to know that Open Source BI is here, and here to win.
- zX41ZdbW 3y agoSuperset is powerful, but I wonder why they don't fix "papercuts", e.g., misaligned pixels on a spinner, or inability to copy a value from a table's cell, or non-monospace font for numbers in a table, etc. There are hundreds of small annoyances in the product.
- rusackas 3y agoWe try! We also accept PRs and Issues if there are things bugging people, of course. It's always a balancing act between building some new feature that people are clamoring for, or fixing those cosmetic issues that always crop up.
- posix_monad 3y agoIs this capable of performing efficient JOINs across non-homogeneous data-stores?
- Lucasoato 3y agoShould it? If you really need that, join the different sources with TrinoDB (or any related managed service like AWS Athena) and connect it to Superset.
- ildjarn 3y agoIt’s common for business questions to only be answerable with a join over a few different stores. I think Athena can only query data on S3?
- totalhack 3y agoSuperset would be on my shortlist if I had to use something else, but the join limitations were part of why I passed.
- grzaks 3y agoWe use https://cube.dev/ https://cube.dev/ as intermediate layer between data warehouse database and Superset (and other "terminal" apps for BI like report generators). You define your schema (metrics, dimensions, joins, calculated metrics etc) in cube and then access them by any tool that can connect to SQL db
- nvrmnd 3y agoOne thing to keep in mind with BI software is that the users are often very different than, well, those individuals that prefer to use mutt as an email client. Many, or most, users for a BI tool will be operations, product managers, and business management who simply will not find the interface to be intuitive, responsive, or well designed. At least that's my experience.
- deleted 3y ago[deleted]
- fuzztester 3y agoWow, those Apache guys have so many projects. Of course, they've been at it for years, starting with the Apache web server, then Tomcat, etc., and also, many projects were first developed outside and then handed over to them, for whatever reasons.
- andrewshadura 3y agoAnd sometimes projects are handed to them to die. The way they (mis)handle OpenOffice is unforgivable.
- fuzztester 3y agoInteresting, did not know. In what way, any details? Not been tracking that or using OpenOffice for a while.
- emilienaples 3y agoHow would you compare Superset with PowerBI for analytics and CSS integration? Trying to develop features and advanced analytics capabilities into an app?
- rusackas 3y agoYou can style dashboards with CSS as much as you'd like, though there are some limitations (canvas/webGL elements). I wrote a whole blog post on it: https://preset.io/blog/customizing-superset-dashboards-with-css/ https://preset.io/blog/customizing-superset-dashboards-with-... If you want to style the whole application, you can fork the repo and go bananas. If you're looking for theming, there's more to be done yet on that front, and I wrote an article on that too: https://preset.io/blog/theming-superset-progress-update/ https://preset.io/blog/theming-superset-progress-update/
- Wilduck 3y agoIs 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? Or a more convenient way to run the heavyweight tools?
- unixhero 3y agoTableau 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.
- VenkatPram7 3y agoSuperset isn't a single user application?
- unixhero 3y agoAh, sure
- c0pium 3y ago> This is a single user application K8s installation instructions: https://superset.apache.org/docs/installation/running-on-kubernetes https://superset.apache.org/docs/installation/running-on-kub... RBAC configuration: https://superset.apache.org/docs/security/#rest-api-for-user--role-management https://superset.apache.org/docs/security/#rest-api-for-user...
- javchz 3y agoI'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.
- spdustin 3y agoFor my last employer, I set up Superset for a number of our clients to show all sorts of heavily customized marketing analytics dashboards, web performance graphs, project management burndown reports, you name it. As with another commenter's experience, we also got a client to replace Tableau with it, and not look back. Such a great product.
- twic 3y agoHow does this compare to Jupyter notebooks and the ecosystem around that? Do the use cases overlap, or are they completely different things?
- Lucasoato 3y agoIn my experience, people with a business related background have an easier time learning how to use BI tools (this is true even if Superset may be less user-friendly than other commercial product like Tableau); Jupyter is an interactive computing platform that is based on notebooks and cells, that's more useful for data scientists/engineers whose needs might exceed the capabilities of a SQL interface.
- tomrod 3y agoIt's been a few years since I evaluated superset. Did they ever resolve drilldown (filter for one chart on a page, populate to all charts)?
- rusackas 3y agoYep... there's Drill By, which is more flexible than drill-down. Rather than having to specify a strict hierarchy of drilling "levels" you can pick columns, hierarchical or otherwise, to drill into.
- rietta 3y agoNeat. I have to admit I about had a heart attack reading "Superset" as "Sunset" at first. I've become too jaded about stuff being shut down and announced on HN. Very pleasantly surprised when I read correctly and clicked through to see its about data analytics.
- cheema33 3y agoI recently discovered Apache Superset. I would love to use it in our product. Does anybody know if it possible to integrate it into an existing product? I am mostly curious about hooking up its authentication system to our own authentication system, which is based on auth in ASP.NET Core 8.
- Cilvic 3y ago>Took me a while figure out how to embed it into my app using Superset Embedded SDK. Superset Embedded SDK - "Embedded SDK allows you to embed dashboards from Superset into your own app, using your app's authentication. Embedding is done by inserting an iframe, containing a Superset page, into the host application."
- HermitX 3y agoHere is a fantastic video made by Soumil Shah, using MinIO+Hudi+StarRocks+Superset. It is amazing to have an interactive query experience on a data lake directly! https://www.youtube.com/watch?v=JkKBzrQTKx0 https://www.youtube.com/watch?v=JkKBzrQTKx0
- 3abiton 3y agoThanks for sharing, it's so exciting to see so many OSS BI frameworks
- atbpaca 3y agoThis looks really good! How does it compare to Tableau?
- rusackas 3y agoWell, it's free! Or significantly cheaper even if you opt to use Preset to run a hosted/managed/compliant version of it, and not have to deal with config/security/upgrades/migrations. This article is a year old, but it might help a bit: https://preset.io/blog/apache-superset-vs-tableau/ https://preset.io/blog/apache-superset-vs-tableau/
- adamgamble 3y agoWe 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?
- xtracto 3y agoMhmm this gives me an idea.. what if I could "group" metabase sql queries by "similarity" (either of results or of the query itself) Another option could be to use LLM to summarize, tag and group queries for better discoverability.
- _pastel 3y ago100% agree. One thing that helps is hooking metabase up to its own database and building queries on your queries, e.g.: select * from report_card where dataset_query ilike '%' || {{query}} || '%' (You can also join in metadata like the author, when it was last ran, etc.) We also try really hard to keep the Collection directory structure clean and consistent. But it's still really hard.
- EricRiese 3y agoThat's so... meta
- scrappyjoe 3y agoMaybe take a look at https://datahubproject.io/integrations 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
- LuciBb 3y ago[dead]
- datatrashfire 3y agolove superset, but one thing that I would love to see is to make it easier for dashboards/charts to use a dynamic table that the user can select. we have multiple tenants + developer instances of our warehouse. to reuse the same dashboard in this setup we need to create at least 3 virtual datasets, plus wrangle a bunch of boiler plate jinja.
- vietvu 3y agoUsed Superset back in 2016 and 2020; both time chose Metabase for our clients' BI dashboard and Superset for our internal dashboard. Superset is nice, easy to modify and extend but not user friendly as Redash or Metabase. But after the author launched Preset, it seems to have improved much with the company effort. It looks like to me the best way for OSS to advance is to have a company dedicated to improve it.
- hiepdev 3y agoHow does it compare to Kibana + Elasticsearch?
- nullify88 3y agoA big thing here is that Superset and most of the other BI tools can connect directly to databases which is commonly the source of truth or data warehouse in some businesses. Secondly, Elastic have focused on other operational areas such as security, observability, and indexing / search. Kibana can do some dashboarding on those areas and its UI is nice, but Superset and similar tooling are more suited for BI purposes.
- nojito 3y agoSuperset is absolutely phenomenal. I really hope Microsoft eventually releases all of their customizations they made to it internally to the OS community someday. https://www.youtube.com/watch?v=RY0SSvSUkMA https://www.youtube.com/watch?v=RY0SSvSUkMA https://github.com/apache/superset/discussions/20094 https://github.com/apache/superset/discussions/20094
- pknerd 3y agoI found Superset difficult to use when I explored it a couple of years back[1], not sure whether this is the same case now. [1] https://blog.adnansiddiqi.me/create-your-first-sales-dashboard-in-apache-superset/ https://blog.adnansiddiqi.me/create-your-first-sales-dashboa...
- kumarvvr 3y agoTried 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?
- waldrews 3y agoMaybe try the Docker installation to keep the dependencies off your system: https://superset.apache.org/docs/installation/installing-superset-using-docker-compose/ https://superset.apache.org/docs/installation/installing-sup...
- altilunium 3y agoYou can query Wikipedia's internal database by using its superset instance. https://superset.wmcloud.org https://superset.wmcloud.org https://phabricator.wikimedia.org/T169452 https://phabricator.wikimedia.org/T169452 Back then, I used this to generate some custom statistics https://github.com/altilunium/wikiidmon https://github.com/altilunium/wikiidmon
- martin82 3y agoBummer that it can't pull data from JSON APIs, which Redash can do.
- hackandthink 3y agoIt should be possible (have not tried myself): https://preset.io/blog/accessing-apis-with-superset/ https://preset.io/blog/accessing-apis-with-superset/ "Shillelagh (ʃɪˈleɪlɪ) is a Python library and CLI that allows you to query many resources (APIs, files, in memory objects) using SQL. It's both user and developer friendly, making it trivial to access resources and easy to add support for new ones" https://github.com/betodealmeida/shillelagh https://github.com/betodealmeida/shillelagh
- wesleyyue 3y agoSurprised no one has mentioned hex yet. There was a post on the yc internal forum today about data stacks and a lot of founders mentioned they liked hex. I hadn't heard too much about them before but they looked interesting for someone (me) who typically prefers something closer to a jupyter notebook and simple stacks.
- lf-non 3y agoFull fledged BI tools like Superset and Metabase are amazing for their intended use cases. But they may be an overkill if your primary use case is to infrequently build semi-interactive reports for non-technical end-users and your use cases are are mostly covered by standard graphs & tables. Esp. so if you are familiar with SQL and have access to the underlying data source. Two nifty utilities I have found to be very useful for latter kind of use cases are SQLPage and Evidence. They make it very convenient to whip out some SQL and convert that to a neat professional looking web ui that can be forwarded to an end user. In case of Evidence it is a statically generated site, and in case of SQLPage it is a web app that connects to a live database. SQLPage: https://sql.ophir.dev/ https://sql.ophir.dev/ Evidence: https://evidence.dev https://evidence.dev
- amai 3y agoDoes it have horizontal bar charts nowadays?
- amai 3y agoCan one run Python scripts in Apache Superset like on can do with PowerBI: https://pycaret.gitbook.io/docs/learn-pycaret/official-blog/machine-learning-in-power-bi-using-pycaret https://pycaret.gitbook.io/docs/learn-pycaret/official-blog/...
- amai 3y agoUnfortunately information about new releases are not available on the superset website, but only at Preset.io: https://preset.io/blog/superset-3-0-release-notes/ https://preset.io/blog/superset-3-0-release-notes/
- uraura 3y agoFrom 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.
- anentropic 3y agoI 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.
- orestis 3y agoCan 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...
- etoulas 3y agoHave a look at Embeddable. It’s still pretty new but build by an experienced team. It’s commercial software though. https://embeddable.com/ https://embeddable.com/
- deleted 3y ago[deleted]
- loufe 3y agoI 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.
- hi41 3y agoHow is it possible to create such amazing software for free?! I am astounded at how many great developers there must be in the world. I am trying to get back to coding but find it hard as I am not able to focus these days.
- Rupesh_Padhye 3y ago[dead]