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 20th at the Global Excel Summit.
🎥You can watch the episode HERE
🎧It is also available on all Podcast apps if you prefer to listen.
