UnpivotShow
Light-hearted discussion about Excel and Power BI - aimed at the business users of the world
QOTW: What Personal Projects have use built with Excel or Power BI Other nonsense: 🖥️🖥️🖥️ How many MONITORS is too many? 👰🏻♀️💍Weddings! 👮🏻🎶 Theme Tune Copyright Violation 🐿️ Is AI diverting us to lower priority activity? 🆑Power BI Bookmark Bliss with Claude Code? 🎼🎸Macro Chords 🐕Pomeranian Technique 🚽Schrodinger's Toilet Unpivot Show Links Page Hosts Wyn Hopkins, Mark Proctor, Sue Bayes and Giles Male.
Special Guest Rob Collie New Book: Fair Game 🟢 Working on the Excel Team 📖 The Original Power Pivot Book 🚿 Fawcett First 🤖 Customising AI 📖 Rob's new book: FAIR GAME 🧐 Hoity Toity Agentic Agents Unpivot Show Links Page Hosts Wyn Hopkins, Mark Proctor, Sue Bayes and Giles Male.
QOTW: Where Do You Start with AI? Special Guest Fay Bordbar Other nonsense: 🏄🏻♂️ Mark's away and we've got Fay 🐟 Start Small and Snowball 🎯 You're Not as Far Behind as You Think 💰 The Hidden Cost of AI ( burnt dinners? ) 🧠 Data Literacy Before AI Hype 🤖 Agents, Copilot and Automation ⚠️ The Promise and Risk of Vibe Coding 📊 AI for Finance and Budgeting 🔍 Semantic Models and Business Context 🛠️ VS Code, GitHub Copilot and MCP Servers Unpivot Show Links Page Hosts Wyn Hopkins, Mark Proctor, Sue Bayes and Giles Male.
QOTW: What does success look like on Excel and Power BI projects? Other nonsense: 🎉 Hitting 1,000 YouTube subscribers Mark's break dancing outfit 🍻 Lithuania trip and alcohol consumption facts 🏷️ Excel name tag fail at a spreadsheet event ⚽ World Cup Permissions 🕵️ Fraud and impersonation targeting content creators 📋 Custom skills in Excel Copilot 💸 Microsoft's confusing Copilot credit pricing (CCCUs) 🪓Prompting in Mandarin to save tokens 🤖 AI auditability and safety concerns 🐹 Lemmings nostalgia ❓ Fabric's SharePoint-to-Delta-table feature 🎂 Two years of the podcast 🤫 Mystery guest teased for next episode Unpivot Show Links Page Hosts Wyn Hopkins, Mark Proctor, Sue Bayes and Giles Male.
Special Guest : Deb Ashby TIKTOK QOTW: What is Cowork and Credits? Plus, we go off on tangents (as usual) 🎥 Camtasia tips 💡 Solving long-standing problems 🛍️ Ultimate goodie bags 😧 Forgetting you already did it… 10 months ago! ⏰ All managers wait until 5PM 🚐 Excel NOT On The Road 🔥 Burning tokens 😨 Tech company FOMO Unpivot Show Links Page Hosts Wyn Hopkins, Mark Proctor, Sue Bayes and Giles Male.
QOTW: What are the first things you do on a new project? Plus, the usual banter: 🤖 Copilot, Fable and real-world experience 🏃🏻♀️➡️Dartmoor Run 📺TV Recommendation - Man on Fire TV Series ( Netflix ) 📗Book Recommendation https://markjdawson.com/books/john-milton-series/ 😴🥱 Value-gate, the pod's worst discussion since Wire-gate ( sorted numbers totalling differently ) 🐏Chopped Mutton? https://tableandspoon.com/why-do-people-use-the-phrase-chopped-liver/ 🗣️ Welsh / Australian / South African ? 📷Camera Fail Unpivot Show Links Page Hosts Wyn Hopkins, Mark Proctor, Sue Bayes and Giles Male.
🗣️🔥The Excel v Power BI debate re-ignites! QOTW: How was the Global Excel Summit? Plus, the usual banter: 🕺🏻Giles learns some moves 📏How tall was Wyn? 🍫🐧 Tim Tams vs Penguins 🚨Hotel Alarms 🍳Is 3 breakfasts in a day too many? 🎤Mark's Magic Mic trick 🙎🏻♀️ Is Julie truly that unruly? 🎵We'll meet again... Unpivot Show Links Page Hosts Wyn Hopkins, Mark Proctor, Sue Bayes and Giles Male.
🌏Global Excel Summit: UNPIVOT for 10% off QOTW: What’s the thing that took you the longest to understand? Plus, the usual banter: 🏃♀️ Marathons x 2 🏫 Global Excel Summit 🗣️ Greeting strangers at conferences 😮 Dragging & clicking the formula tooltip 🖱️ Click tax 🥱 Nobody cares how you built it …(and definitely nobody cares about instructions) 🚀 JFK’s moon goal wasn’t ambitious enough 🦁 Excel people are solo animals 🐧🍫 Tim Tams vs Penguins Unpivot Show Links Page Hosts Wyn Hopkins, Mark Proctor, Sue Bayes and Giles Male.
🌏Global Excel Summit: UNPIVOT for 10% off QOTW: Why is Power Query so important? Other Topics 5️⃣0️⃣ Episodes! ✈️🏃🏻♀️➡️ Boston Sue is 24537 : https://www.baa.org/b-a-a-mobile-app/ ✈️🏃🏻♀️➡️ London Sue is 15315 : https://www.londonmarathonevents.co.uk/london-marathon/tcs-london-marathon-app 🤫🕵🏻 Secret News 🤑💰Why Giles isn't rich 🦹🏻👎🏻Content Theft 😟⬇️Wyn's AI Downer The Alibaba Incident The Mythos escape ⚰️🪦Excel is Dead - again 🔂🔂 LinkedIn 3W Reposting 🧑🏻✈️💲Copilot Cost in Power BI Ⓜ️📉Dataflow Deprecation? 🕒🤬Wait before ranting? Folks to follow Anne Walsh Bill Jelen Geoff Robinson Kevin Lehrbass Jessica S Unpivot Show Links Page Hosts Wyn Hopkins, Mark Proctor, Sue Bayes and Giles Male.
💖 Link for Sue's fundraiser 🌏Global Excel Summit: UNPIVOT for 10% off QOTW: Q1 Review - did we achieve our goals? Other Topics ⏱️Tardy Giles 👟Super Shoes 🤦🏻♂️Mistakes bring us joy 🧢Merch! 🧑🏼🤝🧑🏼Sloppelgangers 🚗Driving Instructor Respect ✈️The Fighter Pilot Fallacy 🪟Frameworks Folks to follow Zoe Douglas Laura Graham- Brown Richard Sumner Craig Hatmaker Unpivot Show Links Page Hosts Wyn Hopkins, Mark Proctor, Sue Bayes and Giles Male.
QOTW: Should the focus be on 100% accuracy or directionally correct reports? Other Discussions 🏃🏻♀️➡️Running until June 🚙Gile's has never filled up with gas before! 🪙Do CFO's actually care about AI? 📈Mark and Giles get worried about the Power BI v Excel debate ⏩Is not keeping up actually a life hack 🤖Claude Code back story https://youtu.be/PQU9o_5rHC4 Folks to follow Chris Webb - https://blog.crossjoin.co.uk/ George Mount - https://stringfestanalytics.com/ Karen Abecia - https://karenabecia.github.io/dashboards/ Eugene Meidinger - https://www.sqlgene.com/ 🧢👕Unpivot Merch 🌏Global Excel Summit: UNPIVOT for 10% off Unpivot Show Links Page Hosts Wyn Hopkins, Mark Proctor, Sue Bayes and Giles Male.
Topic of the Week with pop-up guest Fay Bordbar: What are Copilot Agents? Other Discussions 📡Giles StarLink success & falling back into the LinkedIn rant-wagon 💰For who the Road Tolls - it's Mark! 🌳ChatGPT shows its caring side to Sue and she finds 100GB of Storage to free up 📷Wyn's webcam fail Folks to follow: Chandeep Chhabra Fay Bordbar David Kofod Hanna Damian Bird 🔗Other Links Mentioned Tree Size: RefTree Analyzer ( mistakenly referenced, but great tool! ): LinkedIn Rant 🧢👕Unpivot Merch 🌏Global Excel Summit: UNPIVOT for 10% off Unpivot Show Links Page Hosts Wyn Hopkins, Mark Proctor, Sue Bayes and Giles Male.
Question of the Week: Do you struggle to learn and what tips do you have? Folks to follow: Mike Girvin Kurt Buhler Matt Brattin Peeraya Apiwat Warning: May Contain Traces of Technical Content 🏊🏻♂️Ice Swims 🔥Heated Blankets 💓Is $130 expensive? 🤔Can't even say Ontology 🖨️Do you print anything? ⁉️No QAT? 🧢👕Unpivot Merch 🌏Global Excel Summit: UNPIVOT for 10% off Unpivot Show Links Page Hosts Wyn Hopkins, Mark Proctor, Sue Bayes and Giles Male.
Wyn is back with tales of KitKats from Japan, Sue is away bathing in Ice Lakes, Giles is gearing up for life in a Campervan, and Mark is still not happy with =IMPORTCSV Worth a follow: Andy Cutler Andrew Moss Hilary Smart Question of the Week: Can Anyone Learn Excel and Power BI And then... 🚽 Phantom Toilet seats 🐙 Takoyaki 🚅Trapped on a Train 🚙 Giles on Tour 🔓 Unlocking Spreadsheets 🎣 Not Biting on LinkedIn 🔢 Versions in Excel Unpivot Show Links Page Hosts Wyn Hopkins Mark Proctor and Giles Male ( absent Sue Bayes )
This week we have special guest Dim Early - the reigning Excel World Champion - who took part in our new feature called “If you could ask any question to the Excel World Champion what would you ask? But since you’re not hear we’ll ask on your behalf”. It’s not a catchy title but it is descriptive 😁 Plus, we had Question of the Week: To be an expert, what’s more important, depth of knowledge of breadth of knowledge. And there where the usual set of unexpected revelations 🎤 Mic drops 😡 New feature rant 🏃♀️ Running 51 miles in a week ➕ 99.5 is NOT 100 🍄 Mushrooms of knowledge 🚙 Back on the road again Unpivot Show Links Page Hosts Mark Proctor, Sue Bayes and Giles Male ( absent Wyn Hopkins, )
Question of the Week: 2026 Plans and coping with back to work blues. 🧢👕Unpivot Merch 🌏Global Excel Summit: UNPIVOT for 10% off Warning: May Contain Traces of Technical Content 🍫🪓Chocolate Chisels ❄️Snow 🚃Stockholm 🛷 Stair Sledging 🦒Australian Christmas 🛞Wagon Wheels 🎯Long Distance Darts 😰January Blues 🤔2025 Review Unpivot Show Links Page Hosts Wyn Hopkins, Mark Proctor, Sue Bayes and Giles Male.
Watch on YouTube: YouTube Live Question of the Year: Highlights and Lowlights of 2025 plus hopes for 2026 🧢👕Unpivot Merch 🌏Global Excel Summit: UNPIVOT for 10% off Quiz of the year SharePoint Full Marathon Qualifiers Struggling with top 10 Features Die Hard Try Harder Unpivot Show Links Page Hosts Wyn Hopkins, Mark Proctor, Sue Bayes and Giles Male.
Question of the Day: When you open a file what are the Red Flags 🚩 that indicates it wasn't created by an expert? Special Guest Cristian Angyal https://www.linkedin.com/in/cristian-angyal/ 🔄️ Will Online Schedule refresh ever come to Excel? 🔏 Password Weakness in Excel 👉🏻 SharePoint List Refresh speed up 🐍 Python in Google https://colab.google/ 🚩Any File not created by Mark 🧢👕Unpivot Merch 🌏Global Excel Summit: UNPIVOT for 10% off
Question of the Week: What are Best Practices you ignore? 🧢👕Unpivot Merch 🌏Global Excel Summit: UNPIVOT for 10% off Be prepared for some shocking confessions: 📅 Wyn doesn’t set date tables 🧮 Giles abandons simple formulas ➡️ Mark uses Merge & Centre 🧹Sue leaves unused measures to collect dust Plus, there the usual unexpected revelations: 🙎♂️ Mansplaining remains un-explained 📋 Ontology becomes an everyday word 🎄 Who gets invited to Christmas parties? 🥊 Power BI vs Excel… Bring it on. 🛌 Stickering a hotel room 💻 Is Export to Excel OK? Unpivot Show Links Page Hosts Wyn Hopkins, Mark Proctor, Sue Bayes and Giles Male.
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.