In good system, you don't drill down too far, and you don't overwhelm folks with too much information.
If you know how to do that, tell me how! Honestly, I go too far all the time, and I confuse folks.
But the better you design your "system", then the more efficient the system is at telling you that you've gone far enough.
Here, I divided up Womens productivity by price point ($0 to $20 items, $20 to $50 items, and $50+ items). What do you observe? Well, productivity in the lowest price points is obviously increasing, as is productivity in mid-level price points. High price point items is in free fall.
Then look at the final two columns. We can see that new item productivity is in free fall, while existing item productivity increased for a few years, then fell badly once there weren't enough new items to fuel existing item productivity.
This is a place where you stop telling your story. You have enough information to craft a story, to not overwhelm folks, and to truly identify the business problem. Stop here. Craft your story. And get ready to duck, because there's going to be a contingent that take umbrage with your story.
Don't want to do the work yourself - or don't have the resources to do it? Give me a holler (firstname.lastname@example.org) - click now!!
Here's a trend that keeps coming up: A new CEO is hired because a brand isn't performing well. The new CEO brings in a new Mer...
Look at the first four rows of our life table (values of 0/1/2/3). These are the first 12-15 weeks after a customer buys for the firs...
In our simulation, we learn that there are different definitions of Carrying Capacity. If the CFO demands that we maximize profit o...
You probably run Life Tables for your customer file, right? Right? They've been around forever ( click here for a reference f...