There is a link to the video showing how the dashboard was created. He was also gushing about how he set it up to change things at the click of a mouse button. You know, linking one cell to another cell.
Here is my point: on every screen of this dashboard there are 12 or more metrics/values for each of seven departments ... 84 per screen. Given that he has used sparklines, images, sliders, values ... it is ludicrous to expect anyone to get any value from such a dashboard without having to zoom to, say, 50% or so, thus ruining the desired effect of the thing, surely.
Still, everyone else gushingly loved it. More than that, more and more Excel bloggers are adding more and more features to their own dashboards. Why? Because they can. Why is that so bad? Because it leads to clutter and will have performance implications. But more than that: what happens when Jack or Jenny breaks a link or changes something wrongly?
I suggest you go back to or stay with management by eye, from the old days. 15 ideas on an A4 page or equivalent was an excellent rule of thumb.
Duncan Williamson
14th November 2020
