About | Personal website of Amit Grinson. Data Analytics & Visualizations

So who am I

As you’ve noticed, I’m Amit Grinson (Levinson), a Risk Data Analyst @ Payoneer. I currently live with my wife Tal, our boy Tom and dog Milo in Rehovot, Israel.

I’ve come across the R programming language during my MA in Sociology, actually by chance, and have been hooked on it since. I love the R community, data visualization challenges and more recently other languages such as SQL, Python and doing baby steps in JS.

That’s also what I blog about here. It could be curious questions I came across (such as probability, text-analysis) or challenges I faced somewhere, solved them and would like to share them with my future self or you.

Hope you enjoy your visit and again, reach out so I can get to know you better 😄

Blog & Thoughts

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

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