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
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
Before You Build an Analytics Agent - Issue 307
Getting started with agentic analytics - how to set up business context, benchmarks, and structured workflows
 • Olga Berezovsky
2026 Benchmarks: More Apps, Less Quality - Issue 306
What RevenueCat and Adapty’s 2026 reports say about acquisition, conversion, retention, and where subscription apps are actually heading.
 • Olga Berezovsky
Data Analysis Journal
Data Analysis Journal
Where product, data science, and analytics intersect.
Recommendations
View all 9
SeattleDataGuy’s Newsletter
SeattleDataGuy’s Newsletter
SeattleDataGuy
The VC Corner
The VC Corner
Ruben Dominguez
Learn Analytics Engineering
Learn Analytics Engineering
Madison Mae
Data Gibberish
Data Gibberish
Yordan Ivanov
Stat Significant
Stat Significant
Daniel Parris
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