1. How might analytics be used in the following situations? Determining a personal investment plan Please answer...
Question:
1. How might analytics be used in the following situations? Determining a personal investment plan Please answer using at least ten sentences.
2. Use Excel’s filtering capability in the Purchase Orders database to extract a. all orders for Electrical Connector. b. all orders for quantities of less than 5510 units. c. all orders for Electrical Connector with quantities of less than 5510 units. Please include Excel worksheets with all the details with your answer.
3. The monthly product sales for a company are given in the Homework 1 Question 3 Data excel file posted with this homework. Use Pivot Charts to create a useful dashboard for the data in this Excel file. Include the following 6 charts in your dashboard: - Total Product A sales units for each month - Total Product B sales units for each month - Total Product C sales units for each month - Total Product D sales units for each month - Total Product E sales units for each month - A clustered chart of total sales units for Product A, total sales units for Product B, total sales units for Product C, total sales units for Product D, and total sales units for Product E for each month Explain how a manager might use the dashboard. Please include the Excel worksheet with all the details and the dashboard with your answer.
Sales Units | |||||
Month | Product A | Product B | Product C | Product D | Product E |
January | 7450 | 3600 | 3200 | 4250 | 6580 |
February | 7200 | 3024 | 4200 | 3751 | 9020 |
March | 8200 | 5550 | 2147 | 3320 | 6827 |
April | 6500 | 5600 | 2700 | 4057 | 8544 |
May | 6000 | 5200 | 2726 | 3650 | 8550 |
June | 9800 | 4000 | 3050 | 4700 | 9070 |
July | 8702 | 6000 | 2891 | 5418 | 8389 |
August | 10200 | 5500 | 2782 | 4085 | 7360 |
September | 8986 | 4800 | 2524 | 5720 | 5377 |
October | 8654 | 4746 | 3258 | 5333 | 7645 |
November | 8300 | 3570 | 2150 | 7000 | 8200 |
December | 8600 | 6200 | 5420 | 6563 | 7640 |
Business Analytics Methods Models and Decisions
ISBN: 978-0321997821
2nd edition
Authors: James R. Evans