In terms of use-cases: I've recently started asking people who use it what job they hired it to do. One of the leading answers is for data publishing - they use it as a tool to quickly publish data online for others to use:
Thanks for replying, Simon! I guess my use case was a bit of a toy, I don't have a huge dataset to use facets on, I basically just made a small spreadsheet of blood tests and wanted to see if I could easily navigate the data better than what Excel did. I did install Vega, but it had basically one way to display data (I didn't look into it too much, though).
I think my use case was just not suitable for it, from your answer I guess it's more for people who have huge datasets they want to publish. I imagine it will be much better suited for that purpose, though I tried the demo a few times and couldn't really think of any interesting questions to ask it, so I didn't get it there either...
Datasette is one of those things that sounds very promising, so I want to explore it, but I end up walking away every time. It just sounds like it's not for me, though.
The feature I use most often for exploring new data is facets - I explain those in the tutorial here: https://datasette.io/tutorials/explore#using-facets
By default Datasette doesn't include visualizations, but those can be added as extra plugins. Two of the most popular are https://datasette.io/plugins/datasette-vega for charts and https://datasette.io/plugins/datasette-cluster-map for geographical data, e.g. on https://global-power-plants.datasettes.com/global-power-plan...
In terms of use-cases: I've recently started asking people who use it what job they hired it to do. One of the leading answers is for data publishing - they use it as a tool to quickly publish data online for others to use:
https://docs.datasette.io/en/stable/publish.html