Today, we welcome to the show the most transparent international man of mystery, Dany Hoter. Working on his 5th stint with Microsoft and living his best life in his 8th decade, Dany brings both wisdom and fun to those around him. He brings a passion and joy for teaching to his training sessions and always manages to create a connection between people and technology. Of course, he also has a long-storied past with Rob, and together they share the responsibility for what some view as the most expensive trip billed to Microsoft by non-executives. From luxury accommodations to indulgent automobiles, they expensed it all.

It wasn’t all global jet setting, however, as these two comprised the Dream Team that put the polish on Power Pivot and laid the groundwork for Power Query. Their hard work and dedication paid off as Dany and Rob banded together in their shared time at Microsoft to save the world from an error-filled, rushed incarnation of bi-directional relationships. In retrospect, however, the conversation about this brought up a story that many may prefer to never hear. It seems that amidst all the jet setting, our dear host, Rob Collie, was busy launching a cruise missile with the sole purpose of pissing off the advanced pivot table users.

What heinous act did he commit? Rob was directly involved in changing the default of pivot tables to compact.  While it did enlarge the user base by helping people feel more comfortable with pivot tables, advanced user rage is still alive and well on Twitter.

All of this and more on this episode of Raw Data by P3 Adaptive, where data meets the human element. If you enjoyed this episode, be sure to leave a review on your favorite platform to help others find us!

Also on this show:

Tinkering is a Way of Life w/ Darinee Louvau

Yoda Chong and the Treehouse of Wonder, w/ Donald Farmer

The Italians – Marco and Alberto

Ikigai Venn Diagram

Silicon Valley: Movember clip - mustache filter

Kusto v SQL

KQL - Kusto Query Language

Cube Functions in Excel

Rob on Twitter – to allow more bashing on the compact view