Data Analysis Journal

Welcome to Data Analysis Journal

Go behind the scenes of genuine data analysis and data storytelling.

Data Analysis Journal is a weekly newsletter and advice column about data analysis, data science, and product analytics. Trusted by thousands of analysts and data scientists around the world, it aims to bridge the gap between academic knowledge and industry requirements.

I’m Olga, an analyst and data scientist. Born in Ukraine and based in San Francisco. I am a head of a product analytics team at MyFitnessPal and previously worked at Change.org, Microsoft, First Republic Bank, and quite a few big and small startups that paid me in knowledge and cookies. 

My superpower is that I pay a lot of attention to user engagement and behavior analytics by identifying product personas, developing quantitative and qualitative user profile analyses, building feature usage matrices, and proving relationships between user engagement and revenue. I have never seen revenue growth with low product usage and poor engagement. That’s why I closely watch the DAU/MAU ratio, user retention, and CPO state of mind.

In my free time, I usually stare coldly into foreboding time series charts until they permanently burn into my eyes. When I am not doing that, I write about all the data things people make me do at work with the hope to expand and advance analytics.

With over a decade of trial and error, I share what good or bad analysis practice is, what framework to use to best solve a challenge, what interviewers look for, how to hire the best talent, and how to successfully structure and grow data analytics teams.

You can find me on Twitter and LinkedIn.

When you subscribe to Data Analysis Journal, you will receive:

• SQL and Python solutions, interview questions, and guidance.

• Deep dives and analytical case studies.

• Data analysis project examples and walkthroughs.

• Examples of successful (and not really) A/B tests, rollout procedures, and their analyses.

• Insights from data analytics and data science industry experts.

• My frameworks and playbooks for analysis, reporting, metric calculations, test evaluations, and forecasts. 

What readers say

Popular post picks

Analytics

• The Top 10 Best Blogs To Read For Data Analysts

• Introduction To Event-Based Analytics

• How To Locate The Right Frequency Of Push Notifications

• What Statistics Are Used In Data Analysis?

• Ditch Tableau For God’s Sake. It’s 2021

• Decoding Regression Scores

• Applying ML in Product Analytics

Read more - Data Analysis Journal - Product Analysis

Metrics

• The Ultimate Guide To Churn Reporting

• SaaS Metrics Reporting: A Peek Behind The Curtain

• A Deep Dive Into User Engagement Through Tricky Averages

• Do You Over-Report DAU?

• How To Measure Your Adjacent Users

• Freemium vs Free Trial Analytics

• Analytical Case Study On User Engagement

Experimentation

• A/B Test Checklist

• Embracing the New Era of Accelerated Testing

• Playbook For Launching, Monitoring, and Analyzing A/B Tests

• How To Develop a Highly Trusted Experiment Analysis Workflow

• Build or Buy: How We Developed A Platform For A/B Tests

• Why You Shouldn’t Stop A/B Tests Early

Read more - A/B Testing

Python

• How To Pass A Technical Assignment For a Senior Data Scientist Position

• How To Install And Set Up Python

• Python For Data Science: The Difference Between Merge, Join, And Concat

• Top 10 Python Pandas Tips For Data Analysis

• Correlation Analysis 101 in Python

• A Selection Of Python Tutorials for Analysts

Read more - Data Analysis Journal - Python

SQL

• Top 10 Advanced SQL Functions For Data Analysis

• How To Pass A SQL Interview For A Data Scientist Position

• The Frequency Of User Activity: SQL and Analysis

• A Selection Of SQL Tutorials

• Ranking The Most Used Features in Your Product Using SQL

• The Frequency Of User Activity: SQL and Analysis

• Joining Two Tables That Are Not Related By A Foreign Key Relationship

Read more - Data Analysis Journal - SQL

Posting schedule

• Paid subscribers will receive one newsletter a week and get full access to the website along with my mentorship and support.

• Free subscribers will receive one newsletter per month.

Proceeds from subscriptions are donated to Ukrainian Children's Aid and Relief Effort charity.

If your company would like to purchase a group subscription at a discounted rate, click here:

Get a group subscription

I am giving a 50% discount to all active students and recent graduates → click here. You can also email me at olga@berezovsky.me with your university/school name to receive a discount.

If you are looking for a job, and can’t afford a paying subscription at the moment, please email me at olga@berezovsky.me, and I will set you up!

I love what I do, and my mission is to show you just how exciting and impactful data analysis can be.