Data Analysis Journal

I write about data analysis, data science, and business intelligence.

Editors
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

No reviews, submit yours below.
Add review

Login to submit your review.