Unpivot Episode 40 | Full Stack Modeller

The latest episode of Unpivot is out. This week, they confess the best practices that they don't follow... be prepared for some shocks 

Episode 40: Best Practice Confessions & Terminology Overload

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

You can watch it HERE

“I live for coming up with creative things that solve tricky problems” Wyn Hopkins

Me too Wyn, in one sentence, you summed up why I love my job!

Question of the Week:   What Best Practices do we ignore

This week, they confess the best practices that they don't follow... be prepared for some shocks 😲.

Some sound pretty out there, but I agree with all of them (well, the Excel ones – no idea about the PowerBI ones!)  – as always, it’s all about context - which you’ll need to listen to get.

Mark

• Uses Merge & Center
• Doesn’t always use the simplest formula that he could

Sue

• Sometimes uses calculated columns in PowerBI
• Could be better at documentation

 Wyn

• Separation of Inputs, workings and outputs
• Doesn’t always hide unused columns and dimension keys in PowerBI
• Needs to be better with accessibility
• Doesn’t mark he calendar as a data table – which based on Sue’s response is very naughty!

Giles

• You should always be prepared to bend the rules if it delivers a better outcome

🧢👕There is now Unpivot Merch : Unpivot Mech Shop

🧑‍🤝‍🧑The Unpivot team will be all together for the first time on May 20^th at the Global Excel Summit.

🎥You can watch the episode HERE

🎧It is also available on all Podcast apps if you prefer to listen.