Create pivot tables and pivot charts to analyze sales

Assignment Help Computer Engineering
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

Reference no: EM13996660

Questions Cloud

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.

Reviews

Write a Review

 

Computer Engineering Questions & Answers

  Write down some of the companies which make embedded

what are some of the companies that make embedded operating systems and are these operating systems just scaled down

  Given a 3-d point at position 20 35 10 determine the

given a 3-d point at position 20 35 10 determine the coordinates of the point that results from rotating the original

  Modify the pseudocode and optimize

offer valid reasons why the pseudocode is now more efficient.

  Develop a plan for system testing comprise areas that you

for this assignment you will develop a plan for at least 3 types of tests and describe the quality controls that you

  Based on the assigned materialsnbspwrite a paper answering

based on the assigned materialsnbspwrite a paper answering the following questions.how can an it system initially help

  Convert an nfa to a dfa

Comments should be included in the program to explain your calculations and program.

  Design an application that finds all 4 digit numbers

make an application that finds all 4 digit numbers (those would be the numbers in the range 1000-9999) whose value is equal to the sum of each digit raised to the fourth power. MEANINGFUL output should be sent to the screen.

  Webinars and other web conferencing processes

Webinars and other web conferencing methods have proved most beneficial for the provision of affordable quality corporate training.

  Program that prompts the user to enter his height in inches

make a complete C++ program that prompts the user to enter his or her height in inches and outputs the following.

  Why some argue that companies must put more effort

Their line of reasoning is that leadership traits are essentially intrinsic, and true leadership skills are not really teachable. Do you feel that this sentiment has any merit.

  Explain heat transfer by radiation

Heat Transfer by Radiation, How much does a human body radiate assuming that they are in a vacuum of space

  Question 1a explain the following biometric techniques- i

question 1a explain the following biometric techniques- i retina scan ii fingerprint scan iii iris scan. your answer

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd