This week’s challenge was a challenge aimed at practicing multiple joins/merges with filtering. There was an issue I had (that may have been me honestly). I was having issues with the account numbers not merging correctly. I explained what my issue was and what...
So this challenge was another intermediate challenge. Unpivot was the main trick to get the data lined up and I walk you through that in the video. One thing to note is that a lot of times conceptually it may be easier to break up your tables and solve issues in a...
There has been a lot of news lately about corporate layoffs. It is a tough thing to hear about and obviously much worse if you are affected. A while back Tim Blaisdell during one of our internal meetings asked about how we could connect folks with jobs better. Out of...
So for this challenge, the same dataset was used, but more tricks were needed. There was a number of groupings that needed to be done, some joins, a nested table… yeah. It definitely kicked up a notch! Here is the video walkthrough: Preppin’ Data 2023 Week...
We had a great call with Doc Elder, who has been a great advocate and teacher to veterans over his long career in analytics. The video recording of the call is posted below in case you missed it. Doc provided a great presentation that distilled what to look for jobs,...
