Question
1. Open Tableau. 2. Open the Microsoft Excel Worksheet titled Car Sales. 3. Click on the Data Source Tab. 4. Take a screenshot of the
1. Open Tableau. 2. Open the Microsoft Excel Worksheet titled Car Sales. 3. Click on the Data Source Tab. 4. Take a screenshot of the Data Source Tab showing the data. Make sure to save ALL screenshots on a separate Word Docx. The screenshots must be turned in also. 5. Click on Sheet 1. 6. Go to the Tables section on the left and drag & drop Sales Rep to the Columns area on top. 7. Go to the Table section on the left and drag & drop Units to the Rows area on top. 8. Take a screenshot of Sheet 1 showing the Bar Chart. 9. At this point, who is the top Sales Rep? Approximately how many sales does this Rep have? 10. Go to the Tables section on the left and drag & drop Region to the Columns area on top so that it is placed before Sales Rep. 11. At this point, who are the top Sales Reps in each region? 12. Click on Sheet 1 and rename it Car Sales Data_yourname 13. Take a screenshot of the renamed sheet with your name and the Bar Chart. 14. Go to the Rows area on top click the drop-down box on SUM(Units) and click Remove. 15. Take a screenshot of the Data_yourname sheet with SUM(Units) removed. 16. Go to the Table section on the left and drag & drop Unit Price to the Rows area on top. 17. Take a screenshot of the Bar Graph with the Data_yourname sheet showing the sums of each Sales Rep. 18. On the right of the screen under Show Me, click on Highlight Tables. This will convert the Bar Graph to a table shows total sales. 19. Take a screenshot of the table showing total sales. 20. At this point, who is the top Sales Rep? What is the total of their sales? 21. Undo this action by clicking the back arrow under Data on top 22. In the middle of the screen under Marks, click on Color and choose a new color for your Bar Chart. 23. Go to File at the top of the screen and click Export As PowerPoint. Keep Include This View and click Export. 24. Save as CarSales Assignment_Yourname. 25. Write a 350-Word paper that explains to your boss about the data in this export. In this write-up explain the following: A. Sales Rep who sold the most units. B. Total sales of the leading Sales Rep. C. The top Sales Rep in each region will a 3% bonus. The top Sales Rep in all regions will get a 5% bonus. Who are these Sales Reps and what are their bonuses? D. The type of car that sold the most. E. The type of car that sold the least. F. The region with most units sold. G. Most profitable region.
A 7-May-2020 East April 14-May-2020 Central Daniel 22-May-2020 West Joel 31-May-2020 Central Daniel 8-Jun-2020 East Juan 72 17-Jun-2020 Central Matthew 73 25-Jun-2020 Central Zane 34 27-Jun-2020 Central Valerie 75 28-Jun-2020 East Juan 76 28-Jun-2020 West Mark 77 57 58 59 70 71 B C Tahoe Malibu Malibu D Corvette Corvette Silverado 3500HD Malibu Suburban Trax Trax E 8 6 10 7 9 6 8 9 7 10 F 49,900 22,14C 22,140 58,900 58,900 35,800 22,14C 51,70C 21,300 21,300 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 B Region A Sale Date 4-Jul-2019 East Juan 6-Jul-2019 West Joel 12-Jul-2019 East Micah 15-Jul-2019 Central Michael 16-Jul-2019 Central Daniel 21-Jul-2019 Central Zane 29-Jul-2019 East April 1-Aug-2019 East April 7-Aug-2019 Central Matthew 15-Aug-2019 East Juan 19-Aug-2020 West Betty 22-Aug-2019 Central Michael 24-Aug-2019 West Mark 1-Sep-2019 Central Valerie 1-Sep-2019 West Mark Daniel Micah Micah C SalesRep 10-Sep-2019 Central 11-Sep-2019 East 11-Sep-2019 East 18-Sep-2019 East Juan 27-Sep-2019 West Mark 5-Oct-2019 Central Zane 7-Oct-2019 East 9-Oct-2019 East 14-Oct-2019 West 22-Oct-2019 East 31-Oct-2019 West 8-Nov-2019 East 17-Nov-2019 Central 19-Nov-2019 Central 19-Nov-2019 East 25-Nov-2019 Central 4-Dec-2019 Central Juan April Joel Juan Betty April Michael Valerie April Matthew Michael Equinox Traverse Bolt EV Silverado 1500 D Item Trax Equinox Bolt EV Blazer Equinox Silverado 1500 Blazer Traverse Express Silverado 3500HD Silverado 2500HD Silverado 1500 Silverado 2500HD Colorado Equinox Camaro Bolt EV Blazer Colorado Bolt EV Camaro Silverado 1500 Camaro Bolt EV Trax Impala Spark Bolt EV 9 8 8 E Units Unit Price 23,800 29,800 32,620 34,600 21,300 23,800 32,620 28,800 23,800 34,600 28,800 29,800 32,500 35,800 34,600 34,600 34,600 0x 9 8 6 10 5 6 10 7 9 34 5 65L956 F u N 7 21,300 23,800 25,000 10 32,620 6 28,800 6 21,300 7 32,620 5 25,000 8 34,600 9 25,000 32,620 7 9 5 10 5 21,300 31,620 13,400 32,620 A B 34 7-Dec-2019 West Joel 35 12-Dec-2019 Central Valerie 36 13-Dec-2019 West Joel 37 21-Dec-2019 West 38 28-Dec-2019 East 39 29-Dec-2019 East April 40 30-Dec-2019 Central Valerie 41 31-Dec-2019 Central Valerie 42 6-Jan-2020 East Juan 43 15-Jan-2020 Central Daniel 44 18-Jan-2020 West Mark 45 23-Jan-2020 Central 46 47 48 49 11-Feb-2020 West 50 18-Feb-2020 East 51 19-Feb-2020 Central Zane 52 26-Feb-2020 Central Daniel 1-Mar-2020 Central 53 Michael 54 7-Mar-2020 West Mark 55 15-Mar-2020 West Mark 56 24-Mar-2020 Central 57 58 59 60 61 62 63 64 65 66 C Betty Micah Matthew 1-Feb-2020 Central Valerie 7-Feb-2020 Central Daniel 9-Feb-2020 Central Michael Betty Micah Impala Silverado 1500 Blazer Bolt EV Betty Betty Micah Impala Spark Silverado 2500HD Suburban Silverado 1500 Corvette Suburban Corvette Corvette Tahoe Malibu Trax Corvette Colorado Sonic Traverse Corvette Malibu Michael Spark 30-Mar-2020 Central Valerie 1-Apr-2020 East Juan 4-Apr-2020 West Betty 5-Apr-2020 Central Daniel 6-Apr-2020 Central Zane 10-Apr-2020 West 18-Apr-2020 West 27-Apr-2020 East Sonic 5-May-2020 Central Michael Malibu 7-May-2020 Central Michael Tahoe OfficeSupplies Sheet1 D Suburban Corvette Tahoe Colorado Colorado Malibu Malibu + E 6 5 9 10 6 5 5 5 6 5 10 9 99958677 10 10 10 10 5 50 10 9 9 10 6 OSS a 10 F 31,620 34,600 28,800 32,620 31,620 13,400 34,600 51,700 34,600 58,900 51,700 58,900 58,900 49,900 22,140 21,300 58,900 21,300 16,720 29,800 58,900 22,140 13,400 51,700 58,900 49,900 21,300 21,300 22,140 22,140 16,720 22,140 49,900 A 7-May-2020 East April 14-May-2020 Central Daniel 22-May-2020 West Joel 31-May-2020 Central Daniel 8-Jun-2020 East Juan 72 17-Jun-2020 Central Matthew 73 25-Jun-2020 Central Zane 34 27-Jun-2020 Central Valerie 75 28-Jun-2020 East Juan 76 28-Jun-2020 West Mark 77 57 58 59 70 71 B C Tahoe Malibu Malibu D Corvette Corvette Silverado 3500HD Malibu Suburban Trax Trax E 8 6 10 7 9 6 8 9 7 10 F 49,900 22,14C 22,140 58,900 58,900 35,800 22,14C 51,70C 21,300 21,300 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 B Region A Sale Date 4-Jul-2019 East Juan 6-Jul-2019 West Joel 12-Jul-2019 East Micah 15-Jul-2019 Central Michael 16-Jul-2019 Central Daniel 21-Jul-2019 Central Zane 29-Jul-2019 East April 1-Aug-2019 East April 7-Aug-2019 Central Matthew 15-Aug-2019 East Juan 19-Aug-2020 West Betty 22-Aug-2019 Central Michael 24-Aug-2019 West Mark 1-Sep-2019 Central Valerie 1-Sep-2019 West Mark Daniel Micah Micah C SalesRep 10-Sep-2019 Central 11-Sep-2019 East 11-Sep-2019 East 18-Sep-2019 East Juan 27-Sep-2019 West Mark 5-Oct-2019 Central Zane 7-Oct-2019 East 9-Oct-2019 East 14-Oct-2019 West 22-Oct-2019 East 31-Oct-2019 West 8-Nov-2019 East 17-Nov-2019 Central 19-Nov-2019 Central 19-Nov-2019 East 25-Nov-2019 Central 4-Dec-2019 Central Juan April Joel Juan Betty April Michael Valerie April Matthew Michael Equinox Traverse Bolt EV Silverado 1500 D Item Trax Equinox Bolt EV Blazer Equinox Silverado 1500 Blazer Traverse Express Silverado 3500HD Silverado 2500HD Silverado 1500 Silverado 2500HD Colorado Equinox Camaro Bolt EV Blazer Colorado Bolt EV Camaro Silverado 1500 Camaro Bolt EV Trax Impala Spark Bolt EV 9 8 8 E Units Unit Price 23,800 29,800 32,620 34,600 21,300 23,800 32,620 28,800 23,800 34,600 28,800 29,800 32,500 35,800 34,600 34,600 34,600 0x 9 8 6 10 5 6 10 7 9 34 5 65L956 F u N 7 21,300 23,800 25,000 10 32,620 6 28,800 6 21,300 7 32,620 5 25,000 8 34,600 9 25,000 32,620 7 9 5 10 5 21,300 31,620 13,400 32,620 A B 34 7-Dec-2019 West Joel 35 12-Dec-2019 Central Valerie 36 13-Dec-2019 West Joel 37 21-Dec-2019 West 38 28-Dec-2019 East 39 29-Dec-2019 East April 40 30-Dec-2019 Central Valerie 41 31-Dec-2019 Central Valerie 42 6-Jan-2020 East Juan 43 15-Jan-2020 Central Daniel 44 18-Jan-2020 West Mark 45 23-Jan-2020 Central 46 47 48 49 11-Feb-2020 West 50 18-Feb-2020 East 51 19-Feb-2020 Central Zane 52 26-Feb-2020 Central Daniel 1-Mar-2020 Central 53 Michael 54 7-Mar-2020 West Mark 55 15-Mar-2020 West Mark 56 24-Mar-2020 Central 57 58 59 60 61 62 63 64 65 66 C Betty Micah Matthew 1-Feb-2020 Central Valerie 7-Feb-2020 Central Daniel 9-Feb-2020 Central Michael Betty Micah Impala Silverado 1500 Blazer Bolt EV Betty Betty Micah Impala Spark Silverado 2500HD Suburban Silverado 1500 Corvette Suburban Corvette Corvette Tahoe Malibu Trax Corvette Colorado Sonic Traverse Corvette Malibu Michael Spark 30-Mar-2020 Central Valerie 1-Apr-2020 East Juan 4-Apr-2020 West Betty 5-Apr-2020 Central Daniel 6-Apr-2020 Central Zane 10-Apr-2020 West 18-Apr-2020 West 27-Apr-2020 East Sonic 5-May-2020 Central Michael Malibu 7-May-2020 Central Michael Tahoe OfficeSupplies Sheet1 D Suburban Corvette Tahoe Colorado Colorado Malibu Malibu + E 6 5 9 10 6 5 5 5 6 5 10 9 99958677 10 10 10 10 5 50 10 9 9 10 6 OSS a 10 F 31,620 34,600 28,800 32,620 31,620 13,400 34,600 51,700 34,600 58,900 51,700 58,900 58,900 49,900 22,140 21,300 58,900 21,300 16,720 29,800 58,900 22,140 13,400 51,700 58,900 49,900 21,300 21,300 22,140 22,140 16,720 22,140 49,900Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started