Data Analysis Journal

Data Analysis Journal

Home
Product Analysis
Subscriptions
A/B testing
What experts say
SQL
Python
Machine Learning
Archive
About
User Segmentation and Power User Analysis in SQL
What are user segmentation techniques? How to locate your Power users? How to do user segmentation analysis in SQL?
 • Olga Berezovsky
When AI Agents Become Users: Rethinking Analytics Tracking - Issue 316
Navigating analytics for AI agents: tracking conversations, testing prompts, and optimizing products in real time.
 • Olga Berezovsky
How Asana Found $40M in Recoverable Revenue - Issue 315
A product analytics case study on false churn - and how Asana turned user removals into a $40M product decision - guest post by Kuber Jain
 • Olga Berezovsky and Kuber Jain
April Recap: Stop Buying Users You Already Paid For - Issue 314
Your monthly recap of the latest trends, market shifts, and updates in data science and analytics.
 • Olga Berezovsky
How to Choose the Right Proxy Metric for an A/B Test - Issue 313
Why the right proxy depends on sample size, noise, and what your past A/B tests can teach you.
 • Olga Berezovsky
Why Winbacks Are One of the Most Important Growth Signals - Issue 312
Most customers return early. Those who come back later tend to generate less revenue.
 • Olga Berezovsky
Claude for Excel: What It Does Well - and Where It Still Falls Short - Issue 311
What Claude for Excel does well, where it still fails, and how to use it safely for analytics and finance
 • Olga Berezovsky
Amplitude Agents 101: How They Work + 20 Prompts to Try - Issue 310
A practical guide to Amplitude MCP, global and specialized agents, and the prompts that make them more useful.
 • Olga Berezovsky
March Recap: The Gap Between Analysis and Communication - Issue 309
Your monthly recap of the latest trends, market shifts, and updates in data science and analytics.
 • Olga Berezovsky
What AI Terms Mean for Analytics - Issue 308
The key BI and analytics AI glossary shaping analytics, data workflows, and decision-making.
 • Olga Berezovsky
Data Analysis Journal
Data Analysis Journal
Where product, data science, and analytics intersect.
Recommendations
View all 9
The VC Corner
The VC Corner
Ruben Dominguez
Stat Significant
Stat Significant
Daniel Parris
Genuine Impact - Because your money deserves better
Genuine Impact - Because your money deserves better
Genuine Impact
Learn Analytics Engineering
Learn Analytics Engineering
Madison Mae
SeattleDataGuy’s Newsletter
SeattleDataGuy’s Newsletter
SeattleDataGuy
Checklists
A/B Test Checklist
A short guide to product experimentation steps and must-know terminology.
SQL Date-Time Cheatsheet
A short guide to steps, solution, and must-know terminology
Python Pandas DateTime Reference Guide
A short guide to solutions and tips for handling DateTime cases in Python Pandas
Subscription Growth Metrics Checklist
A short guide to steps and must-know terminology
Tutorials
A Selection Of SQL Tutorials
A roundup of free SQL tutorials and articles to either get started with or to keep your querying skills strong.
A Selection Of Python Tutorials for Analysts
A roundup of my favorite tutorials for data analysts to either get started with or upkeep existing Python skills

Data Analysis Journal

AboutArchiveRecommendationsSitemap
© 2026 Olga Berezovsky · Privacy ∙ Terms ∙ Collection notice
Start your SubstackGet the app
Substack is the home for great culture