Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Tableau Data Analyst Exam > Domain 1 & 2 > Flashcards

Domain 1 & 2 Flashcards

1
Q

DateDIFF Syntax

A

DATEDIFF(date_part,startdate,enddate,startofweek)
DATEDIFF(‘month’,[orderdate],[shipdate])

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

Where do columns and rows show up on axis?

A

Columns appear on X axis
Rows appear on Y axis

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

Replace a data source steps

A
  1. Open workbook with original data
    2.Data Tab > New Data Source
  2. Set up data in canvas (drag to canvas)
  3. Back to workbook
  4. Data Tab>Replace Data Source
    6.Select current and replacement source

NOT- Go to data source page and select “add” - that causes a cross data

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

Ascending vs Descending

A

Ascending: going up 0 to 100
Descending: going down 100 to 0

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

Difference between Index and Rank Function

A

Index deals with physical position of the record. Rank deals with value of record with highest value at highest rank.

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

Rank_Dense

A

Optimist tie Returns the dense rank for the current row in the partition. Identical values are assigned an identical rank, but no gaps are inserted into the number sequence. Use the optional ‘asc’ | ‘desc’ argument to specify ascending or descending order. The default is descending.

With this function, the set of values (6, 9, 9, 14) would be ranked (3, 2, 2, 1).

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

Rank_Modified

A

Pessimist tie Returns the modified competition rank for the current row in the partition. Identical values are assigned an identical rank. Use the optional ‘asc’ | ‘desc’ argument to specify ascending or descending order. The default is descending.

With this function, the set of values (6, 9, 9, 14) would be ranked (4, 3, 3, 1).

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

Rank_Percentile

A

Returns the percentile rank for the current row in the partition. Use the optional ‘asc’ | ‘desc’ argument to specify ascending or descending order. The default is ascending.

With this function, the set of values (6, 9, 9, 14) would be ranked (0.00, 0.67, 0.67, 1.00).

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

Rank_Unique

A

Returns the unique rank for the current row in the partition. Identical values are assigned different ranks. Use the optional ‘asc’ | ‘desc’ argument to specify ascending or descending order. The default is descending.

With this function, the set of values (6, 9, 9, 14) would be ranked (4, 2, 3, 1).

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

FIRST () function

A

Returns the number of rows from the current row to the first row in the partition. For example, the view below shows quarterly sales. When FIRST() is computed within the Date partition, the offset of the first row from the second row is -1.
0
-1
-2
-3

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

DATEPARSE

A

Converts Original date into a date format.
DATEPARSE(date_format,date_string)
DATEPARSE(‘yyyy-MM-dd’, “1986-03-25”) = #March 25, 1986#
DATEPARSE(‘yyyy-MM-dd’, [originaldate]) = #March 25, 1986#

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

DATETRUNC

A

Rounds up to first day of date_part
DATETRUNC(date_part, date, [start_of_week])
DATETRUNC(quarter, #9/22/2018#) = #7/1/2018#

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

P-Value

A

Measure of statistical confidence

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

Low P-Value vs High P-Value

A

Lower the P-Value, the greater the statistical confidence. Values below .05 are considered “statistically significant”

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

How are blends and left joins different?

A

Blends do not introduce duplication since aggregation happens before data sources are combined. In a Left join, sources are combined and then aggregation happens

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

Difference between a join and a blend in data connections

A

A join combines data first then aggregates after. a blend aggregates first then combines data.

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

IQR

A

Interquartile Range:
difference between upper and lower hinge
Range for middle 50% of data
Q3-Q1
UH-LH

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

Lower Hinge

A

25% of data is below lower hinge
“Lowest quarter”
“1st Quarter”
Q1
25% percentile

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

Upper Hinge

A

Highest quarter of data
Only 25% if data is above/higher
75% percentile
3rd Quarter
Q3

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

Best chart for distribution? Best chart for dates?

A

Histogram is the best chart for Distribution.
Line chart is the best chart for dates.

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

Measure Names and Measure Value fields are most used for:

A

When you want to dynamically switch between multiple measures in a viz (parameters)

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

What color pills are continuous and discrete data?

A

Continuous- Green
Discrete- Blue

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

Measure attributes

A

Measures are aggregated to the current level of detail. They are Quantitative. ( clicks, sales, profit, height). Often continuous in nature

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

Dimension attributes

A

Dimensions increase the level of detail. They are Qualitative (eye color, country, region, name) Usually discrete

25
Q

Density maps

A

You have to change the marks card to Density for it to convert

26
Q

Tree maps

A

Measure is on marks card twice: once in size and another one in color.

27
Q

Calc for : Return Middle name (if any) and Last Name of Customer

A

MID ([CustomerName], FIND([CustomerName],” “) +1)

Find tells it to start at the “ “ after first name and +1 makes sure the space isn’t included

28
Q

Calc for : Return Middle name (if any) and Last Name of Customer

A

MID ([CustomerName], FIND([CustomerName],” “) +1)
Find tells it to start at the “ “ after first name and +1 makes sure the space isn’t included

29
Q

Calc for: Return a “Profit” or “Loss” Status based on profit

A

IIF ([Profit]>0,’Profit’,’Loss’)
IIF(_____, then, else, [unknown])

30
Q

IF() vs IIF() Syntax

A

IF is a statement; IIF is a function:
IF ___THEN _____END
IF ___THEN _____ELSE ______END

IIF(_____, then, else, [unknown])

31
Q

FIND Syntax
What is the syntax and explain what it does

A

FIND(string, substring, [start]) FIND(“Calculation”, “a”, 1) = 2

Returns the index position of substring in string or 0 if the substring isn’t found.

If nested within another syntax, it’s telling you where to start.
MID ([Cust Name], FIND([Cust Name],” “) +1)
tells you to start at the first SPACE in the Customer name field. The +1 makes sure the space isn’t included

32
Q

Calc: Compute the 50-day moving average of sales for data in window

A

WINDOW_AVG(Sales), -49,0)
Then add new field to Row. Right click field to create Dual Axis Chart

33
Q

FIRST()
When FIRST() is computed alongside INDEX, what is the result for the row with index=3

A

-2 - First starts at 0 and counts in negatives
INDEX FIRST()
1 0
2 -1
3 -2

34
Q

LAST()
When last is computed alongside INDEX, what is the result for the row with index=3

A

0
LAST() Starts at the max and goes down to 0. All numbers are positive.
INDEX LAST()
1 2
2 1
3 0

35
Q

WINDOW_AVG SYNTAX

A

WINDOW_AVG(expression, [start, end])
WINDOW_AVG(SUM([sales]), FIRST(), LAST() )

  • Can change out AVG with Sum, Min, Max, STDV, Median,
36
Q

Calc: field to link parameter called [dimension swap] with list to visualization

A

CASE [dimensionswap]
WHEN “Category” THEN [Categoryfield] – (do for all list items)
END

37
Q

Add to Context

A

Forcing Tableau to process Context filter first, then any other dimension filter.

38
Q

Applying filter to other worksheets

A

Click down arrow on filter pill>Apply to worksheet>Selected Worksheets> Pick the ones you want to apply it to

39
Q

Order of Operations: Filters

A

Extract Filters(sql)
Data Source Filters
Context Filters
Dimension Filters
Measure Filters
Table Calculation Filters

40
Q

Order of Operations

A

Sets, Conditional Filters, Top N, Fixed LOD
Include/Exclude LOD, data blending
Forecasts, Table Calculations, Totals
Trend Lines, Reference Lines

41
Q

Calc: isolate domains in emails

A

MID ( “xyz@google.com”, FIND (“xyz@google.com”, “@”)+1) =”google.com”

42
Q

SPLIT Syntax

A

SPLIT ( CustomerName), “ “, 2)
SPLIT ([field], seperator, which component you want)
split can’t be used when there is a middle name

43
Q

Turning Amanda Babineaux into
Babineaux, A

A

RIGHT([CustomerName], LEN([LastName]))
+ “, “
+ LEFT ([customer name], 1)

44
Q

Left Syntax

A

Find all products that start with Xerox:
LEFT([productname], 5) = XEROX

45
Q

Calc: Find customer’s first order

Calc: Number of orders by customer

A

{fixed[customerID] : MIN (orderdate)}

{fixed[customerID] : CountD(orderID)}

46
Q

Compound Growth Rate of Sales

with original compound growth rate syntax

A

POWER ( ZN (SUM[sales])) / LOOKUP (ZN (SUM[sales]))
, -[N Years] , ZN (1/ [N Years] -1

(ZN(End Sales Value/Beginning Sales Value) ^ (ZN(1/n)) - 1

47
Q

Syntax for : DOES NOT EQUAL

A

!=

48
Q

Profit Ratio

A

SUM(profit) / SUM(sales)

49
Q

Calc: LOD Expression to show total sales by month without the regional componet

A

{EXCLUDE[region] : SUM(sales)}

50
Q

Connect to Published Data Source in Tableau Server and Create a new Workbook

A
  1. Select all Data sources you want in “All Data Sources”
  2. At top of page from Action menu select “New Workbook”
51
Q

Combining Sets

A

Must be based on same dimension
Select two sets > RTCLICK>Create Combined Set

52
Q

Convert Sales into Bins with discrete set of bins equal to 500 and create a histogram that shows how many products fall into each bin.

A

Sales>Create>Bin
Set to 500
Drag field to Columns; Drag Product name to Row.
Change Row Measure to COUNT instead of dimension.

53
Q

Create a filled map to show profit by state

A
  1. Add longitude and latitude in row and column
  2. Add sum(profit) to Color Marks ; Add state to Detail Marks
  3. Make sure Mark’s dropdown is on Map
54
Q

” Add a reference line to show the average sales value”

A

Add an average reference line based on SUM(sales) BUT make sure the LABEL= VALUE !

55
Q

What trend line models do you have in Tableau (5)

A

Linear
Logarithmic
Exponential
Polynomial
Power

56
Q

Which two functions can be used in tableau to build a predictive model?

A

Model_Quantile
Model_Percentile

57
Q

Model_Percentile Syntax
Model_Quantile Syntax

Give function for Sales & OrderCount

A

MODEL_PERCENTILE( SUM([Sales]),COUNT([Orders]))
MODEL_QUANTILE(0.5, SUM([Sales]), COUNT([Orders]))

58
Q
A
59
Q

LOOKUP(expression, [offset])

DATEDIFF(date_part, date1, date2, [start_of_week])

FIND(string, substring, [start])

MID(string, start, [length])

SPLIT(string, spacer, side)

A

Tableau Data Analyst Exam (4 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions