              Data Analysis Journal

                  SubscribeSign in
                  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?
                          Jun 29, 2020 • Olga Berezovsky
                                  99
                                3
                                4
                              30 Must-Read Books to Become a Better Analyst or Data Scientist - Issue 320
                              A reading list for analysts and data scientists working at the intersection of data, product, and decision-making.
                              Jun 17 • Olga Berezovsky
                                    4
                              Omni: The Better Looker, or Just Another Expensive BI Tool? - Issue 319
                              A deep dive into Omni’s semantic layer, BI-as-code workflow, customer feedback, AI features, and where the tool still falls short.
                              Jun 10 • Olga Berezovsky
                                    18
                                  1
                              Figuring Out Chaos. Now What? - Issue 318
                              May recap: How teams are trying to make decisions when the old playbook no longer works
                              Jun 3 • Olga Berezovsky
                                    9
                              10 Data Concepts Analysts Use Every Day - Part 2 | Issue 317
                              From academia to industry: the core analytical principles for separating signal from noise.
                              May 27 • Olga Berezovsky
                                    18
                        Most Popular
                      View all
                                  My Consulting Journey: $0 to $685K in 6 months - Issue 232
                                  Nov 13, 2024 • Olga Berezovsky
                                    106
                                  4
                                  3
                                  10 Must-Know Concepts Every Analyst Should Know - Issue 290
                                  Nov 12, 2025 • Olga Berezovsky
                                    49
                                  5
                                  Refresher on Retention - Issue 236
                                  Dec 11, 2024 • Olga Berezovsky
                                    34
                                  1
                                  How To Pull Stories From Data and Make Them Actionable - Issue 251
                                  Mar 26, 2025 • Olga Berezovsky
                                    32
                                  3
                                LatestTopDiscussions
                                      When AI Agents Become Users: Rethinking Analytics Tracking - Issue 316
                                      Navigating analytics for AI agents: tracking conversations, testing prompts, and optimizing products in real time.
                                      May 20 • Olga Berezovsky
                                            4
                                      How Asana Found $40M in Recoverable Revenue - Issue 315
                                      A product analytics case study on false churn - and how Asana turned user removals into a $40M product decision - guest post by Kuber Jain
                                      May 13 • Olga Berezovsky and Kuber Jain
                                            13
                                      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.
                                      May 6 • Olga Berezovsky
                                            11
                                      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.
                                      Apr 29 • Olga Berezovsky
                                            14
                                      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.
                                      Apr 22 • Olga Berezovsky
                                            18
                                          4
                                          2
                                      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
                                      Apr 15 • Olga Berezovsky
                                            8
                                      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.
                                      Apr 8 • Olga Berezovsky
                                            8
                                      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.
                                      Apr 1 • Olga Berezovsky
                                            20
                                          1
                                      What AI Terms Mean for Analytics - Issue 308
                                      The key BI and analytics AI glossary shaping analytics, data workflows, and decision-making.
                                      Mar 25 • Olga Berezovsky
                                            9
                                          1
                            See all
                                Data Analysis Journal
                                Where product, data science, and analytics intersect.
                                  Subscribe
                                Recommendations
                              View all 9
                                      The VC Corner
                                      Ruben Dominguez
                                      Stat Significant
                                      Daniel Parris
                                      Genuine Impact - Because your money deserves better
                                      Genuine Impact
                                      Learn Analytics Engineering
                                      Madison Mae
                                      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

                      Subscribe
                  AboutArchiveRecommendationsSitemap
            © 2026 Olga Berezovsky · Privacy ∙ Terms ∙ Collection notice
            Start your SubstackGet the app
            Substack is the home for great culture