So a large chunk of my daily job consists of finding better ways of viewing and obtaining data. Being the geeky individual I am, I do my best to push Open Source initiatives (as a real quick aside, anyone else had the extreme fun of having to prove over and over again that Open Source can be high quality, enterprise-grade stuff? I'm pretty sure that is the case in a lot of places, but it's good to hear the horror stories lol).
So over the last two years I've come across many programs (Pentaho Business Intelligence and have recently come across a really neat little php app over at Sparkline PHP Graphing Library: an open source application to build sparklines from databases/array data.
What are these sparklines anyway?
I was first introduced to the concept of sparklines by reading Information Dashboard Design: The Effective Visual Communication of Data by Stephen Few (Stephen Few's company site. If you're looking for a good overview on how to design information dashboards, I highly recommend picking it up.
Sparklines were developed by Edward Tufte, who describes them as "data-intense, design-simple, word-sized graphics" (here is a post Tufte made about them).
Basically, they are a way to show a large chunk of data in a relatively small space. Here's a few examples from sparkline.org:
Notice there are two types - a line chart and a bar chart. Both types can be embedded within a section of text to give
quick, relevant data without breaking the stride of the writing. As the first example also shows, you can also have
sparklines be any size depending on what information you want to display. I've been using them for On Time In Full
calculations by customer - basically an overview page showing all customers on file with three sparklines beside them:
one for On Time, In Full, and On Time In Full respectfully. This way everyone (and I do mean everyone - I'm all about keeping data open to all those involved with the process) within the facility can see how well we are at shipping to our customers on time.
I've gotten a tutorial about halfway finished on how to use the sparkline package with a mysql database (quick hint -
since OTIF is a hit/miss calculation, use a MySQL case statement to transform your data into a hit/miss total....).
Look for it soon.
EDIT - Now here's some irony. While looking through the WordPress widget repository, I came across this: Sparkstats Widget. It even uses the Sparkline PHP Graphing Library. Check it out.