Archive for August, 2008

Dashboard Design Part 3 of 3: An Iterative Tale

27th August 2008 by Tim Wilson 11 Comments

On Monday, we covered the first chapter of this bedtime tale of dashboard creation: a cutesy approach that made the dashboard into a straight-up reflection of our sales funnel. Last night, we followed that up with the next performance management tracking beast — a scorecard that had lots (too much) detail and too much equality [...]

Dashboard Design Part 2 of 3: An Iterative Tale

26th August 2008 by Tim Wilson 2 Comments

Yesterday, I described my first shot at developing a weekly corporate dashboard for my current company. It was based on the concept of the sales funnel and, while a lot of good came out of the exercise…it was of no use as a corporate performance management tool. Tonight’s bedtime story will be chapter 2, where [...]

Dashboard Design Part 1 of 3: An Iterative Tale

25th August 2008 by Tim Wilson 3 Comments

One of my responsibilities when I joined my current company was to institute some level of corporate performance management through the use of KPIs and a scorecard or dashboard. It’s a small company, and it was a fun task. In the end, it took me over a year to get to something that really seems [...]

Your Customer Data Is Dirtier than You Think

22nd August 2008 by Tim Wilson 1 Comment

Wow, has it ever been a while since I got a new post up. Three-part excuse: 1) Vacation that was wayyyy offline, 2) Vacation was proceeded by a crazy week on the road for business, and 3) I’ve been working on a post that’ll turn out to be three separate posts. Stay tuned for that, [...]

Shortest Excel Tip Ever: <F4> and <Ctrl>-Y

3rd August 2008 by Tim Wilson 6 Comments

I’ll put my standard big, fat, hairy disclaimer here that this blog is not about Excel tips. There are lots of resources for that. As a matter of fact, the Contextures blog is one that I stumbled across after Debra commented on my last Excel tip. Nevertheless, here’s a handy one that requires no customization [...]