I’ve been working with Ron Keler (@ronkeler) to build some new dashboard demos. Please check out his post about our Medicare enrollment dashboard that consolidates public data into a central database and serves up live XML data to feed our Xcelsius model here at BIHappy Blog.
Here is another file originally posted on MyXcelsius.com that went missing. In this example, I used a PNG file to create whitespace around a progress bar. This example clearly shows where my idea for the scalable Sales Funnel originated.
I have been working a lot more with pagination lately and here is an example that mimics web 2.0 styles. This template is setup to display up to 20 pages and expands outward from the center. Try it out and let me know what you think. The XLF has also been posted for download.
Due to the number of requests I’ve had for Gantt chart dashboards, I figured that I would post an example with my own technique. This really isn’t any different than other Xcelsius examples on the web, except that it tends to look better in my customized theme than it does in Nova or Halo. To take this example to the next level, I’ve added a few extra series to allow for the banding of rows in the table and to toggle on/off the critical path display.
Chris Hickman posted a challenge to Twitter today to automatically wrap two word text labels on the horizontal axis. Here is my solution, which uses the FIND function to find the space within the label (if one exists) and replaces it with a carriage return.
I’ve seen the following effect in a number of infographics and presentations to display a percentage visually (opposed to a pie chart). While I figured that most people design these manually, I decided it would be fun to figure out the logic for when you use the different displays (e.g. bottom right 5×5 for 25%, exclude top left 4×4 for 86%, or just fill from the bottom with 52%).
While I’m probably two years too late on this, I’d figured that I would give it a shot based on the popularity of my previous (image based) sales funnel template. Colors for the most part have been keyed to Hex numbers in the underlying table, so it should be very easy to apply your own color scheme. When asked about such a template, readers of this blog also mentioned label lines which you will see was more complicated for me to implement than the actual funnel.
As I transition into my new role at Cleartelligence, I’m going to be working on creating more complete dashboard samples. Here is a balanced scorecard example using the power of Xcelsius while delivering a clean crisp look.
Clicking the individual metrics on either the measures or the strategy map tabs will drill into that specific measure on the detail tab.
I’m constantly looking for new color themes for my dashboards, but I tend not to record the ones that I liked. To solve my dilemma, I have created the dashboard picker to start storing color themes and quickly display them in a graph. Many times I have seen themes that I like on Adobe’s Kuler and ColourLovers.com only to find out that they don’t translate well to graph format.
Please feel free to share your color theme suggestions and I’ll add them to the dashboard. Hex or RGB formats are both fine. My initial version has some colors that I think work, and some that don’t translate as well.