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.
Was this enterprise dashboard interesting enough to share? Help spread the news about Dashboards By Example. Click on the "Share" icon above to submit this post to your social bookmark service or email the link to a fellow dashboarder or even yourself.
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 ...
- Happy Face Excel Dashboard - using conditional graphics to show KPI status ...
- Excel Dashboard for Hospital Bed Management ...
- Web Measurement KPIs - Choosing the best metrics for web analytics enterprise dashboards ...
- More Dashboard Spy Search Terms ...
- Excel 2007 Executive Dashboard with new excel cube functions and sparklines ...
- Customizing Ribbon Buttons for Excel 2007 Dashboards ...
- Airline Executive Dashboards - Business Intelligence Dashboard Contest Entries Revisited ...
Latest posts of interest to the business intelligence dashboarding community - Have you read these recent enterprise dashboard posts?
- Project Gemini and Excel Dashboards
- Bling My Dashboard
- Direct Marketing Metrics Dashboard
- Pop-Up Dashboard for 2008 Election Results
- Synchronized Presidential Debates Dashboard-Style
- 2008 Political Dashboards for the Election Home Stretch
- Intranets, Portals and Dashboards, Oh My!
- Real Time Excel Dashboard Tracks Gas Prices
- CERN Collider Dashboard
- Dashboards As Navigation


