The Dashboard Spy

December 8, 2010

Excel Dashboard Tutorial

Filed under: Dashboard Screenshots — Tags: , — dashboardspy @ 4:37 pm

Microsoft Excel (particularly Excel 2010 with it’s data visualization functionality) continues to be a strong choice for business intelligence dashboards – particularly for those without access to a team of developers and database programmers.

in this hour long Excel Dashboard Tutorial, you can watch a real-life excel dashboard being designed and constructed.

Here’s what the excel dashboard looks like:
Excel dashboard

Anyone who uses excel and would like to see what kind of dashboard can be created in excel should watch this video lesson. Taught by veteran dashboard expert and excel guru, Chandoo, this tutorial is 65 minutes long and includes:

  • Dashboard Design Principles
  • Dashboard Architecture Considerations
  • Data Cleansing
  • Pivot Table Techniques
  • Excel Word Clouds

This Excel Dashboard Tutorial is highly recommended to Dashboard Spy readers.

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.

Blog at WordPress.com.