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
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
Going over various cases of text operations in a data analysis flow, showing how to solve it with R/Python compared to SQL.
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.
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
Solving an SQL interview question using three different approaches.
Exploring maps and distances to various Golda ice-cream locations throughout Israel
a light introduction to GitHub Actions for automating a plot of frequently used R packages.
Looking back at my year of learning R
Aestheticaly printing descriptive variables from your survey data
- ← Newer
- 1 of 2
- Older →