Data Analysis Journal
I write about data analysis, data science, and business intelligence.
Olga Berezovsky
Medieval Data Analyst | Blogger https://dataanalysis.substack.com/
Latest Posts
Day Of The Week Analysis in SQL
How to break down user activity by day of the week in SQL
Financial Forecasting 101: Why, When, And How
How and when to apply revenue forecasting for data analysis
User Engagement and Activity Histogram Analysis
User engagement and frequency of usage analysis using SQL
5 Mistakes To Avoid When Running A/B Tests
Common product test mistakes and a practical guide for successful A/B tests
How To Create Date Series in SQL
Advanced SQL challenge on how to generate a time series in Postgres or RedShift.
Correlation Analysis 101 in Python
How to read and run correlation plots in Python Pandas
Generating a Word Cloud In Python
Learn how to make a word cloud for text analysis
How Improving User Engagement and Retention Drives Revenue
Case study: how increasing user activity affects company revenue
User Activity Analysis In SQL
A common SQL problem solution and code walkthrough
SQL Date-Time Cheatsheet
A short guide to steps, solution, and must-know terminology
Reviews
Login to submit your review.