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
3
Spring Recap: 100 Winning Tests, No Growth
Reflections from data summits, industry shifts, and what we’re still getting wrong in analytics.
 • 
Olga Berezovsky
7
Which Analyst Are You? - Issue 262
Data analyst career guide: an overview of roles, skills, and industry trends
 • 
Olga Berezovsky
How to Report on DAU/MAU Ratio - Issue 261
How to interpret DAU/MAU with benchmarks, examples, and align it with your product’s real usage frequency.
 • 
Olga Berezovsky
When Great Work Isn’t Enough - Issue 260
How invisible contributions undermine career growth (and what to do about It)
 • 
Olga Berezovsky
1
Most Popular
View all
My Consulting Journey: $0 to $685K in 6 months - Issue 232
 • Olga Berezovsky
3
How to Create Decks That Don’t Suck - Issue 245
 • Olga Berezovsky
Refresher on Retention - Issue 236
 • Olga Berezovsky
The Battle You’ll Always Lose: Documentation - Issue 234
 • Olga Berezovsky
3
How To Set Up Analytics for Web and Mobile Products - Issue 259
Build analytics that scale with your product - a practical guide for product analysts
 • 
Olga Berezovsky
Refresher on A/B Testing - Issue 258
Stats, tools, and trusted resources for doing experimentation right
 • 
Olga Berezovsky
From Analytics to Data Science: Building Forecasts - Issue 257
A step-by-step guide to ARIMA and Prophet to forecast events, transactions, and customer growth.
 • 
Olga Berezovsky
1
April Recap: Everyone’s Ready for AI. Except Your Data.
Reflections from data summits, industry shifts, and broken academia.
 • 
Olga Berezovsky
3
1:23:06
The ultimate guide to A/B testing | Ronny Kohavi (Airbnb, Microsoft, Amazon)
Brought to you by Mixpanel—Event analytics that everyone can trust, use, and afford | Round—The private network built by tech leaders for tech leaders …
Published on Lenny's Newsletter • 
How To Develop Analytical Intuition - Issue 254
Error-spotting and how to cross-check metrics when the data won’t match.
 • 
Olga Berezovsky
Why Most Benchmarks Are Misleading - and What to Use Instead - Issue 253
What benchmarks to trust, where to find them, and how to use them.
 • 
Olga Berezovsky
How To Differentiate Yourself in Analytics and Stand Out - Issue 252
Reforge founder Brian Balfour on going deep, earning influence, and avoiding the generalist trap
 • 
Olga Berezovsky
How To Pull Stories From Data and Make Them Actionable - Issue 251
Finding the Why: turning raw data into clear, actionable insights and stories
 • 
Olga Berezovsky
Data Analysis Journal
Data Analysis Journal
Where product, data science, and analytics intersect.
Recommendations
View all 18
The VC Corner
The VC Corner
Ruben Dominguez Ibar
Python and Data Analysis Insights
Python and Data Analysis Insights
Benjamin Bennett Alexander
Pedram's Data Based
Pedram's Data Based
Pedram Navid
Experimental Mind
Experimental Mind
Kevin Anderson
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
© 2025 Olga Berezovsky
Privacy ∙ Terms ∙ Collection notice
Start writingGet the app
Substack is the home for great culture