I had the same experience with SQL Server Analysis Services and later with Power BI.

I would simply open Excel, connect to the OLAP cube and start dragging & dropping columns while explaining what it was representing. Like: "Here's your sales total, you know that, now we'll break it down so that government sales are in a separate column, now split by state, etc...". People would ask questions they hadn't had answers to in years and I would simply rearrange the pivot table so they'd not only get the number they wanted, but they could see the process of getting there.

I once had an executive stand up, point at the screen and shout: "I want this, right f%^&ing now!"