Unpivot

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

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

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.youtube.com/@Unpivot

#Excel #PowerBI

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

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.

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

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

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