Data Science Glossary
Key terms from the Data Science course, linked to the lesson that introduces each one.
619 terms.
A
- above the upper fence
- Any value below the lower fence or above the upper fence is an outlier.
- Lesson 72 — IQR Method and Tukey's Fences
- accessible population
- Your accessible population is the group you can realistically reach and sample from.
- Lesson 233 — Populations in Practice
- ACF
- ACF is like saying "I look like my grandmother" — this might be true, but partly because you look like your mother, who looks like her mother
- Lesson 728 — PACF vs ACF: Key Differences
- Acquisition channels
- Acquisition channels are the various pathways through which potential users discover and arrive at your product, website, or service.
- Lesson 1711 — What Are Acquisition Channels?
- Actions
- Actions are operations that trigger actual computation and return results or write output.
- Lesson 1780 — Transformations vs Actions in Spark
- Acyclic
- Acyclic means no variable can cause itself through any path (no loops)
- Lesson 1468 — Introduction to Directed Acyclic Graphs (DAGs)
- Additive changes
- Additive changes are safest: adding new columns doesn't break existing queries that don't reference them.
- Lesson 1876 — Schema Evolution and Backwards Compatibility
- Additive seasonality
- Additive seasonality means seasonal fluctuations stay roughly constant in size regardless of the data's level.
- Lesson 766 — Additive vs Multiplicative Seasonality
- Adjustment
- Adjustment means including confounders directly in a regression model as additional predictors.
- Lesson 1431 — Controlling for Confounders: Adjustment
- Aggregated summaries
- Storing total_order_value on a customer record instead of calculating it from order lines each time.
- Lesson 1074 — Duplicating Data Across Tables
- Algorithm initialization
- Neural networks, k-means clustering, random forests all start with random states
- Lesson 2055 — Why Randomness Matters in Data Science
- ALL
- Returns TRUE only if the comparison is true for every value returned by the subquery
- Lesson 963 — ANY and ALL Operators
- Alt text
- Alt text (alternative text) is a brief written description of a visualization that screen readers can announce.
- Lesson 1250 — Text Alternatives and Screen Reader Compatibility
- Alternative
- The interaction coefficient differs from zero (it matters)
- Lesson 654 — Testing Interaction Significance
- Always positive
- Log-normal variables are strictly greater than zero
- Lesson 178 — Log-Normal Distribution: Definition and Properties
- Analogy
- Think of wide format like a spreadsheet optimized for human reading—everything visible at once. Long format is optimized for computers—each piece of information has its own clearly labeled row.
- Lesson 1068 — Higher Normal Forms: 4NF and 5NFLesson 1144 — Common Violations: Wide vs Long Format
- Anderson-Darling test
- The Anderson-Darling test is another statistical test that checks whether your data follows a normal distribution, but with a special feature: it gives more weight to the tails (the extreme values at both ends) than the K-S test does.
- Lesson 207 — Anderson-Darling Test
- ANY
- Returns TRUE if the comparison is true for at least one value returned by the subquery
- Lesson 963 — ANY and ALL Operators
- Any shape
- The original population can be uniform, exponential, Poisson, or anything else.
- Lesson 218 — What the Central Limit Theorem States
- any z-score beyond ±3
- The standard rule of thumb: any z-score beyond ±3 is typically considered an outlier.
- Lesson 71 — Z-Score Method for Outlier Detection
- area chart
- An area chart is essentially a line chart with the space between the line and the x-axis filled with color.
- Lesson 1227 — Area Charts and Stacked Area Charts
- ARR
- ARR is MRR × 12, representing the annualized value of subscriptions.
- Lesson 1628 — SaaS Metrics: MRR, ARR, and Logo Churn
- Artists
- Everything visible on the plot—lines, text, patches, images—are "Artist" objects. This includes titles, legends, grid lines, and your actual data representations.
- Lesson 1255 — The Anatomy of a Matplotlib Figure
- Assumption Validation
- Assumption Validation means checking whether your model's prerequisites are met.
- Lesson 2089 — Stage 5: Model Development and Validation
- At-Risk Customers
- Previously active users showing warning signs—declining usage, skipped payments, reduced session frequency, or negative support interactions. Your leading indicators of churn are firing.
- Lesson 1704 — Customer Lifecycle Stages
- Auditability
- In regulated industries, explaining "we followed rule X" is far easier than defending a black-box model's decision.
- Lesson 1986 — Automated Report GenerationLesson 2123 — Simple Rules Beat Complex Models
- Autocommit mode
- Each SQL statement is automatically committed (saved) immediately after it runs. It's like hitting "Save" after every single keystroke in a document.
- Lesson 1111 — Autocommit Mode vs Explicit Transactions
- Autocorrelation
- successive residuals are similar (clustered positive, then negative)
- Lesson 562 — Index Plots and Time-Ordered Residuals
- Automating documentation
- Automating documentation means writing scripts that inspect your data and generate complete documentation automatically.
- Lesson 2067 — Automating Documentation with Code
- Average Purchase Value
- Average Purchase Value is the mean revenue per transaction.
- Lesson 1663 — Simple LTV: Average Revenue Per Customer
- Axes
- The region where data is plotted. Each Axes contains two (or three, for 3D) Axis objects—the x-axis and y-axis with their tick marks, labels, and scales. Despite the confusing naming, one Axes has multiple Axis objects.
- Lesson 1255 — The Anatomy of a Matplotlib FigureLesson 1274 — Creating Multiple Subplots with plt.subplots()
- Axis
- The number lines (x, y, or z) that provide the scale and ticks. These handle the actual numeric or categorical scales.
- Lesson 1255 — The Anatomy of a Matplotlib Figure
- Azimuth
- The horizontal rotation angle around your plot. Imagine walking in a circle around a statue—azimuth controls which side you're viewing from.
- Lesson 1326 — Viewing Angles and Projection Types
B
- Balance
- Balance means mixing high-volume/low-margin channels with low-volume/high-ROI ones
- Lesson 1716 — Channel Mix and Portfolio Thinking
- balanced design
- In two-way ANOVA, a balanced design means you have equal sample sizes in every combination of your two factors.
- Lesson 468 — Balanced vs Unbalanced Designs
- bandwidth
- The bandwidth is the width of the window on each side of the cutoff that you include in your analysis.
- Lesson 1463 — RDD Bandwidth Selection and Local Estimation
- Bartlett's Test
- Bartlett's Test is more powerful when your data is truly normal, but it's very sensitive to non-normality—it might reject equal variances simply because your data isn't perfectly bell-shaped, not because variances actually differ.
- Lesson 380 — Testing Equal Variances: Levene's and Bartlett's Tests
- Bayesian inference
- Bayesian inference is the extension of this idea into a full statistical methodology.
- Lesson 116 — From Bayes' Theorem to Bayesian Inference
- Bernoulli trial
- A Bernoulli trial is a single experiment or observation that can result in exactly two outcomes: we call one outcome "success" and the other "failure." These labels don't imply anything is good or bad—they're just convenient names for the two possibilities.
- Lesson 123 — Bernoulli Trial Definition and PropertiesLesson 126 — From Bernoulli to Binomial: Multiple Trials
- Bessel's correction
- Dividing by N-1 instead of N is called Bessel's correction.
- Lesson 50 — Population vs Sample Variance
- Beta distribution
- For conversion rates (proportions), the Beta distribution is the natural choice because it:
- Lesson 1581 — Setting Priors for A/B Tests
- beta weights
- Standardized coefficients (also called beta weights or β weights) put all predictors on the same scale by expressing them in standard deviation units.
- Lesson 608 — Standardized Coefficients (Beta Weights)
- Bonferroni Correction
- The Bonferroni Correction is a conservative, straightforward method to control this risk.
- Lesson 458 — Bonferroni Correction
- Breadth
- Breadth means splitting into many parallel branches at fewer levels.
- Lesson 1623 — Depth vs Breadth in Metric Trees
- Break-even ROAS
- Break-even ROAS is the threshold where ad spend equals the profit you generate.
- Lesson 1752 — Target ROAS and Break-Even Analysis
- Building confidence intervals
- SE is the foundation (future topic!)
- Lesson 265 — Using Standard Error in Practice
- Burn-in
- Burn-in refers to discarding the first portion of your MCMC samples—typically the first 10-50% of iterations.
- Lesson 1592 — Burn-in, Thinning, and Convergence Diagnostics
- business metric
- A business metric is a quantifiable measure that tracks the performance or health of a business.
- Lesson 1516 — Business Metrics: Definition and Examples
- Business metrics
- A handful of products generate most revenue
- Lesson 191 — Pareto Principle and the 80/20 Rule
C
- Caching
- Caching means storing the results of expensive computations so you can reuse them instead of recalculating.
- Lesson 1337 — Dashboard Performance and Caching
- Calculated fields
- Storing computed values (like order_total) instead of recalculating from line items every time.
- Lesson 1071 — When to Denormalize: Performance Trade-offs
- Calculating the posterior distribution
- Calculating the posterior distribution means applying Bayes' theorem to compute exactly how probable each parameter value is, given both your starting assumptions and the observed data.
- Lesson 1545 — Calculating the Posterior Distribution
- Call Centers
- A help desk receives 30 calls per day on average. Poisson models how many calls might arrive tomorrow—useful for staffing decisions.
- Lesson 144 — Poisson Applications: Arrivals and Events
- Cardinality
- Cardinality is the count of unique values in a column.
- Lesson 1083 — Index Selectivity and Cardinality
- Categorical predictors
- Categorical predictors are encoded using dummy variables (one fewer than the number of categories).
- Lesson 829 — Continuous and Categorical Predictors
- Causation
- Causation means one variable directly causes changes in another.
- Lesson 1420 — Defining Correlation and Causation
- CC-BY
- Requires attribution when data is used
- Lesson 2082 — Choosing a License for Data Science Projects
- census
- A census means collecting data from every single member of a population.
- Lesson 230 — Why We Sample Instead of Census
- Centered moving averages
- Centered moving averages are better for analysis and understanding patterns because they smooth the data symmetrically, giving you the clearest view of the underlying trend.
- Lesson 753 — Centered vs Trailing Moving Averages
- Centering
- Centering means subtracting the mean from your predictor before creating polynomial terms.
- Lesson 661 — Centering Predictors for Polynomials
- Central tendency
- Central tendency is the statistical concept of finding a single representative value that describes the "center" or "typical" value of a dataset.
- Lesson 38 — What is Central Tendency?
- ceteris paribus
- This "all else equal" condition is called ceteris paribus (Latin for "other things being equal").
- Lesson 604 — Marginal Effects and Ceteris Paribus
- Changing spread
- The fluctuations get wider or narrower over time (violates constant variance)
- Lesson 715 — Visual Tests for Stationarity
- Channel concentration
- percentage of volume from top channel (lower is safer)
- Lesson 1716 — Channel Mix and Portfolio Thinking
- Chartjunk
- Chartjunk refers to anything in a visualization that doesn't represent data or support comprehension:
- Lesson 1246 — Visual Clutter and Chartjunk
- Cherry-picking time ranges
- Cherry-picking time ranges means deliberately selecting start and end dates that support a preferred narrative while hiding inconvenient context.
- Lesson 1241 — Cherry-Picking Time Ranges
- chi-squared distribution
- The chi-squared distribution is another special case.
- Lesson 182 — Special Cases: Exponential and Chi-Squared
- Choosing α before analysis
- Choosing α before analysis means deciding your threshold for rejecting the null hypothesis—typically 0.05, 0.01, or 0.10—before you collect or analyze your data.
- Lesson 329 — Choosing α Before Analysis
- Churn
- Churn is when customers stop doing business with you.
- Lesson 1670 — What is Churn and Why It Matters
- City sizes
- A few megacities contain most urban population
- Lesson 191 — Pareto Principle and the 80/20 Rule
- closing
- Position-Based Attribution works well when you believe both awareness and closing are crucial moments, but you have complex, multi-step journeys where middle touchpoints play a supporting role.
- Lesson 1729 — Position-Based (U-Shaped) Attribution
- Clustered Data
- Students within the same classroom, patients from the same hospital, or measurements from the same family are often more similar to each other than to observations from different clusters. These "nested" observations violate independence.
- Lesson 381 — Independence Assumption and Its Violations
- Code management
- Code management means tracking changes to your scripts and notebooks, usually with tools like version control systems.
- Lesson 29 — Code and Environment Management
- Code review happens
- Team members examine your changes, spot bugs, suggest improvements, and ensure standards are met
- Lesson 2022 — Understanding Pull Requests
- Coefficient of Variation
- Coefficient of Variation is your tool when comparing datasets with different units or scales (e.g., comparing variability in temperature vs. income).
- Lesson 54 — When to Use Each Measure
- Coffee consumption and lung cancer
- Smoking is the lurking variable (smokers drink more coffee and get lung cancer)
- Lesson 1423 — The Third Variable Problem
- Cohen's d
- for t-tests (difference between means in standard deviation units)
- Lesson 384 — What is Effect Size?
- coherence
- Whether you process observations one-by-one or in chunks, the final posterior is identical—a property called coherence.
- Lesson 1563 — Sequential Updating with New Data
- Cohort analysis
- Cohort analysis is a technique that divides users or customers into groups—called cohorts—based on a shared characteristic or experience within a defined time window.
- Lesson 1644 — What is Cohort Analysis?
- cohort start event
- A cohort start event is the specific action or timestamp that defines when a user officially enters your cohort.
- Lesson 1646 — Defining Cohort Start Events
- Collectively exhaustive events
- Collectively exhaustive events are a group of events whose union contains every possible outcome in the sample space—nothing is left out.
- Lesson 82 — Collectively Exhaustive Events
- collider
- You already know from your DAG studies that a collider is a variable caused by two or more other variables (arrows point into it).
- Lesson 1432 — Colliders and Bad ControlsLesson 1471 — Mediators and CollidersLesson 1473 — Conditioning on Colliders: Selection Bias
- collider bias
- This is called collider bias or selection bias.
- Lesson 1432 — Colliders and Bad Controls
- cols
- The variable that splits plots into columns (horizontal organization)
- Lesson 1358 — facet_grid() for Two Variables
- column
- The value you want to retrieve from a future row
- Lesson 1025 — LEAD Function: Accessing Next Row ValuesLesson 1358 — facet_grid() for Two Variables
- Company Level
- Your North Star Metric becomes the top-level objective. For example, if your North Star is "Weekly Active Users," the company objective might be "Grow meaningful user engagement."
- Lesson 1608 — Connecting North Star Metrics to OKRs
- Complete rows
- If entire rows are missing, perhaps certain groups weren't measured
- Lesson 1179 — Identifying Missing Values Patterns
- Completeness checks
- Completeness checks are your detective work for finding exactly where data is missing, how much is missing, and whether the missingness follows patterns.
- Lesson 1153 — Completeness Checks
- Complexity penalty
- A term that increases with the number of parameters (k)
- Lesson 629 — Akaike Information Criterion (AIC)
- Confidence bands
- Usually shown as blue shaded regions or dashed lines (typically at ±2/√n). Bars extending beyond these bands are statistically significant
- Lesson 722 — ACF Plots and Interpretation
- Confidence intervals
- the range of plausible differences between means
- Lesson 462 — Interpreting and Reporting Post-Hoc Results
- confounder
- In a Directed Acyclic Graph (DAG), a confounder is a variable that points arrows to both your treatment and your outcome.
- Lesson 1470 — Confounders in DAGs
- confounding variable
- A confounding variable (or confounder) is a third variable that affects both your treatment (independent variable) and your outcome (dependent variable), creating a spurious or false association between them.
- Lesson 509 — Confounding Variables and ControlLesson 1423 — The Third Variable ProblemLesson 1427 — What is a Confounding Variable?
- Confusion
- New team members (or your future self) waste time trying to understand if old experiments are still relevant
- Lesson 2135 — Dead Experimental Code and Feature Sprawl
- conjugate prior
- A conjugate prior is a prior distribution that, when combined with a specific likelihood function, produces a posterior distribution from the same probability family as the prior.
- Lesson 1550 — What Are Conjugate Priors?
- Connection pooling
- Connection pooling is like a parking lot for database connections.
- Lesson 1092 — Connection Pooling Basics
- Content Library Depth
- Number of titles and hours of available content. This is a leading indicator of platform attractiveness, but raw counts are vanity metrics—you need utilization rates (% of library watched in 30 days) to know if you're investing wisely.
- Lesson 1635 — Media and Content Metrics: Watch Time and Content Performance
- Context expertise
- Owner knows when the metric is actionable vs. a vanity metric
- Lesson 1619 — What is Metric Ownership?
- Continuity
- The eye naturally follows smooth, continuous paths. Line charts work because we perceive connected points as a single trend. Align multiple plots vertically or horizontally so the eye flows naturally from one to the next.
- Lesson 1236 — Gestalt Principles in Visualization
- Continuous data
- mapping numeric ranges to positions or gradients
- Lesson 1344 — Scales and Coordinate Systems
- Continuous numerical data
- Continuous numerical data represents measurements that can take any value within a range, including decimals.
- Lesson 18 — Numerical Variables: Discrete and Continuous
- Continuous unbounded data
- The identity link (standard linear regression) is appropriate.
- Lesson 678 — Choosing the Right Link Function
- Contracting funnel
- The opposite—wide on the left, narrow on the right.
- Lesson 559 — Detecting Heteroscedasticity (Non-Constant Variance)
- control chart
- A control chart is a time-series plot with added reference lines that help you distinguish normal variation from abnormal shifts in your data.
- Lesson 1396 — Introduction to Control Charts
- control group
- A control group is a segment that doesn't receive your intervention, while a treatment group does.
- Lesson 1641 — Isolating Effects with Control Groups
- Control Limits
- Control Limits are the "voice of the process." They tell you what your process is naturally capable of doing right now, based on its inherent variation.
- Lesson 1400 — Control Limits vs Specification Limits
- conversion
- A conversion is any desired action a user completes that moves them closer to delivering value to your business.
- Lesson 1686 — Defining Conversions and Conversion Rate
- Cookie banners
- Cookie banners are designed to extract "consent" through friction and confusion.
- Lesson 1914 — Consent in Digital Contexts
- Cookiecutter
- Cookiecutter is a command-line tool that creates projects from templates.
- Lesson 2076 — Code Organization Templates and Cookiecutter
- Coordinated disclosure
- If external disclosure is needed, work with security/ethics experts to time and frame it appropriately
- Lesson 1925 — Mitigation Strategies and Responsible Disclosure
- Core
- Think of it like a building with two floors: the Core is the foundation level, and the ORM (Object-Relational Mapper) is built on top of it.
- Lesson 1118 — SQLAlchemy Core vs ORM
- Correlation
- Correlation means two variables move together in a statistically observable pattern.
- Lesson 1420 — Defining Correlation and Causation
- Correlation matrices
- Quickly spot which variable pairs are strongly related
- Lesson 1224 — Heatmaps and Correlation Matrices
- correlation matrix
- A correlation matrix is a table showing correlation values between all pairs of numeric variables—think of it as a "relationship scorecard" for your dataset.
- Lesson 1192 — Correlation Matrices and Heatmaps
- correlogram
- An ACF plot (also called a correlogram) is a visual tool that displays autocorrelation values at different lags.
- Lesson 722 — ACF Plots and Interpretation
- Covariate balance
- Covariate balance means the distribution of baseline characteristics—age, prior purchase behavior, device type, etc.—is similar across your experimental groups.
- Lesson 1491 — Covariate Balance and Diagnostics
- covering index
- A covering index is an index that contains all the columns your query needs—both those used in the WHERE clause and those in the SELECT list.
- Lesson 1082 — Covering Indexes and Index-Only Scans
- Cramér's V
- Cramér's V is the standard effect size measure for chi-squared tests of independence.
- Lesson 429 — Effect Size: Cramér's V and Phi
- credible interval
- A credible interval is a Bayesian probability statement that tells you: "Given the data I've observed, there's a certain probability (like 95%) that the true parameter value lies within this range."
- Lesson 1562 — Credible Intervals for ProportionsLesson 1573 — What is a Credible Interval?
- critical value
- A critical value is the specific number on the sampling distribution that separates the rejection region from the non-rejection region.
- Lesson 268 — Critical Values and the t-DistributionLesson 326 — Critical Values
- CSV
- CSV is human-readable and universal but slow to parse and memory-intensive.
- Lesson 1133 — Performance Considerations Across Formats
- CTEs
- CTEs are named and defined upfront (we'll cover these in detail soon):
- Lesson 974 — When to Use FROM Subqueries vs CTEs
- Customer service calls arriving
- If no one has called in the last 5 minutes, that doesn't make a call in the next minute more or less likely
- Lesson 167 — Memoryless Property of Exponential
- Cut technical debt
- Features with low adoption and low frequency are candidates for removal
- Lesson 1696 — Feature Adoption and Usage Frequency
- cyclical patterns
- While seasonality repeats at fixed, predictable intervals (every 12 months, every 7 days), cyclical patterns are fluctuations that rise and fall over longer, irregular periods.
- Lesson 708 — Cyclical Patterns: Non-Fixed Fluctuations
D
- Dark patterns
- Dark patterns are interface designs that deliberately trick users into giving up data or privacy rights.
- Lesson 1914 — Consent in Digital Contexts
- dashboard
- A dashboard is an interactive, real-time (or near-real-time) monitoring tool that updates automatically as underlying data changes.
- Lesson 1974 — Defining Dashboards and Reports
- Data lineage
- Data lineage is the documented history of data from its original source through every transformation, merge, filter, and calculation until it reaches its final form in a report, model, or dashboard.
- Lesson 1159 — What is Data Lineage?Lesson 1875 — Data Lineage and Provenance
- Data locality
- Data locality means running your computation where the data already lives.
- Lesson 1772 — Data Locality and Network Bottlenecks
- Data parallelism
- Data parallelism is like having five chefs all chopping vegetables using the same technique.
- Lesson 1769 — Task Parallelism and Work Distribution
- data pipeline
- A data pipeline is an automated workflow that reliably moves data from one or more sources (databases, APIs, files) through a series of processing steps, and delivers it to a destination (data warehouse, dashboard, ML model).
- Lesson 1822 — What is a Data Pipeline?
- Data provenance
- Data provenance is the documented history of your data: where it came from, who collected it, when it was gathered, and every transformation it underwent.
- Lesson 23 — Data Provenance and MetadataLesson 1875 — Data Lineage and Provenance
- Data rows
- Each subsequent line represents one record
- Lesson 1125 — CSV Files: Structure and Common Issues
- Data surprises
- Real-world data is messy. Distributions aren't what documentation claimed. Key variables have unexpected missing patterns. You iterate back to acquisition or feature engineering.
- Lesson 2109 — Why Data Science is Inherently Iterative
- Data versioning issues
- The dataset changes, but nobody tracks which version was used (Data Provenance)
- Lesson 30 — The Reproducibility Crisis and Solutions
- database
- A database is an organized collection of structured data stored electronically in a computer system.
- Lesson 842 — What is a Database?
- Dataset
- A collection of typed objects (numbers, strings, custom objects). Unlike a database table with fixed columns, RDDs can hold any serializable data structure.
- Lesson 1777 — RDDs: Resilient Distributed Datasets Fundamentals
- dead experimental code
- In data science, dead experimental code refers to scripts, notebooks, models, or feature engineering logic that was created during exploration but is no longer used or relevant.
- Lesson 2135 — Dead Experimental Code and Feature Sprawl
- Dead Letter Queue
- A Dead Letter Queue is a separate storage location where permanently failed tasks or messages are routed after exhausting all retry attempts.
- Lesson 1852 — Dead Letter Queues
- Deciles
- Deciles are popular in education (top 10% of students) and income distribution studies.
- Lesson 57 — Quantiles: Quartiles, Deciles, and Beyond
- Defense in depth
- Defense in depth means building multiple independent security layers so that if one fails, others still protect you.
- Lesson 1109 — Input Validation and Defense in Depth
- Definition drift
- Changing what "active" means breaks trend comparisons
- Lesson 1694 — Daily Active Users (DAU) and Monthly Active Users (MAU)
- Delimiter
- The character separating values (usually a comma, but sometimes tabs, semicolons, or pipes)
- Lesson 1125 — CSV Files: Structure and Common Issues
- Dependency isolation
- Dependency isolation is critical in data science because:
- Lesson 2039 — Virtual Environments: Concept and Benefits
- derived table
- A derived table is a subquery placed in the FROM clause that creates a temporary, on-the-fly table you can query just like any physical table.
- Lesson 970 — Subqueries in the FROM Clause (Derived Tables)
- determinant
- A determinant is any attribute (or set of attributes) that functionally determines another attribute.
- Lesson 1067 — Boyce-Codd Normal Form (BCNF)
- Deterministic with ORDER BY
- The same query produces the same numbering
- Lesson 1007 — ROW_NUMBER(): Assigning Unique Row Numbers
- Deviance
- Deviance is the generalization of RSS for all GLMs.
- Lesson 697 — Deviance: A Measure of Model Fit
- Diagonal patterns
- Gradual retention decline is normal; sudden cliff-drops warrant investigation
- Lesson 1649 — Visualizing Cohort Data with Heatmaps
- Direct identifier removal
- Direct identifier removal means stripping obvious PII like names, social security numbers, email addresses, and phone numbers.
- Lesson 1895 — Data Anonymization Basics
- Directed Acyclic Graph
- A Directed Acyclic Graph is a mathematical structure where nodes (tasks) are connected by directed edges (dependencies) with one ironclad rule: no cycles allowed.
- Lesson 1842 — Directed Acyclic Graphs (DAGs)
- direction
- The direction is clear even if the exact magnitude isn't
- Lesson 2122 — When Uncertainty Is Acceptable
- Discrete numerical data
- Discrete numerical data consists of whole numbers that represent counts of distinct items.
- Lesson 18 — Numerical Variables: Discrete and Continuous
- disjoint events
- In probability, mutually exclusive events (also called disjoint events) are events that cannot occur simultaneously.
- Lesson 81 — Mutually Exclusive Events
- Distributed
- Your data is partitioned across multiple machines. Instead of one computer holding 1TB of data, you might have 100 machines each holding 10GB. Operations run in parallel across all partitions.
- Lesson 1777 — RDDs: Resilient Distributed Datasets Fundamentals
- Document active experiments
- Maintain a simple tracking file listing which experiments are ongoing, which succeeded, and which are archived.
- Lesson 2135 — Dead Experimental Code and Feature Sprawl
- Domain context
- Domain context is the background knowledge about the field you're analyzing: its terminology, business processes, constraints, typical patterns, and unwritten rules.
- Lesson 1168 — Understanding Domain Context
- Domain knowledge
- Domain knowledge means understanding the real-world context behind your data—the business processes, industry norms, causal mechanisms, and human behaviors that generate the numbers you're analyzing.
- Lesson 1201 — Domain Knowledge as a Hypothesis Source
- Double funnel
- Variance is small in the middle but large at both extremes
- Lesson 559 — Detecting Heteroscedasticity (Non-Constant Variance)
- Downstream dependencies
- Downstream dependencies are the tasks that rely on your task's output.
- Lesson 1841 — Upstream and Downstream Dependencies
- Draft pull requests
- Draft pull requests are a special PR state that signals "this is work-in-progress—feedback welcome, but don't merge yet." They let you share code early without the pressure of a formal review.
- Lesson 2029 — Draft Pull Requests and WIP Workflows
- Driven by a lurking variable
- A third factor causes both (like the weather example)
- Lesson 494 — Spurious Correlations and Coincidence
- Dual use
- Dual use refers to technology, methods, or data that can be applied for both beneficial and harmful purposes.
- Lesson 1919 — Defining Dual Use in Data Science
E
- Economic business cycles
- Economic business cycles are the classic example.
- Lesson 708 — Cyclical Patterns: Non-Fixed Fluctuations
- Effect size
- Bigger lifts are easier to detect reliably
- Lesson 1692 — Statistical Significance and Iteration
- Emotional connection
- Emotional connection means helping your audience feel the human stakes behind the numbers.
- Lesson 1941 — Emotional Connection Without Manipulation
- Empirical Rule
- The Empirical Rule is your quick mental map for normal distributions.
- Lesson 171 — The 68-95-99.7 Rule (Empirical Rule)
- Employee-manager relationships
- An employees table where each employee has a manager_id pointing to another employee in the same table
- Lesson 945 — Introduction to Self-Joins
- Enclosure
- Elements surrounded by a boundary are perceived as a group. Draw a subtle box around related charts in a dashboard, or use background shading to separate different sections of your visualization.
- Lesson 1236 — Gestalt Principles in Visualization
- encoding
- We must translate these labels into a numerical format the model can use—this process is called encoding.
- Lesson 634 — Categorical Variables in Regression
- engine
- The engine is the starting point for any SQLAlchemy application.
- Lesson 1119 — Setting Up SQLAlchemy and Creating an Engine
- Environment management
- Environment management means recording exactly which software versions you used.
- Lesson 29 — Code and Environment Management
- environment specification files
- In data science, environment specification files are your recipes—they list every package and version your project needs so anyone (or any machine) can recreate your working environment perfectly.
- Lesson 2044 — Recreating Environments from Specifications
- estimate
- The estimate is your calculated coefficient (β̂)
- Lesson 607 — Confidence Intervals for Coefficients
- Eta-squared
- Eta-squared is the most straightforward effect size for ANOVA.
- Lesson 445 — Effect Size: Eta-Squared and Omega-Squared
- event
- The event is the specific outcome you're monitoring—it must be binary (yes/no) and well-defined.
- Lesson 78 — Events as Subsets of the Sample SpaceLesson 803 — Defining the Event and Time Origin
- Exact duplicate detection
- Find rows where all columns match exactly—these are often accidental copies from data loading errors.
- Lesson 1154 — Uniqueness and Duplication Checks
- Exogeneity
- Exogeneity means that your predictor variable X is determined outside the model and is completely independent of the error term ε.
- Lesson 553 — Exogeneity: X Must Be Independent of Errors
- Expanding funnel
- Residuals start tight on the left and fan out wider on the right. This means the model's prediction errors grow larger as fitted values increase.
- Lesson 559 — Detecting Heteroscedasticity (Non-Constant Variance)
- Expected
- The count you would expect if the null hypothesis were true (which you calculated in the previous lesson)
- Lesson 417 — The Chi-Squared Test Statistic Formula
- Expected loss threshold
- Stop when the expected loss of choosing variant B is below $X
- Lesson 1585 — Early Stopping in Bayesian Tests
- Expected uniqueness violated
- An ID column contains repeats
- Lesson 1154 — Uniqueness and Duplication Checks
- expected value
- The expected value is the long-run average of that statistic across all possible samples.
- Lesson 255 — Expected Value of Sample Statistics
- Explanatory visualization
- Explanatory visualization is your public communication tool.
- Lesson 1213 — Exploratory vs Explanatory Visualization
- Explicit transactions
- You manually control when a group of statements is committed or rolled back. It's like drafting a document and only hitting "Save" when you're ready.
- Lesson 1111 — Autocommit Mode vs Explicit Transactions
- Exploitation
- playing the machine you currently believe is best
- Lesson 1586 — Multi-Armed Bandit Connections
- Exploratory Analysis
- IQR and box plots are faster for initial screening
- Lesson 13 — Exploratory Analysis and ModelingLesson 1395 — When to Use Grubbs' Test
- Exploratory visualization
- Exploratory visualization is your private investigation tool.
- Lesson 1213 — Exploratory vs Explanatory Visualization
- exponential family
- The exponential family is a special class of probability distributions that can all be written in the same mathematical form.
- Lesson 664 — What is the Exponential Family of Distributions?
- External conditions
- A task queries an API to see which regions have new data, then dynamically creates one downstream task per region.
- Lesson 1844 — Dynamic Dependencies
- extrapolation
- Predicting beyond that range is called extrapolation, and it assumes the linear relationship continues indefinitely—which is rarely true.
- Lesson 526 — When the Intercept Has No Meaning
F
- F-ratio
- The F-ratio is simply the ratio of these two mean squares:
- Lesson 443 — Mean Squares and the F-Ratio
- Faceting
- Faceting means creating multiple small charts—one per category—arranged in a grid.
- Lesson 1193 — Conditional Distributions and Faceting
- false negative
- This is called a false negative or Type II error.
- Lesson 1495 — Power Analysis Fundamentals
- False precision
- The mathematical convenience might tempt you to use an inappropriate prior
- Lesson 1555 — Advantages and Limitations of Conjugate Priors
- Feather
- Feather is a lightweight columnar format optimized for speed.
- Lesson 1129 — Parquet and Feather: Columnar Formats
- Figure
- The Figure is the entire building—the blank canvas or container that holds everything.
- Lesson 1255 — The Anatomy of a Matplotlib Figure
- Finding duplicates
- Match rows where key fields are identical
- Lesson 947 — Self-Joins for Comparisons Within a Table
- five-number summary
- The five-number summary is a concise way to describe the spread and center of a dataset using exactly five values:
- Lesson 59 — The Five-Number Summary and Box Plots
- Focus indicators
- Focus indicators are critical: users must see where they are in the interface at all times.
- Lesson 1253 — Interactive Accessibility: Keyboard Navigation
- Focus on the slope
- The slope still tells you about the relationship within your data range
- Lesson 526 — When the Intercept Has No Meaning
- Font family
- The typeface itself (e.g., 'serif', 'sans-serif', 'monospace', or specific names like 'Arial')
- Lesson 1297 — Font Properties and Text Styling
- forecast horizon
- The forecast horizon is simply how far into the future you're predicting.
- Lesson 794 — Forecasting Concepts and Horizons
- foreign key
- A foreign key is a column (or set of columns) in one table that references the primary key of another table.
- Lesson 921 — Primary and Foreign Key RelationshipsLesson 1051 — Introduction to Foreign Keys
- foreign key constraint
- A foreign key constraint is a database rule that ensures values in one table's foreign key column must match an existing primary key value in the referenced table.
- Lesson 1052 — Foreign Key Constraints
- Format expectations
- You assume dates come in one format, numeric codes have certain meanings, or null values are handled consistently—until they're not.
- Lesson 2133 — Undocumented Data Dependencies
- Frequently accessed lookup values
- Product categories, customer names, or status labels that rarely change but are queried constantly.
- Lesson 1074 — Duplicating Data Across Tables
- full load
- A full load is deep-cleaning every room from top to bottom, regardless of whether it's dirty.
- Lesson 1828 — Incremental vs Full Load Strategies
- Funnel analysis
- Funnel analysis is a method that visualizes and measures how users move through a defined sequence of steps (a "funnel") toward completing a desired action—like making a purchase, signing up, or subscribing.
- Lesson 1678 — What is Funnel Analysis?
G
- Gamma distribution
- The Gamma distribution is a continuous probability distribution that describes positive real numbers (values greater than zero).
- Lesson 181 — Gamma Distribution: Shape and Rate ParametersLesson 1552 — Gamma-Poisson Conjugacy
- GeoJSON
- GeoJSON is a newer, web-friendly format built on JSON.
- Lesson 1311 — Working with Shapefiles and GeoJSON
- ggplot2's faceting
- ggplot2's faceting is deeply integrated into the Grammar of Graphics—you define your plot once, then split it by categorical variables using facet_wrap() or facet_grid().
- Lesson 1372 — Faceting: ggplot2 vs Seaborn and Matplotlib Subplots
- Git
- Git is a distributed version control system, meaning every collaborator has a complete copy of the project history on their machine.
- Lesson 1990 — What is Version Control and Why Git?
- Grammar of Graphics
- The Grammar of Graphics is a systematic approach to creating visualizations by combining independent building blocks, rather than selecting from a fixed menu of chart types.
- Lesson 1339 — What is the Grammar of Graphics?
- Great Expectations
- Great Expectations is the leading Python library for this purpose.
- Lesson 1158 — Automated Validation Frameworks
- guardrails
- Counter-metrics and guardrails are defensive metrics designed to catch these problems before they damage your business.
- Lesson 1624 — Counter-Metrics and Guardrails
H
- H₀
- The die is fair (each face has a 1/6 probability)
- Lesson 415 — Setting Up Hypotheses for Goodness of Fit
- H₁
- The die is not fair (at least one face has a probability ≠ 1/6)
- Lesson 415 — Setting Up Hypotheses for Goodness of FitLesson 1511 — Sequential Probability Ratio Test (SPRT)
- harmonic mean
- The harmonic mean is calculated by dividing the number of values by the sum of their reciprocals.
- Lesson 44 — Geometric and Harmonic Means
- Header row
- The first line often contains column names (name, age, city)
- Lesson 1125 — CSV Files: Structure and Common Issues
- Heavy-tailed distributions
- Extreme values are naturally more common than the normal model predicts
- Lesson 1379 — Assumptions and Limitations
- Heroku
- Heroku is a general-purpose cloud platform that works with both Streamlit and Dash.
- Lesson 1338 — Deployment and Sharing Dashboards
- Heteroscedasticity
- Heteroscedasticity is when this assumption breaks down—when residuals become more (or less) spread out as predictions change.
- Lesson 559 — Detecting Heteroscedasticity (Non-Constant Variance)
- hidden variable
- The hidden variable is warm weather, which causes both people to buy ice cream and to go swimming.
- Lesson 1421 — Why Correlation Does Not Imply Causation
- Higher λ
- Higher λ means events happen more frequently → shorter waiting times
- Lesson 164 — The Exponential Distribution
- holdout group
- A holdout group is a randomly selected set of users who are excluded from receiving a marketing treatment (like an ad, email, or promotion).
- Lesson 1745 — Holdout Groups and Test Design
- Holt-Winters Multiplicative Model
- The Holt-Winters Multiplicative Model is designed for time series where seasonal fluctuations change in size as the overall level of the series changes.
- Lesson 768 — Holt-Winters Multiplicative Model
- honest broker role
- Maintaining your honest broker role means preserving your integrity even when it's uncomfortable.
- Lesson 1931 — When to Push Back on Requests
- Hue
- Hue is what we typically call "color": red, green, blue, purple, etc.
- Lesson 1234 — Color: Hue, Saturation, and Luminance
- Hypothesis
- The specific change and expected directional effect
- Lesson 1485 — Documentation and Pre-Registration
I
- Idempotency
- Idempotency means that running a pipeline multiple times with the same input produces the exact same output every time.
- Lesson 1847 — What is Idempotency?
- Identify patterns
- A single representative value helps you spot trends over time or differences between categories
- Lesson 38 — What is Central Tendency?
- Identify Unused Indexes
- Query your database's system catalogs to find indexes that are never or rarely used. These are candidates for removal.
- Lesson 1086 — Index Maintenance and Monitoring
- Identity
- Coefficients are direct additive effects (simplest interpretation).
- Lesson 678 — Choosing the Right Link Function
- identity link
- The identity link is the simplest possible link function: it does absolutely nothing!
- Lesson 672 — The Identity Link
- Incorporates uncertainty naturally
- The width of your posterior reflects how confident you are
- Lesson 1570 — Comparing Two Means: Bayesian Approach
- increasing volatility
- Stock prices with increasing volatility are not stationary (variance changes)
- Lesson 712 — What is Stationarity?
- incremental load
- An incremental load is spot-cleaning only the rooms that were used since yesterday.
- Lesson 1828 — Incremental vs Full Load Strategies
- Incrementality
- Incrementality is the measurement of the true causal impact of a marketing action—the additional outcomes that happened because of your intervention, beyond what would have occurred naturally without it.
- Lesson 1743 — What is Incrementality?
- Independence
- Independence means making decisions based solely on data and sound methodology—not on what others want to hear.
- Lesson 35 — Conflicts of Interest and Independence
- Independence of observations
- Independence of observations means that the value or response from one subject (observation) does not influence or relate to the value from another subject.
- Lesson 448 — Independence of Observations
- index
- An index is a separate data structure that the database maintains to help find rows quickly without scanning the entire table.
- Lesson 1078 — What Are Indexes and Why They Matter
- Index-based selection
- Index-based selection is severely limited.
- Lesson 1796 — Limitations and Differences from Pandas
- Individual points beyond the whiskers
- Individual points beyond the whiskers are flagged as potential outliers
- Lesson 1176 — Box Plots for Spread and Outliers
- infinite population
- An infinite population is unbounded—like all possible coin flips, future customer arrivals, or measurements from a manufacturing process.
- Lesson 233 — Populations in Practice
- Influence
- Influence is the real impact: it measures how much the fitted model—the coefficients, predictions, or fitted line itself—would change if you removed that observation and re-fit the model.
- Lesson 571 — What Are Leverage and Influence?Lesson 574 — Influence: Impact on Fitted Model
- INNER JOIN
- An INNER JOIN is SQL's way of bringing together information from two separate tables based on a relationship between them.
- Lesson 918 — What is an INNER JOIN?
- INNER JOIN table2
- The table you're joining to (the "right" table)
- Lesson 919 — Basic INNER JOIN Syntax
- instance of that class
- An instance of that class represents a row in the table
- Lesson 1117 — What is an ORM and Why Use It?
- interaction term
- An interaction term represents a relationship where the effect of one predictor on your outcome variable depends on the level or value of another predictor.
- Lesson 648 — What are Interaction Terms?
- intercept
- In simple linear regression, the intercept is the predicted Y value when X equals zero.
- Lesson 526 — When the Intercept Has No Meaning
- interference
- This is called interference or interaction effects.
- Lesson 1531 — Interference from Concurrent Tests
- Interpretability
- The posterior parameters have clear meanings (e.g., Beta parameters as "successes + prior successes")
- Lesson 1555 — Advantages and Limitations of Conjugate Priors
- Interpretation
- If group means truly differ, MSB should be larger than MSW, making F > 1. If there's no real difference between groups, F should be close to 1 (both numerator and denominator estimate the same underlying variance).
- Lesson 443 — Mean Squares and the F-Ratio
- INTERVAL
- INTERVAL represents a duration or time span (e.g., 5 days, 3 hours 20 minutes).
- Lesson 1038 — Date and Time Data Types in SQL
- Interval censoring
- Interval censoring means you know the event occurred within a specific time window, but not the precise moment.
- Lesson 805 — Left and Interval Censoring
- Inverted S-shape
- Light tails. The distribution is more concentrated around the center than normal.
- Lesson 566 — Reading Q-Q Plots: Interpreting Points Along the Reference Line
- Irreversibility matters
- Decisions are costly to reverse
- Lesson 1522 — Balancing Speed and Accuracy in Metric Selection
- Isolates brand impact
- The PSA has no commercial intent, so any lift from your real ad is truly incremental
- Lesson 1747 — Ghost Ads and PSA Tests
- Iteration
- Iteration means deliberately refining your approach based on what you learned—testing a new feature, adjusting model complexity, or exploring a different angle after stakeholder feedback.
- Lesson 2112 — Iteration vs Rework: Learning from Each Cycle
K
- Keep conditions simple
- Complex nested CASE statements are hard to maintain and slower to execute. If you're nesting more than 2-3 levels deep, consider breaking logic into multiple CTEs or using lookup tables with JOINs instead.
- Lesson 1037 — CASE Best Practices and Performance
- Kernel Density Estimation
- Kernel Density Estimation is the mathematical technique behind these visualizations.
- Lesson 1312 — Heatmaps and Density Maps for Spatial Data
- Key characteristic
- Unlike the sampling distribution of the mean (which becomes normal thanks to the CLT), the sampling distribution of the variance follows a chi-squared distribution when the population is normal. The sample variance tends to be an unbiased estimator of the population variance when calculated with the n-1 divisor.
- Lesson 254 — Sampling Distribution of the Sample Variance
- key difference
- The key difference is simply what you're waiting for:
- Lesson 137 — Geometric vs Negative Binomial: Key Differences
- Key Results
- Key Results are 2-5 specific, measurable outcomes that define how you'll know you've succeeded.
- Lesson 1607 — Introduction to OKRs (Objectives and Key Results)
- Kruskal-Wallis test
- The non-parametric cousin of one-way ANOVA, comparing medians across groups using ranks
- Lesson 470 — When Parametric ANOVA Assumptions Fail
L
- Lagging indicators
- Lagging indicators are outcome-focused metrics that tell you what has already happened.
- Lesson 1597 — What Are Leading and Lagging Indicators?
- Language-agnostic
- The same DataFrame operations work in Python, Scala, R, and Java
- Lesson 1778 — DataFrames and Spark SQL Basics
- large F-statistic
- A large F-statistic means your model explains a lot relative to what's leftover — evidence against the null hypothesis.
- Lesson 618 — Global F-Test for Overall Model Significance
- Lazy loading
- Lazy loading means only computing what's currently visible, deferring expensive operations until absolutely necessary.
- Lesson 1337 — Dashboard Performance and Caching
- Leading indicators
- Leading indicators are predictive, forward-looking metrics that signal what is likely to happen in the future.
- Lesson 1597 — What Are Leading and Lagging Indicators?
- Leading indicators of disengagement
- Leading indicators of disengagement are behavioral signals that precede actual churn—like smoke before fire.
- Lesson 1700 — Leading Indicators of Disengagement
- Levene's Test
- Levene's Test is more robust to departures from normality.
- Lesson 380 — Testing Equal Variances: Levene's and Bartlett's Tests
- Leverage
- Leverage refers to an observation's position in the predictor space—specifically, how far its X-value is from the mean of all X-values.
- Lesson 571 — What Are Leverage and Influence?
- likelihood
- The likelihood is the product of all these individual probabilities across your dataset.
- Lesson 682 — Maximum Likelihood Estimation in Logistic Regression
- Linearity
- If the relationship truly is linear, residuals should scatter randomly around zero with no pattern. If you see a curve or U-shape, your relationship might not be linear.
- Lesson 557 — The Residuals vs Fitted Values Plot
- Ljung-Box test
- Tests if residuals are independent (p-value > 0.05 confirms no autocorrelation remains)
- Lesson 783 — Ljung-Box Test for Residual IndependenceLesson 799 — Fitting and Diagnosing SARIMA Models
- Load balancing
- assigning work so no worker sits idle while others are overloaded
- Lesson 1769 — Task Parallelism and Work Distribution
- loess
- Unlike classical decomposition methods that assume fixed, unchanging seasonal patterns, STL uses a technique called loess (locally estimated scatterplot smoothing) to flexibly fit curves to your data.
- Lesson 745 — STL Decomposition (Seasonal-Trend Loess)
- Logistic regression
- Logistic regression is designed specifically for binary outcomes.
- Lesson 679 — Logistic Regression Setup and the Binary Response
- Long-term business viability
- A 2% floor vs 20% changes unit economics dramatically
- Lesson 1658 — Flattening and Asymptotic Behavior
- Lower λ
- Lower λ means events happen less frequently → longer waiting times
- Lesson 164 — The Exponential Distribution
- lurking variable
- This is sometimes called a lurking variable or hidden confounder.
- Lesson 497 — The Third Variable Problem
M
- Mahalanobis distance
- Mahalanobis distance is the multivariate equivalent of the Z-score.
- Lesson 1381 — Multivariate Z-Score Methods
- Main effects and interactions become entangled
- Larger groups influence the overall means more, making it harder to separate what's due to factor A, factor B, or their interaction
- Lesson 468 — Balanced vs Unbalanced Designs
- Maintenance
- Rule-based systems are trivial to update. Change the threshold from 3 to 4 late payments with one edit. Compare that to retraining and validating an entire ML pipeline.
- Lesson 2123 — Simple Rules Beat Complex Models
- Map projections
- Map projections are mathematical transformations that flatten the globe onto a plane—like peeling an orange and trying to lay the peel flat.
- Lesson 1308 — Geographic Data Types and Coordinate Systems
- margin of error
- The margin of error is the "plus-or-minus" part of a confidence interval—it tells you how far your estimate might reasonably be from the true population parameter.
- Lesson 271 — Margin of Error
- Markers
- Markers are symbols that appear at each data point along your line.
- Lesson 1258 — Customizing Lines: Colors, Styles, and Markers
- Markov chain
- A Markov chain is a sequence of states where the next state depends only on the current state, not on how you got there.
- Lesson 1589 — Markov Chains: The Foundation of MCMC
- masking
- The sequential approach seems logical, but it has a serious flaw called masking.
- Lesson 1394 — Sequential Application of Grubbs' Test
- Mathematical convenience
- Some priors (called conjugate priors) make calculations simpler
- Lesson 1534 — The Prior Distribution
- Maximizing internal validity
- You recruit a highly homogeneous group of students, control every aspect of the environment, use strict protocols, and carefully monitor compliance. Your causal conclusions are rock-solid—but only for students exactly like yours, in settings exactly like yours.
- Lesson 1441 — Internal vs External Validity
- Maximum test
- Only checks if the largest value is an outlier
- Lesson 1393 — Two-Sided vs One-Sided Grubbs' Test
- McNemar's Test
- McNemar's Test is specifically designed for situations where:
- Lesson 435 — McNemar's Test: Paired Categorical DataLesson 437 — Applications: Clinical Trials and Market Research
- Mean
- The center of the distribution is the true proportion p
- Lesson 42 — Comparing Mean, Median, and ModeLesson 174 — Symmetry and the Mode, Median, MeanLesson 224 — CLT for ProportionsLesson 1173 — Numerical Variable Summary Statistics
- Median
- Since the curve is perfectly balanced around μ, exactly 50% of the area (probability) lies to the left of μ, and 50% lies to the right. That's the definition of a median.
- Lesson 174 — Symmetry and the Mode, Median, MeanLesson 1173 — Numerical Variable Summary Statistics
- median survival time
- The median survival time is the point at which exactly 50% of subjects have experienced the event.
- Lesson 816 — Median Survival Time
- Merge joins
- Merge joins are efficient for pre-sorted data or when the database can sort cheaply, advancing through both tables in lockstep.
- Lesson 957 — Join Strategies: Nested Loop, Hash, Merge
- Metadata
- Metadata is "data about data"—the descriptive information that explains what each piece of data means.
- Lesson 23 — Data Provenance and MetadataLesson 1163 — Metadata and Data Dictionaries
- Metric attribution
- Metric attribution is the process of assigning credit to the specific drivers that caused a metric to move.
- Lesson 1637 — What is Metric Attribution?
- Minimum test
- Only checks if the smallest value is an outlier
- Lesson 1393 — Two-Sided vs One-Sided Grubbs' Test
- Mistaking correlation patterns
- Seeing A and Y correlate and assuming A→Y, when really both are caused by unmeasured C.
- Lesson 1476 — Common DAG Patterns and Pitfalls
- mode
- The peak of the curve—where the probability density is highest—sits right at μ. That's where the most "probability mass" concentrates.
- Lesson 41 — The Mode: Most Frequent ValueLesson 174 — Symmetry and the Mode, Median, MeanLesson 1173 — Numerical Variable Summary Statistics
- Model insights
- A baseline model might show your problem is too easy (100% accuracy suggests data leakage) or impossibly hard (random performance suggests the question can't be answered with available data). You revisit problem definition.
- Lesson 2109 — Why Data Science is Inherently Iterative
- Model-ready format
- Machine learning libraries expect features in columns and samples in rows. Tidy data is already in this format, eliminating an entire preprocessing step.
- Lesson 1149 — Benefits of Tidy Data for Downstream Work
- Modeling
- Modeling is where you build mathematical representations that can make predictions or explain what's happening in your data.
- Lesson 13 — Exploratory Analysis and Modeling
- most common mistake
- The most common mistake is treating P(A|B) and P(B|A) as the same thing—they're usually very different!
- Lesson 100 — Common Conditional Probability Mistakes
- moving average
- A moving average is a simple yet powerful technique for smoothing time series data.
- Lesson 750 — What is a Moving Average?
- MRR
- MRR is the normalized monthly value of all active subscriptions.
- Lesson 1628 — SaaS Metrics: MRR, ARR, and Logo Churn
- Multi-touch
- Credit is distributed across multiple touchpoints (linear, time-decay, position-based)
- Lesson 1637 — What is Metric Attribution?
- Multiplicative seasonality
- Multiplicative seasonality means seasonal swings grow or shrink proportionally with the trend level.
- Lesson 766 — Additive vs Multiplicative Seasonality
- MySQL
- MySQL is another open-source option, popular for web applications and simpler projects.
- Lesson 845 — Database Management Systems (DBMS)
N
- New hypothesis
- Email engagement is the driver, not day-of-week effects
- Lesson 1201 — Domain Knowledge as a Hypothesis Source
- Non-canonical links
- Non-canonical links are any other valid link functions you might choose for that distribution.
- Lesson 676 — Canonical vs Non-Canonical Links
- Non-correlated subqueries
- Non-correlated subqueries are completely independent.
- Lesson 968 — Correlated vs Non-Correlated Subqueries in SELECT
- Non-independence
- If observations are related in ways you haven't accounted for (clustered data, time series correlations), the independence assumption fails completely, and your p-values become meaningless.
- Lesson 390 — When Parametric Tests Fail: Violations of Assumptions
- Non-linearity
- The relationship between X and Y curves rather than forming a straight line
- Lesson 591 — When and Why to Transform Variables
- Non-nested models
- Non-nested models are competitors that can't be simplified into one another.
- Lesson 791 — Comparing Nested and Non-Nested Models
- Non-normal residuals
- The Q-Q plot shows heavy tails, skewness, or other departures from normality
- Lesson 591 — When and Why to Transform Variables
- Non-normality with small samples
- If your sample size is small (typically n < 30) and your data show strong skewness, heavy outliers, or non-normal distributions (confirmed through visual checks or tests like Shapiro-Wilk), the t-test's results become unreliable. The Central Limit Theorem hasn't kicked in yet to rescue you.
- Lesson 390 — When Parametric Tests Fail: Violations of Assumptions
- Non-probability sampling
- Non-probability sampling means selection isn't random—some members have zero chance of being included, or their selection probability is unknown.
- Lesson 242 — Probability vs Non-Probability Sampling
- Normality
- Each group's data is roughly normally distributed (or sample size is large)
- Lesson 447 — Conducting One-Way ANOVA in Practice
- Normality holds
- Your data (or sampling distribution) is approximately normal, especially with small samples (n < 30)
- Lesson 398 — Choosing Between Parametric and Non-Parametric Tests
- Normality required
- Your data must be approximately normally distributed (Grubbs' is parametric)
- Lesson 1389 — What is Grubbs' Test?
- Normalizing values
- Normalizing values means replacing variations with a single standard form.
- Lesson 1138 — Cleaning and Standardizing Text Fields
- North Star Metric
- A North Star Metric (NSM) is the one metric that best captures the core value your product or service delivers to customers.
- Lesson 1604 — What is a North Star Metric?
- Null hypothesis
- All instruments are exogenous (valid)
- Lesson 464 — Main Effects in Two-Way ANOVALesson 654 — Testing Interaction SignificanceLesson 1467 — Testing Instrument Strength and Validity
O
- Objective
- An Objective is a clear, inspiring goal that describes what you want to achieve.
- Lesson 1607 — Introduction to OKRs (Objectives and Key Results)
- Objectives
- In the OKR framework, Objectives are the qualitative, inspirational statements that describe what you want to achieve.
- Lesson 1609 — Setting Effective Objectives
- Observed
- The actual count you got in each category
- Lesson 417 — The Chi-Squared Test Statistic Formula
- observed frequencies
- The test measures how far your observed frequencies are from your expected frequencies across all categories.
- Lesson 414 — Introduction to Chi-Squared Goodness of Fit Test
- offset
- An offset is a predictor whose coefficient is fixed at 1.0.
- Lesson 692 — Offset Terms for Exposure
- Omitted variable bias
- A third variable influences both X and Y, creating a spurious relationship
- Lesson 553 — Exogeneity: X Must Be Independent of Errors
- ON condition
- The matching rule, usually comparing a column from each table
- Lesson 919 — Basic INNER JOIN Syntax
- one-sample Z-test for proportions
- The one-sample Z-test for proportions is designed specifically for these yes/no, success/failure, category questions where you want to compare an observed proportion from your sample against a hypothesized population proportion.
- Lesson 399 — When to Use the One-Sample Z-Test for Proportions
- One-sided test
- The entire 5% sits in one tail (left or right, depending on your alternative hypothesis)
- Lesson 325 — The Rejection Region
- One-size-fits-all
- A news app should have high DAU/MAU; tax software shouldn't
- Lesson 1694 — Daily Active Users (DAU) and Monthly Active Users (MAU)
- One-tailed test
- You only care about one specific direction (say, bigger). You look at just one tail. For the same test statistic of 2.1, you only find the probability of getting ≥2.1. This is exactly half the two-tailed p-value.
- Lesson 348 — P-Value Calculation Differences
- Ongoing monitoring meets periodic analysis needs
- A sales dashboard tracks daily metrics, while quarterly reports analyze trends, explain variance, and recommend strategic shifts
- Lesson 1980 — Hybrid Approaches and When to Use Both
- OpenStreetMap
- OpenStreetMap is the most popular open-source tile provider, offering street-level detail perfect for urban data visualization.
- Lesson 1314 — Basemaps and Map Tiles
- operators
- In Airflow, operators are templates that define what work gets done, while tasks are specific instances of operators that actually execute that work in your DAG.
- Lesson 1835 — Airflow Operators and Tasks
- Orchestration
- Orchestration is like conducting a symphony: it coordinates multiple tasks in a specific order, handling dependencies, managing failures, and passing data between steps.
- Lesson 1832 — Orchestration vs Scheduling
- Order conditions by likelihood
- Place the most frequently matched conditions first to minimize unnecessary evaluations. If 80% of orders are "shipped," test for that status before checking "pending" or "cancelled."
- Lesson 1037 — CASE Best Practices and Performance
- Orders
- Here, customer_id in Orders is a foreign key that must match a customer_id in Customers.
- Lesson 1051 — Introduction to Foreign Keys
- out-of-sample evaluation
- In time series forecasting, out-of-sample evaluation means holding back recent data points, building your model on the earlier data, then measuring how accurately it predicts the held-out future.
- Lesson 790 — Out-of-Sample Forecast Evaluation
- Outliers present
- The median is robust—extreme values don't affect it. Mean gets distorted.
- Lesson 42 — Comparing Mean, Median, and Mode
- Outside the bounds
- The autocorrelation is statistically significant—there's likely a real pattern at that lag
- Lesson 723 — Significance Bounds in ACF Plots
- Overall model F-test
- The global significance doesn't change
- Lesson 647 — Impact on Model Results and Reporting
P
- p̂
- p̂ (p-hat) is your observed sample proportion
- Lesson 402 — Calculating the Test Statistic for Proportions
- p-value
- Telling you if the effect is statistically significant
- Lesson 318 — What is a P-Value?Lesson 464 — Main Effects in Two-Way ANOVA
- p^k
- The probability of getting k successes (since each success has probability p)
- Lesson 127 — Binomial Distribution PMF
- p₀
- p₀ is the hypothesized population proportion from your null hypothesis
- Lesson 402 — Calculating the Test Statistic for Proportions
- p̂₂
- p̂₁ and p̂₂ are your two sample proportions
- Lesson 287 — Confidence Intervals for the Difference Between Two ProportionsLesson 409 — Z-Test Statistic for Two Proportions
- PACF
- PACF is like saying "I inherited traits directly from my grandmother (beyond what came through my mother)" — the unique, direct connection
- Lesson 728 — PACF vs ACF: Key Differences
- Paired or Repeated Measurements
- If you measure the same subjects twice (before/after treatment), those measurements aren't independent—they're linked to the same person. This is why we use paired t-tests instead of two-sample tests.
- Lesson 381 — Independence Assumption and Its Violations
- paired t-test
- Compares means from matched observations (e.g., same people measured before and after treatment)
- Lesson 369 — When to Use a Paired t-TestLesson 375 — Paired t-Test vs Two-Sample t-Test
- pairplot
- A scatter plot matrix (also called a pairplot) solves this by creating a grid where each cell shows the relationship between two variables—like a multiplication table, but for scatter plots.
- Lesson 1191 — Scatter Plot Matrices and Pairplots
- Pairwise independence
- Pairwise independence means every pair of events is independent.
- Lesson 103 — Mutual Independence vs Pairwise Independence
- Parallel trends
- Parallel trends means that, without the intervention, the treated and control groups would have experienced the same change over time.
- Lesson 1453 — The Parallel Trends Assumption
- Parameter uncertainty
- The spread of the distribution shows how confident you are. A narrow, peaked posterior means high certainty; a wide, flat one means substantial uncertainty remains even after seeing data.
- Lesson 1547 — Interpreting Posterior Distributions
- Parameters
- Parameters are numerical characteristics that describe a population.
- Lesson 228 — Defining Populations and Parameters
- Parametric part
- The model assumes covariates affect hazard through a mathematical formula with parameters (coefficients) you estimate.
- Lesson 825 — What is the Cox Proportional Hazards Model?
- Pareto
- Pareto describes heavy-tailed phenomena where extreme values are common—wealth distributions, file sizes on servers, or social network connections.
- Lesson 193 — Choosing Between Distributions in Practice
- Parquet
- Parquet is a compressed, column-oriented format designed for efficiency.
- Lesson 1129 — Parquet and Feather: Columnar Formats
- Parquet and Feather
- Parquet and Feather are columnar formats optimized for analytics.
- Lesson 1133 — Performance Considerations Across Formats
- parsimony
- In multiple linear regression, parsimony means preferring models with fewer predictors when they perform comparably to more complex alternatives.
- Lesson 632 — Parsimony and Occam's Razor
- partial likelihood estimation
- Unlike ordinary regression models that use standard maximum likelihood, the Cox model uses a clever trick called partial likelihood estimation.
- Lesson 828 — Fitting the Cox Model
- partition
- A partition is a chunk of your DataFrame or RDD that lives on a single machine.
- Lesson 1782 — Spark Performance Basics: Partitions and Caching
- partitions
- While Pandas loads everything into memory at once, Dask breaks your data into manageable chunks called partitions and processes them in parallel.
- Lesson 1791 — Dask DataFrame Basics
- Pattern
- The overall shape tells you about your data's structure
- Lesson 722 — ACF Plots and Interpretation
- Pearson correlation
- Pearson correlation is your go-to for linear relationships between normally distributed variables.
- Lesson 1184 — Correlation Coefficients in Bivariate Analysis
- Percentiles
- The value below which a certain percentage of data falls. The 25th percentile (Q1), 50th (median), and 75th (Q3) split your data into quarters.
- Lesson 1173 — Numerical Variable Summary Statistics
- Permutation methods
- Permutation methods are useful when testing whether two groups differ.
- Lesson 291 — Non-Parametric Alternatives for Difference Intervals
- Personalize experiences
- Tailor messaging based on where users are in their journey
- Lesson 1719 — The Customer Journey and Touchpoints
- Phantom reads
- A query returns different rows on repeat execution because another transaction inserted/deleted data
- Lesson 1116 — Transaction Isolation and Concurrency
- Phi
- Phi is a special case used exclusively for 2×2 contingency tables.
- Lesson 429 — Effect Size: Cramér's V and Phi
- point forecast
- A point forecast is your model's single best estimate for a future value.
- Lesson 794 — Forecasting Concepts and Horizons
- Point forecasts
- The expected values for each future time step
- Lesson 800 — Generating Forecasts with SARIMA
- Points along the line
- Perfect or near-perfect normality. Your residuals behave as the regression model assumes—this is what you want to see.
- Lesson 566 — Reading Q-Q Plots: Interpreting Points Along the Reference Line
- pooled variance t-test
- The pooled variance t-test is specifically designed for situations where you can reasonably assume both populations have the same variance (even if their means differ).
- Lesson 361 — Pooled Variance t-Test
- population
- In statistics, a population is the complete collection of all items, individuals, or measurements that you want to study or draw conclusions about.
- Lesson 228 — Defining Populations and ParametersLesson 229 — Defining Samples and Statistics
- Population distribution
- Population distribution is the complete album of everyone's heights in a country — every single person.
- Lesson 258 — Comparing Population, Sample, and Sampling Distributions
- Portfolio thinking
- Portfolio thinking means treating your channels like investments:
- Lesson 1716 — Channel Mix and Portfolio Thinking
- position along a common scale
- Of all the ways you can encode data visually (color, size, shape, angle, etc.), position along a common scale is the most accurately perceived by the human brain.
- Lesson 1233 — Position as the Most Effective Channel
- Post
- Post is a binary indicator (1 if observation is from post-treatment period, 0 if pre-treatment)
- Lesson 1455 — DiD with Regression
- posterior distribution
- The posterior distribution is the end result of Bayesian inference—it's what you actually care about.
- Lesson 1537 — The Posterior Distribution
- Posterior mean
- The expected value of the posterior distribution — think of it as the "center of mass" of your updated beliefs.
- Lesson 1553 — Normal-Normal ConjugacyLesson 1561 — Posterior Mean and Mode
- Posterior Mode
- The peak of the posterior distribution, also called the Maximum A Posteriori (MAP) estimate — the single most probable value.
- Lesson 1561 — Posterior Mean and Mode
- PostgreSQL
- PostgreSQL is an enterprise-grade, open-source DBMS known for handling complex queries and large datasets.
- Lesson 845 — Database Management Systems (DBMS)
- postmortem
- A postmortem is a written retrospective documenting what happened, why, and how to prevent recurrence.
- Lesson 1862 — Incident Response and Postmortems
- Power analysis
- Power analysis is the process of determining the minimum sample size required to detect an effect of a given size with adequate statistical power, all while controlling your Type I error rate (alpha).
- Lesson 344 — Power Analysis in Study Design
- Practical limit
- Most effective trees are 3-5 levels deep with 3-7 branches per node
- Lesson 1623 — Depth vs Breadth in Metric Trees
- Practical significance
- Even if your p-value is small, if the confidence interval includes very small effect sizes, the practical importance might be questionable.
- Lesson 387 — Confidence Intervals for Effect Sizes
- Pre-experiment validation
- Pre-experiment validation means running tests to ensure your randomization works properly and your metrics behave as expected before you expose users to actual treatment differences.
- Lesson 1483 — Pre-Experiment Validation
- Pre-registration
- Pre-registration means writing down your hypotheses, metrics, sample size, stopping rules, and correction methods before you peek at any results.
- Lesson 1508 — Pre-Registration and Correction Strategy
- Precision
- A narrow interval (e.g., [0.60, 0.70]) means you estimated the effect size precisely. A wide interval (e.g., [0.20, 1.10]) signals high uncertainty.
- Lesson 295 — Trade-offs: Precision, Confidence, and CostLesson 387 — Confidence Intervals for Effect Sizes
- predicted values
- Fitted values (also called predicted values) are the Y values that your regression line predicts for each X value in your dataset.
- Lesson 538 — What Are Fitted Values?
- primary key
- A primary key is a unique identifier for each row in a table—like an employee ID number that no two employees share.
- Lesson 921 — Primary and Foreign Key RelationshipsLesson 1048 — What Are Primary Keys?
- prior distribution
- In Bayesian inference, the prior distribution represents what you believe about a parameter before observing new data.
- Lesson 1543 — Defining Prior Distributions
- Probability sampling
- Probability sampling means every member of the population has a known, non-zero chance of being selected.
- Lesson 242 — Probability vs Non-Probability Sampling
- Probability statements
- You can make direct claims like "There's a 95% probability the conversion rate is between 0.12 and 0.18" by finding the credible interval. This is much more intuitive than frequentist confidence intervals.
- Lesson 1547 — Interpreting Posterior Distributions
- Problem definition
- Problem definition means translating a business need into a specific, answerable question.
- Lesson 10 — Problem Definition and Scoping
- Production deployment
- Compiled models are easier to integrate into non-Python systems
- Lesson 1595 — Stan: High-Performance Bayesian Inference
- Project-Join Normal Form
- 5NF (also called Project-Join Normal Form) eliminates join dependencies.
- Lesson 1068 — Higher Normal Forms: 4NF and 5NF
- propensity score
- A propensity score is the probability that an individual receives treatment given their observed covariates (characteristics).
- Lesson 1447 — Propensity Score: Concept and Estimation
- Protected classes
- Protected classes are groups of people shielded by law from discrimination.
- Lesson 1888 — Protected Classes and Sensitive Attributes
- Proximity
- Elements placed close together are perceived as related. In a scatter plot, tight clusters of points signal a group even without explicit labels. Place related legend items near each other, and separate unrelated chart elements with whitespace.
- Lesson 1236 — Gestalt Principles in Visualization
- proxy variable
- A proxy variable is a feature that correlates strongly with a protected attribute (like race, gender, or religion) even though it appears neutral on the surface.
- Lesson 1883 — Protected Classes and Proxy VariablesLesson 1889 — Proxy Variables and Redlining
- psycopg2
- The standard driver for PostgreSQL. Use when connecting to Postgres databases in production environments. Known for reliability and feature completeness.
- Lesson 1087 — Database Drivers and Connection Libraries
- pull request
- A pull request (PR) is a formal proposal to merge your branch into another branch—typically from a feature branch into main.
- Lesson 2022 — Understanding Pull Requests
- Python's approach
- Python's approach is like learning the second language natively from the start.
- Lesson 1374 — Interactivity: plotly in R vs Python and Integration Patterns
- Pyvis
- Pyvis is purpose-built for network visualization.
- Lesson 1321 — Interactive Network Graphs with Plotly and Pyvis
Q
- Quality control
- A manufacturing process with high variability produces inconsistent products
- Lesson 46 — What is Variability?
- Quantiles
- Quantiles are the general family of cut-points that divide ranked data into any equal-sized groups.
- Lesson 57 — Quantiles: Quartiles, Deciles, and Beyond
- Query Complexity
- Higher normalization means more tables. A query that once touched two tables might now JOIN across five or six. This makes queries harder to write, debug, and understand.
- Lesson 1070 — When to Stop Normalizing
- Query execution time
- The obvious metric, but run queries multiple times to account for caching
- Lesson 1077 — Measuring Performance Impact of Denormalization
R
- R's approach
- Think of it like translation services: R's approach is like having an interpreter who translates your speech (ggplot2 code) into another language (plotly).
- Lesson 1374 — Interactivity: plotly in R vs Python and Integration Patterns
- Radioactive decay
- An atom that hasn't decayed for an hour is no more "due" to decay than a fresh atom
- Lesson 167 — Memoryless Property of Exponential
- Random assignment
- Random assignment means each user has an equal, unpredictable chance of seeing the control or treatment version.
- Lesson 1486 — Why Randomization Matters in A/B Tests
- random walk
- A random walk is cumulative: each value equals the previous value plus random noise.
- Lesson 724 — ACF Patterns for Different Processes
- Randomized experiment
- You randomly assign 100 people to drink coffee or not, then measure productivity. Any differences are likely caused by coffee because randomization balanced all other factors (sleep habits, personality, stress levels, etc.).
- Lesson 1443 — Observational Studies vs Randomized Experiments
- range
- The range is just the difference between the largest and smallest values in your dataset.
- Lesson 47 — Range: The Simplest MeasureLesson 54 — When to Use Each Measure
- range slider
- A range slider is a draggable control—typically positioned below the x-axis—that lets viewers select a specific subset of data to display.
- Lesson 1303 — Range Sliders and Zoom Controls
- Rapid prototyping of complex statistical graphics
- The grammar of graphics lets you build sophisticated multi-layered plots with intuitive, declarative syntax.
- Lesson 1375 — Choosing Tools: When to Use R vs Python for Visualization
- rate
- The rate is stable but individual occurrences are unpredictable
- Lesson 153 — Real-World Use Cases: Quality Control and Defects
- Read-heavy workloads
- If a table is queried 10,000 times daily but updated once, duplicating data to avoid joins is worthwhile.
- Lesson 1071 — When to Denormalize: Performance Trade-offs
- Readability
- c.customer_id is shorter and clearer than customers.customer_id, especially in complex queries.
- Lesson 924 — Using Table Aliases in Joins
- Recognizing boundaries of competence
- Recognizing boundaries of competence means honestly assessing what you know versus what a problem requires, and making responsible decisions about whether to proceed alone, seek help, or decline the work entirely.
- Lesson 34 — Recognizing Boundaries of Competence
- Redundant labels
- Over-labeling every single data point when patterns are clear
- Lesson 1246 — Visual Clutter and Chartjunk
- Referential integrity
- Referential integrity is a database rule that ensures every foreign key value in one table correctly points to an existing primary key value in another table—or is NULL (if allowed).
- Lesson 1055 — What is Referential Integrity?
- Referrer Headers
- Referrer Headers are automatically sent by browsers, telling your server which website the user came from.
- Lesson 1713 — Tracking Users by Channel
- Reliability
- Reliability is the probability a system survives beyond time t.
- Lesson 188 — Weibull Distribution: Hazard Function and Reliability
- Replicability
- Replicability means someone else can use different data or different methods to test whether your findings still hold true.
- Lesson 26 — Reproducibility vs. Replicability
- report
- A report is a static, point-in-time document that captures analysis and findings at a specific moment.
- Lesson 1974 — Defining Dashboards and Reports
- Repository
- The sealed, labeled package that's been officially sent and recorded
- Lesson 1993 — The Three States: Working Directory, Staging, Repository
- representative sample
- A representative sample is a subset of a population that accurately mirrors the key characteristics of the whole group.
- Lesson 231 — Representative Samples
- Reproducibility
- Reproducibility means someone else can take your exact same data and exact same code and get the exact same results.
- Lesson 26 — Reproducibility vs. Replicability
- Rerandomization
- Rerandomization is a technique where you check covariate balance before starting your experiment, and if balance is poor, you rerandomize until you get acceptable balance.
- Lesson 1492 — Rerandomization and Practical Implementation
- residual
- A residual is the difference between what actually happened (the observed value) and what your model predicted (the fitted value).
- Lesson 539 — What Are Residuals?
- residuals
- Key Takeaway: ANOVA assumes residuals are normally distributed—always check residuals, not raw data, using both visual plots and statistical tests.
- Lesson 449 — Normality of ResidualsLesson 516 — Residuals: The Distance from PredictionLesson 556 — What Are Residuals and Why Plot Them?
- RESTRICT
- The strict parent. It prevents any deletion or update of the parent row if child rows still reference it. You must handle the children first. This is often the safest default to prevent accidental data loss.
- Lesson 1057 — ON DELETE and ON UPDATE Actions
- retention curve
- A retention curve is a line graph that shows what percentage of users continue returning to your product over successive time periods after experiencing an initial event (like signing up, making a first purchase, or installing an app).
- Lesson 1653 — What are Retention Curves?
- retention table
- A retention table is a grid that shows what percentage of users from each cohort returned in each subsequent time period.
- Lesson 1655 — Constructing Retention Tables
- Reusability
- The same parameter name can appear multiple times in one query
- Lesson 1106 — Parameter Placeholders: Named Parameters
- Revenue
- Revenue is the quintessential lagging indicator—it tells you what already happened.
- Lesson 1600 — Business Examples: Revenue vs Pipeline
- Rework
- Rework means repeating work because something was missed, misunderstood, or poorly executed the first time—rerunning analysis because you forgot to document your seed, rebuilding features because requirements weren't clarified, or re-validating a model because you trained on contaminated data.
- Lesson 2112 — Iteration vs Rework: Learning from Each Cycle
- Right-skewed
- The distribution has a long tail extending to the right (high values)
- Lesson 178 — Log-Normal Distribution: Definition and Properties
- rollback
- A rollback is your "undo" button for database transactions.
- Lesson 1113 — Rolling Back Transactions
- Rollback Mechanisms
- Simulate a mid-pipeline failure during a database write or transformation. Confirm that partial changes are rolled back and the system returns to a consistent state.
- Lesson 1854 — Testing Error Handling
- Roughly constant variance
- the noise level should be stable
- Lesson 709 — Irregular Component: Random Noise
- rows
- The variable that splits plots into rows (vertical organization)
- Lesson 1358 — facet_grid() for Two Variables
S
- sample
- A sample is a subset of the population—a smaller group selected to represent the whole.
- Lesson 229 — Defining Samples and StatisticsLesson 230 — Why We Sample Instead of Census
- Sample distribution
- Sample distribution is one snapshot from that album — maybe 100 randomly selected people.
- Lesson 258 — Comparing Population, Sample, and Sampling Distributions
- Sample size matters
- Typically, n ≥ 30 is considered sufficient for the CLT to "kick in," though it depends on how non-normal the original population is.
- Lesson 218 — What the Central Limit Theorem States
- sample space
- A sample space is simply the complete set of all possible outcomes that can occur when you perform a random experiment or observation.
- Lesson 77 — Sample Spaces: Definition and Examples
- Sampling bias
- Sampling bias is a systematic error in how you collect your sample that pushes your results in one direction, away from the truth.
- Lesson 248 — Sampling Error vs Sampling Bias
- sampling distribution
- Formal definition: A sampling distribution is the probability distribution of a statistic (like the mean, median, or proportion) computed from all possible samples of a fixed size drawn from the same population.
- Lesson 251 — What is a Sampling Distribution?Lesson 258 — Comparing Population, Sample, and Sampling Distributions
- sampling distribution of a proportion
- The sampling distribution of a proportion describes the pattern of this variation.
- Lesson 276 — Sampling Distribution of a Proportion
- sampling distribution of the sample mean
- The sampling distribution of the sample mean is the distribution of all those sample means you'd get if you repeated this process infinitely many times.
- Lesson 252 — Sampling Distribution of the Sample Mean
- sampling distribution of the sample proportion
- The sampling distribution of the sample proportion describes the pattern of all possible sample proportions you could get from repeated sampling.
- Lesson 253 — Sampling Distribution of the Sample Proportion
- Sampling error
- Sampling error is the natural, random variation you get just because you didn't measure everyone.
- Lesson 248 — Sampling Error vs Sampling Bias
- Saturation
- Saturation is the intensity or purity of the color, ranging from vivid/vibrant to dull/grayish.
- Lesson 1234 — Color: Hue, Saturation, and Luminance
- scalar subquery
- A scalar subquery is a subquery that returns exactly one value—a single row with a single column.
- Lesson 960 — Subqueries Returning Single Values
- Scheduler
- Monitors DAGs and triggers tasks when dependencies are met
- Lesson 1833 — Introduction to Apache Airflow
- Scheduling
- Scheduling is like setting alarm clocks: "Run this job every day at 2 AM." It's purely time-based task execution without awareness of what other tasks are doing.
- Lesson 1832 — Orchestration vs Scheduling
- schema
- A schema is an organizational container that groups related tables together.
- Lesson 846 — Tables, Schemas, and Data Types
- Scripts
- Scripts are executable files that run a complete workflow — useful for automation and reproducibility.
- Lesson 2071 — Modular Code: Functions and Scripts
- SE
- SE is the standard error for the difference (calculated using the pooled proportion)
- Lesson 287 — Confidence Intervals for the Difference Between Two ProportionsLesson 402 — Calculating the Test Statistic for ProportionsLesson 409 — Z-Test Statistic for Two Proportions
- Seamless visualization
- Plotting libraries expect data in predictable formats. When data is tidy, creating a chart often means specifying which column goes on the x-axis and which on the y-axis—no reshaping required mid-analysis.
- Lesson 1149 — Benefits of Tidy Data for Downstream Work
- Searched CASE
- Searched CASE is more flexible—each WHEN clause can contain any boolean condition.
- Lesson 1031 — Simple CASE vs Searched CASE
- seasonal period
- The seasonal period is the number of observations it takes for a seasonal pattern to complete one full cycle and repeat.
- Lesson 746 — Choosing Seasonal Period
- Seasonally adjusted data
- Seasonally adjusted data is your original time series with the seasonal component removed, leaving you with just the trend and irregular components.
- Lesson 748 — Seasonally Adjusted Data
- Second-order differencing
- Second-order differencing means you difference the already-differenced data:
- Lesson 736 — Higher-Order Differencing
- Selectivity
- Selectivity is how well a query condition narrows down the result set.
- Lesson 1083 — Index Selectivity and Cardinality
- self-selection bias
- Volunteer bias (also called self-selection bias) occurs when people choose whether or not to participate in a study, and those who volunteer differ in important ways from those who don't.
- Lesson 246 — Volunteer and Self-Selection Bias
- Sensitivity
- probability the test is positive given you have the disease (true positive rate)
- Lesson 109 — Medical Diagnostic Testing
- Sensitivity analysis
- Sensitivity analysis is the practice of deliberately varying your prior choices and observing how the posterior distribution responds.
- Lesson 1572 — Sensitivity Analysis and Prior Robustness
- Sensors
- Sensors are specialized operators that continuously check for specific conditions—like whether another pipeline has completed or if a particular file exists in storage.
- Lesson 1845 — Cross-Pipeline Dependencies
- Separating columns
- Separating columns means splitting one column containing compound data (like "Smith, John" or "2024-01-15 14:30:00") into multiple columns ("LastName", "FirstName" or "Date", "Time").
- Lesson 1147 — Separating and Uniting Columns
- sequential model building strategy
- A sequential model building strategy is a disciplined, step-by-step approach where you start simple, add predictors one at a time (or in logical groups), test their significance, and decide whether to keep them.
- Lesson 703 — Sequential Model Building Strategy
- Sequential updating
- Sequential updating means applying Bayes' Theorem iteratively: your posterior probability after one update becomes the prior probability for the next update.
- Lesson 114 — Sequential Updating
- Sessions
- Sessions are your workspace for database operations.
- Lesson 1122 — Creating Tables and Session Management
- Shapiro-Wilk test
- Tests the null hypothesis that residuals are normally distributed
- Lesson 449 — Normality of Residuals
- Shrinkage
- Shrinkage means your posterior estimate gets "pulled" away from extreme sample values toward your prior belief.
- Lesson 1569 — Shrinkage and Regularization Effects
- Similarity
- Objects sharing visual properties (color, shape, size) are seen as belonging together. If you color all data points from Category A in blue and Category B in orange, viewers instantly understand the grouping—even across multiple subplots.
- Lesson 1236 — Gestalt Principles in Visualization
- Simple composition
- If you run 10 queries each with ε=0.1, your total privacy loss is ε=1.0 (worst case)
- Lesson 1900 — Privacy Budget and Composition
- Simple ratio check
- Calculate the ratio of residual deviance to degrees of freedom from your fitted Poisson model. If this ratio is substantially greater than 1 (often >1.5 or 2), overdispersion is likely present.
- Lesson 693 — Overdispersion in Count Data
- skiprows
- Bypasses the top rows, which is crucial for skipping visual report titles and empty space.
- Lesson 1127 — Excel Files: Sheets, Ranges, and Formats
- Slack
- Daily Active Users sending messages — communication happening means teams are getting value, not just licenses purchased.
- Lesson 1606 — Examples of North Star Metrics by Industry
- Small tables
- The table has few columns and you genuinely need all of them
- Lesson 851 — Selecting All Columns with Asterisk
- Smaller storage footprint
- Less duplication means less disk space
- Lesson 1810 — Snowflake Schema and Normalization Trade-offs
- Source URL or Location
- The exact web address, API endpoint, database connection string, or file path where you obtained the data. Without this, no one (including future you) can verify or refresh the data.
- Lesson 2063 — Essential Metadata to Capture
- Spark Core
- Spark Core is the foundation of the entire framework.
- Lesson 1775 — Spark Components: Core, SQL, MLlib, Streaming
- Specification Limits
- Specification Limits are the "voice of the customer." They define acceptable performance boundaries set by customer requirements, engineering standards, or business rules.
- Lesson 1400 — Control Limits vs Specification Limits
- Specificity
- probability the test is negative given you don't have the disease (true negative rate)
- Lesson 109 — Medical Diagnostic Testing
- Speed
- A few conditional checks run in microseconds. No model loading, no feature preprocessing overhead.
- Lesson 2123 — Simple Rules Beat Complex Models
- Speed and Scale
- A biased recommendation algorithm can expose millions to harmful content in hours, far beyond what human curation could achieve.
- Lesson 1923 — Algorithmic Amplification of Harm
- Spot real trends
- See if unemployment is genuinely rising or just following seasonal patterns
- Lesson 748 — Seasonally Adjusted Data
- SQLite
- SQLite is a lightweight DBMS that stores your entire database in a single file.
- Lesson 845 — Database Management Systems (DBMS)
- Stack traces
- The full path of execution leading to the failure
- Lesson 1851 — Error Logging and Notifications
- stage
- Each stage is one step (like "preprocess data" or "train model"), and you declare exactly what files it needs (dependencies) and what it produces (outputs).
- Lesson 1874 — DVC Pipelines and Stages
- staggered adoption
- This is called staggered adoption or staggered rollout.
- Lesson 1457 — Multiple Time Periods and Staggered Adoption
- stakeholder
- A stakeholder is anyone who can affect or be affected by your project's outcomes—from executives who fund the work to end-users who'll interact with your model's predictions.
- Lesson 2101 — Identifying and Mapping Stakeholders
- standard deviation
- The standard deviation is √5 ≈ 2.24 calls
- Lesson 141 — Mean and Variance of Poisson Distribution
- Standard Error
- Standard error (SE) is simply the standard deviation of a sampling distribution.
- Lesson 224 — CLT for ProportionsLesson 260 — Defining Standard Error
- Standard Error of the Mean
- The Standard Error of the Mean is calculated using a beautifully simple formula:
- Lesson 262 — Standard Error of the Mean
- standard normal distribution
- The standard normal distribution is a special case of the normal distribution with a mean (μ) of 0 and a standard deviation (σ) of 1.
- Lesson 194 — The Standard Normal Distribution
- standardization
- Any normal distribution can be transformed into the standard normal distribution through a process called standardization (which you'll learn soon).
- Lesson 194 — The Standard Normal Distribution
- star schema
- A star schema is a common data warehouse design where one central fact table (containing measurements like sales amounts, quantities, or counts) connects to multiple dimension tables (containing descriptive attributes like customer names, product details, or dates).
- Lesson 956 — Star Schema JoinsLesson 1808 — Star Schema and Fact Tables
- Static validation
- Parse your DAG definition without executing it. Check that all referenced tasks exist, upstream tasks are declared before being referenced, and no circular dependencies exist.
- Lesson 1846 — Testing and Validating Dependency Graphs
- Stationarity
- Stationarity means that a time series has constant statistical properties over time.
- Lesson 712 — What is Stationarity?
- Statistical power
- Statistical power is the probability that your hypothesis test will correctly reject a false null hypothesis.
- Lesson 338 — What is Statistical Power?Lesson 397 — Power and Efficiency of Non-Parametric TestsLesson 446 — Power and Sample Size for ANOVALesson 1529 — Running Underpowered Tests
- Statistical power increases
- the test becomes better at detecting any deviation
- Lesson 209 — Sample Size Considerations in Normality Tests
- Statistical test
- Run a DiD-style regression using only pre-treatment data, with placebo "treatment" dates. If you detect a significant "effect" when no real treatment occurred, parallel trends is violated.
- Lesson 1456 — Testing Parallel Trends
- Statistical Tests
- You can run t-tests or chi-square tests comparing covariates between groups. However, failing to reject the null hypothesis doesn't prove balance—it just means you lack evidence of imbalance with your sample size.
- Lesson 1491 — Covariate Balance and Diagnostics
- statistical transformations
- These automatic calculations are called statistical transformations (or "stats").
- Lesson 1343 — Statistical Transformations
- strata
- Once you've calculated Kaplan-Meier survival curves for different groups (called strata)—like treatment vs. control, male vs. female, or different product tiers—you need to compare them to understand whether survival differs meaningfully between groups.
- Lesson 817 — Comparing Multiple Survival Curves
- Streamlit Cloud
- Streamlit Cloud is the easiest option for Streamlit apps—simply connect your GitHub repository, and it deploys automatically.
- Lesson 1338 — Deployment and Sharing Dashboards
- Structured data
- Structured data is information organized into rows and columns, like a spreadsheet or database table.
- Lesson 16 — Structured vs Unstructured Data
- Subtract 1
- Because once you know the counts for all but one category, the last one is determined (they must sum to your total sample size)
- Lesson 418 — Degrees of Freedom in Goodness of Fit
- Supporting observations
- the patterns, anomalies, or visualizations that sparked the hypothesis (e.g., "scatter plot shows clustering of churned customers at high response times")
- Lesson 1203 — Documenting Hypotheses and Evidence
- Surrogate keys
- Surrogate keys are artificial identifiers created solely for database purposes—typically auto-incrementing integers or UUIDs.
- Lesson 1050 — Choosing Effective Primary Keys
- Swamping
- A valid point gets falsely flagged because outliers distort the statistics
- Lesson 1407 — The ESD Component
- symmetric difference
- The symmetric difference is everything except the middle overlap—only the parts unique to each circle.
- Lesson 938 — Symmetric Difference Pattern
- Systematic sampling
- Systematic sampling is efficient and easy.
- Lesson 243 — Choosing the Right Sampling Method
T
- t-statistic
- The t-statistic is the core calculation in a one-sample t-test.
- Lesson 353 — Calculating the t-Statistic
- T-test
- Compares means between two groups (treatment vs control)
- Lesson 1749 — Measuring Statistical Significance
- table
- A table is like a spreadsheet in a database—it stores data in rows and columns.
- Lesson 846 — Tables, Schemas, and Data Types
- Table name qualification
- Table name qualification means prefixing column names with their table name using dot notation:
- Lesson 922 — Selecting Columns from Joined Tables
- target population
- Your target population is your ideal—the complete group you want to draw conclusions about.
- Lesson 233 — Populations in Practice
- Task parallelism
- Task parallelism is having one chef chop vegetables, another boil pasta, another prepare sauce, and another plate desserts—all simultaneously, each doing something different.
- Lesson 1769 — Task Parallelism and Work Distribution
- tasks
- In Airflow, operators are templates that define what work gets done, while tasks are specific instances of operators that actually execute that work in your DAG.
- Lesson 1835 — Airflow Operators and Tasks
- Temperature
- Temperature is the confounder: hot weather increases ice cream sales and increases swimming (thus drowning risk).
- Lesson 509 — Confounding Variables and ControlLesson 1427 — What is a Confounding Variable?
- test statistic
- A test statistic is a standardized measure that quantifies how far your sample data deviates from what you'd expect if the null hypothesis (H₀) were true.
- Lesson 314 — What is a Test Statistic?
- They're reasonable
- The conjugate family genuinely captures your prior knowledge
- Lesson 1556 — Choosing Between Conjugate and Non-Conjugate Priors
- Think of it like
- Organizing two enormous filing cabinets by matching customer IDs—each worker handles one drawer pair independently.
- Lesson 1786 — Data Processing Patterns Best Suited for Spark
- Thinning
- Thinning means keeping only every kth sample (e.g., every 10th) to reduce correlation between consecutive draws.
- Lesson 1592 — Burn-in, Thinning, and Convergence Diagnostics
- Tick Marks and Labels
- Customize where tick marks appear and what they say using set_xticks() and set_xticklabels(). This is crucial for readability, especially with categorical data or dates.
- Lesson 1270 — Customizing Axes: Labels, Limits, and Scales
- Tidy data
- Tidy data is a standardized way of organizing datasets that follows three simple rules:
- Lesson 1142 — What is Tidy Data?
- time origin
- The time origin is your starting line—the moment when the clock begins for each subject.
- Lesson 803 — Defining the Event and Time Origin
- Time-bound
- Set a clear horizon (quarterly, annually) so urgency is built in
- Lesson 1609 — Setting Effective Objectives
- Timeboxing
- Timeboxing means allocating a fixed duration—say, three days for EDA or one week for initial modeling—and forcing yourself to produce something deliverable when time runs out, even if it's imperfect.
- Lesson 2113 — Timeboxing and Sprint Planning for Data Projects
- Too many bins
- The plot becomes noisy and hard to interpret
- Lesson 1267 — Histograms and Distribution Plots
- Too many color bins
- 3-7 bins is ideal. More creates confusion.
- Lesson 1309 — Choropleth Maps: Basics and Best Practices
- Too rare
- Conversions on high-ticket items are infrequent
- Lesson 1517 — Surrogate Metrics: When Direct Measurement is Impractical
- touchpoint
- Each interaction point along this path—an ad click, email open, website visit, or social media engagement—is called a touchpoint.
- Lesson 1719 — The Customer Journey and Touchpoints
- Tracking Pixels
- Tracking Pixels are tiny, invisible images embedded in emails or third-party sites.
- Lesson 1713 — Tracking Users by Channel
- Traffic volume
- Traffic volume is often your biggest limitation.
- Lesson 1500 — Practical Considerations and Trade-offs
- Trailing moving averages
- Trailing moving averages are essential for forecasting because they only use information available at that moment.
- Lesson 753 — Centered vs Trailing Moving Averages
- transaction
- A transaction is a logical unit of work that groups one or more database operations together.
- Lesson 1110 — What Are Database Transactions?
- Transformations
- Transformations are operations that define what you want to do with your data — they create a new RDD or DataFrame by specifying a recipe.
- Lesson 1780 — Transformations vs Actions in Spark
- transient failure
- A transient failure is temporary—caused by conditions that will likely resolve themselves, like a momentary network hiccup, a database briefly under heavy load, or a service restarting.
- Lesson 1849 — Transient vs Permanent Failures
- Transitive dependencies
- Transitive dependencies are the hidden culprit: Package A depends on Package B version 2, but Package C needs Package B version 3.
- Lesson 2048 — The Dependency Hell Problem
- Treated
- Treated is a binary indicator (1 if unit is in treatment group, 0 if control)
- Lesson 1455 — DiD with Regression
- Treated × Post
- Treated × Post is the interaction term between the two indicators
- Lesson 1455 — DiD with Regression
- Trend
- The series consistently moves up or down (violates constant mean)
- Lesson 715 — Visual Tests for Stationarity
- Two-Sample t-Test
- Compares means from two independent groups (e.g., treatment group vs control group with different people)
- Lesson 375 — Paired t-Test vs Two-Sample t-Test
- Two-sided
- H₁: μ_d ≠ 0 (there is some difference, positive or negative)
- Lesson 373 — Hypotheses for Paired t-Tests
- Two-sided test
- The rejection region sits in both tails of the distribution, with 2.5% in each tail
- Lesson 325 — The Rejection Region
- Two-tailed test
- You care about differences in either direction (bigger or smaller). You look at both tails of the distribution. If your test statistic is 2.1, you find the probability of getting ≥2.1 or ≤-2.1. This doubles the area in the tail.
- Lesson 348 — P-Value Calculation Differences
U
- unbiased estimator
- An unbiased estimator is a sample statistic whose expected value equals the population parameter it's trying to estimate.
- Lesson 255 — Expected Value of Sample Statistics
- underpowered test
- Running an underpowered test means your sample size is too small relative to the minimum detectable effect you care about—typically yielding power below 80%.
- Lesson 1529 — Running Underpowered Tests
- Understanding patterns
- Knowing that average temperature is 70°F doesn't tell you if you need both winter coats and shorts
- Lesson 46 — What is Variability?
- Unequal variances
- Groups differ dramatically in spread and sample sizes are unequal
- Lesson 398 — Choosing Between Parametric and Non-Parametric Tests
- Unexpected duplicates
- The same transaction or observation recorded multiple times
- Lesson 1154 — Uniqueness and Duplication Checks
- Unicode
- Unicode is the universal character encoding standard that assigns a unique number to every character across all writing systems.
- Lesson 1139 — Dealing with Special Characters and Unicode
- unit of randomization
- The unit of randomization is the entity you assign to treatment or control groups in your A/B test.
- Lesson 1481 — Unit of Randomization
- unit root
- It tests the null hypothesis that a unit root is present—meaning the series is non-stationary.
- Lesson 716 — Augmented Dickey-Fuller Test
- Uniting columns
- Uniting columns is the reverse: combining multiple columns into one when they represent a single logical unit.
- Lesson 1147 — Separating and Uniting Columns
- Upstream dependencies
- Upstream dependencies are the tasks that must run before your current task.
- Lesson 1841 — Upstream and Downstream Dependencies
- upward trend
- A time series with an upward trend is not stationary (mean changes)
- Lesson 712 — What is Stationarity?
- USING
- ON works everywhere; USING is syntactic sugar for the common case
- Lesson 953 — Join Conditions: ON vs USING
- UTM Parameters
- UTM Parameters are tags appended to URLs that capture campaign details.
- Lesson 1713 — Tracking Users by Channel
V
- Vanity metrics
- Vanity metrics are measurements that appear impressive at first glance—often large, growing numbers—but don't connect to actionable business outcomes or inform strategic decisions.
- Lesson 1612 — What Are Vanity Metrics?
- Variable Name
- The exact column name as it appears in your data
- Lesson 2064 — Creating Data Dictionaries
- Veracity
- Veracity refers to the trustworthiness and accuracy of your data.
- Lesson 1762 — Extended Dimensions: Veracity and Value
- Version drift
- Version drift means that installing "the latest" packages today gives you a different environment than "the latest" six months ago, breaking reproducibility even when you follow the same steps.
- Lesson 2048 — The Dependency Hell Problem
- Vertical bars
- Each bar represents the correlation at a specific lag
- Lesson 722 — ACF Plots and Interpretation
- violin plot
- A violin plot is like a boxplot that went to art school—it shows you not just the summary statistics (median, quartiles, outliers) but the entire shape of your data's distribution.
- Lesson 1286 — Violin Plots and Distribution Shape
- Viridis palettes
- Viridis palettes are perceptually uniform and colorblind-friendly:
- Lesson 1368 — Color Scales and Palettes
- virtual environment
- A virtual environment is an isolated, self-contained directory that houses a specific Python interpreter and its own set of installed packages.
- Lesson 2039 — Virtual Environments: Concept and Benefits
- visual style guide
- A visual style guide is your rulebook for creating plots that look like they belong together, making your work more polished and easier to interpret.
- Lesson 1298 — Building a Consistent Visual Style Guide
- Vulnerability
- Over-reliance on power users means losing a few hurts badly
- Lesson 1698 — Power User Curves and Engagement Distribution
W
- Wait until your pre-planned sample size
- Wait until your pre-planned sample size is reached (fixed-horizon testing)
- Lesson 1523 — Peeking at Results Early
- Wealth distribution
- A small percentage of people control most wealth
- Lesson 191 — Pareto Principle and the 80/20 Rule
- Web scraping
- Web scraping is the automated process of extracting data directly from web pages—essentially teaching a program to "read" websites like a human would, then pull out the specific information you need.
- Lesson 21 — APIs and Web Scraping
- White noise
- White noise is purely random data with no temporal structure.
- Lesson 724 — ACF Patterns for Different Processes
- Widely understood
- The standard language for discussing variability across fields
- Lesson 49 — Standard Deviation: Interpretable Spread
- Win-Back Candidates
- A subset of churned customers worth targeting for reactivation—perhaps they left for fixable reasons or represent high LTV potential.
- Lesson 1704 — Customer Lifecycle Stages
X
Y
- Years of Experience and Salary
- The intercept would mean salary at zero years of experience. While this might make sense for entry-level positions, if your data only includes people with 5+ years of experience, extrapolating back to zero is unreliable and potentially misleading.
- Lesson 526 — When the Intercept Has No Meaning