I have been using Dremio for a year and a half. My main use case for Dremio is that I am able to access multiple databases and I can easily and quickly connect Dremio with my dashboards.
In my recent project, my databases are full of information about our insurance operation, and I monitor my KPIs by connecting Dremio to my dashboards. I have multiple KPIs that I have to stay tuned to, and I need to access that very quickly and in an easy way, which is how Dremio helps me.
About my use case with Dremio, I find databases that I don't know very much about, and in that web environment of Dremio, I am able to scroll and navigate through the databases by searching for an example or a column name, so it is much easier to navigate through with that kind of help.