Unpivot - podcast cover

Unpivot

UnpivotShowunpivot.podbean.com
Light-hearted discussion about Excel and Power BI - aimed at the business users of the world
Last refreshed:
Follow this podcast in the Metacast mobile app to refresh it and see new episodes.
Download Metacast podcast app
Podcasts are better in Metacast mobile app
Don't just listen to podcasts. Learn from them with transcripts, summaries, and chapters for every episode. Skim, search, and bookmark insights. Learn more

Episodes

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

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

Apr 11, 20251 hr 27 minEp. 22

Time Quotes, 100k Subscribers and Black Box Lambdas

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

Mar 29, 20251 hr 3 minEp. 21

Data Visualisation Choices in Power BI in Excel

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/ 🏃🏻‍♂️Mark Stephanie Evergreen https://stephanieevergreen.com/ Book: Effective Data Visualization Robert M...

Mar 15, 20251 hr 8 minEp. 20

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

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

Mar 01, 20251 hr 13 minEp. 19

Excel Summit ABBA and Presentation Tips

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

Feb 15, 20251 hr 22 minEp. 18

Copilot Fail and Work Life Balance

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

Feb 01, 20251 hr 4 minEp. 17

When does a business outgrow Excel and Power BI?

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

Jan 18, 20251 hr 7 minEp. 16

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

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

Jan 04, 20251 hr 1 minEp. 15

Christmas Livestream Uncut - Live and Unedited

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

Dec 20, 20241 hr 8 minEp. 14

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

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

Dec 07, 20241 hr 28 minEp. 13

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

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

Nov 26, 20241 hr 12 minEp. 12

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

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

Nov 10, 20241 hr 23 minEp. 11

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

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

Oct 26, 20241 hr 9 minEp. 10

Late to the Party and Presentation Tips

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

Oct 12, 20241 hr 6 minEp. 9

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

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

Sep 27, 202457 minEp. 8

Essential Functions and when formulas go wrong

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

Sep 14, 20241 hr 10 minEp. 7

Excel and Power BI Dangerous Features and what to learn?

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

Aug 30, 20241 hr 4 minEp. 6

Excel v Power BI and what would you change about them

🙏🏻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 . YouTube...

Aug 17, 20241 hr 9 minEp. 5

TikTok, Training, and Top Voice

🙏🏻Thanks to special guest Deb Ashby https://www.tiktok.com/@cellmates_ https://www.linkedin.com/in/deborahashby/ 🔗Links mentioned in show PowerToys: https://learn.microsoft.com/en-us/windows/powertoys/install Forums: Mr Excel: https://www.mrexcel.com/board/ Power BI Community: https://community.fabric.microsoft.com/t5/Power-BI-forums/ct-p/powerbi Excel Tech Community: https://techcommunity.microsoft.com/t5/excel/bd-p/ExcelGeneral Reddit Excel: https://www.reddit.com/r/excel/ Reddit Power BI: ...

Aug 03, 20241 hr 25 minSeason 1Ep. 4

Worst Mistakes, LinkedIn and Community

The Unpivot hosts share their most embarrassing career blunders, including audit mishaps and Power BI normalization errors. A passionate discussion ensues about the state of LinkedIn, critiquing content plagiarism and the platform's algorithms, while also acknowledging its professional value. The conversation extends to other online communities like Twitter and YouTube, emphasizing the importance of curated feeds. Finally, the team highlights several recommended in-person conferences and local meetups, stressing the irreplaceable value of face-to-face networking for data professionals.

Jul 20, 20241 hr 2 minEp. 3

Tables and Imposter Syndrome

UnPivot hosts Wyn, Mark, Sue, and Giles discuss Jon Acampora's controversial stance on no longer recommending Excel Tables to inexperienced users due to confusing structured references. They explore the fundamental importance of tables for data hygiene and automation, balancing best practices with client needs when designing solutions. The conversation then shifts to the challenges of keeping up with evolving technology in Excel and Power BI, candidly sharing experiences with imposter syndrome and strategies for continuous learning.

Jul 06, 202456 minEp. 2

Intros and AI Hype

The Unpivot hosts introduce themselves and the podcast's focus on Excel, Power BI, and business tech, sharing personal stories about their first jobs and running endeavors. They delve into recent tech news, discussing the Excel World Championships, the utility of Python and Regex in Excel, and best practices for data structure and report design. A significant portion of the episode explores the current AI hype, contrasting Copilot's practical applications with ChatGPT's capabilities, and emphasizes the continued importance of fundamental data skills.

Jun 28, 20241 hrSeason 1Ep. 1
For the best experience, listen in Metacast app for iOS or Android