The CEO wants to increase Gross Margin month on month. You, as an analyst, are required to build an analytical dashboard to identify drivers of Gross Margin change (up or down).
This month (Jun 2020) the Gross Margin % has decreased dramatically. How would you dashboard support a root cause analysis of this decrease.
Hints:
Analysts need a lot of interaction with the visuals
Using navigation hierarchies will make it easier for you drill up and drill down on some charts. This might help you find out what was wrong with the business.
Sales look good in the current month while % Gross Margin is not ideal. Play around with the dimensions to find the root cause! It could be because of a certain product, sales location and etc.
Consider a map with diverging color to prove your findings!