Reference no: EM13996660
Pivot Analysis Project
In this project you will create pivot tables and pivot charts to analyze sales, customer and product data.
Cleanse the data
1. Open Pivot Analysis Raw Data and save it as Pivot Analysis your name completed.
2. Review and interpret the data. Resize and/or format the data as you desire.
3. Create a column for Order_Date_Year. Use a function to extract the information from Order_Date and fill in this new column.
4. Create a Product_Order_Total column. 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.
1. How were monthly sales in 2013 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.
2. In terms of Product_Order_Total, what were the top 10 customers in 2013? 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.
3. In terms of Product_Order_Total, what were the top 10 products in 2013? 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.
4. In terms of Product_Order_Total, what were the top 10 countries in 2013? 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.
5. Create a "dashboard" sheet that contains all 5 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.
Attachment:- Pivot Analysis Raw Data.rar
|
Calculate the torque around your knee joint
: If you strap a 10-kg weight to your heel and then straighten out your leg as shown in the diagram, calculate the torque around your knee joint due to the weight at each of the four angles indicated. (You may ignore the gravitational force on your ..
|
|
Discuss the natural gas crisis of 1974-1975
: Your initial post should be at least 250 words in length. Support your claims with examples from the required material(s) and/or other scholarly resources, and properly cite any references.
|
|
Describe the prevailing view that experts hold
: Describe the prevailing view that experts hold about the likely future of the concept in question. Include the views of at least three (3) experts to support your response
|
|
What is the speed at the top of the flow
: The cross-sectional area of the stream in a region near the top is A1, and the cross sectional area lower region is A2 . If the distance between the two regions is h, find an expression for the speed of the water in the top region in terms of A1, ..
|
|
Create pivot tables and pivot charts to analyze sales
: 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 ..
|
|
Identify and discuss the four goals of the new medicare
: The authors suggest that the CMS will need a broader strategy to accomplish its mission. List and discuss at least 3 recommendations for shaping this strategy. Which one do you feel will achieve the most good?
|
|
How much ice remains when the mixture reaches equilibrium
: Does all the ice melt? If so, what is the final temperature of the water? If not, how much ice remains when the mixture reaches equilibrium.
|
|
Determine the maximum speed of the mass
: A 400g mass on a spring has a speed of 95.4cm/s when it's displacement is 3.0cm and 71.4 cm/s when it's displacement is 6.0 cm what is the maximum speed of the mass?
|
|
Calculate the current commission that the dealer receives
: CSDP241 Spring, 2016 - Produce a sequential update program using techniques similar to the program given posted at the end of this homework.
|