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
From Forecast to Action - Issue 279
Why communicating, packaging, and embedding forecasts is where most data scientists fail.
 • Olga Berezovsky
Inside Product Analytics: Decoding User Behavior Part 2 - Issue 278
Deep dive into product analytics: required skills, tools, projects, and navigating challenges.
 • Olga Berezovsky
Sunday Q&A: When Great Work Goes Nowhere
Becoming proficient in experimentation, navigating consulting, positioning for promotion, and dealing with the frustration of unused work.
 • Olga Berezovsky
Analysis for Optimal Cadence and Frequency - Issue 276
Bringing data science into marketing analytics: How to locate the right frequency for upsells, ad impressions, or push notifications
 • Olga Berezovsky
Sunday Q&A: How Teams Fail Themselves - Issue 275
A reader’s story about impossible expectations, the path to becoming an analyst, and actionable retention reporting.
 • Olga Berezovsky
Rethinking A/B Testing for B2B and SaaS - Issue 274
Lessons from StatSig on best practices of designing and running experiments in B2B
 • Olga Berezovsky
Sunday Q&A: When Metrics Get Messy
Revenue modeling, stakeholder engagement, and the pitfalls of root cause frameworks.
 • Olga Berezovsky
Recommendations
View all 18
The VC Corner
The VC Corner
Ruben Dominguez
Data Gibberish
Data Gibberish
Yordan Ivanov
Cautious Optimism
Cautious Optimism
Alex Wilhelm
The Founders Corner®
The Founders Corner®
Ruben Dominguez
Python and Data Analysis Insights
Python and Data Analysis Insights
Benjamin Bennett Alexander
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
© 2025 Olga Berezovsky
Privacy ∙ Terms ∙ Collection notice
Start writingGet the app
Substack is the home for great culture