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.

January 25, 2007

Excel 2007 Executive Dashboard with new excel cube functions and sparklines

Filed under: Dashboard Screenshots — Tags: , , — dashboardspy @ 7:28 am

Some of you enterprise dashboard project members have not yet moved with the Dashboard Spy to his new url at http://www.enterprise-dashboard.com/ so here is a clip of the types of enterprise dashboard posts that you’ve been missing. We’ve been covering dashboard issues such as sparklines and new excel 2007 cube functions.Excel Dashboard Update: This short video shows you MicroCharts for Excel and Microsoft BI in action.Dear Dashboard Spy: Here’s our latest dashboard using sparkline charts. We created an Excel 2007 based dashboard and a PivotTable for KPI Analysis. The first screenshot shows you a management dashboard for the Microsoft BI sample database Adventure Works. Bullet graphs and sparklines are created with MicroCharts formulas. The disjoint blocks of figures are done with the new Excel Cube formulas.Sparklline Enterprise Dashboard Excel Cube FunctionsThe second screenshot shows you a Excel Pivot Table for KPI analysis. The sparklines and bullet graphs enrich the KPIs, allowing you to see trends and patterns. The small graphs are done with the MicroCharts server extension. MicroCharts are calculated as strings within SQL Server and rendered as high quality TrueType fonts with the PivotTable or Reporting Services.Excel Pivot Table Dashboard SparklinesFor the latest info on MicroCharts check out: http://www.microcharts.net/Tags: Sparklines, Excel 2007 Dashboard, Enterprise Dashboard, Executive Dashboards, Excel Dashboards

The Dashboard Spy Business Intelligence Dashboards Blog

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.

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.