I had done my Industrial Training for 12 weeks starting from 20th July 2020 until 9th October 2020. My internship company is DAR Energy SDN BHD in Kuala Lumpur. It is a consultant engineering company mainly in Oil and Gas Industry. It is such a quite known consultant company and their main client is PETRONAS. Since it is a consultant engineering company, the job scope is more to office works. However, the interns still got the knowledge and exposure regarding what are engineers doing.
There are 15 UTM's interns in this company and most of us were working from home since this pandemic (COVID-19) is not end yet. I was assigned in Project Management department focusing on project dashboard together with another intern, Ahmad Faris. My supervisor is Captain Sarudin Awang. I feel very glad when he was my supervisor because he is very supportive and he always shared his experience in which indirectly gave me an exposure on consultant works.
My main task objective was to create a project dashboard using third party application. Basically dashboard is to display a key performance indicator in an organized way. From hundreds data, simplified it by using excel to display status of the project and will be presented to a higher management. At first, it was quite challenging for me because I dont have much knowledge on Excel formula and functions. I was having a hard time when I did my first task which is extract manhour data from MDR and sorted it by week. The manhour data is recorded by how many manhour spent for each task by each department and the leader of department will reported it every week.
There are many other things that I got to know in order to create dashboard. For instance, use pivot table and slicer, drop-down list where there is more than one options in a cell, and many other things. As time goes by, I learned a lot in excel formula and functions in which I think, really helpful in my future.
From almost 500 rows data, I had simplified the data based on dashboard's needs; manhour histogram plan vs actual, project progress, document summary, key project data, etc.
This is only a little piece data that I had simplified.
These are my final dashboard that I created.
I used this dashboard as my presentation during Final Review session involved owner of the company, Ir Rozali, and some CPE lecturers. I am very happy as my hardwork to create this kind of dashboard paid off. They praised my dashboard as I included speedometer to show current status of the project and drop-down list in manhour histogram by discipline in which seems interesting and provides at-a-glance views.