Data Analysis Journal

Home
Product Analysis
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
2
How to do linear regression and correlation analysis
Steps, methods, tools, and use cases for locating predictable user actions and improving retention
Published on Lenny's Newsletter • 
What Is the Best Advice You Have Ever Received? - Issue 145
What advice changed or transformed your career? Take some advice from analytics industry leaders.
 • 
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 Pass A SQL Interview For A Data Scientist Position - Issue 140
 • Olga Berezovsky
The Ultimate Guide On Churn Reporting (And Its Technicalities) - Issue 138
 • Olga Berezovsky
2
Applying ML in Product Analytics - Issue 131
 • Olga Berezovsky
3
New
Top
Community
Introduction To Problem-Solving And Critical Thinking - Issue 144
The basics of analysis - steps of the analytical process, main techniques, and methodologies for informed decision-making.
 • 
Olga Berezovsky
How To Get Average Logins Per User Per Day - Issue 143
SQL solution for getting average user activity per day for weekly or monthly reporting
 • 
Olga Berezovsky
Introduction To Event-Based Analytics - Issue 142
Or: how to set up your events-based tracking for product analytics
 • 
Olga Berezovsky
1
A Selection Of SQL Tutorials - Issue 141
A roundup of my favorite free SQL tutorials and articles to either get started with or to keep your querying skills strong.
 • 
Olga Berezovsky
1
How To Pass A SQL Interview For A Data Scientist Position - Issue 140
A case study challenge breakdown for a data scientist position solved in SQL
 • 
Olga Berezovsky
Do You Over-Report DAU? - Issue 139
Yes if you use Sessions. Why measuring app activity is tricky, and how to best capture user engagement to report accurate DAU and MAU
 • 
Olga Berezovsky
The Ultimate Guide On Churn Reporting (And Its Technicalities) - Issue 138
Everything about churn in SaaS - how to calculate churn rate, the best way to report it, how it is connected with retention, and how not to get lost in…
 • 
Olga Berezovsky
2
Introduction To Analytics Engineering
How analytics engineering is changing the data landscape and what you need to know to keep up with the industry - a guest post by Madison Schott.
 • 
Olga Berezovsky
 and 
Madison Mae
2
Getting Date Functions in SQL - Issue 136
A quick lookup one-pager for common DATE functions in SQL
 • 
Olga Berezovsky
Data Analysis Journal
Data Analysis Journal
Where product, data science, and analytics intersect. Trusted by thousands of analysts and data scientists around the world
Recommendations
View all 11
Data Engineering Central
Data Engineering CentralDaniel Beach
data beats
data beatsArpit Choudhury
SeattleDataGuy’s Newsletter
SeattleDataGuy’s NewsletterSeattleDataGuy
Sunday 1-1-2-3 with George
Sunday 1-1-2-3 with GeorgeGeorge Nurijanian
Data Dives from Dataphyte
Data Dives from DataphyteDataphyte
Checklists
A/B Test ChecklistA short guide to product experimentation steps and must-know terminology.
SQL Date-Time CheatsheetA short guide to steps, solution, and must-know terminology
Python Pandas DateTime Reference GuideA short guide to solutions and tips for handling DateTime cases in Python Pandas
Subscription Growth Metrics ChecklistA short guide to steps and must-know terminology
Tutorials
A Selection Of SQL TutorialsA 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 AnalystsA 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