Project Overview As a Data Analyst who writes a lot of SQL, I find myself coming across challenges I solved that I’d love to share with others. This project (the website) is exactly that — Analytical challenges I encountered in work that required solutions with SQL. For each challenge I provide the questions, data that can be locally created, the solutions and a video I recorded going over the answer.
Website containing various SQL Challenges from my daily work as a Data Analyst
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.