Data Analysis How I frame data questions to make analyses more useful A simple yet effective mental model I use to turn a vague stakeholder request into something that can be analyzed with data.
Why star schema is set up for failure What is star schema?Star schema is the most common approach to data modeling — primarily made up of fact and dimension tables. Why you need data modeling Your company has a lot of data across many different data sources: website and marketing interactions, internal databases, Salesforce, Zendesk, etc…Querying production
Data Engineering Handling slowly changing dimensions in an Activity Schema The simplicity of modeling slowly changing dimensions in an Activity Schema vs a Star Schema
Data Engineering Identifying bot traffic with SQL Systematically identify bot users in your web traffic with a simple SQL query.
Data Science When Correlation is Better than Causation A heuristic approach for using correlations to inform decisions
Data Analysis The best way to calculate Customer Lifetime Value for Ecommerce Understanding what Customer Lifetime Value is, why it's a useful metric, and how to compute it.
Data Analysis One question to make your data project 10x more valuable Make sure your data analysis is actionable by asking this one question before getting started.
Data Science How to choose an attribution model, advice from a data scientist The data-driven way to choose an attribution model
When good data analyses fail to deliver the results you expect A cautionary tale of a data analysis, a dashboard, and a huge waste of resources