SQL and You
This clause is used to filter grouped results after a GROUP BY, unlike WHERE which filters before grouping
What is HAVING?
This type of Tableau calculation, abbreviated LOD, lets you compute aggregations at a different granularity than the view: FIXED, INCLUDE, and EXCLUDE are the three flavors
What is a Level of Detail (LOD) expression?
This measure of central tendency is the middle value in an ordered dataset
What is the median?
This chart type uses bars to compare quantities across categories
What is a bar chart?
This term describes the percentage of customers who stop using a product or service over a given period
What is (customer) churn?
This SQL clause lets you assign a temporary alternative name to a table or column, often used to shorten long table references in a query
What is AS (an alias)?
This Tableau feature lets you combine data from two different sources sharing a common dimension, without a formal join
What is data blending?
This statistical concept describes the spread or dispersion of data points around the mean, often expressed as a square root of variance
What is standard deviation?
This type of chart displays parts of a whole as slices, though it's often criticized by data viz purists for being harder to read accurately than a bar chart
What is a pie chart?
This three-letter acronym describes the process of moving data from a source system into a target system, transforming it along the way
What is ETL?
This kind of join returns all rows from the left table and matched rows from the right, filling unmatched right-side columns with NULL
What is a LEFT JOIN?
This Tableau feature lets you click a mark to jump from a summary view into more granular underlying detail
What is drilling down (or a drill-down action)?
This type of chart shows the distribution of a dataset using quartiles, a median line, and whiskers
What is a box plot (or box-and-whisker plot)?
This type of visualization uses color intensity within a grid to represent values, popular for showing usage or activity patterns
What is a heatmap?
This term describes the process of identifying and correcting inaccurate, incomplete, or duplicate records in a dataset before analysis
What is data cleaning (or data cleansing)?
This SQL clause limits the number of rows returned by a query, often paired with an ORDER BY to grab the top N results
What is LIMIT (or FETCH FIRST / ROWNUM in Oracle)?
This Tableau feature lets you save a specific combination of filter and view settings so others can return to that exact configuration later
What is a saved view?
This term describes a metric that appears to decline or improve simply due to statistical noise reverting toward the average, rather than a real change
What is regression to the mean?
This framework, used to define product engagement metrics, stands for Happiness, Engagement, Adoption, Retention, and Task success
What is HEART?
This term describes the practice of testing two versions of something against each other to determine which performs better based on a measurable outcome
What is A/B testing?
This type of SQL construct, often abbreviated CTE, lets you define a temporary named result set referenced within a larger query (and can get expensive if not trimmed!)
What is a Common Table Expression?
This Tableau feature lets you display multiple views of the same data side by side by duplicating a field across rows or columns, useful for comparing across categories at a glance
What is a trellis chart?
This type of error occurs when a test incorrectly rejects a true null hypothesis, sometimes called a "false positive"
What is a Type I error?
This chart type plots two numeric variables against each other to reveal correlation or clustering patterns
What is a scatter plot?
This term describes grouping customers or users by a shared starting point in time, such as signup month, to track their behavior over subsequent periods
What is a cohort analysis?