Hi There, Welcome!
Welcome to my personal website, very glad you’re here and interested in learning more about me. Do reach out and introduce yourself, I’d like to meet you too!
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
Read moreFollowing 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
Read moreText 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.
Read moreProjects & Exploration
Queries from my daily work
Website containing various SQL Challenges from my daily work as a Data Analyst
Read moreAssorted Landing pages
Various landing pages I built to practice HTML, CSS and basic JS
Read moreIsraeli Elections Twitter-bot
Twitter bot setup on a Raspberry Pi running every 10 minutes
Read moreTalks that Last
The Joys of an unconventional Portfolio
Translating unconventional data analytics projects to resources and value I can bring to the team.
Read moreCommunity Visualization Challenges and their Educational Inspiration
The great things about Data Visualization Challenges
Read moreLearning GIS with ice-cream parlors.
How I learned GIS by exploring ice-cream parlors.
Read more