Given a clean data set, is there a best-practice way of highlighting likely causes of changes in a KPI -- for instance, examining 10-50 dimensions to find out which contributed most (or was most off trend) to sales declining?
Typically my solution is to pull together all the likely attributes; then chart them based upon % change and magnitude, to see what sticks out; often it's "the West region is down" or "this plan is reducing" ; but the process for finding is surprisingly manual.
As an example, imagine a data set
If we note that the total number of sales is down 10% WoW; is there a common way to suggest the likely trends to investigate further?
I don't even know what to call this sort of analysis.
p.s. It gets more complex when you expect sales to be down somewhat; so you want to see which dimensions/attributes are the outliers from the trend