Reference no: EM131305786
Pivot Analysis Project
In this project you will create pivot tables and pivot charts to analyze sales, customer and product data.
Cleanse the data
Open Pivot Analysis Raw Data and save it as Pivot Analysis your name completed.
Review and interpret the data. Resize and/or format the data as you desire.
In Column I enter the label Product_Order_Total. Create a formula to calculate the total and fill this column.
Analysis
For each question below place the pivot table and pivot chart on a separate sheet and name the sheet tab with the Question number.
Tables should be sorted.
Charts should have appropriate titles.
Column headings should be modified to be “user friendly”.
Numbers should be formatted with commas and no decimal places.
How were monthly sales in 2016 compared to the prior year? Create a pivot table and then create a pivot chart. Both should show sales grouped by month using the month name, not the month number. You will need to use the Order_Date and then group the field.
In terms of Product_Order_Total, what were the top 10 customers in 2016? Create a pivot table and then create a pivot chart. The pivot chart should be a bar chart and display the customers in order, showing the best customer at the top.
In terms of Product_Order_Total, what were the top 10 products in 2016? Create a pivot table and then create a pivot chart. The pivot chart should be a bar chart and display the products in order, showing the best product at the top.
In terms of Product_Order_Total, what were the top 10 countries in 2016? Create a pivot table, sorted in descending order, and then create a pivot chart. The pivot chart should be a pie chart with data labels.
Create a “dashboard” sheet that contains all 4 pivot charts and move it to the beginning of the workbook. Verify that the size of each chart is large enough to show all labels.
|
Link leadership perspective chosen to eventual outcomes
: First, describe Shackleton’s leadership in detail using two of the approaches below. Second, link the leadership perspective chosen to eventual outcomes. Leader (traits, skills, styles) external (contingency and situational) and follower needs (path-..
|
|
Identify and discuss the chain of command
: identify and discuss the chain of command and how problems can arise within the organizational structure.
|
|
Leadership style or lack of project management skills
: With regard to the reluctant workers case study, is the problem about management or leadership style or lack of project management skills?
|
|
How department of defense and the pentagon cannot account
: Discuss how the Department of Defense and the Pentagon cannot account for some $6.5 trillion which illustrates the issue of accountability in public administration including the leadership within the DoD and Pentagon.
|
|
Pivot analysis project
: How were monthly sales in 2016 compared to the prior year? Create a pivot table and then create a pivot chart. Both should show sales grouped by month using the month name, not the month number. You will need to use the Order_Date and then group the ..
|
|
Explain the relevance of the topic to the articles
: Over the length of the course, upload three separate URL references to articles relating to current healthcare insurance and managed healthcare issues.- Explain the relevance of the topic to the articles.
|
|
Why is audit consider to be final phase of budgetary process
: Why is an audit considered to be the final phase of a budgetary process? What organizations undertake governmental program evaluations, and why do they do it?
|
|
Find the value of this constant
: A radioactive isotope is being produced at a constant rate dN/dt - R in an experiment. The isotope has a half-life Show that after a time t >> t1/2, the number of active nuclei will become constant. Find the value of this constant.
|
|
Analyze the external factors on or of international business
: Explain and analyze the external factors on or of international business (e.g., political, legal, economics, culture, etc.) and how these may impact business.
|