Data Analysis Journal

Refresher on SQL for Data Analysis - Issue 238

SQL solutions for data analysis, ad hoc, and modeling.

Dec 25, 2024 • Olga Berezovsky

21

December 2023

Parsing Semi-Structured Data In SQL - Issue 177

How to process and work with JSON formats via SQL in Snowflake

Dec 20, 2023 • Olga Berezovsky

5

October 2023

SQL For Weekday Product Usage Analysis - Issue 166

How to get the frequency of user engagement in SQL: day of the week analysis

Oct 11, 2023 • Olga Berezovsky

7

2

September 2023

A Selection Of SQL Tutorials - Issue 163

A roundup of my favorite free SQL tutorials to get started with or advance at querying

Sep 27, 2023 • Olga Berezovsky

36

2

July 2023

Top 10 Advanced SQL Functions For Data Analysis - Issue 151

A roundup of helpful SQL functions to leverage for statistics, data generation, processing, and analytics.

Jul 5, 2023 • Olga Berezovsky

18

2

May 2023

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

May 10, 2023 • Olga Berezovsky

8

April 2023

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.

Apr 26, 2023 • Olga Berezovsky

38

1

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

Apr 19, 2023 • Olga Berezovsky

17

4

March 2023

Getting Date Functions in SQL - Issue 136

A quick lookup one-pager for common DATE functions in SQL

Mar 15, 2023 • Olga Berezovsky

7

February 2023

When Simple Becomes Tricky: SQL CASE Statement - Issue 132

How to apply CASE conditional expressions to specify a result when there are multiple conditions.

Feb 15, 2023 • Olga Berezovsky

5

How To Measure Your Adjacent Users - Issue 130

A practical guide on how to locate and measure a tricky product persona of adjacent users in SQL, and challenges of getting such analysis in product…

Feb 1, 2023 • Olga Berezovsky

10

December 2022

How To Get Randomly Distributed Users in SQL - Issue 123

Some simple and quick ways to apply sampling techniques for your analysis to get random users.

Dec 14, 2022 • Olga Berezovsky

6