PART 1 - To get started:
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:
Interpret the data –
what kind of data is available,
what can it be used for,
what is the purpose of each column, etc.
Make a list of at least 10 questions that could be answered by utilizing this data set.
Fully discuss the details of this data set.
PART 2 – Data Analysis Report:
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. You should end up with tabs like the following snip, at a minimum. Submit this file along with your finalized project.
At a minimum, you must discuss the following questions, and offer visual support for each:
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?
PART 3 - Presentation
Prepare a Power Point presentation(about 20 slides) based on the data and your analysis. Included notes for each slide 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 verbage to assist in demonstrating a full data analysis.
The final slide(s) should contain your recommendations/suggestions based on the data analysis.
17 freelancers están ofertando el promedio de $131 para este trabajo
Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India