Raw Data with Rob Collie22 Marras 2022

Something Bigger than Yourself, w/ Microsoft's Miguel Escobar

Today, we reunite two old friends with a penchant for writing books for people adjacent to tech as we welcome Miguel Escobar to the show. If you use Power Query or Power BI, you might have heard of Miguel. He is the co-author of several books on Power Query, Power BI, Power Pivot, and DAX. He is also part of the expert trifecta that created Skill Wave training and he is now an integral part of Microsoft working to make Power Query better for all users. He and Rob reminisce about book deals, DAX, training, and writing in a voice for the people, instead of for the tech giants. But, most importantly, you get the inside scoop on the data-cleaning drudgery that was Excel and analytics before the DAX and Power Query data revolution.

Miguel and Rob trade entertaining stories of how Excel gives people a competitive edge in the job market but somehow remains a fundamentally underappreciated skill during the educational years. After all, it's not just about the tool, what matters is what people do with it, how they use it, and how it has changed the trajectory of their careers. After hearing a few of these stories, you're going to want to send a tweet to Tom to encourage him to finally admit that Power Query deserves a spot in the Software Hall of Fame.

This episode isn't all about Power Query, though as we also learn a little about the eclectic taste in music our hosts share as well as some interesting tidbits regarding songwriting and the musical process. Miguel opens up about his passion for music and composition as he shares some personal insight into the process of collaborating and creating music in the digital world. If you listen closely, you can even hear some of his work spliced into this podcast in a musical first for us. Of course, you can hear Miguel's song: Someday, Somehow (feat. Chris Cron) in its entirety across multiple musical platforms. Be sure to give it a listen and share it with a friend.

As always, if you enjoyed this episode, be sure to leave us a review on your favorite podcast platform to help others find us.

Also in this episode:

Good Will Hunting – I don't understand the piano

Jerry was a race car driver

Miguel Escobar: Geo Flow using Panama's Census Data

DAX formulas for power pivot: A Simple Guide to the Excel Revolution

Major Key / Minor Key culturally different

Box Office Mojo

Mr. Excel

M is for (Data) Monkey

Bell Biv DeVoe

Johnny Cash: Hurt

Blues Traveler: Hook

Rocksmith

Guitar Pro

Power Query online

Software Hall of Fame Podcast

Power Query Saves Christmas w/ Gus Miranda

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