Raw Data with Rob Collie1 Marras 2022

Power Query Saves Christmas w/ Gus Miranda

Today's guest, Gustavo Miranda, started his career in a research adjacent Program Evaluation position using Power Pivot Slicers in a non-Power Pivot table before he was introduced and lured by the power of the Power Platform. He shares his story of how reducing friction and creating automation introduced even non-data people to the concept that data quality matters. Most importantly, though, today you will learn the underdog story of how Power Query saved Christmas during the Kronos Hack of 2021. Get the inside scoop from crisis meeting to crisis meeting until the moment when Gus stood up to save the day. While Gus did the heavy lifting, a task force soon formed to collectively finish the project. While other multi-million-dollar companies were paralyzed, shocked, and attempting to ad-hoc calculate payroll and vacations, often incorrectly, Gus's task force used Power Query to create an effective solution in time to prevent employees from missing Christmas with their families. Even Tom must agree that tales like this really show the power of Power Query's ETL abilities.

Also in today's episode, we learn the origin story of slicers in Excel, how Rob and Amir were behind their creation by seducing the Excel team, trading resources, and creating the opportunity for Microsoft to back into needing a separate application to maximize the impact of those slicers. That application? Power BI desktop. In an exciting tale of what could have been, we also hear the story of the Power BI canvas in Excel that was never meant to be as well as the lessons learned: never try to add truly new capabilities to Excel or you end up with Power View. As our friend Scott Esti used to say there are two kinds of people in the world, people who hate Power View and those who haven't used it!

All this and more on today's episode! Be sure to leave us a review on your favorite podcast platform to help new listeners find us.

Also on this episode:

Nash Equilibrium / Prisoner's Delimma

The truth behind recycling

Program evaluation

He may only need his eyes checked ...

Calculation Groups in Power BI

Microsoft's Power View

Gilligan's Island theme song

Zeno's paradox

Gus's P3 Blog - Using Power Query to Transform and Combine Online Statscan Data

Matt Masson - Deep Dive Into the Power From the Language

Active v Inactive Relationships

Kronos hack disrupts payroll

Live action How the Grinch Stole Christmas

Live action Cat in the Hat

Abyss - Bomb at the bottom of the sea (Don't look Tom!)

Rumble in the Jungle George Foreman - Muhammad Ali

Guns and Roses – It's so easy

Blown Away – Tommy Lee Jones

Tommy Lee Jones Montage

Sankey (Diagram)

Fight Club - Corn Flower Blue

G Rated Fight Club

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(241)

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

The End of All You Can Eat AI

For about two years, we've all been reaching for the biggest hammer on the wall because someone else was paying for the nails. If you were on a subscription, you grabbed the biggest, baddest model on ...

30 Kesä 24min

Waiting Worked...Until AI

For years, Rob had a pretty good system. When a new technology showed up, he didn't immediately declare it the next big thing. He wanted to understand why it mattered first. Sometimes that meant jumpi...

23 Kesä 15min

Why Bigger AI Isn't Always Better

Microsoft just unveiled a monster of a machine built for local AI. More memory. More horsepower. More everything. Which led Rob and Justin to a question that has almost nothing to do with the hardware...

16 Kesä 29min

What Happens After the AI Works?

For the past few years, the conversation around AI has focused on the technology. Which model is best. Which tools to use. How fast everything is changing. But once you start building with it, a diffe...

9 Kesä 35min