Long time excel user here and am working through python to hopefully make a full switch. Excel works beautifully for what I do (mostly visualizing time series data per person with a filter, along with rolling averages and rolling stdev’s again per person).

Is plotly and dash a decent way to accomplish this? I’ve looked into things like PowerBI, and like that there’s things called measures that can calculate averages/standard deviations without hard coding them into your data as a new column.

Can plotly/dash do anything similar? Perfect scenario would be a interactive dashboard where I can filter by name, a metric, and it’s rolling avg and stdev for just that person in a dataset that has multiple people.

I’m just not super tech savvy and would love guidance on how to go about educating myself to accomplish this in python