Excel-based Enterprise Dashboard - excel worksheet xls file download
Enterprise Dashboard Spy reader update: With your great interest and contributions of your own dashboards, The Dashboard Spy collection of executive dashboard screenshots has grown to over 800 examples of all sorts of BI dashboards! This unique enterprise dashboard reference can now be found at a new URL:http://enterprise-dashboard.com. And for your convenience, the posts on the various dashboard screenshots are collected together on the enterprise dashboard sitemap. The move to the new url allows exciting new functionality such as videos on enterprise dashboard related information.
Now back to the topic at hand:
I see that many of you Dashboard Spies out there are very interested in the tried and true excel spreadsheet approach to dashboards. Thanks to a download from javaplanetinc.com, there is this excel dashboard xls file for you to play with. Here are 2 screenshots. The first shows the graphic presentation of the data. There are 2 larger sections across the top of the screen. On the left is a pie chart showing salary by department and on the right side, we have a simple listing of outstanding balances. Below this section we have 4 smaller portlets (sales by region, budget by project, current output by plant, and sales by business unit). To show you that this is straight excel, I’ve taken a screenshot of the second sheet in the workbook. Try this with your own data and see what you come up with. Remember to send us your dashboard screenshots so that we can all learn how executive dashboards apply to your business.


Homework: Don’t ignore excel as a dashboard tool. It’s graphing ability is powerful and the number of users is unmatched. If you need a refresher on the tool, see these books on excel.
So what or who is The Dashboard Spy? As his about page states, The Dashboard Spy is just a guy interested in the design of enterprise dashboards. He could not find any executive dashboard design source books (or even screenshots of real business dashboards) and so set about creating his own. Finally convinced to post his extensive collection of dashboard screenshots online, he was amazed to find how popular it has become. If you have a nice screenshot of a digital dashboard, balanced scorecard, or any business intelligence graphic to share, please send an email to info _at_ dashboardspy.com. Also check out The Dashboard Spy’s favorite books.


Awesome piece
Comment by Bhagavathi — November 13, 2006 @ 9:35 am
HI,
This is what i needed for long time. It’s simply awesome.
Can you please send me some more reports to prepare more useful dashboard/scoreboards.
Thanks.
Warm Regards,
Ramesh
Comment by Ramesh — March 15, 2007 @ 8:57 am
Totally awesome! How do I go about getting information on the programs or training on how to go about setting up dashboards? This seems to be the new thing that executives are asking for and I am extremely interested.
Comment by Bob Forslund — April 23, 2007 @ 12:54 am
good
Comment by kalyan — August 30, 2007 @ 5:45 am
Check another sample of how to create dashboard from Excel data
http://www.infocaptor.com/how_to_build_dashboard_using_excel.pdf
Comment by Nilesh — September 19, 2007 @ 3:23 pm
BonavistaSystems brings Excel Dashboards into the Web
http://www.bonavistasystems.com/OnlineDemoReports.html
Comment by Andreas — May 4, 2008 @ 12:27 pm