Steps Flashcards

The steps to do something in Tableau

1
Q

Fixed Set

A

In Viz

Open Sheet > (In visualization) Ctl+click & drag over data > hover over data > click ‘linked circles’ icon, click ‘Create Set’

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Dynamic Set

A

In Data Pane

Open Sheet > (in Data Pane) right-click dimension >’Create’>’Set…‘>Conti in General/Condition/Top tab

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Filter Set

A

In Filter Pane

Open Sheet > (in Filter pane) Click dimension > ‘Create Set…‘>Conti in General/Condition/Top tab

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Combine Sets

A

In Data Pane

Right-click set (in Data Pane)>’Create Combined Set’> choose how to combine sets (looks like Full, Inner, LeftOnly, RightOnly joins)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Join

A

Data Source > drag table to canvas>

double click table/right click table>click Open (or tables if you already have a set) (Note: skipping this step creates a Relationship) >

Drag in other table (next to first table)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Union

A

Data Source > drag table to canvas>

double click table/right click table>click Open (or tables if you already have a set)(Note: skipping this step creates a Relationship) >

Drag in other table (below to first table)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Blending

How to create & edit.

A
  1. Upload 1 Data source:
    “Data” menu > “New Data Source” > (in Data Source tab) Drag table from 1 data source into view
  2. Upload 2nd data source:
    “Data” menu > “New Data Source” > (in Data Source tab) Drag table from 2nd data source into view
  3. Input data from both data sources into the sheet (paperclip will automatically appear on a potentially shared dimension/measure)

EDIT Blended Relationship:
Open Worksheet>Data tab>’Edit Blend Relationship’

https://www.youtube.com/watch?v=ZkeRWhj7CCk

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Relationship

A

Data Source > drag table to canvas>

Drag in other table (next to first table)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Create one Show/Hide option for all filters on a Dashboard

A

Open Dashboard > create horizontal/vertical container > place filters in container > Select container (can do this by clicking the drop arrow of any of the filters and select “Select container: horizontal/vertical container”) > Drop down arrow > “Add Show/Hide Button”

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

How would you see which gender contributes the most distance, per respective Fitbit category?

Chart should show the percentage of people that were male/female per each category.

Be mindful of using low granularity.

Dimensions:
Distance (Whole Number)
Gender(dimension)
Category(dimension)

A

Hint:
1- Create Fixed LOD Calculated Field:

2 - Create another calculated field with a ratio:

3 - Assemble visual:
.
.
.
.
..
..
.
..
..
..
.
Hint 2:Image 1
.
.
.
..
.
.
.
.
.
.
.

1- Create Fixed LOD Calculated Field:
‘Distance per Category’
{ FIXED [Category] : SUM([Distance]) }

2 - Create calculated field:
‘% of Category’
SUM( [Distance] ) / SUM( [Distance per Category] )

3 - Assemble visual:
Rows: Gender & Category
Column: AGG(% of Category)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Create a chart that shows how many people continued logging steps after their first day.

Don’t include ‘User ID’ in the rows/columns of the visual.

Fields:
User ID
Activity Date
Steps (Only Measure)

A

Cohort Analysis

1- Create a Calculated field,
‘First Day with Steps’ :
IF [Steps] > 0 THEN { FIXED [User ID] : MIN ([Activity Date]) END

2- Create a Calculated Field,
‘Days with steps’:
IF [Steps] > 0 and [Activity Date] > [First Day with Steps] THEN [Activity Date] END

3- Create Calculated Field,
“Days from first steps”:
[Days with steps]-[First Day with Steps]

4- Assemble visual:
Column =
[Days from first steps]
Rows =
[First day with steps]
Label & Color =
CNTD([User ID])
Filter
out Nulls (right click > exclude)
Marks =
Squares

Image 2

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

You only have ‘Steps per hour’, ‘Activity date’, and ‘User ID’ fields, but we want to show the average steps per day per user.

How do we do this without showing an ‘Activity date’ on the canvas?

A

Hint: create a text table

Create a new calculated field: ‘Average daily steps’
{INCLUDE [Activity date]: [SUM([Steps per hour])]}

Hint: Average after dragging into canvas

Create Visual:

Columns:
none

Rows:
[User ID]

Text:
AVG([Average daily steps])

Image 6

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Create Image 11 with the following:

Measure:
* Average daily Steps (this is a calculation including user ID)

Dimension
* Age bin

A

Create a calculated field:
Called ‘Overall daily average’
{EXCLUDE [Age bin]: AVG([Average daily Steps])

Create visual:
Text: AVG(Average daily Steps) & ATTR(Overall daily average)
Columns: Measure Names
Rows: Age Bin

Image 5

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Create a boolean check called ‘Above benchmark?’ comparing average ‘Daily workout time per fitness level’ to average ‘Benchmark per fitness form’.

A

Create calculated field:
[Daily workout time per fitness level] > [Benchmark per fitness form]

Results in T/F answers

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Edit a Blend

A

Data tab > Edit Blend Relationships

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Add a Statistical Summary Card

A

Worksheet tab > Show Summary

17
Q

Make it so that when you hover over a treemap, the related data in the bar chart is highlighted.

A

Dashboard
> Actions
> Add Action
> highlight
> Select the proper Source Sheet/s and Target Sheet/s
& Change “Run action on” option to “Hover”

See notes for image

18
Q

What are the options when creating an Action in a dashboard?

A

Filter
highlight
Go to URL
Go to Sheet
Change Parameter
Change Set Value

https://www.youtube.com/watch?v=xjk7sWEFm1w - change parameter

19
Q

You have a dashboard that looks like Image 8. You want to make it so that if you select a group of data, you change the “Total Sales”.

How can you do this using Actions?

A
  1. Create a parameter of “Total Sales”
  2. Create a calculated field with the parameter (this is bc parameters cannot be used in marks card)
  3. Place new calculated field in label
  4. Edit label to say “Total Sales: [Name of Step 2 Calulated Field]” & Format to dollars
  5. Place “Total Sales” sheet into dashboard
  6. Open “Add Parameter Action” dialouge box: Select “Dashboard” > “Actions” > “Add Actions” > “Change Parameter…”
  7. Edit “Add Parameter Action” dialouge box: Image 9

https://www.youtube.com/watch?v=xjk7sWEFm1w

20
Q

In what tabs can you create an action?

A

Worksheet & Dashboard
(NOT story)

21
Q

Add Grand totals (the totals do not need to be further aggregated)

A

Analysis tab > totals > choose option

22
Q

Remove the city layer from the map.

A

Map tab > Background layers > unselect “City”

23
Q

Change Map to a dark style.

A

Map > Background Maps> Dark

24
Q

Change Map to a street style.

A

Map > Background Maps> Streets

25
Remove the street layer from the map.
Map tab > Background layers > unselect "Streets, Highways, Routes"
26
Where can you go to open an option to change the formatting of the Dashboard, story, or workbook? As well as Reference Lines, Titles and Captions, filters, & more?
Format Tab
27
What can you find in the Analytics Panel?
In the side bar next to the data panel Image 4
28
What the difference between Map Backgrounds and Map Layers
Backgrounds changed the who background (e.g. dark, satellite, streets). Just one option. Layers you have multiple options to add to the map (e.g. you can have streets and city visible, but not states or countries)
29
The Navigation Button allows users to navigate from _______
Dashboards to Dashboards & Worksheets. Not between visuals inside one dashboard. Button only found on Dashboard.
30
What are buttons?
Clicking on them does an action. Not a filter or a parameter.
31
# T/F Filters/parameters are examples of buttons.
False
32
How to add a Data Source filter
1. From DataSource Tab 2. See "Filter" at the upper right hand corner 3. See"Add" below
33
How do you reorganize the Data Pane by Folders instead of Data Source Tables?
1. Right click any field in the data pane > "Group by" > "Folder" 2. Data Pane arrow > "Group by Folder"
34
The default organization for the data pane is to group by **[Folder/Data Source Table]** when there is only 1 table.
Folder
35
The default organization for the data pane is to group by **[Folder/Data Source Table]** when there are multiple tables.
Data Source Table
36
"Group by" options are available for **[relational data/multidimensional/both]** sources
relational data only
37
Scenario: **Image ** This is an example of ____ analysis.
Hint: Survival VS Cohort . . . . . .. . .