SQL and You
This clause sorts a result set, ascending unless you say otherwise
What is ORDER BY?
Tableau colors dimensions blue and measures this color by default
What is green?
This measure of central tendency is the value that appears most often
What is the mode?
This chart type connects points in sequence and is the go-to for showing trends over time
What is a line chart?
This three-letter acronym is a measurable value showing how effectively a goal is being achieved
What is a KPI?
This set operator stacks the results of two queries and removes duplicate rows
What is UNION?
This Tableau object defines a custom subset of data, with each member either “in” or “out”
What is a set?
This is the difference between the largest and smallest values in a dataset
What is the range?
This chart shows how a starting value is increased and decreased by a series of steps to reach a final value
What is a waterfall chart?
This type of analysis answers “what happened?” using summaries and historical data
What is descriptive analytics?
This kind of join has no ON condition and returns every combination of rows from both tables
What is a CROSS JOIN?
This dashboard feature lets a click on a mark in one sheet filter the other sheets
What is a filter action?
This theorem says the distribution of sample means approaches a normal distribution as sample size grows
What is the Central Limit Theorem?
Edward Tufte coined this term for decorative elements that add clutter without conveying data
What is chart junk?
This term describes estimating and filling in missing values in a dataset
What is imputation?
Introduced by the OVER keyword, this kind of function calculates across related rows without collapsing them into one output row
What is a window function?
Unlike a live connection, this type of data connection stores a compressed snapshot of the data for faster performance
What is an extract?
Often stated at 95%, this is a range of values likely to contain the true population parameter
What is a confidence interval?
This chart uses horizontal bars to lay out tasks or phases across a timeline
What is a Gantt chart?
This term describes the traceable path of data from its origin through every transformation to the final report
What is data lineage?
Prefixing a query with this command shows the database’s execution plan, revealing scans, joins, and cost
What is a EXPLAIN PLAN?
Running totals and moving averages are examples of this calculation type, computed on the results already in the view
What is a table calculation?
This error occurs when a test fails to reject a false null hypothesis, sometimes called a “false negative”
What is a Type II error?
Built around the 80/20 idea, this chart pairs descending bars with a cumulative-percentage line
What is a Pareto plot?
In this paradox, a trend appears in several groups of data but reverses when the groups are combined
What is Simpson’s paradox?