Power Query Saves Christmas w/ Gus Miranda

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

Jaksot(231)

Cowork Builds Apps Now, and 'Acquired Skills Will Appear Here' w/ Garett Medlin

Cowork Builds Apps Now, and 'Acquired Skills Will Appear Here' w/ Garett Medlin

Garett Medlin just got the official title for the job he was already doing: AI Practice Lead at P3. He's also the person responsible for Rob trying Cowork in the first place, despite Rob's very reason...

28 Huhti 56min

AI "versus" the Medical Establishment, Rob's Sith Name, and the Death of Social Media?

AI "versus" the Medical Establishment, Rob's Sith Name, and the Death of Social Media?

Rob didn't go looking for a fight with the medical system. He just showed up with receipts. Claude had already mapped the symptoms, suggested the tests, and summarized the situation better than any po...

21 Huhti 30min

Book PR, Fourth-and-One, the AI Knowledge Cliff, and LinkedIn WTF Moments

Book PR, Fourth-and-One, the AI Knowledge Cliff, and LinkedIn WTF Moments

Something shifted this year and you can see it in the reactions. Not to the technology. To people talking about it. Rob shared a screenshot on LinkedIn. CFO. Friday night. Using CoWork in real time. T...

14 Huhti 28min

How Claude Cowork is Helping a College Senior Boil the Job-Hunting Ocean

How Claude Cowork is Helping a College Senior Boil the Job-Hunting Ocean

The job hunt is a numbers game. The problem is, the numbers are brutal. Hundreds of applicants per role. Ghosted applications. "Entry level" jobs asking for experience no one at 22 could possibly have...

8 Huhti 46min

More Cowork Love, "Data Gene" Gets a Rebrand, Tiny Bottle, and the End of Wordpress

More Cowork Love, "Data Gene" Gets a Rebrand, Tiny Bottle, and the End of Wordpress

The work feels different now. You can hear it in this one. Something that used to feel like overhead suddenly starts pulling its weight. Not a demo. Not something you have to babysit. It's actually do...

31 Maalis 30min

Knowitall Doctors, Mac Keyboards, More Love for CoWork, and Maybe it was the Models After All

Knowitall Doctors, Mac Keyboards, More Love for CoWork, and Maybe it was the Models After All

Most AI still lives in the "that's pretty cool" category. It answers questions, writes a decent paragraph, maybe even points you in the right direction. And then you still have to go do the work. That...

24 Maalis 43min

Why CoPilot Cowork is a Big Deal

Why CoPilot Cowork is a Big Deal

Most people think they've already experienced AI. They've asked a chatbot a question, had it summarize something, maybe even draft an email. That version is useful, but it isn't the one that actually ...

17 Maalis 43min

Career Growth Curves and the Data Gene as the Answer to Everything

Career Growth Curves and the Data Gene as the Answer to Everything

Every once in a while a new tool shows up that bends the career curve for a certain kind of person. Not everyone. Just the people with that itch to poke at systems until they finally give up their sec...

10 Maalis 29min

Suosittua kategoriassa Liike-elämä ja talous

sijotuskasti
mimmit-sijoittaa
rss-rahapodi
psykopodiaa-podcast
hyva-paha-johtaminen
rss-oivalluksia-rahasta-elamasta
rss-rahamania
inderespodi
rss-lahtijat
ostan-asuntoja-podcast
rahapuhetta
oppimisen-psykologia
lakicast
rss-bisnesta-bebeja
rss-sisalto-kuntoon
rss-inderes
leadcast
mihin-sita-saastais
rss-rikasta-elamaa
rss-40-ajatusta-aanesta