Financial Dashboard

financial_dashboard

Case: A typical organisation in a production industry. The financial data is stored in a database. Every quarter the Finance Department receives from IT a report with all the Financial Data from the current year. The CFO uses this report for its analysis. However the report is limited, a quick comparision between years is difficult as he needs to switch between different reports.

Solution: A Financial dashboard which is updated on a predefined shedule. This dashboard shows in one view the Financial status of the company in comparison to the Forecast and to past 3 years.

Key Indicators from Income Statement (e.g. Revenue, EBITDA, EBIT) and Balance Sheet (e.g. Solvency, Return on Equity and Total Assets, Quick Ratio and Current Ratio) are displayed. A what-if analyses is possible on the Key Indicators of the Income Statement.

Dashboard is bilangual (English and Dutch).

This dashboard was developed for Ensior, the dashboard can be viewed from its website after leaving your name and email address.

Recent Related Posts
Femke Kooij is a dashboard and report designer, developer and educator specializing in SAP | BusinessObjects Dashboards (better known as Xcelsius) and Crystal Reports. She has also a lot of experience with other SAP | BusinessObjects toolings like, Web Intelligence (WebI), Information Design Tool (Universe Designer), BusinessObjects Data Services (BODS) and the overall server platform BusinessObjects Enterprise (Launchpad, CMC). She spends a lot of her time thinking about and sharing her knowledge of Xcelsius to others through her own blog. Lately she is exploring other visualization tools like Qlikview and Tableau. On the later she is also posting some experiences. Currently she is in the employment of Cognizant Technology Solutions. Her blog only contains her personal views, thoughts and opinions. It is not endorsed by Cognizant Technology Solutions nor does it constitute any official communication of Cognizant Technology Solutions.

This entry was posted in Portfolio and tagged , . Bookmark the permalink.

One Comment to Financial Dashboard

  1. adi says:

    please give me a guidance to design financial model via xcelsius …tkhs