Intermediate concepts in Analytics & Metrics
Cohort Analysis: Comparing User Groups Over Time
Instead of averaging all user behavior, cohort analysis groups users by a shared starting point, like their sign-up month. This reveals how product changes affect retention for specific groups. The footgun is lumping everyone together, which hides real trends.
Customer Segmentation: Treat Different Customers Differently
Instead of treating all customers the same, segmentation groups them by shared behaviors or traits. This helps tailor marketing campaigns or manage relationships.
The Data Layer: Your Web Page's Central Message Bus
The data layer is a central message bus for your website, decoupling your app from analytics tags. It passes dynamic data like purchase totals or button clicks to tools like Google Tag Manager, which listens for these events to fire tags.
User ID: The Key to Cross-Device Analytics
A User ID stitches together a person's journey across devices and sessions, moving beyond anonymous tracking. It's key for apps with logins to see the full customer lifecycle. The footgun: never use the User ID for a custom dimension; it will break reporting.
Client-Side vs. Server-Side Tracking
The difference is who sends your data: the user's browser (client-side) or your server (server-side). Client-side is simple but fragile against ad blockers. Server-side offers more control but adds cost. The footgun is thinking server-side is a magic fix.
Event Autocapture: Low-Effort Frontend Analytics
Event autocapture is like a security camera for your UI, recording all user interactions automatically. It's used in web analytics to capture clicks and page views with minimal setup, letting you analyze behavior without manually instrumenting every button.
Data Lake: Store Raw Data Now, Analyze It Later
A data lake is a central repository that holds vast amounts of raw data in its native format. This "store now, structure later" approach is ideal for machine learning on original, unfiltered source data.
Data Marts: Your Department's Slice of the Data Warehouse
Think of a data mart as a department's personal slice of the main data warehouse, containing only relevant data. This allows teams like Sales or Marketing to run faster, focused queries. The footgun is letting each team define shared terms differently.
Star Schema: The Blueprint for Analytics Data
A star schema organizes analytics data with a central fact table (e.g., sales) surrounded by dimension tables (e.g., customers). It's built for fast queries in data warehouses. The footgun is normalizing dimensions, which negates its speed advantage.
Snowflake Schema: Trading Query Speed for Storage
A snowflake schema saves storage by normalizing a star schema's dimensions into smaller, related tables. It's used in data warehouses to reduce redundancy, but the extra joins required can slow down queries, making it a trade-off against a simpler star schema.
Change Data Capture (CDC): Turn Your Database Into a Stream
Change Data Capture (CDC) turns your database into a real-time stream of change events (inserts, updates, deletes). It's used to sync data across systems, like updating search indexes or feeding analytics warehouses, without full table scans.
Data Profiling: The First Step in Any Data Project
Data profiling creates a 'character sketch' of a dataset, revealing its structure, content, and quality. It's the first step in data warehousing or analytics to discover metadata and assess risks. The footgun is skipping it, leading to late-project surprises.
Data Quality: Is Your Data Fit for Purpose?
High-quality data is defined by its fitness for a specific purpose, not just its correctness. It must accurately represent the real world. This is critical for business planning or ML models.
Data Lineage: The Story of Your Data
Data lineage is a family tree for your data, showing its origins, transformations, and final destination. It's essential for debugging broken analytics and tracing errors to their source.
Data Catalog: The Library Card for Your Data
A data catalog is like a library card catalog for your company's data, telling you what exists, where it lives, and what it means. It helps analysts find trustworthy datasets and engineers trace the impact of schema changes. The footgun is letting it go stale.
Data Anonymization: Protecting Privacy by Removing PII
Data anonymization breaks the link between data and real people by removing personal identifiers. It’s used to share datasets for research or analytics while protecting privacy.
GDPR: Treating User Data as a Liability, Not an Asset
GDPR treats personal data as a liability borrowed from the user. It gives EU citizens strong rights over their data, like access and erasure, forcing any company processing it to comply. The footgun is assuming it doesn't apply if your company isn't in the EU.
Data Aggregation: The Big Picture from Small Details
Data aggregation rolls up granular records into high-level summaries, like turning individual sales logs into a daily sales report. It's used to power dashboards and speed up warehouse queries.
Drill-Down Analysis: From Summary to Specifics
Drill-down analysis moves from a high-level data summary to the granular details composing it. It's used in dashboards to investigate a metric's change, like clicking a monthly sales dip to see daily figures.
Cross-Tabulation: Finding Relationships in Your Data
Cross-tabulation reveals how two variables are related by counting their joint occurrences in a grid. It's key for survey analysis or A/B testing. The footgun is assuming correlation implies causation; the table shows a relationship, not its cause.
We are hiring for this. Every open role lists the topics its interview covers, so you can prepare for the real thing rather than guessing.
See open roles