The Dashboard Spy

June 5, 2006

Excel Enterprise Dashboard Download – worksheet with small business KPI charts

Filed under: Dashboard Screenshots — dashboardspy @ 9:22 am

Dashboard Spy reader updates:

See latest examples of Small Business Dashboards.

And be sure to check these Excel Templates for Dashboard Reports.

The recent focus in this dashboarding forum on Excel dashboards has prompted Dashboard Spy emails with links to their favorite enterprise dashboard worksheets. Lynn points us towards this Excel business dashboard. It’s a downloadable xls file. As you can see from these dashboard screenshots, there is a data input page and lots of nicely laid out charts. Try it out and compare it to the other Excel-based spreadsheets we’ve been pointing to. This one has a good set of business KPIs that are particularly helpful to small businesses.

Executive KPIs include:

Sales by Product
Total Sales
Total Sales Budget Over/Under
Cost of Goods Sold
Materials
Labor
Overhead
Operating Expenses
G&A Expenses
Payroll Salaries
Budget
Sales Expenses
Marketing Expenses
Research & Development Expenses
EBIT
Interest income (expense)
Other income (expense)
Total Nonoperating Income (expense)
Income (Loss) Before Taxes
Income Taxes
Net Income (Loss)
Cumulative Net Income (Loss)

Enterprise Dashboard

Executive Dashboard

Homework: Don’t feel bad if you need to review the basics of graphing using Microsoft Excel. Start with these books on excel charts. A good excel charting basics books is Excel Charts for Dummies

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.

2 Comments »

  1. […] Excel Dashboards The Dashboard Spy has been reporting on how people are using Excel to provide nice looking dashboards that help them keep their businesses smoothly.   […]

    Pingback by Magnum B.I. : Excel Dashboards — June 7, 2006 @ 8:45 am

  2. Excel for dashboard style displays. This is great. Thanks. I’ve been trying to create excel dashboards. Go Dashboard Spy!

    Comment by Excel Dashboarder — June 16, 2006 @ 7:48 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

Blog at WordPress.com.

%d bloggers like this: