Using Pivot Tables for Excel Dashboard Analysis
An interactive excel dashboard can add so much more data to be displayed on a dashboard. With a sound data model structure, data can be added and then updated on the excel dashboard without needing too much time and energy. Any executive dashboard, whether it be static or interactive should not require excessive maintenance. You key aim in setting up a dashboard is to reduce manual tasks not create more.
