Trolls, Features and Common Data problems. In this chaotic episode of Unpivot, the gang kicks things off with Halloween antics and quickly spirals into the wild world of Excel, Power BI, and internet comment drama. From TikTok trolls who think Power Pivot lives in Access (spoiler: it doesn’t) to debates about whether picking pumpkins is just muddy shopping, it’s a rollercoaster of laughs and learning.
They also dive into juicy new features like visual calcs, agent mode, and formula-by-example, and share their favourite ways to handle messy data, missing dates, and the eternal mystery of “what does sales actually mean?”
Question of the Week: What are Common Data Problems you come across
🎃 What does "Pick your own" actually mean?
😡 Haters gonna Hate
👩💻 Lots of New Features in Excel and Power BI
📊 Visual calcs
🤔 Is Excel a database?
Unpivot Show Links Page
Hosts Wyn Hopkins, Mark Proctor, Sue Bayes and Giles Male.
--------
1:14:16
--------
1:14:16
More AI Hype and Modeling Mistakes to Avoid
Question of the Week: What are your top 3 modeling mistakes to avoid.
👾 10 Goto 20 - Reminiscing Coding and Games of the Past
😬 Mark feels like a spare part ( "I do not think that word means what you think it means")
😳 Giles suffers from foot-in-mouth disease
🤖 AI over-Hyped? Surely not?
🍫 Will chocolate ever be a healthy snack?
Unpivot Show Links Page
Hosts Wyn Hopkins, Mark Proctor, Sue Bayes and Giles Male.
--------
1:04:56
--------
1:04:56
Deb, Leila and the Humble MVP
Question of the Week: What shall we ask Deb and Leila?
🚩Red Flags
🦹Serial Killer Tips?
🤖 Excel Agent Mode
➡️ Swipe Right?
❓Excel Autocomplete
🏃♀️➡️ Is Speed Good?
🔢 Prompt Bingo
🍓Strawberry Laces
🩳Short Shorts?
🎛️ Video Editor Tips
Thanks to our special Guests
Deb Ashby Cellmates - YouTube
Leila Gharani https://www.youtube.com/@LeilaGharani
Links to regular hosts and other content
Unpivot Show Links Page
--------
1:05:54
--------
1:05:54
Conference and Networking Hacks
Question of the Week: What's your Conference and Networking tips / hacks?
🥨Vienna Fabcon
🤝All about the members
🗞️News - Dataflows Gen 2 and UDFs
😶🌫️ How to Enter and Exit a conversation
⌛ Time Capsule
Thanks to our sponsor 😆✈️Cabeau https://cabeau.com/products/evolution-s3-neck-pillow
Links to hosts and other content
Unpivot Show Links Page
--------
1:03:10
--------
1:03:10
Hardware Takes a Turn
Question of the Week: What's your favourite hardware?
⌚Tardy Giles
🎤 Rap Review
❎ Sue's XLOOKUP admission
⌨️Fn Backspace
🕜Sue's mysterious object
🤬Cross(ed) Wires - the most boring topic so far goes off!
⏲️ They call him Mark "High-Tech" Proctor
🦶🏻Foot Fans?
✈️Cabeau https://cabeau.com/products/evolution-s3-neck-pillow
Links to hosts and other content
Unpivot Show Links Page
UK