Data Analysis Journal

Home
Notes
Product Analysis
A/B testing
What experts say
SQL
Python
Machine Learning
Archive
Leaderboard
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
1
November Digest: It’s Okay Not To Have All The Answers
Case studies, reports, analysis, and tutorials you may have missed.
 • 
Olga Berezovsky
 and 
timo dechau 🕹🛠
2
Inside Product Analytics: Decoding User Behavior - Issue 173
Introduction to Product Analytics: required skills, common projects, and navigating challenges.
 • 
Olga Berezovsky
Most Popular
View all
Introduction To Event-Based Analytics - Issue 142
 • Olga Berezovsky
1
What Statistics Are Used In Data Analysis? - Issue 126
 • Olga Berezovsky
How To Do a Root Cause Analysis - Issue 162
 • Olga Berezovsky
How Strava Accelerated User Engagement - Issue 161
 • Olga Berezovsky
Top 10 Advanced SQL Functions For Data Analysis - Issue 151
 • Olga Berezovsky
New
Top
Community
An Analysis Of Bias Or Why A/B Testing Fails - Issue 172
A recap of Stanford and Airbnb's collaborative paper on experimentation setup and analysis in two-sided platforms and marketplaces.
 • 
Olga Berezovsky
When To Use Mean Or Median - Issue 171
Working with descriptive statistics: how to know when to use Mean or Median in your reporting
 • 
Olga Berezovsky
From Event Collection To Behavioral Data Modeling
October Digest: Case studies, reports, analysis, and tutorials you may have missed
 • 
Olga Berezovsky
 and 
timo dechau 🕹🛠
When To Use Client-Side Or Server-Side Data - Issue 169
Setting up analytics - how to figure out which data source to use for reporting and analysis
 • 
Olga Berezovsky
Why Today Is The Perfect Time to Learn Data | Seattle Data Guy
Interviewing Seattle Data Guy - how to transition to data engineering, stay motivated, and break out of tutorial hell.
 • 
Olga Berezovsky
 and 
SeattleDataGuy
When Things Go South - Issue 167
Or why self-service is a myth.
 • 
Olga Berezovsky
SQL For Weekday Product Usage Analysis - Issue 166
How to get the frequency of user engagement in SQL: day of the week analysis
 • 
Olga Berezovsky
Applying Statistics In Product Analytics - Issue 165
Distributions 101: Introduction to statistical distributions, their types, use cases, and examples
 • 
Olga Berezovsky
September Digest: A Recap Of All Things Analytics
Case studies, reports, analysis, and tutorials you may have missed
 • 
Olga Berezovsky
 and 
timo dechau 🕹🛠
2
Data Analysis Journal
Data Analysis Journal
Where product, data science, and analytics intersect. Trusted by tens of thousands of data scientists around the world
Recommendations
View all 14
Pedram's Data Based
Pedram's Data Based
Pedram Navid
AI Supremacy
AI Supremacy
Michael Spencer
L
Learn Analytics Engineering
Madison Mae
Data Engineering Central
Data Engineering Central
Daniel Beach
timo's substack
timo's substack
timo dechau 🕹🛠
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
© 2023 Olga Berezovsky
Privacy ∙ Terms ∙ Collection notice
Start WritingGet the app
Substack is the home for great writing