Title: “Pivot Analysis with Microsoft Excel: A Case Study on Sales Data for the Executive Board Meeting”

I have attached the Pivot table analysis I have created to go along with this paper. It does not need to be attached. Sheet 1 has the pivot tables and associated charts for the data  set.
Mastery Assignment: Pivot Analysis with Microsoft Analysis
In this
exercise we will be using Microsoft Excel for a Pivot analysis. Open the
spreadsheet (Mastery Assignment – Dataset) and familiarize yourself with the
data.
1.      Interpret
the data:
○  
What kind of data is it and what can
it be used for?
○  
Explain the purpose of each column, in
particular of the columns including measures (such as “Order_Price_Total”).
2.      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
discuss the following business questions:
○  
How has sales developed in 2009 –
compared to the year before?
○  
Who are our top 10 customers in 2009?
○  
What are our top 10 products in 2009?
○  
How are sales distributed over the regions?
Requirements
for Executive Summary (Paper):
Prepare a quality, substantive paper that
addresses the objectives of the assignment and the expectations set forth
in the grading rubric.
A minimum of 500 words (excluding the title
page and references) is required. 
Cite at least two credible sources (including
course materials) written within the past 5 years.
Use APA style:
Refer to APA Resources
and the Online Tutoring Center resources in Academic Resources (see SC College
Resources Links) for guidance on writing style and page and citation formatting

Comments

Leave a Reply