The Dashboard Spy

April 20, 2006

Excel-based Enterprise Dashboard – excel worksheet xls file download

Excel Dashboard Alert: Microsoft Excel is a strong choice for business intelligence dashboard implementation. And, yes, the latest version of Excel has out-of-the-box data visualization capabilities that make it a strong choice for dashboards. In fact your microsoft excel dashboard can look like this:

excel dashboard

There is a video tutorial on how to build that excel dashboard. Click here to view it:

Design and build an excel dashboard

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.

Business dashboard screenshot

excel-based dashboard

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.

Also, have you checked out this resource on EXCEL Dashboard templates?

Learn how to create Excel dashboards.

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.

26 Comments »

  1. Awesome piece

    Comment by Bhagavathi — November 13, 2006 @ 9:35 am

  2. 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

    • Dera Sir,
      Could you please email me example of your excel dash boards, More specifically the speedometer layout.
      I have managed to do one on excel but this was not good enough.
      I would appreciate your kind assistance

      Kind Regards
      Prem

      Comment by Prem — June 26, 2009 @ 9:21 am

  3. 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

  4. good

    Comment by kalyan — August 30, 2007 @ 5:45 am

  5. 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

  6. BonavistaSystems brings Excel Dashboards into the Web
    http://www.bonavistasystems.com/OnlineDemoReports.html

    Comment by Andreas — May 4, 2008 @ 12:27 pm

  7. It’s a worth site, but still need further improvement- I enjoy it

    Comment by roelly — August 11, 2008 @ 8:38 pm

  8. Its such as you read my thoughts! You appear to understand a lot about
    this, like you wrote the book in it or something. I think that you just could do with some p.
    c. to power the message home a bit, however other than that, that is great blog.
    An excellent read. I will definitely be back.

    Comment by work from home jobs assembly — February 17, 2013 @ 12:48 am

  9. Howdy, I read your blog from time to time and I own a similar one and
    I was just wondering if you get a lot of spam feedback?
    If so how do you protect against it, any plugin or anything you can recommend?
    I get so much lately it’s driving me crazy so any assistance is very much appreciated.

    Comment by Best iPhone App — March 5, 2013 @ 5:05 pm

  10. Hmm it appears like your site ate my first comment (it was extremely long) so I guess I’ll just sum it up what I had written and say, I’m thoroughly enjoying
    your blog. I too am an aspiring blog writer but I’m still new to the whole thing. Do you have any recommendations for first-time blog writers? I’d
    definitely appreciate it.

    Comment by Digsitevalue.Org — April 5, 2013 @ 4:45 pm

  11. Fine way of telling, and pleasant post to get information about my presentation topic, which i am going
    to convey in academy.

    Comment by http://Khimtayler.Skyrock.Com — April 15, 2013 @ 4:30 am

  12. I pay a visit each day a few web pages and information sites to read articles, however this weblog offers quality based writing.

    Comment by cheap fireworks — April 23, 2013 @ 1:47 am

  13. hello!,I love your writing so so much! percentage
    we be in contact more about your article on AOL? I need a specialist
    on this space to unravel my problem. May be that’s you! Looking forward to see you.

    Comment by Walter — April 23, 2013 @ 2:29 pm

  14. I don’t even know the way I ended up here, however I believed this submit was once good. I do not recognise who you might be however definitely you are going to a well-known blogger if you aren’t
    already. Cheers!

    Comment by www.zpwh.cn — April 25, 2013 @ 5:23 pm

  15. Aw, this was a very nice post. In thought I wish to put in
    writing

    like this additionally – taking time and precise effort
    to make an excellent article…

    but what can I say… I procrastinate alot and not

    at all seem to get one thing done.

    Comment by fulmilist.altervista.org — April 27, 2013 @ 2:55 am

  16. Fine way of describing, and nice post to get information on
    the topic of my presentation subject matter, which i am going to
    deliver in institution of higher education.

    Comment by Online Home Careers Scam — May 21, 2013 @ 5:04 am

  17. I got this website from my friend who shared with me concerning this
    website and at the moment this time I am browsing this web
    site and reading very informative content at this place.

    Comment by rabbit vibrators — June 6, 2013 @ 7:45 pm

  18. Valuable info. Lucky me I discovered your web site by chance, and I am stunned why this accident did not took place in advance!
    I bookmarked it.

    Comment by dmca takedown — July 16, 2013 @ 9:18 pm

  19. Very soon this site will be famous amid all blogging users, due to it’s nice posts

    Comment by ProDermagenix — August 2, 2013 @ 1:27 am

  20. Hi there, I wish for to subscribe for this weblog to
    get latest updates, so where can i do it please assist.

    Comment by sports team management — May 10, 2014 @ 1:00 am

  21. This design is steller! You most certainly know how to keep
    a reader entertained. Between your wit and your videos, I was almost moved
    to start my own blog (well, almost…HaHa!) Excellent job.
    I really enjoyed what you had to say, and more than that,
    how you presented it. Too cool!

    Comment by robert — July 16, 2014 @ 3:53 pm

  22. I’ve been browsing online more than three hours today, yet I never found any interesting
    article like yours. It’s pretty worth enough for me.
    In my view, if all site owners and bloggers made good
    content as you did, the net will be much more useful than ever before.

    Comment by home-based business — July 28, 2014 @ 6:56 pm

  23. […] Excel-based Enterprise Dashboard – excel worksheet xls … – 20/4/2006 · Excel Dashboard Alert: Microsoft Excel is a strong choice for business intelligence dashboard implementation. And, yes, the latest version of Excel has out …… […]

    Pingback by Building Web Based Dashboard | Technology Documents — January 5, 2015 @ 10:45 pm

  24. […] Excel-based Enterprise Dashboard – excel worksheet xls … – 20/4/2006 · Excel Dashboard Alert: Microsoft Excel is a strong choice for business intelligence dashboard implementation. And, yes, the latest version of Excel has out …… […]

    Pingback by Web Based Excel Dashboard | Technology Documents — January 12, 2015 @ 7:11 am

  25. […] Excel-based Enterprise Dashboard – excel worksheet xls … – 20/4/2006 · Excel Dashboard Alert: Microsoft Excel is a strong choice for business intelligence dashboard implementation. And, yes, the latest version of Excel has out …… […]

    Pingback by Web Based Excel Sheet | Technology Documents — January 21, 2015 @ 11:09 am


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: