Description
Turn in your assignments using a PDF file. Do NOT using any Tableau file types (twb, twbx) – they take forever to open and read and I have to toggle back and forth. An acceptable alternative is a link to your Tableau Public folder where your answer is.
Tableau website: https://public.tableau.com/en-us/s/
I will provide Tableau login credentials upon tutor accepting bid, to include gDrive access to two books required for the course
These labs are from the end of chapters in Sosulski (as previously stated ebook will be provided upon tutor accepting bid), but I have rewritten them here:
Access the following dataset and answer questions a and b below using Tableau: Download Lab 1 Data sales.xls-Providing in attachment
a. Design a chart for an executive to access sales over the past day across different income groups. In a sentence or two provide the main takeaway.
b. On a different visual, show the age and gender demographic that has the most sales. In a sentence or two provide the main takeaway.
To assist you, please read the following tutorials:
Bar chart tutorial: http://becomingvisual.com/portfolio/bar-graphLinks to an external site.
Table tutorial: http://becomingvisual.com/portfolio/table-graphLinks to an external site.
Unformatted Attachment Preview
sales.xls
purchase age
0
0
1
1
0
0
0
0
0
0
0
1
0
0
1
0
0
0
0
0
1
0
1
1
0
0
1
0
0
0
0
1
1
1
1
0
0
0
1
1
0
0
1
1
1
0
0
1
1
0
0
gender
41 Female
47 Female
41 Female
39 Female
32 Female
32 Female
33 Female
45 Female
43 Female
40 Female
39 Female
46 Female
38 Female
38 Female
44 Female
39 Female
26 Female
45 Female
40 Female
35 Female
30 Female
44 Female
47 Female
35 Female
36 Female
34 Female
38 Female
38 Female
47 Female
41 Female
45 Female
37 Female
38 Female
29 Female
40 Female
35 Female
44 Female
39 Female
50 Female
41 Female
41 Female
40 Female
38 Female
36 Female
37 Female
39 Female
41 Female
33 Female
51 Female
31 Female
31 Female
income
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Page 1
sales.xls
0
0
1
0
0
1
0
0
0
0
1
0
1
0
1
0
0
0
1
0
1
1
1
0
0
0
0
0
1
1
1
0
0
0
1
1
0
1
1
0
1
1
0
0
0
0
0
1
1
0
0
0
35 Female
46 Female
39 Female
47 Female
40 Female
56 Female
36 Female
37 Female
36 Female
44 Female
36 Female
40 Female
38 Female
35 Female
35 Female
45 Female
41 Female
42 Female
37 Female
55 Female
41 Female
33 Female
36 Female
33 Female
38 Female
38 Female
55 Female
50 Female
31 Female
37 Female
37 Female
38 Female
41 Female
42 Female
34 Female
31 Female
28 Female
35 Female
39 Female
39 Female
34 Female
45 Female
41 Female
42 Female
46 Female
42 Female
33 Female
47 Female
39 Female
41 Female
33 Female
43 Female
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Page 2
sales.xls
1
1
0
1
0
1
0
1
1
0
1
0
1
0
0
0
0
1
0
0
1
0
1
0
0
1
1
1
0
1
0
0
1
0
0
0
0
0
0
0
1
1
0
1
1
0
1
0
0
0
1
0
31 Female
43 Female
45 Female
48 Female
40 Female
35 Female
33 Female
34 Female
43 Female
35 Female
31 Female
48 Female
36 Female
39 Female
37 Female
40 Female
39 Female
44 Female
35 Female
33 Female
34 Female
50 Female
44 Female
40 Female
36 Female
41 Female
37 Female
38 Female
38 Female
41 Female
36 Female
42 Female
43 Female
43 Female
50 Female
42 Female
42 Female
38 Female
33 Female
39 Female
41 Female
44 Female
42 Female
33 Female
49 Female
40 Female
37 Female
38 Female
36 Female
39 Female
34 Female
44 Female
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Page 3
sales.xls
1
0
1
1
1
1
0
0
0
0
1
0
0
1
0
1
0
0
0
0
0
1
1
0
1
1
0
1
1
1
1
0
0
1
0
0
0
0
1
1
0
1
1
1
0
0
0
0
0
0
1
1
34 Female
39 Female
38 Female
34 Female
52 Female
41 Female
41 Female
37 Female
45 Female
44 Female
35 Female
30 Female
28 Female
40 Female
33 Female
44 Female
39 Female
42 Female
31 Female
29 Female
49 Female
33 Female
35 Female
34 Female
40 Female
40 Female
32 Female
38 Female
23 Female
49 Female
39 Female
32 Female
43 Female
38 Female
34 Female
38 Female
35 Female
45 Female
28 Female
35 Female
26 Female
38 Female
34 Female
46 Female
35 Female
36 Female
37 Female
48 Female
41 Female
40 Female
51 Female
45 Female
Medium
Medium
Medium
Medium
Medium
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
Page 4
sales.xls
0
1
1
0
1
1
1
1
1
0
0
0
1
0
0
0
1
1
1
1
1
0
0
1
0
0
0
0
0
1
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
1
0
0
0
33 Female
37 Female
36 Female
42 Female
51 Female
51 Female
41 Female
26 Female
49 Female
46 Female
41 Female
40 Female
44 Female
35 Female
40 Female
37 Female
32 Female
45 Female
29 Female
41 Female
39 Female
26 Female
30 Female
38 Female
35 Female
39 Female
24 Female
32 Female
46 Female
40 Female
38 Female
42 Female
43 Female
29 Male
58 Male
40 Male
35 Male
47 Male
33 Male
40 Male
37 Male
37 Male
40 Male
36 Male
32 Male
37 Male
49 Male
38 Male
36 Male
42 Male
44 Male
38 Male
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Page 5
sales.xls
0
0
0
0
1
0
0
0
1
1
0
0
0
0
0
1
1
0
1
0
0
0
0
0
0
0
0
0
1
0
1
0
0
0
1
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
40 Male
41 Male
40 Male
47 Male
39 Male
38 Male
43 Male
46 Male
48 Male
38 Male
35 Male
38 Male
37 Male
32 Male
29 Male
41 Male
39 Male
40 Male
48 Male
37 Male
40 Male
42 Male
42 Male
38 Male
46 Male
45 Male
33 Male
34 Male
33 Male
42 Male
47 Male
43 Male
35 Male
43 Male
33 Male
26 Male
34 Male
43 Male
41 Male
38 Male
25 Male
45 Male
37 Male
34 Male
39 Male
32 Male
44 Male
39 Male
30 Male
36 Male
45 Male
39 Male
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Page 6
sales.xls
0
0
0
1
1
0
0
1
0
1
0
1
0
1
1
0
1
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
1
0
0
0
0
1
0
0
1
0
44 Male
47 Male
46 Male
34 Male
38 Male
31 Male
34 Male
33 Male
38 Male
43 Male
43 Male
47 Male
41 Male
37 Male
38 Male
38 Male
35 Male
34 Male
33 Male
40 Male
39 Male
41 Male
44 Male
37 Male
41 Male
45 Male
29 Male
40 Male
40 Male
35 Male
49 Male
40 Male
38 Male
41 Male
35 Male
33 Male
47 Male
36 Male
37 Male
40 Male
44 Male
48 Male
43 Male
41 Male
30 Male
42 Male
33 Male
41 Male
33 Male
37 Male
42 Male
25 Male
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
Medium
High
High
High
High
High
High
High
Page 7
sales.xls
1
0
0
0
0
0
0
1
1
0
0
1
1
1
1
0
1
1
0
0
0
0
1
1
1
1
1
1
1
0
1
0
1
0
1
0
1
0
1
0
1
1
0
0
1
1
0
0
1
0
0
0
39 Male
39 Male
36 Male
43 Male
41 Male
34 Male
37 Male
46 Male
42 Male
40 Male
41 Male
39 Male
34 Male
35 Male
35 Male
44 Male
45 Male
38 Male
39 Male
38 Male
43 Male
31 Male
45 Male
36 Male
33 Male
49 Male
41 Male
41 Male
31 Male
34 Male
39 Male
44 Male
46 Male
32 Male
52 Male
41 Male
48 Male
50 Male
38 Male
36 Male
34 Male
37 Male
38 Male
42 Male
33 Male
35 Male
30 Male
48 Male
35 Male
44 Male
41 Male
37 Male
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
Page 8
sales.xls
1
0
0
1
1
1
1
1
1
1
0
1
0
1
0
0
35 Male
46 Male
37 Male
47 Male
39 Male
47 Male
45 Male
37 Male
37 Male
33 Male
40 Male
43 Male
31 Male
32 Male
34 Male
34 Male
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
Page 9
Sum of purchase
Column Labels
23 24 25 26 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45
Total
1 0 0 1 1 2 1 5 2 10 11 13 7 12 15 12 5 13 3 6 8 7
16
14
12
10
8
Series1
6
4
2
0
1 3 5 7 9 11 13 15 17 19 21 23 25 27 29 31
46 47 48 49 50 51 52 55 56 58 Grand Total
4 6 4 5 1 4 2 0 1 0
162
Purchase answer to see full
attachment
