PowerPoint Development

Develop a PowerPoint to answer the following questions. Each question should have at least one slide that provides an analysis and uses the Excel Dashboard to provide a data visualization that corresponds to the question asked. Make sure you include the question for each slide and you clearly point out the answer to your question (Both written and visualized)

Questions to Answer 1.Develop an introduction: In one to three slides, provide an overview of the totals 2020 vs. 2019. And show the comparative trends between the two years. Provide a narrativehighlighting your summary of findings. (e.g. sales for 2020 decreased by 20%. Actual revenue vs. budget revenue was off by XXX%, etc.)

2.Analysis by Quarters:Provide an analysis comparing 2020 quarterly revenues actual vs. budget. Identify the best performing quarter and the worst performing quarter. Visualize your data and provide some insight to what may be driving the performance. (e.g. Walmart sales increase by, Macy’s sales decrease by, Accessories revenue was up, outerwear revenue was down by x%)

3.Analysis of Categories:Provide a graph that shows comparison of revenues (2020 vs. 2019) by category and show the change in revenue dollars from 2019. Show the sales products for the category with the biggest decrease and the category with the smallest decrease in revenues. In your narrative, identify the products that are driving the largest and smallest decreases.

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. )

???????????Introduction

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

Analysis By Quarters

A 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.

Analysis of customers

Create a slide providing analysis of customers comparing current year actual revenue to prior year actual revenue and show the difference (current year to prior year). In the slide, provide insight into what you think might be the drivers of the top performing customers and give some explanation as to why you think their sales performance was better then others.

In the second part of the customer analysis, Look across the current year and see if the top performers improved or declined. Do not forget to look to see if the performance of poor performers improved or further declined as the year progressed. Provide data visualization of your findings (Graphs, trends, etc.) and make sure to include a clear narrative to explain what you found and what was most notable that the viewer should take away.

In the second part of the customer analysis, Look across the current year and see if the top performers improved or declined. Do not forget to look to see if the performance of poor performers improved or further declined as the year progressed. Provide data visualization of your findings (Graphs, trends, etc.) and make sure to include a clear narrative to explain what you found and what was most notable that the viewer should take away.

This is your chance to use academic freedom to demonstrate you have learned something from your analysis and you now have the opportunity to draw it to a conclusion. As an analysis, your value comes from your ability to provide insight into what might not be obviously identified in just reviewing numbers.

Here you may provide details like which categories suffered or excelled during the comparative times. You may also look at the performance of sales people, some may have performed better then others; if so why? Which of their customers did better then others. You may identify products that performed well in a spcific category or products that did not perform well.

Tell your story. Properly label your slides (what are you communicating to your audience) Present your findings (what did you find and what is the significance of your findings) Give your opinion of what you think should be done to correct or benefit further from what you find (i.e. remove the product, replace the item with a new one, etc.)

pur-new-sol

Related Questions