Archive for May, 2010

Color is a Funny Thing

Thursday, May 13th, 2010

In the visualization of data and BI dashboard design, color is often overlooked and overused as an element of design, despite the central role it plays throughout our lives in how we dress ourselves, paint our houses, and display monthly sales figures.

Randall Munroe’s Blag on XKCD.com (a robust sense of humor is required and rewarded on this übergeek comic site) recently released the results of a color survey that included more than 5 million named colors recorded over 222,500 user sessions. It is impossible to read much of the results and not burst out laughing and also realize that color is both intensely personal and emotional. Why do we pay it so much attention at some times and so little at others?

Part of the reason is that color is highly context sensitive, that is, we perceive colors to be very different depending on the background on which they appear and whatever colors happen to be adjacent to them. When Dan and I were giving a presentation titled “Data Visualization Best Practices: Know How to Improve Your BI and EPM Reports, Dashboards, and Queries at Collaborate 2010” a couple of weeks ago, we threw in some slides featuring some traditional “optical illusions” including some with color (mis)perception. Invariably, more people comment on the optical illusions than on the more substantive parts of presentation, despite the fact that most of us have been exposed to them since we’ve been in the fourth grade.

The best “simple” advice I have is to use color sparingly and carefully. Don’t underestimate its power.

Collaborate Conference Summary

Friday, May 7th, 2010

We made it through the Collaborate conference! It was a whirlwind of activity, with Vlamis Software presence from Saturday through the closing session on Thursday. Here are some of the Vlamis Software (and associated BIWA SIG) highlights:

Saturday: Dan attended Collaborate conference committee kickoff meeting. Really good group of people to work with!

Sunday: Dan set up hands on lab (HOL) room. Everything worked! By the way, the HOLs were a huge hit. We ran 6 different HOL sessions, using 2 virtual machines on 20 computers, servicing as many 60 people at a time. We received great feedback on the sessions and I believe people really appreciated having a chance to actually touch and feel the software. HOL sessions included:

  • OBIEE (presented by KPI Partners)
  • BI Publisher (presented by BI Publisher product management)
  • Oracle Warehouse Builder (presented by Rittman Mead)
  • Oracle Data Mining (presented by Rexer Analytics)
  • Oracle OLAP (presented by OLAP product management with help from Vlamis Software)
  • Excel running against Oracle OLAP (presented by Simba)

Our thanks go out to the above excellent instructors, to KPI Partners for sponsoring the hands-on labs and to our very own Jonathan Clark of Vlamis Software for working with all of the instructors to get the PCs configured for the labs.

Monday: Lots of sessions to attend. Also, the trade show floor opened up. Vlamis Software had a booth at the show and we received a lot of traffic throughout the show. Our notebooks and pens were a big hit. We raffled off a copy of the book Oracle Essbase & Oracle OLAP: The Guide to Oracle’s Multidimensional Solution. We will be mailing out a copy of the book to the winner soon.

Tuesday: More sessions followed by the BIWA Reception, with Robert Gersten, Sr. VP of BI Development at OracleI. It was great to be able to slow down and actually talk with some of you in the BIWA community. I (along with Karl Rexer) was honored to receive the 2010 BIWA Haydu Contribution Award for outstanding contribution to BIWA SIG.  Very nice!

Wednesday: More sessions. Vlamis Software was involved in three different sessions that morning:

Thursday: Dan participated in the closing debate: Should I Stay (10g, MySQL)
or Should I Go (11gR2+)? Dan argued for Going to 11gR2+

After a whirlwind week, it was nice to head home. Lots of great contacts. I’m looking forward to Collaborate 2011!