Data Analysis Journal
Subscribe
Sign in
Home
Notes
Product Analysis
A/B testing
What experts say
SQL
Python
Machine Learning
Archive
Leaderboard
About
Latest
Top
Discussions
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
Share this post
Parsing Semi-Structured Data In SQL - Issue 177
dataanalysis.substack.com
Copy link
Facebook
Email
Note
Other
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
Share this post
SQL For Weekday Product Usage Analysis - Issue 166
dataanalysis.substack.com
Copy link
Facebook
Email
Note
Other
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
33
Share this post
A Selection Of SQL Tutorials - Issue 163
dataanalysis.substack.com
Copy link
Facebook
Email
Note
Other
2
August 2023
SQL And Python Mistakes To Avoid - Issue 155
Don’t repeat my mistakes. Learning from common errors and how to avoid them
Aug 2, 2023
•
Olga Berezovsky
9
Share this post
SQL And Python Mistakes To Avoid - Issue 155
dataanalysis.substack.com
Copy link
Facebook
Email
Note
Other
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
17
Share this post
Top 10 Advanced SQL Functions For Data Analysis - Issue 151
dataanalysis.substack.com
Copy link
Facebook
Email
Note
Other
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
9
Share this post
How To Get Average Logins Per User Per Day - Issue 143
dataanalysis.substack.com
Copy link
Facebook
Email
Note
Other
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
34
Share this post
A Selection Of SQL Tutorials - Issue 141
dataanalysis.substack.com
Copy link
Facebook
Email
Note
Other
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
15
Share this post
How To Pass A SQL Interview For A Data Scientist Position - Issue 140
dataanalysis.substack.com
Copy link
Facebook
Email
Note
Other
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
8
Share this post
Getting Date Functions in SQL - Issue 136
dataanalysis.substack.com
Copy link
Facebook
Email
Note
Other
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
6
Share this post
When Simple Becomes Tricky: SQL CASE Statement - Issue 132
dataanalysis.substack.com
Copy link
Facebook
Email
Note
Other
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
Share this post
How To Measure Your Adjacent Users - Issue 130
dataanalysis.substack.com
Copy link
Facebook
Email
Note
Other
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
7
Share this post
How To Get Randomly Distributed Users in SQL - Issue 123
dataanalysis.substack.com
Copy link
Facebook
Email
Note
Other
Share
Copy link
Facebook
Email
Note
Other
This site requires JavaScript to run correctly. Please
turn on JavaScript
or unblock scripts