Unpivot

Unpivot

Follow Unpivot
Share on
Copy link to clipboard

Light-hearted discussion about Excel and Power BI - aimed at the business users of the world

UnpivotShow


    • May 24, 2025 LATEST EPISODE
    • every other week NEW EPISODES
    • 1h 6m AVG DURATION
    • 27 EPISODES


    Search for episodes from Unpivot with a specific topic:

    Latest episodes from Unpivot

    Data Hall Of Fame

    Play Episode Listen Later May 24, 2025 66:57


    #Excel #PowerBI QotW: Who or What is in your Data Hall of Fame? Other chat: Trying to start the pod without Wyn Bike Thief #YouveBeenHumbled Giles Issue with Cheat Sheets explored Is it still worth writing blog posts? QotW Jingle Theft! Links to hosts and other content Unpivot Show Links Page Hosts Wyn Hopkins, Mark Proctor, Sue Bayes and Giles Male.

    Excel Updates Mini Pod May 2025

    Play Episode Listen Later May 16, 2025 35:39


    Mark and Giles do a mini pod discussing recent Excel updates including Copilot Copilot Dark Mode Copilot

    What is a Microsoft MVP & Is it all getting too complicated?

    Play Episode Listen Later May 10, 2025 73:35


    #Excel #PowerBI Please leave a 5 Star Review ⭐⭐⭐⭐⭐ QotW: What is a Microsoft MVP? Other chat: Is Excel getting too complicated? Deb's Marathon horror story Dogs and Chocolate DUREX ANDREX Links to hosts and other content Unpivot Show Links Page Hosts Wyn Hopkins, Mark Proctor, Deb Ashby and Giles Male. EVERYTHING SEARCH TOOLBAR https://www.linkedin.com/posts/brianjuliusdc_windows-tipsandtricks-search-activity-7187144578196492288-6SmG/

    Mini Pod - Power BI Updates April 2025

    Play Episode Listen Later May 3, 2025 30:21


    Wyn and Sue try out a shorter 2-person pod discussing recent Power BI Updates including Live edit of semantic models in Direct Lake mode in Desktop F2 Capacity now can use Copilot Style Presets PowerPoint Annotation File Picker and more...     April Blog: https://powerbi.microsoft.com/en-us/blog/power-bi-april-2025-feature-summary/ Azure Maps https://powerbi.microsoft.com/en-us/blog/power-bi-april-2025-feature-summary/#post-29602-_Toc195631038   #PowerBI

    The Value of Experience

    Play Episode Listen Later Apr 25, 2025 62:34


    #Excel #PowerBI Please leave a 5 Star Review ⭐⭐⭐⭐⭐ (if we've inspired you to do exercise) QotW: What Value does Experience Have? Other chat: Sue's Swag Becoming fitness influencers Editor's Note-gate Excel Speedrun Power BI course announcement Advanced vs beginner training challenges Merch and Staying Humble Links to hosts and other content Unpivot Show Links Page Hosts Wyn Hopkins, Mark Proctor, Sue Bayes, and Giles Male. Brian Julius DAX Helper https://www.linkedin.com/posts/brianjuliusdc_dax-ai-prompting-activity-7298279526210387968-qhHM/?utm_source=share&utm_medium=member_ios&rcm=ACoAAAJrY_QBWQHQpSN8U1UK8kGKjuTbZI0iCR4 Wyn's DAX GPT https://chatgpt.com/g/g-zCDnEznGt-dax-helper-by-access-analytic

    Livestream with Oz Du Soleil - what drives us to make changes?

    Play Episode Listen Later Apr 11, 2025 87:21


    #Excel #PowerBI Find Oz here: www.youtube.com/@OzduSoleilDATA Oz's songs (YouTube) Tin Man by America On and On by Stephen Bishop QotW: What Drives us to make changes Other chat: QUIZ! Oz goes deep Sue is late, but gets a song Mark meets his target Please leave a 5 Star Review  Links to hosts and other content Unpivot Show Links Page   Hosts Wyn Hopkins, Mark Proctor, Sue Bayes, and Giles Male.

    Time Quotes, 100k Subscribers and Black Box Lambdas

    Play Episode Listen Later Mar 29, 2025 63:27


    #Excel #PowerBI QotW: How to quote for work and estimate time. Other chat: What's the secret to 100K subscribers Are Lambdas a black box? Giles toys with occupational ruin. Sue is not happy with Mark Mark drops shade on Wyn's REGEX idea Please leave a 5 Star Review  Links to hosts and other content Unpivot Show Links Page   Hosts Wyn Hopkins, Mark Proctor, Sue Bayes, and Giles Male.

    Data Visualisation Choices in Power BI in Excel

    Play Episode Listen Later Mar 15, 2025 67:36


    Please leave a 5 Star Review ⭐⭐⭐⭐⭐ Links to hosts and other content Unpivot Show Links Page QotW: What data visualisation choices do you make? Other chat: Sue chats to everyone Mark chats to no-one Wyn geeks out over PowerToys Giles discusses his port-folio of news Hosts Wyn Hopkins, Mark Proctor, Sue Bayes, and Giles Male.  

    Jon Acampora, Shirts, Coding and things people get stuck on.

    Play Episode Listen Later Mar 1, 2025 73:09


    Special Guest:  Jon Acampora of Excel Campus Stay tuned to the end for bonus shirt count! QotW: Which features, techniques or concepts do most people get stuck on? How can we make it understandable? Other chat: Sue discovers the Automate tab in Excel Mark takes researching guests too far Jon reveals how many shirts he has Giles dances while cheat sheets fall from the sky Hosts Wyn Hopkins, Mark Proctor, Sue Bayes, and Giles Male. Links to watch and more Unpivot Show Links Page     #Excel #PowerBI

    Excel Summit, ABBA, and Presentation Tips

    Play Episode Listen Later Feb 15, 2025 81:59


      QotW:  What are you tips for delivering good presentations Other chat: Mark explains why he doesn't like Chris Webb Giles is sick but soldiers on Sue did DP700 exam and presentation Wyn needs to work on Irish names   Hosts Wyn Hopkins, Mark Proctor, Sue Bayes, and Giles Male.   Watch https://www.youtube.com/@Unpivot #Excel #PowerBI

    Copilot Fail and Work Life Balance

    Play Episode Listen Later Feb 1, 2025 63:47


      QotW:  Can we achieve Work Life Balance? Other chat: Commitments update Wyn rants about Copilot Giles gets invited onto a radio show during the recording Mark gets a new webcam Sue is getting ready for a BIG presentation Hosts Wyn Hopkins, Mark Proctor, Sue Bayes, and Giles Male.   Watch https://www.youtube.com/@Unpivot #Excel #PowerBI

    When does a business outgrow Excel and Power BI?

    Play Episode Listen Later Jan 18, 2025 66:33


      QotW:  Can majority of businesses run on Excel and Power BI alone? Commitments update Giles rants about LinkedIn copyright infringement What makes for good visuals At what point do you outgrow Excel Main Topic: Once again we ran out of time! Hosts Wyn Hopkins, Mark Proctor, Sue Bayes, and Giles Male.   Watch https://www.youtube.com/@Unpivot #Excel #PowerBI

    Should Power BI be part of Fabric - who is Fabric aimed at?

    Play Episode Listen Later Jan 4, 2025 60:56


    Main Topic: Should Power BI be part of Fabric? QotW: Goals / Resolutions  Christmas Catch up and New Year's resolutions We struggle with maths - How many pies per day does Mark need to eat, how many pounds in 15 stone Mark gets on a hobby horse Hosts Wyn Hopkins, Mark Proctor, Sue Bayes, and Giles Male.   Watch https://www.youtube.com/@Unpivot #Excel #PowerBI

    Christmas Livestream Uncut - Live and Unedited

    Play Episode Listen Later Dec 20, 2024 68:18


    More chaotic than normal and also unedited due to the livestream nature. Hope you enjoy it even if sound is not up to usual standard and some of the content makes more sense if watching. YouTube: https://www.youtube.com/live/T05qrByEarg?si=7QW3uaMwwYfYcFbC

    Chandeep Chhabra - Wow Factor Demos - Adapting when moving from Excel to Power BI

    Play Episode Listen Later Dec 7, 2024 87:43


    Thanks to special guest Chandeep Chhabra.   QotW:  What's your show off / wow factor demo / trick?  Main Topic: How to think about Power BI and DAX and the transition from Excel Power BI?   Hosts Wyn Hopkins,  Mark Proctor, Sue Bayes, Giles Male.   Watch https://www.youtube.com/@Unpivot #Excel #PowerBI

    The Diarmuid Early Episode. Competitions, Challenges and Productivity Toolkit recommendations

    Play Episode Listen Later Nov 26, 2024 71:49


    Thanks to special guest Dim Early   QotW: Does taking part in competitions and challenges help in the real world? If so… how? What skills do they not teach you? Main Topic: What are the best methods for building a personal toolkit for productivity?   Hosts  Mark Proctor, Sue Bayes, Giles Male.   Watch https://www.youtube.com/@Unpivot #Excel #PowerBI

    What features would you add to Excel or Power BI & Starting your own business

    Play Episode Listen Later Nov 10, 2024 82:39


    Mark lays down a challenge to who has the easiest dependent drop down list technique Giles is glad not to be in charge and has become a Lambda Lover Sue has run ANOTHER marathon! Wyn has an embarrassing rant online. QotW: What Features would you add to Excel?  Main Topic:  Motivations and Challenges of starting your own business   Mark's video on Easiest Dependent Drop Downs Wyn's video on Easiest Dependent Drop Downs Hosts Wyn Hopkins, Mark Proctor, Sue Bayes, and Giles Male.   Watch https://www.youtube.com/@Unpivot #Excel #PowerBI

    When are you an expert and are technical books still relevant?

    Play Episode Listen Later Oct 26, 2024 68:31


    ai relevant groot technical books
    Late to the Party and Presentation Tips

    Play Episode Listen Later Oct 12, 2024 66:06


    QotW:  What features were you late to discover but now love Main Topic:  Presentation Tips and tricks    Join the conversation on LinkedIn https://www.linkedin.com/company/the-unpivot-show Hosts Wyn Hopkins, Mark Proctor, Sue Bayes, and Giles Male.   Watch https://youtu.be/LNgzqrepyic #Excel #PowerBI

    Giles MVP Award and advice to your 20-year-old self

    Play Episode Listen Later Sep 27, 2024 56:43


    We also discuss Best Practice  Links mentioned: 1️⃣ Giles MVP award video 2️⃣ Spreadsheet Best Practice Rules 3️⃣ Question Of the Week on LinkedIn Hosts Wyn Hopkins, Giles Male, Mark Proctor and Deb Ashby   YouTube

    Essential Functions and when formulas go wrong

    Play Episode Listen Later Sep 14, 2024 69:47


    Links mentioned: Data Scotland: https://datascotland.org/ Chris Barber: https://www.starschema.co.uk/  Hosts Wyn Hopkins,, Sue Bayes, Giles Male, and Mark Proctor.   YouTube

    Excel and Power BI Dangerous Features and what to learn?

    Play Episode Listen Later Aug 30, 2024 63:53


    Welcome back Mark! Training Resources: https://pbi.guide/resources/ https://learn.microsoft.com/en-us/?WT.mc_id=M365-MVP-5002589  https://exceloffthegrid.com/  https://www.fullstackmodeller.com/  https://skillwave.training/  https://www.w3schools.com/python/default.asp  Hosts Wyn Hopkins, Mark Proctor, Sue Bayes, and Giles Male.   YouTube  

    Excel v Power BI and what would you change about them

    Play Episode Listen Later Aug 17, 2024 68:53


    TikTok, Training, and Top Voice

    Play Episode Listen Later Aug 3, 2024 85:05


    Worst Mistakes, LinkedIn and Community

    Play Episode Listen Later Jul 20, 2024 61:32


    A light hearted discussion about Excel, Power BI and some other occasional tech. Hosts Wyn Hopkins, Mark Proctor, Sue Bayes, and Giles Male.   YouTube

    Tables and Imposter Syndrome

    Play Episode Listen Later Jul 6, 2024 56:23


    The one where we discuss Jon Acampora's post that he's stopped recommending Excel Tables and whether we fear we are falling behind with the rapid pace of change. The Kurt Buhler post Does it feel like too much? — DATA GOBLINS (data-goblins.com) A light hearted discussion about Excel, Power BI and some other occasional tech. Hosts Wyn Hopkins, Mark Proctor, Sue Bayes, and Giles Male.

    Intros and AI Hype

    Play Episode Listen Later Jun 28, 2024 60:11


    The one where we introduce ourselves, chat about Excel World Championships, REGEX, Power BI, Copilot, ChatGPT, running, Sue discovers she's a programmer, and Mark's ability to now fit in an old suit. A light hearted discussion about Excel, Power BI and some other occasional tech. Hosts Wyn Hopkins, Mark Proctor, Sue Bayes, and Giles Male.

    Claim Unpivot

    In order to claim this podcast we'll send an email to with a verification link. Simply click the link and you will be able to edit tags, request a refresh, and other features to take control of your podcast page!

    Claim Cancel