Hello and welcome to something a construction KPI dashboard. Sampat keep the eyes which means K performance indicators are really essential nowadays and getting much more important day-by-day. Construction is one of the most important areas which has - Krabbe strengths and witnesses at the same time. This is the nexus eggs. Our template will improve your quality and managing the critical health and safety aspects of the building industry. So let's see the details. Basically, the template has two main sections. The first one is a section in which we input our values like current year actual, current year target, and past year actual. The second one is a section at which we analyze our results in the dashboard field and also together charts at the same time. Additionally, in keeping for sheet, you can see the details and descriptions for each KPI behave using templates. So we've used some dumb information to show you the tool, but you feel the stamp it with your own data. Let's make an example together. Now I'm going to add a new metric to my report as a new item, so I'm going to add.

this new item to my input section here. I can use existing empty areas or add a new row. For this example, I'm going to select the relative group, and instead of inputting manually, I'm just going to copy and paste values from another file that I've marked known before. I'm taking courier actual values and putting it into the current director sheet as values. Similarly, I'm taking current year targets values and putting them into the current year target section here. And the last one, I'm taking pastoralism, putting it together, deflection, and the relative group as values. Yeah, that's okay. Now we can see the dashboard updates according to our need. KPI dashboard section shows monthly and cumulative results. At the same time, we can change the month from this drop-down easily and see the details. And in the track section, we can check our trans monthly and cumulatively. Let's select our new KPI to show updates here. That's all. Thanks for watching, and don't forget to check our other templates to make a website. Thank you.

Construction KPI Dashboard | Excel Template for Construction Industry

Construction KPI Dashboard | Excel Template for Construction Industry

스크립트