How To: Group by & Window Functions Together

A short overview of how to use window functions within a group by query. Going over 3 examples that help illustrate how to combine the two, as well as a better understanding the order of opertaions in SQL

Following users' funds and possible money layering using a recursive CTE

Though not commonly used, recursive CTEs can be a great tool to work with hierarchal formatted data. In this post we learn to use them to identify where money was moved to by following users transfer activities

Text Manipulation & RegEx in a Data Analysis Flow (with examples in SQL vs Python/R)

Going over various cases of text operations in a data analysis flow, showing how to solve it with R/Python compared to SQL.

Community visualization challenges and their educational inspiration (talk summary)

Summarizing the things I love about and learned from data visualization challenges as part of a talk I gave at the Israeli visualization conference, 2022.

R vs Python — Live Stream Analysis

Using both R and Python we answer various questions about the Dog of Zurich dataset. Try it yourself and get some hands-on data analysis practice

Reviewing an SQL interview question

Solving an SQL interview question using three different approaches.

Distances to Golda Ice-Cream Locations in Israel

Exploring maps and distances to various Golda ice-cream locations throughout Israel

Automatic Rendering of a Plot with GitHub Actions

a light introduction to GitHub Actions for automating a plot of frequently used R packages.

My year in R

Looking back at my year of learning R

Survey categorical variables with KableExtra

Aestheticaly printing descriptive variables from your survey data