Before everything else, let’s define first what an Excel dashboard is and why it’s smart to use one.
An Excel dashboard is a place where you can have a quickview of the key performance indicators in one place.
Dashboards usually fall into one of these three (3) types:
1. Strategic Dashboards
These dashboards are ‘strategic’ because they’re designed to help you make decisions and actions with strategy. They do it by tracking performance related to key performance indicators and help you better understand them.
2. Analytical Dashboards
This type of dashboard focuses on helping you compare data from the past to identify trends, spikes, and drops. By design, analytical dashboards are interactive since they have lots of pivot tables and drill-downs.
3. Operational Dashboards
To date, operational dashboards are the most common type. They show day-to-day metrics which gives a quick view of the organization’s daily performance.