Raw Data with Rob Collie7 Maalis 2023

Put Some Adventure On Your Taco, w/ Dan Battagin

Today's guest is Dan Battagin, a former program manager for Microsoft and the genius behind Adventure Taco! Dan has an impressive track record as the former lead developer of Microsoft's Power Query as well as experience with multiple other software programs. We're excited to have him on the show, especially since he only agreed to appear in order to learn about Rob's video background. But once the conversation gets going, you will realize that Dan has a wealth of expertise in data cleansing and transformation that we can all learn from.

As the conversation progresses, we also get a glimpse into Microsoft's hiring practices of the past. Remember those brain teasers and psychological questions that used to be all the rage? We discuss how these inane questions often resulted in great candidates being passed up, simply because they didn't fit into the expected answer patterns. Fortunately, times have changed and we get to hear the story of how Rob helped keep Dan on at Microsoft after his initial internship.

In addition, Dan brings with him stories of his internship at Microsoft and the stories of programs ending before their time. And, as frequently happens, the conversation takes a turn to DAX and unsurprisingly, Dan is another former Microsoft manager who is not a well-versed DAX user. As Rob points out, DAX is the most accessible language to come out of Microsoft which leads us to question why so few former employees embrace the magic.

All this and a few Lego and Age of Empire references you won't want to miss. And don't forget, if you enjoyed this episode be sure to leave us a review on your favorite podcast platform.

Also on this episode:

Brain Teasers for your next interview prep

Age of Empires

Ways to Fix Excel Not Recognizing Date Format

Adventure Taco

Fantasy Football

DAX Functions

Power Pivot and Power BI: The Excel User's Guide to DAX

Soda Machine Brain Teaser

12 Men on an Island Brain Teaser

LEGO Modular Buildings

Tämä jakso on lisätty Podme-palveluun avoimen RSS-syötteen kautta eikä se ole Podmen omaa tuotantoa. Siksi jakso saattaa sisältää mainontaa.

Jaksot(245)

AI and the Art of Building Backwards

There are two ways to build backwards. One starts with the answer you actually want and works its way toward the plumbing. The other starts with the plumbing and hopes the answer is in there somewhere...

29 Syys 29min

AI and the Rule Nobody Wrote

Rob has a lot of Claude folders now. One knows the book. Another knows the company planning. Others have picked up meeting notes, briefing docs, LinkedIn ideas, strategy work, and whatever else was us...

22 Syys 35min

Your Favorite AI Has a Moat Problem

For a minute there, it looked like the AI wars would come down to who built the smartest model. Rob's not buying that anymore. Take Claude. Rob's increasingly convinced that what makes Anthropic so st...

15 Syys 25min

Knowledge Is Having Its Data Moment

For years, businesses learned that having data and being able to use it are two very different things. We cleaned it, structured it, modeled it, argued about which version was the truth, and built ent...

1 Syys 22min

What is "Botsitting?" (plus: Data Agents Continue to Blow Our Minds)

There's a new word for what your team is doing with the AI you bought them. You're not going to love it. "Botsitting." Babysitting, but for bots. Journalists are suddenly all over it, and not one of t...

18 Elo 38min

Power BI Veterans React to the Fair Game AI Book

For most of tech history, the new thing belonged to the new people. Then AI showed up and ruined a perfectly good pattern. Because the smartest model on the planet can know darn near everything and st...

12 Elo 1h 24min

The Crafter's Edge with Pedro Rossello

There have always been people who can't help themselves. Give them a clunky process, a messy spreadsheet, or a problem nobody owns, and they're already halfway to building something better. Rob calls ...

4 Elo 1h 24min

Everyone's Priority. Nobody's Job

AI headlines have already moved on to the deep end. Most businesses haven't. Every week brings another headline about what's next for AI. Build your own model. Train your own LLM. Customize everything...

14 Heinä 32min