Unpivot

By UnpivotShowBusiness Technology

Unpivot episodes

November 10, 2024What 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.youtube.com/@Unpivot

#Excel #PowerBI
1 hr 23 min
October 26, 2024 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
1 hr 9 min
October 12, 2024 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.
1 hr 7 min
September 27, 2024 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
57 min
September 14, 2024 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
1 hr 10 min
August 30, 2024 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

1 hr 4 min
August 17, 2024 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

1 hr 9 min
August 03, 2024 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: https://www.reddit.com/r/PowerBI/
Stack Overflow: https://stackoverflow.com/questions/tagged/excel

Hosts Wyn Hopkins, Mark Proctor, Sue Bayes, and Giles Male.

YouTube

1 hr 26 min
July 20, 2024 Worst Mistakes, LinkedIn and Community
A light hearted discussion about Excel, Power BI and some other occasional tech.
Hosts Wyn Hopkins, Mark Proctor, Sue Bayes, and Giles Male.

YouTube

1 hr 2 min
July 06, 2024 Tables and Imposter Syndrome
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.
57 min