Unpivot

watch the video intro https://youtu.be/pzmaa74LErc?si=xydH-biTfjTbKUYh It's our 1-year anniversary and our Question of the Week is: What should and shouldn't you put on your CV and say in an interview   Also discussion around: 💚Excel Stats for Accountants 💛 Visual Calcs updates 💚 Clip-Champ 💛 Training day tips   Links to hosts and other content Unpivot Show Links Page Hosts Wyn Hopkins , Mark...

🐒🔨🪛Ken Puls: https://excelguru.ca/ QotW: What motivates you? Other chat: AI Theft  Ultramarathon Can you keep up, how to avoid the stress 18 years as an MVP Links to hosts and other content Unpivot Show Links Page Hosts Wyn Hopkins , Mark Proctor ,   Sue Bayes and Giles Male . 📢 Special Mention: The Secrets Behind the Graph: Mastering Any Chart in Excel | Laura Szepesi https://youtu.be/Hd_yfUr...

#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 .

Mark and Giles do a mini pod discussing recent Excel updates including Copilot Copilot Dark Mode Copilot 🙄 Tokens and more...  

#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-...

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...

#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 Pro...

#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 .

#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 .

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 .   💊Giles Ali Torban : https://www.linkedin.com/in/allisontorban/...

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 P...

  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

  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

  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

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

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 🎄Christmas Quiz🎄 🎄Favourite Features of 2024🎄 Hosts Wyn Hopkins ,  Mark Proctor , Sue Bayes, Giles Male .   #Excel #PowerBI

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

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

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...

🙏🏻 Special Guest: Rick De Groot ( Gorilla. Bi )  (  Power Query How - Home of the M Language ) QotW: When are you an expert?  Main Topic:  Are technical books still relevant in the world of AI?   Join the conversation on LinkedIn https://www.linkedin.com/company/the-unpivot-show Hosts   Giles Male,   Mark Proctor , Sue Bayes, and Rick de Groot

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 Host Host: Wyn Hopkins is a Power BI and Excel expert known for simplifying complex business in...

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

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

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  

🙏🏻Thanks to special guest Cristian Angyal https://www.linkedin.com/in/cristian-angyal Romania Power BI and Modern Excel User Group | Meetup 🔗Links mentioned in show Ideas: Power BI https://ideas.fabric.microsoft.com/ideas/ Ideas: Excel  https://feedbackportal.microsoft.com/feedback/forum/c23f3b77-f01b-ec11-b6e7-0022481f8472     Hosts Wyn Hopkins , Mark Proctor , Sue Bayes, and Giles Male .   Yo...