This dashboard shows company’s financial summary on industry estimated vs. actual revenue, revenue by region, estimated revenue.
This review is for the business owner who needs an intuitive financial dashboard on a daily basis, but more so, needs the ability to forecast and run scenarios to grow a company.
In today’s world, there is a huge pressure on the management to provide faster and transparent information, which helps in determining company’s overall performance. It tracks financial data, which helps to see the growth from various perspective of the industry.
There are several ways in which you can visualize financial data to understand the company’s goal. In October, Excel Forum team launched a dashboard, competing in which you are asked to visualize financial data using sample data. The challenge has generated a huge thrill around the community and fetched 118 incredible entries.
Thanks everyone for participating and making this a huge learning experience for everyone. Excel Forum team has learned several useful dashboard and charting tricks.
In this article, we will show you the steps on how to create this dashboard.
Let us see how the Dashboard made by Mkulp looks:
We have divided this dashboard into 4 sections of information. Let us take a look at each one separately.
In this dashboard,you will get estimated vs. actual revenue by yearly.
The change from the previous year is calculated & shown in percentage.
This section covers information related to Industry contribution region-wise.
The top product & sales rep is shown for each industry.
The below picture is showing Region/Sales Rep Contribution, yearly in percentage through chart.
This section covers the right pane of the screen, which is controlled through slicer.
The slicers are filtered according to Industry, Product & year. If we select any particular industry with product & year combination then all the data will be accordinglyupdated.
Using this dashboard we can get a clear view of the financial industry and thus we can get the information from various points of view.