Excel Dashboard for Monitoring the Competitive Landscape
Here is a look at how an excel dashboard can be used to compare the financial ratios of competing companies. It comes from excel dashboard guru, Charley Kyd, who provides sample excel dashboards at his site. This enterprise dashboard provides a graph of a company’s sales and profits and lists the company’s competitors. Various financial ratios are then provided so that the user can perform a competitive analysis. The data is provided via data from live links to an OLAP database of public data from Hoovers.com. The KPI categories include: Operating Ratios, Profitability Ratios, Financial Ratios, Cash Flow Ratios and information on Revenue Growth. Here is the screenshot of the excel dashboard:

Need to review charting with excel? Start with Excel Charts for Dummies.
Tags: Excel Dashboard, Enterprise Dashboard, Executive Dashboard
The Dashboard Spy Business Intelligence Dashboards Blog
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:
- SharePoint Template for a Competitive Intelligence Dashboard ...
- Security Update Patch Management Dashboard for Monitoring Patch Status ...
- A Look at Building Dashboards in Excel ...
- Excel 2007 Dashboard Screenshots - a new wave of dashboards on the way ...
- Small Business Dashboards ...
- Excel-based Enterprise Dashboard - excel worksheet xls file download ...
- Venture Deal Dashboards ...
- Performance Dashboard Screenshot - A university research division scorecard based on excel ...
Latest posts of interest to the business intelligence dashboarding community - Have you read these recent enterprise dashboard posts?
- Dell IdeaStorm Dashboard
- Excel Tool Tips
- Rube Goldberg Dashboard
- Dashboard Spy White Paper Collection Launches
- Excel Visualization of Olympic Medal Count
- Executive Dashboards for Wholesale Distributors
- Focus on Priorities with Desktop Dashboards
- 3rd Place Excel Dashboard is for Pharmaceutical Sales
- Diversity Dashboard
- Second Best Excel Dashboard of 2008


