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
Related Business Intelligence Dashboard Examples:
Download this excellent free Excel resource from Charley Kyd. It's an excel worksheet with a lis ...
Executive Dashboards Template Example: Excel Template for Sales Dashboard A Dashboard Spy reade ...
Are less dashboards being built using Excel 2007 than I thought? The recent post about customizi ...
Hi,
I am looking for information on how to create Speedometer Dashboard using Excel