As the gas prices at the pump increase, I wanted to see just how much we are paying for gas here in California compared to the rest of the country. To do this, I utilized Xcelsius 2008 to build a dashboard not only to help make information easier to consume, but also to showcase a sample/viral dashboard for my blog.

The resulting dashoard exemplifies the benefits of using interactive data visualization compared to static HTML tables/reports. At a glance, I can quickly assess what I am paying at the pump in relation to the national average and state averages.

Just showing the data wasn’t good enough…I wanted to provide additional analysis to transform the $/gallon data into something meaningful. A simple calculator was added to illustrate what we will pay per month and year, given the current price.

Gas Prices DashboardView full size example

All data for this dashboard originates from AAA.com. I am not providing source files for this dashboard at this time, but if you have any questions about what I have done, please add them to the comments in this post. If you are interested in using this dashboard in your web site for non-profit, please contact me.

I have several people point out that the gauges are distracting, which is absolutely correct. I have reverted back to the original graph version that can be viewed here:
View Gas Price Dashboard v0.9

All rights reserved Goodman Group LLC