Financial Dashboard by Johnny247

 

Created by: Johnny247

 

About Dashboard:

This dashboard showsShift Handover Report of a company. With this dashboard we can quickly analyze the performance of all the associated lines.

There is performance shown on various scales for 4 days at one point of time. Using this dashboard we can easily compare the performance with various parameters like plan, cost, efficiency, etc.

There are several ways in which you can visualize data to understand the company’s goal. In October month, Excel forum team has launched a dashboard competing in which you are asked to visualize data using sample data. The challenge has generated a huge thrill around the community and fetched 118 incredible entries.

 

In this article, we will show you the steps on how to create this dashboard.

Let us see the how Dashboard made by Johnny247 looks:

img1
 
We have divided this dashboard into 6 sections of information. Let us take a look at each one separately.

Section1:

In this section,performance from day 1 to 4 are shown on following parameters:

Plan, Cost, Efficiency, Predicted Zone Recovery, Predicted Zone cost, Actual Tonnage, Planned Tonnage, Zone Headcount.

img2
 
Section2:

This section covers information on Attendance.

img3
 
Section3:

This section shows Head count used in this shift. The graph is shown using pie chart for all the lines.

img4
 
Section 4:

This section zone accident per incidents this shift.

img5
 
Section 5:

The following is a quality shift summary chart shows different parameters like paperwork, non coms, food safety.

img6
 
In the above picture, paperwork & food safety are in green color while non coms is in red color.

Section 6:

This section shows blue zone accident free days

img7
 
There are only 50 days in which there is no accident occurs, the same information is shown in above chart in percentage.

Using this dashboard you can get a clear view of the industry and we can get the information from various point of view.

 

image 48

 

If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com

 
 



20 thoughts on “Financial Dashboard by Johnny247

  1. i really liked this feature.could you please send me the link to download this dashboard.so that i can also create something like this.
    Thank,
    Anand

  2. Extremely well presented! I am wondering if the needle in section 4 – zone accidents – actually moves (and how, calculation behind it)?. Also in section 2, I am assuming the red dot and 96% are one graphic and the red bar is another graph, correct? How can I get more info?

  3. Hi,

    Can you please email me your dashboard. I think it is great but without looking I can’t really provide much comments

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>