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