The Dashboard Spy

March 3, 2010

Excel Dashboards for Information Visualization

Filed under: Dashboard Screenshots — Tags: , , , , — dashboardspy @ 11:20 am

Really excellent examples of Excel Dashboards continue to come from Chandoo, author of Excel Forumla Helper.

Take a look at this infographic-style Excel dashboard. It’s made with Excel 2010 (now with sparklines!).

You can download this excel dashboard from Chandoo’s post: An Excel Info-graphic Poster.

Excel Dashboard

Hubert Lee
The Dashboard Spy

Advertisements

February 13, 2010

Excel Tutorials Now Available at Microsoft Excel School

Filed under: Dashboard Screenshots — Tags: , , — dashboardspy @ 8:25 pm

Excel tutorial tip of the day: Think Excel when you think Dashboards.

Excel dashboards are proving to be the most cost effective business intelligence dashboard tools. First of all, everyone has Microsoft Excel, it’s already the standard for data analysis, and the new charting features are quite powerful.

We are seeing more and more data visualization being done in Excel. Everyone is urged to sharpen their Microsoft Excel skills especially in the area of charting.

The Excel tutorials at Chandoo.org have always been my favorite and are well worth checking out. See http://budurl.com/exceltutorial

Pointy Haired Dilbert (PHD – the editor of Chandoo.org and author of Excel Forumla Helper) is now offering EXCEL SCHOOL.

The content is awesome and some really excellent excel tutorials are going to be offered.

Check out the content:

Excel School Topics

Tags: Excel tutorials

May 26, 2006

Excel Dashboarding Spreadsheet Download – nice presentation of dashboard KPIs

Excel Dashboards Update:

Video on Excel Dashboards.

Looking for a great example of an Excel Dashboard? How about some excel dashboard templates?

And in this new 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

Excel dashboards, KPI and charting examples are among the business intelligence resources that Dashboard Spy readers find at the new site.  With your great interest and contributions of your own dashboards, The Dashboard Spy Blog has grown to over 1000 examples of all sorts of Business Intelligence dashboards.  Excel, Xcelsius, Sharepoint, AJAX and Flex are only some of the underlying dashboarding technologies covered.  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 excel dashboard related information.

And now back to our unique enterprise dashboarding content such as this post on Excel Dashboards:

Dashboards speak an international language, right? In that case, you’ll have lots of fun figuring out these italian excel-based dashboards. Take a look at these MS Excel dashboard screenshots. The first shows the portlet-style presentation of the dashboard KPIs. The second shows the regular input view of the excel spreadsheet. Here is a link to a generic xls file. This link is to the production kpi dashboard and this link is the one to the marketing KPI version. Have fun with these excel dashboards.

Also, as a Dashboard Spy reader points out: “If you take the time to look over the dashboard, there’s some pretty cool things – unprotect the sheet with the charts and look how they did the gauge – It’s a pie chart with fancy formatting. It also fits very nicely on a single screen when you view it full-screen. In all, a very good job considering the tool used.”

Update: This just in from the Italian Dashboard team!:

Hi,
I have seen some nice traffic coming from dashboardspy, so we translated the Italian page into english. There could be some errors (sorry for this!), but please have a look at the page: www.excelling.it/excel/dashboard_en.asp

I will keep you posted on updates, but you can count on the fact that there will be a lot of new cool excel dashboards. I you have suggestion, please tell us 🙂

Best Regards,
GF
____________________________
Gianclaudio Floria
____________________________
Excelling.it
President & Founding Partner

Excel Dashboard

Excel input view

Tags: Excel Dashboarding, Sample Dashboard Download,

Excel Dashboard

Homework: If you need to review graphing using excel, check out these books on excel charts .

PS: If you find yourself part of an enterprise dashboard effort, you must study Enterprise Dashboards: Designs & Best Practices for IT, the only book on actually implementing enterprise 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.

May 5, 2006

Excel 2007 Dashboard Screenshots – a new wave of dashboards on the way

Filed under: Dashboard Screenshots — Tags: , — dashboardspy @ 2:11 pm

Update: No time to learn the ins and outs of Excel 2007 versus earlier versions? If you need a fast, low-cost path to Microsoft Excel dashboards, consider using ready-to-go  <a href=”http://www.exceluser.com/cmd.asp?af=784889” rel=”nofollow” target=”_blank”>Excel Dashboard Templates</a> from ExcelUser. They are plug and play, pure Excel worksheets. Just point them to your data source. They look great and are inspired by magazine-style dashboards.

When Office 2007 comes out, the impact on casual, do-it-yourself dashboards, will be huge. Out of the box, Excel 2007 (Excel 12) will have some serious dashboarding capability. We will see a new wave of Excel-based dashboards that look like the screenshot below.

This article discusses the impact on IT departments of the new Excel. In it, the author focuses on the fact that “Spotting trends or out-of-the-norm values is likely more important to your users.” and that the new Excel has serious capabilities in that regard. He goes on to say:

“The most significant improvements in Excel fall in the area of data visualization. In the new release, a colored gradient in cell backgrounds can be used to represent a cell’s value. The higher the value, the longer the bar. Excel 12 gives you the ability to create your own dashboards. Traditionally, the three-color traffic light (red, yellow, green) has been a popular way for end users to spot problems. Now traffic lights—and a variety of other graphics, such as arrows—are available in Excel 12, and you can define the intervals each colored light is assigned.”

In the dashboard screenshot below, green lights represent values over 67% of the maximum, yellow for values between 33 and 67 percent, and red for those less than 33 percent. These intervals are user adjustable, and you can base indicators (traffic light colors, arrow directions, or whatever icon you choose) on values in addition to percents.

Excel Dashboard Screenshot

Another significant change is in the Excel controls. Here is a screenshot of the toolbar “ribbon” used for pivot tables.

Excel Toolbar Dashboard Screenshot

Homework: Don’t underestimate the impact on the dashboarding landscape that Excel 2007 will have. Also, as this is a significant upgrade, the training impact will be high. Keep an eye on these upcoming books on Excel 2007.

Tags: Excel Dashboards, Dashboard Screenshots

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.

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.

Create a free website or blog at WordPress.com.