Excel Enterprise Dashboard Download - worksheet with small business KPI charts
->
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)


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.

What do you think about this dashboard post? Please leave a comment. Your opinions are valuable to the entire business dashboarding community.
Leave a Reply
Dashboard Spy Readers: See these related Business Intelligence Dashboard posts:
- A Look at Building Dashboards in Excel ...
- Excel Infographics ...
- Happy Face Excel Dashboard - using conditional graphics to show KPI status ...
- Web Measurement KPIs - Choosing the best metrics for web analytics enterprise dashboards ...
- Excel Dashboard for Hospital Bed Management ...
- Customizing Ribbon Buttons for Excel 2007 Dashboards ...
- Excel 2007 Executive Dashboard with new excel cube functions and sparklines ...
- More Dashboard Spy Search Terms ...
Latest posts of interest to the business intelligence dashboarding community - Have you read these recent enterprise dashboard posts?
- Excel Infographics
- iDashboards Winter Olympics Dashboard
- Go Back to School for Excel
- 7 Ways to Remain Relevant for Business Intelligence in 2010
- Dashboard Data Table Navigation
- Dashboard Metrics Status Indicators
- Communicating Through Business Dashboards
- Building a Flex Dashboard
- Retail Store Scorecard
- Google Analytics Marketing Dashboard




