Microsoft is pushing Power BI as a general replacement for all of its old access, VB, etc. dashboard related tools: https://powerbi.microsoft.com/en-us/
Smilling people dragging rectangles on the screen! PowerBI on the web turns corporate Angular mess into an Angular disaster with iframes and loading spinners.
Just be warned, if you are used to vba you might feel constrained in the various dashboard tools we have today (Tableau, PowerBI, etc.). I am convinced we need more than that, we need tools to build web apps that allow data entry.
Tried Dash lately and was pleasantly surprised. We didn't leave much time at all for the dashboard section, but we were able to pick it up and hack something together in the little bit of time we had left.
I came here to write this too. I've had success building proof of concept apps and deploying as a Dash/Plotly app. Bokeh is also worth a look for a solution supported by the open source ecosystem [0].
A particularly useful example of Bokeh is the dashboard which gives visibility into how Dask is running your distributed compute job [1].
