I created this particular visual with Tableau OEM'd as Hyperion Visual Explorer. The data comes from a semiconductor company I did a proof of concept for back in '98. (I told you I'm a cube geek.)
These are the top 20 sales reps monthly sales figures on the top selling product. The weakest rep is on top, the best rep is at the bottom. This visualization gives some very cool insights into the reps. Not every good rep is really good.
Take for example, our 'worst' rep at the top. He's a producer but he just had a bad month. I'd rather keep him around than the next three. His pattern is just like Rep 22222, which suggests I'm just having a bad January. That might be manufacturing's fault.
Rep 22922 must have just up and quit after his first bad month. Forget him. Now I've got three consistently good reps in {15528, 15128 and 30517} They hit a positive number almost every month. 21216 hits big once a quarter but he stung me last March. I'll take consistency, thanks.
Of my top three reps, one of them simply hit the jackpot, but other than that he appears mediocre. The jury's out on that guy. 85232 is a big performer and so is the top rep, even though he lost a lot one month.
A picture is worth 1000 words.
I built this app with Essbase 7.1.3 using block storage. It's a six dimensional bookings database with daily orders for 2800 products across 6 geos and 50 reps. There are about 20,000 line items in 5500 orders. It took about 4 hours to build, but I already had nice data. and the schema was done. If I remember correctly, it was a 4 day proof of concept. So, no big deal.
Comments