For more Business Intelligence Dashboard Examples, use this link to the Dashboard Spy sitemap: Dashboard

Note: Dashboards By Example readers can get these interesting business intelligence dashboard white papers discussing the latest approaches to enterprise dashboards.

Dashboard

From a simple excel dashboard to a fully integrated enterprise reporting suite, the Business Dashboard is being quickly adopted as the new face of Business Intelligence. It has a rapidly growing role in BI reporting and analysis.

An enterprise dashboard allows at-a-glance visualization of company health and monitoring of key performance indicators. Simple to understand and high in ROI, these executive dashboards are becoming "must-haves" for all enterprises. Easy-to-use by business users and fun-to-implement by the IT department, BI dashboard projects are quickly funded and politically popular.

Dashboards by Example Sponsors

"Dashboards by Example" is a business intelligence blog dedicated to showing you actual examples of do's and don'ts of dashboard design. Study examples of enterprise dashboards, scorecards and other business intelligence interfaces implemented by the world's top organizations.

Looking for a particular dashboard? Try these listings of BI dashboards (call them what you want):

Dashboards Page 1
Dashboards Page 2
Dashboard Page 3
Dashboard Page 4
Dashboard Page 5
Dashboard Page 6
Dashboard Page 7

Search Dashboards

This dashboard screenshot blog is part of the Dashboard Spy network - a unique collection of business intelligence resources. Send us your Dashboards!

Email the Dashboard Spy

RSS Feed

Subscribe to Feed

Navigate

Enterprise Dashboard Advertisements

Real Time Excel Dashboard Tracks Gas Prices

Dashboard Topic: Excel Gas Dashboard

Web queries have been part of the Microsoft Excel object model for quite a while now, but are not often seen on Excel dashboards. Talented Xcelsius and Excel developer Kalyan Verma (author of the fabulous myxcelsius.com blog), has posted an example of using Excel Web Queries to power an Excel dashboard connected to the American Automobile Association’s database of pump prices of 100,000 gas stations.

The post is entitled Real Time Fuel Gauge Dashboard using Excel Web Query and walks the reader through not only a lesson in the use of Excel Web Queries, but also some principles learned from reading Stephen Few’s Information Dashboard Design: The Effective Visual Communication of Data. Can you guess which specific principles?

Take a look at this screenshot. Click on the image to enlarge this excel dashboard. Be sure to visit the post at the link above to read more from Kalyan as well as see more screenshots of the Excel dashboard. Most importantly, you can download the .xls file for the Excel Dashboard and play around with the Excel Web Query dashboard for yourself.

Excel Gas Price Dashboard

Excel Dashboard using Web Queries to Show Gas Prices

If you are new to Excel’s Web Query feature, consult this introduction from Microsoft’s Office Online resource:

Get and Analyze Data From the Web in Excel

Speaking of Microsoft Online, try this query and look who is the first result! Click on the word “Dashboard” below:

Dashboard Search on office.microsoft.com

Update: As noted in the comments below, we have covered similar gas price dashboards previously. Take a look at Ryan Goodman’s Xcelsius Gas Price Data Dashboard. It even has a Dashboard Spy Video!

Tags: Excel Dashboard for Gas Price Monitoring, Web query excel dashboard, myxcelsius.com, excel gas dashboard

What do you think about this dashboard post? Please leave a comment. Your opinions are valuable to the entire business dashboarding community.

5 Responses to “Real Time Excel Dashboard Tracks Gas Prices”

Joe the Plumber Said on October 20th, 2008 at 4:43 pm quote
Looks to be a copy of another dashboard: http://ryangoodman.net/blog/index.php/2008/06/26/gas-prices-at-the-pump-dashboard
S. Palin Said on October 20th, 2008 at 8:50 pm quote
Joe - dude - is that you? Good job. I’ve been seeing a lot of you on tv!

Didn’t know you were a business intelligence dashboard afficionado.

Me too!

I’m a dashboarding hockey mom!
B Obama Said on October 21st, 2008 at 3:29 am quote
I’m loving the change. Especially in the fuel prices.
Tina Fey Said on October 21st, 2008 at 8:11 pm quote
Palin, I made you popular

http://www.dashboardzone.com/election-intelligence-collection-of-electoral-dashboards
MyXcelsius Said on November 6th, 2008 at 5:47 pm quote
Joe,

its not a copy of Ryan’s Dashboard. Ryan designed it in Xcelsius and has many more options. This is more simple and designed in Excel. Both the Dashboards are Realtime and the source is AAA.

Last Modified: Tuesday, October 21st, 2008 @ 10:13

This business intelligence dashboard blog entry was posted on Monday, October 20th, 2008 at 3:33 pm and is filed under Dashboard Screenshots. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Want to see a different randomly selected business intelligence dashboard example? Click here to view another Digital Dashboard from the Dashboard Spy.

Dashboard Spy Readers: See these related Business Intelligence Dashboard posts:

Latest posts of interest to the business intelligence dashboarding community - Have you read these recent enterprise dashboard posts?

Recently Posted

Dashboards by Example Volume 1 Goals and Objectives

"Dashboards By Example" is the theme and mission statement of this blog. We salute the Dashboard Spy in the field - those business users, project managers, IT executives, application designers, business intelligence experts, analysts, coders and subject matter experts who are on site creating this exciting and new "face of BI". Your business intelligence dashboard can go by many names - performance dashboard, executive dashboard, business dashboard, balanced scorecard, KPI metric summary, enterprise dashboard, bi dashboard, corporate dashboard. Whatever we call it, we believe that the at-a-glance visual approach is the key to user-centric design. Let's learn from each other's dashboard examples and continue to increase the level of usability and usefulness.

We strongly believe that the more dashboards you study, the more adept you will become at choosing correct design solutions for your company. "Learn by Example" is not just a motto - we take it literally, hence the name "Dashboards by Example". So take every chance you get to view examples of BI interfaces. As a matter of fact, take a second now, and study this dashboard example.

What's on your Dashboard?

The Dashboard Spy wants your dashboards!! I've collected over 1000 screenshots of business intelligence dashboards and scorecards for Volume 1 and now need you to send me the next 1000 dashboards for Volume 2. Email me at info at dashboardspy.com and tell me about your dashboard. Send me images, notes, technical details, business rules, metrics, KPIs, anything that you think your fellow Dashboard Spies will have an interest in. Keep this library of dashboarding resources going!

Also, I'd love more links to both the main Dashboard Spy site at http://dashboardspy.com and the Volume 1 blog of 1000 dashboards at http://www.enterprise-dashboard.com. I'd love your help in making these resources better known.

Looking forward to seeing your dashboards, The Dashboard Spy

P.S. Did you check out this free dashboard template for wireframing? Click on the image below for the download link and instructions. Consider it a gift for your unfailing support. Thank you very much. Sincerely, your friend in dashboarding, Hubert Lee, The Dashboard Spy.

PPS. Looking for an HTML Dashboard Template? Check out this great layout for a digital dashboard. Use this HTML template to jumpstart your front end coding.

(Sign up today and I'll also send you the following Digital Dashboard HTML Templates),

Dashboard

Dashboards by Example Sponsors

Search Dashboards

RSS Feed

Navigate

Enterprise Dashboard Advertisements

Archives

Meta

Categories

Links

Real Time Excel Dashboard Tracks Gas Prices

5 Responses to “Real Time Excel Dashboard Tracks Gas Prices”

Leave a Reply

Recently Posted

Dashboards by Example Volume 1 Goals and Objectives

What's on your Dashboard?