Users of analytics are generally on the hunt for answers, not a funtime activity. (Though the luckier ones sometimes do have time to "play around" with data). Sometimes, they're even in an urgent situation requiring a quick fix (think systems administrators faced with an outage).
So why do we make them dig and slice and dice to find the answers they need? Forensic work is a time vampire, and in an update to this post, I'll discuss ways to give users quicker results with less stress, and introduce my concept of a Hunter-Gatherer.
Follow the Zod Principle
How quickly can your users grasp what a report or visualization is trying to say? (The answer should be "pretty quick", if not better.) I'll lay out my Zod Principle (and explain the name).
Make the machine give analytics users superpowers
The end result of cutting the forensic work out of analytics should be making your users feel and look like they have superpowers.
If you do this well, then in many cases, your users should see your analytics tool as a "toothbrush"—something they'll use frequently because it's quick, painless, and provides a lot of benefits.