Dashboard Development

There were a total of 7 graphs to be included in the dashboard. The graphs and pivot tables were listed in detail in the instructions given (Dashboard Creation)

This criterion is linked to a Learning OutcomePowerPoint Development

The PowerPoint was well developed with an appropriate design format for a business presentation.
Each slide has an appropriate title to explain what information is being provided. The graphs correspond with the titles of analysis being presented. The narration of the slide makes clear what the viewer is to take away from the information (what question was asked and how it was answered).

The formatting of the excel inserts was clear and the formatting consistent through out the presentation. A summary slide was provided to outline what will be covered. This is independent from the introduction. Think of a slide that tells the viewer what they are about to view (e.g. comparative analysis of sales data 2020 vs. 2019. )

This criterion is linked to a Learning OutcomeIntroduction

Provide an introduction to your analysis project. The introduction should provide a very high level overview of the purpose of your analysis and what you will be reviewing.

In your introduction, you should give scope to the period of times you are analyzing and what were you "Big Picture Findings". Be creative but be informative so viewers will have some idea of what to expect and what they should come away with in terms of understanding your findings.

Make sure your introduction is cogent and sets expectations of what the viewer is to see as they progress through your presentation.

10 to >7.0 ptsExcellent Introduction
The introduction was well developed and provided a clear expectation of what was contained in the analysis and what findings the viewer should take away. The items listed in summary in the introductory slides were well covered and expanded upon in the main body of the presentation. The content was clear and easy to understand and organized in a logical manner making it an informative introduction.

7 to >5.0 ptsGood Introduction
The introduction was good in its development and provided a clear expectation of what was contained in the analysis and what findings the viewer should take away with minor corrections needed. The items listed in summary in the introductory slides were mostly covered and expanded upon in the main body of the presentation. The content was clear and easy to understand and organized in a logical manner making it an informative introduction.

5 to >0 ptsPoor Introduction
The introduction was not well developed and did not provide a clear expectation of what was contained in the analysis and what findings the viewer should take away; there were major corrections needed. The items listed in summary in the introductory slides were not covered and expanded upon in the main body of the presentation. The content was not clear and was not easy to understand . The overall organization of the introduction was not presented in a logical manner and was not a very informative introduction.

10 pts

This criterion is linked to a Learning OutcomeAnalysis By QuartersA comparative analysis by quarter was presented The best and worst performing quarters were presented and insight to the performance drivers were identified and visualized in the data. The narration of each slide for the quarterly analysis corresponded with the data visualized in the slides.