What is Dashboard?
Importance of Dashboard
- To quickly gain insights into the most important aspects of the data
- Highlights problems or issues that need further attention
- Allows to consolidate information from across organization.
Dashboard - by using excel
P1022 is the number for the project which is Puteri K5 Infill Development Project. The dashboard cut off date is 3/8/2020 and in week 12 can be seen at the right top. Some of the important things in the dashboard are Project Data, Project Progress Plan vs Actual where we can see overall progress of the project is better than the planned or not, and overall progress in terms of table which is more details for each department based on current week and last week performance. In addition, in the table form, there are some highlight (red color) that we can see in which may needs further attention.
The speedometer of Current Project Progress shows updated status of the project. From that we can easily know the project is better than the plan or not. Same with Man hour & Cost (Expended vs Budget), where it shows current budget used so that we can estimate how much the budget need to be used.
Project Progress vs Utilised Manhours percentage is to show the varience of both elements. We can compare how much percent man hours used for that particular percentage of project progress. If percent man hours is less than percent project progress, then it is in a good status. The Document Summary shows percentage submission of every document status which are:
- Start - the task start
- IDC - Interdisciplinary check
- IFR - Issued for Review
- AFC - Approved for Construction
and the table to show exact total numbers of each document. Last but not least, Man hour Histogram at the bottom is to show overall number of man hour for plan and actual project and by discipline (right) where I inserted drop-down list to choose the department.
All the data included in the dashboard was the data I had simplified were come from Master Deliverables Register (MDR) given by my Supervisor. In the MDR included:
- Document type and class, weight, and status
- Total man hours for each discipline
- Info on plan and actual delivery dates (Start, IDC, AFC, IFR)
and others.