Order from us for quality, customized work in due time of your choice.
I have attached the Pivot table analysis I have created to go along with this pa
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
Order from us for quality, customized work in due time of your choice.