Any recommendations for a good piece of software for the single user case? Or a more convenient way to run the heavyweight tools?
I see these products as tools for data visualization and reporting i.e. presenting prepared datasets to users in a visually appealing way. They aren't as well suited for serious analytics.
I can't comment on Superset or Tableau but I am familiar with Power BI (it has been rolled out across my org), the type of statistics you can do with it are fairly rudimentary. If you need to do any thing beyond summarizing (counts, averages, min, max etc). It is not particularly easy.
For data analysis I use SAS or R. This software allows you do things like multivariate regression, timeseries forecasting, PCA, Cluster analysis etc. There is also plotting capability.
Both these products are kind of old school, I've been using them since early 2000's, the "new school" seems to be Python. Pretty much all the recent data science people in my organization use Python. Particularly Pandas and libraries like Seaborn (https://seaborn.pydata.org/).
The "power" users of Power BI in my organization tend to be finance/HR people for use cases like drill down into cost figures or Interactively presenting KPI's and other headline figures to management things like that.
This is a single user application, unless you make it part of your built application.
K8s installation instructions: https://superset.apache.org/docs/installation/running-on-kub...
RBAC configuration: https://superset.apache.org/docs/security/#rest-api-for-user...
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.