1- What is a Excel Dashboard and how to I get started? (15:23)
Looks at the parts of a dashboard and dicusses how to get started.
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.
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
|Required Excel Elements when doing analysis and creating charts/graphs for Dashboard:|
|USE IN THE ANALYSIS TABS
Advanced Formula (Choose from your book)
Advanced Function (Choose from your book)
CLICK on each one and you have instructions on how to do it. Your book has great examples.
You will use these in the analysis tabs.
|USE ON THE DASHBOARD TAB
1 chart that shows Trending (Smoothing or Linear Forecast)
This will equal 4 charts, a slicer and a Macro on the Dashboard.
2 Challenging options:
1 chart with an Interactive Control
(Check Box or List Control) You cannot use a macro with the control.
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 Mockup should 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 (Click here to see an example
) — 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. Worksheets – Tabs Labeled Analysis 1
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.
Download the Excel file (named dashboardprotootype)that you will use for the Dashboard Prototype Project. You need to understand the data to get started. You MUST use this file with the data included to create your Dashboard.
We value our customers and so we ensure that what we do is 100% original..
With us you are guaranteed of quality work done by our qualified experts.Your information and everything that you do with us is kept completely confidential.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
The Product ordered is guaranteed to be original. Orders are checked by the most advanced anti-plagiarism software in the market to assure that the Product is 100% original. The Company has a zero tolerance policy for plagiarism.Read more
The Free Revision policy is a courtesy service that the Company provides to help ensure Customer’s total satisfaction with the completed Order. To receive free revision the Company requires that the Customer provide the request within fourteen (14) days from the first completion date and within a period of thirty (30) days for dissertations.Read more
The Company is committed to protect the privacy of the Customer and it will never resell or share any of Customer’s personal information, including credit card data, with any third party. All the online transactions are processed through the secure and reliable online payment systems.Read more
By placing an order with us, you agree to the service we provide. We will endear to do all that it takes to deliver a comprehensive paper as per your requirements. We also count on your cooperation to ensure that we deliver on this mandate.Read more