What is a dashboard?
Definition and Purpose: A dashboard is a visual display of important information
needed to achieve one or more objectives, consolidated and arranged on a single
screen for easy monitoring.
Components and Features: Dashboards typically include charts, tables, and descriptive
statistics like sum, min, max, and average. They are designed to simplify complex data
into a consolidated format.
Dashboards allow us to perform descriptive analytics by reducing large amounts of
data into only a few numbers.
Time Relevance: Dashboards are always with respect to time, meaning they provide the
most up-to-date information available.
Excel Advantages: Excel is a great tool for building dashboards because it's widely
available, allows for easy and rapid development, and includes a suite of features like
tables, charts, and formulas.