POST BUS521 Unit 2 Assignment Latest 2022 March
BUS521 Business Analytics for Managers
Unit 2 Assignment
Pivot Table – A Gateway into your Data
Overview:
In this assignment you will take the table you used in the first assignment and place a pivot table and a pivot graph on it. Pivot tables and graphs are a common tool in Excel and often used when you have thousands, tens of thousands, or hundreds of thousands of lines. If you are wondering, Excel can handle 1,048,576 total rows. Let your curiosity take you on this one.
Some of the Excel videos show Excel 2013. If you have 2010, the Pivot Table Analysis tab is called Options. Some features shown in the video will not be included in Excel 2010; none of these features will be required for any of the assignments, so your ability to complete these assignments will not be compromised at all.
If you run into trouble with the assignments, please use the Watercooler Tab and ask your classmates. I will be monitoring this board to lend a hand as well. Your grade is not dependent on whether you can figure out something on your own; you are graded on your abilities to use the resources you have (within reason) available to you to execute on what needs to be completed.
Instructions:
Create a pivot table of the data you created for Assignment 1 and add a pivot chart of something you find interesting in this data. Filter the data in a way that makes it digestible(example: one product over 2 years).
Requirements:
For this and future excel assignments, repeating the action of the tutorials should be done at a minimum. For full credit, your ability to make adjustments to formatting, use of other formulas and other additional manipulations will demonstrate that you are gaining the understanding needed in Excel to be a leader in managing analytics.
Please upload your entire Excel workbook to Blackboard when completed
Having Trouble Meeting Your Deadline?
Get your assignment on POST BUS521 Unit 2 Assignment Latest 2022 March completed on time. avoid delay and – ORDER NOW
