Pretend that you are utilizing the data from the most recent year that you find in the file.
For example, if you find the most recent year of data is 2013 – you will produce the project as if it were actually 2014.
Do not look at the data is if it is actually the current year (2017).
Follow the directions below.
Data Analysis Report (PART 1 – 3)
In this final exercise, we will be using the Microsoft Suite (Word, Excel, and Power Point) to create a data analysis report.
This report (PART 1 to 3) will be utilized as a representative sample of your work in the ePortfolio.
PART 1 – Data Analysis Report (in MS Word):
• Open the Excel spreadsheet and familiarize yourself with the raw data.
• Open a new Word document (blank), and create at least one full page (single-spaced) report addressing the following:
o Interpret the data –
what kind of data is available,
what can it be used for,
what is the purpose of each column, etc.
o Make a list of at least 10 questions that could be answered by utilizing this data set.
o Fully discuss the details of this data set
• Save this report (in .docx format) with your name included in the file name.
PART 2 – Data Analysis Report (in MS Excel):
• Imagine the following scenario – You are hired as the new assistant to the executive board. You are asked to prepare a meeting for tomorrow, in which the board will expect a full briefing based on the data you have been given (raw data set). Remember, they already know the data – your job is to reveal the trends, patterns, find information, dig for the hidden gems that will help the organization improve!
• Do the data analysis and creation of visuals in your excel file – save it with a file name reflecting that work – include your name in the file name please. You should end up with tabs like the following snip, at a minimum.
At a minimum, you must discuss the following questions, and offer visual support for each:
• Sales overview.
• How have sales developed in 2013 – compared to the year before?
• Who are the top 10 customers in each year? What changes can be noted?
• What are the top 10 products in each year? What changes can be noted?
• How are sales distributed over the regions? Have shifts occurred?
• What else might be helpful?
TIP: The minimum 4 Diagrams/Charts should look similar to there snips
PART 3 — Data Analysis Report (in MS PowerPoint):
Prepare a Power Point presentation (in MS PowerPoint) based on the data and your analysis. Included notes for each slide and add voice narrations as if you were presenting this information to the executive board.
• The first slide should contain the executive summary of the report (no more than 120 words).
• The content slides should contain visuals, charts, graphs, tables, and any verbiage to assist in demonstrating a full data analysis.
• The final slide(s) should contain your recommendations/suggestions based on the data analysis.
*FYI – on average, I find that the most successful projects contain around 20 slides.
Submit your final project to the Designated Dropbox (or you can go to Activities (on the top) >> Assignments >> Dropbox-Final Project).
At the end of current term, students need to upload all three reports (with passing grade – 80% or higher andsave as PDF format) to student’s ePortfolio.
• Business Statistics for Competitive Advantage with Excel 2016: Basics, Model Building, Simulation and Casesby Cynthia Fraser & Published by SpringerLink