Excel dashboard project!

Please see video to learn about this project

1- What is a Excel Dashboard and how to I get started? (15:23)



Dashboard ProtoType

Every company no matter how big or small needs a dashboard to give them a source of direction, a gauge, that lets employees, customers, and even stockholders know where it’s headed.  Your dashboard is a visual interface that provides at-a-glance views into key measures relevant to a particular objective or business process. 

A dashboard consists of three key attributes:

     Displays data graphically (such as in charts). Provides visualizations that help focus attention on key trends comparisons, and exceptions.
     Displays only data that is relevant to the goal of the dashboard.
    Contains predefined conclusions relevant to the goal of the dashboard and relieves the reader from performing his own analysis. 


Download the Excel file with the raw data. You need to understand the data to get started. The link to the Excel spreadsheet is available below the instructions. 

The Objective

You will complete a dashboard project. You will make a dashboard using the project data.  Each Dashboard must fit entirely on a single computer screen so it can be monitored at a glance.  It will have at least 4 charts.

Required Dashboard Elements when Creating the Dashboard:

• &νβσπ;&νβσπ;You will develop a dashboard layout mockup. It will represent the component and the type of data required to create the measures

Scroll to Top