Analytics
494 bites tagged Analytics — interview questions with model answers, and 60-second explainers.
Identity Resolution: Stitching User Profiles Together
Identity resolution stitches together scattered user data into a single profile. It's like a detective matching a phone number from your CRM and a cookie from your website to the same person.
The Data Layer: A Central Hub for Website Events
A data layer is a central JavaScript object acting as a message bus between your site and analytics tags. It passes event data, like button clicks or purchase values, in a structured way. The key footgun: never overwrite it; always use `dataLayer.push()`.
Customer Lifetime Value (LTV): A Customer's Future Net Profit
LTV predicts the total net profit a customer will generate over their entire relationship. It's used to set marketing budgets and prioritize features for high-value users.
Figma's Library Analytics API: Quantify Your Design System's Impact
Figma's Library Analytics API lets you quantify your design system's impact by tracking component usage. Use it to find adoption trends or get a snapshot of where components are used. The footgun: data for files you can't access is obfuscated, not omitted.
Measuring Documentation Effectiveness
Treat your design system docs like a product, not a library. Use analytics on page views, search queries, and user feedback to find confusing components and content gaps. The footgun: high traffic can signal a confusing page, not just a popular one.
OLAP Cube Operations
OLAP cube operations let you analyze data like a multi-dimensional spreadsheet. Instead of just rows and columns, you navigate dimensions like time and location. Used in business intelligence to answer complex analytical questions.
The Big Idea: Your Presentation's Single-Sentence Core
The "Big Idea" is a single sentence distilling your presentation's core message. It must state your point of view and what's at stake, telling your audience what to know and what to do.
Data Sonification: Hearing Your Data's Story
Data sonification is data visualization for your ears, mapping data points to sound properties like pitch or volume. It helps find patterns in complex datasets, like network traffic, where visuals fail.
Dashboard Design: Guide, Don't Overwhelm
A good dashboard guides users to an insight, not just displays charts. Place your key takeaway in the top-left and limit views to 2-3 to maintain focus. The biggest mistake is including too many views, which clutters the message and slows down the dashboard.
Proxy Metrics: Estimate Long-Term Impact Now
A proxy metric uses a model to estimate a slow, long-term outcome, like annual revenue. It lets you quickly judge an A/B test's impact without waiting months for the true result. The footgun is trusting a biased model or ignoring its error, giving you false.
Network Visualization: Making Sense of Connections
Network visualization turns abstract relationships into a 2D map. It's used to see structure in social networks or biological pathways. The footgun is that layout choices can create misleading patterns; a pretty graph isn't always a true one.
Interactive Data Viz: Let Users Explore the Data
Interactive data viz turns a static report into a conversation, giving users controls to ask their own questions. It's key for BI dashboards and research tools. The footgun is overwhelming users with too many options, creating confusion instead of clarity.
Chartjunk: Less is More in Data Visualization
Chartjunk is visual noise in a graph that doesn't help the user understand the data, like 3D effects or decorative backgrounds. It's common in reports where aesthetics are prioritized over clarity.
Audience Analysis: Translate Data for Your Listener
Don't just show data; translate it for your audience. Audience analysis means tailoring communication to who's listening, based on their knowledge and needs. The biggest mistake is assuming your audience shares your context and jargon—they rarely do.
Data Storytelling: Using Narrative to Drive Insight
Structure your data presentation like a story—a journey with rising tension and a clear resolution. This guides stakeholders from a problem to a solution in reports.
Columnar Storage: Read Less Data, Analyze Faster
Columnar formats like Parquet store data by column, not by row. This makes analytical queries that select a few columns from a wide table incredibly fast by minimizing disk I/O. It's a poor fit for transactional workloads that need entire rows at once.
A/A Testing: Sanity-Checking Your Experiments
A/A testing is a fire drill for your A/B testing system. You run two identical versions of a page to ensure your tools are working correctly before a real experiment. The biggest footgun is panicking at a false positive; 1 in 20 tests will show.
Heatmap: Visualizing Magnitude with Color
A heatmap is like coloring in a spreadsheet, using color to show the magnitude of values in a 2D grid. It's used to spot user engagement hotspots on a webpage, analyze financial data, or visualize gene expression.
Bar Chart: Compare Categories at a Glance
A bar chart is a lineup of rulers for different categories, making it easy to compare values. It's perfect for showing "how much" for discrete items, like monthly sales or user counts by country. The footgun: don't use it for continuous data—use a line chart.
Histogram: See the Shape in Your Data
A histogram turns a raw list of numbers into a picture of its distribution, like sorting coins into stacks. It's used to see where data clusters and how it's spread out. The main footgun: the story your histogram tells depends entirely on the bin size.
Data Quality Management: Is Your Data Fit for Use?
Data quality management ensures data is "fit for purpose." It's vital when training ML models or creating financial reports, as outcomes depend on data reliability. The footgun is treating quality as a one-time project, not a continuous process.
Data Warehouse: The Central Repository for Analytics
A data warehouse is a central repository for historical analysis, integrating data from many systems. It's used for reporting and complex queries to find business insights, not for day-to-day transactions.
Causal Inference: Proving Cause, Not Just Correlation
Causal inference goes beyond correlation to ask "did X *cause* Y?". It's used to prove a new feature drove engagement or a drug improved outcomes. The main footgun is mistaking association for causation, ignoring confounding variables.
Issue Trees: Deconstruct Problems, Not Symptoms
An issue tree maps a problem's potential root causes. It's used in consulting and debugging to break down vague questions like 'Why is revenue down?' into testable hypotheses.
Get Analytics bites daily.
Five a day, five minutes, offline. With quizzes so it sticks.
Open testing — you’ll join as an early tester.