I'm looking into Superset in these days, so it's very nice to have found it here on HC.
I'm also looking for suggestions. A client of ours has a classic CSV representing sales data. I want to build a dashboard to make the visualization of the dataset easier for the client. I was looking both for Metabase and Superset. However, I don't really know if there are any other products out there which could help in this. I'm obviously referring to open source products which could be easily deployed, so I'm removing tools like Tableau or PowerBI from the list.
Can you do the analysis/visualization in Python? If so, you could use https://github.com/datapane/datapane to build and share a report or dashboard (either as an HTML file, or publish it for free on datapane.com). I'm one of the people building it, so let me know if I can help!
Having briefly used datapane, this would be my initial choice if I had no other info about parent use case and just needed something with low overhead.
Edit: Metabase probably a fair alternative if they are likely to need the number of queries and views to increase, and even more so if you'd like to have them "self serve"
I definitely would not consider Superset unless you know that you need the advanced features.
Try https://perspective.finos.org/ - it is easy to deploy as it is a purely client-side browser widget, and supports CSV and a dashboard-like experienced out of the box.
as far as I know, Metabase doesn't support CSV files. Google DataStudio might be an option? but also no idea if it supports CSVs (I know its not open source, but still its free and online)
The expectation is that data is loaded into your database, which is reasonable. None of these tools are built to ingest data from multiple disparate sources and perform their own aggregations (like Tableau), but rather depend on locality of data on the database under query.
there is a csv driver[1] which allows you map a csv file on the metabase server, or providing a url of the csv. But I guess most people (including myself) would think of "upload csv file via UI" when it comes to csv support.
I'm also looking for suggestions. A client of ours has a classic CSV representing sales data. I want to build a dashboard to make the visualization of the dataset easier for the client. I was looking both for Metabase and Superset. However, I don't really know if there are any other products out there which could help in this. I'm obviously referring to open source products which could be easily deployed, so I'm removing tools like Tableau or PowerBI from the list.