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!"
I've earned paychecks teaching and presenting for more than ten years, and the powerpoint is just passive, as you said. You sit back. Your brain lulls as you wait to be fed information. I'm not necessarily opposed to it, but...
Anything that can be manipulated - blackboard, open .doc file projected that you type into, or (maybe best) The Prop - gives a sense of the living tool. It's not the finished product; it's not your Auntie's knick-knacks. It's the living tool. And everybody wants to play with a new tool, even if it's just by asking a question so you'll modify a cell and re-run.
Also, the real-time interaction of changing things in front of people gives them something more: a chance to glance around and take in social cues that are lost while everyone's passively staring at a powerpoint.
Don't know why I wrote all that. Guess I'm preaching to the choir, and maybe I'm just spurring myself to move away from some of my own bad practices... or maybe, I'd love a little experiment, since my money's on #2. Ask a lecturer to give the same presentation, once with a blackboard, once with a powerpoint. And take a survey before and after both lectures (different participants of course) and see if there really is a difference.
Anyways glad you've had some luck with your Jupyter notebooks! (Just looked them up - they seem really cool!)
https://jupyterlab.readthedocs.io/en/stable/user/export.html
I like making a static webpage (my colleagues use a TWiki, but you can use your own flavor) for collaboration talks. You just scroll through the webpage, gifs "just work", pictures look great, and you can add descriptive text that your audience can read on their own time.
This is really nice, because if anyone wants to look at what you said later, they don't have to go rooting through PDFs or powerpoints. The whole talk is indexed and searchable, and it's immediately available (with correct formatting) on any internet-connected device.
1. The novelty of it for most of the audience catches their attention.
2. It creates a feeling of participation rather than passive observation, especially if they ask a question and I answer it by modifying a cell and re-running it.
3. There's an implied sense of immediacy: The information is so new and cool that I didn't have time to make slides.