Preppin’ Data 2023 Week 7 – With Power Query!

Preppin’ Data 2023 Week 7 – With Power Query!

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...
Preppin Data 2023 Week 6 – With Power Query!

Preppin Data 2023 Week 6 – With Power Query!

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...
Finding Jobs with Google and Python and … TikTok?

Finding Jobs with Google and Python and … TikTok?

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...
Preppin’ Data 2023 Week 5 – With Power Query!

Preppin’ Data 2023 Week 5 – With Power Query!

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...
VA TUG Call Video and Slides – January 2023

VA TUG Call Video and Slides – January 2023

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,...
Bitnami