Tableua 3

The project will consist of a Tableau Analysis and Presentation.

Download the following attachments to complete the project.

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.

OfficeSupplies

9

00

-Jul-2019

8

East

8

-Jul-2019

9

,600

Central

8

Central

Equinox
6

East

Bolt EV

32,620

East
April

5

-Aug-2019

Central

Equinox
6
23,800

East
Juan
Silverado 1500
10

West

Blazer
7
28,800

Central
Michael
Traverse
9
29,800

West

34

Central

5

1-Sep-2019
West
Mark

9
34,600

Central
Daniel
Silverado 1500
5
34,600

East
Micah
Silverado 2500HD
6
34,600

11-Sep-2019

Micah

7
21,300

East
Juan
Equinox
5
23,800

West
Mark

9

Central
Zane
Bolt EV
10
32,620

East
Juan
Blazer
6
28,800

East
April
Colorado
6
21,300

West
Joel
Bolt EV
7
32,620

East
Juan
Camaro
5
25,000

West
Betty
Silverado 1500
8
34,600

East
April
Camaro
9
25,000

Central
Michael
Bolt EV
7
32,620

Central
Valerie
Trax
9
21,300

19-Nov-2019
East
April

5

Central
Matthew

10

Central
Michael
Bolt EV
5
32,620

West
Joel
Impala
6
31,620

Central
Valerie
Silverado 1500
5
34,600

West
Joel
Blazer
9
28,800

West
Betty
Bolt EV
10
32,620

East
Micah
Impala
6
31,620

East
April
Spark
5
13,400

Central
Valerie
Silverado 2500HD
5
34,600

Central
Valerie

5

East
Juan
Silverado 1500
6
34,600

Central
Daniel

5

West
Mark
Suburban
10
51,700

Central
Matthew
Corvette
9
58,900

Central
Valerie
Corvette
10
58,900

Central
Daniel

10

Central
Michael

10

West
Betty
Trax
7
21,300

East
Micah
Corvette
5
58,900

Central
Zane
Colorado
8
21,300

Central
Daniel

6

Central
Michael
Traverse
7
29,800

West
Mark
Corvette
7
58,900

West
Mark
Malibu
10
22,140

Central
Michael
Spark
5
13,400

Central
Valerie
Suburban
5
51,700

East
Juan
Corvette
10
58,900

West
Betty
Tahoe
9
49,900

Central
Daniel
Colorado
10
21,300

Central
Zane
Colorado
6
21,300

West
Betty
Malibu
8
22,140

West
Betty
Malibu
5
22,140

East
Micah
Sonic
5
16,720

Central
Michael
Malibu
9
22,140

Central
Michael
Tahoe
10
49,900

7-May-2020
East
April
Tahoe
8
49,900

Central
Daniel
Malibu
6
22,140

West
Joel
Malibu
10
22,140

Central
Daniel
Corvette
7
58,900

East
Juan
Corvette
9
58,900

Central
Matthew
Silverado 3500HD
6
35,800

Central
Zane
Malibu
8
22,140

Central
Valerie
Suburban
9
51,700

East
Juan
Trax
7
21,300

28-Jun-2020
West
Mark
Trax
10
21,300

SaleDate

Region

SalesRep

Item

Units

Unit Price

4-Jul-201

9

East

Juan

Equinox

23,

8

6

West

Joel

Traverse

29,800

12-Jul-2019

Micah

Bolt EV

32,620

1

5

Central

Michael

Silverado 1500

34

16-Jul-2019

Daniel

Trax

21,300

21-Jul-2019

Zane

23,800

29-Jul-2019

April

10

1-Aug-2019

Blazer

28,800

7

Matthew

15-Aug-2019

34,600

19-Aug-2020

Betty

22-Aug-2019

24-Aug-2019

Mark

Express

32,500

1-Sep-2019

Valerie

Silverado 3500HD

35,800

Silverado 2500HD

10-Sep-2019

11-Sep-2019

East

Colorado

18-Sep-2019

27-Sep-2019

Camaro

25,000

5-Oct-2019

7-Oct-2019

9-Oct-2019

14-Oct-2019

22-Oct-2019

31-Oct-2019

8-Nov-2019

17-Nov-2019

19-Nov-2019

Impala

31,620

25-Nov-2019

Spark

13,400

4-Dec-2019

7-Dec-2019

12-Dec-2019

13-Dec-2019

21-Dec-2019

28-Dec-2019

29-Dec-2019

30-Dec-2019

31-Dec-2019

Suburban

51,700

6-Jan-2020

15-Jan-2020

Corvette

58,900

18-Jan-2020

23-Jan-2020

1-Feb-2020

7-Feb-2020

Tahoe

49,900

9-Feb-2020

Malibu

22,140

11-Feb-2020

18-Feb-2020

19-Feb-2020

26-Feb-2020

Sonic

16,720

1-Mar-2020

7-Mar-2020

15-Mar-2020

24-Mar-2020

30-Mar-2020

1-Apr-2020

4-Apr-2020

5-Apr-2020

6-Apr-2020

10-Apr-2020

18-Apr-2020

27-Apr-2020

5-May-2020

7-May-2020

14-May-2020

22-May-2020

31-May-2020

8-Jun-2020

17-Jun-2020

25-Jun-2020

27-Jun-2020

28-Jun-2020