Jacksonville University Dashboard ProtoType Excel Project

Dashboard ProtoType (300 Points)

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.

Data

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. See Figure 1-3 for an example of a Dashboard mockup.

Your Project should have the worksheets below included.

They form the three layers: data, analysis, and presentation. Here is what is should look like.

1. Worksheet 1 – Tab Labeled Mockup — The Layout Mockupshould be drawn using shapes and textboxes to look similar to Figure 1-3 (link is shown above). I should see the questions that correspond to the components in the Dashboard. Figure 1-3 has examples of questions.

2. Worksheet 2 – Tab Labeled Map — Add a data model map tab to your data model. The map tab essentially summarizes the key ranges in the data model and allows you to document how each range interacts with the dashboard components in the final presentation layer. The idea is to give yourself a handy reference (using Hyperlinks) that guides you through the elements in your data model. The columns will be called TAB, CELL RANGE, PURPOSE, COMPONENT.

3. Worksheet 3 – Tab Labeled Dashboard

4. Worksheet 4 – Tab Labeled DATA

5. Analysis Worksheets – Tabs Labeled

• Analysis 1,
• Analysis 2,
• Analysis 3 , and so on.

PLEASE NOTE:

• 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.
• You can create subsets of the data as needed to create your components.
• Document the logic in your data model by using comments and labels liberally. To receive credit, I MUST be able to find everything.
• The data and grading rubric is available in separate tabs.