SABA camp project

Overview

This dashboard is used to monitor the project of implementing temporary structures of a large camp. Each structure consists of precast concrete foundations on which columns are installed. Slabs, walls and the required furniture are installed next. Then the final handover takes place. This is not the actual project I made the dashboard for but they both have the same concept and the dashboard can still be understood with the given information to avoid the need for technical background in the original project. The datasets are also manipulated and do not represent any actual data of the company or the project.

The requirements

The client required that the report :

• Be summarised in a single page that include charts rather than narratives (as it was included within a larger report with narratives and comments).
• Include metrics of my selection given that they describe the project progress speed.
• Cover the period of three months devided by weeks.
• Compare the current period to the period before using average.

The data

• PostgreSQL database.
• 1 Google sheets csv file
• A few excel sheets.

The analysis:

The metrics I selected were:

• Earthworks: Since the speed by which earthworks were implemented is critical to the following installations. It also costs the most and any lag in earthworks may indicate financial issues or disfunctioning project management and thus requires attention. It also takes the most time to accomplish.
• Number of implemented sites: It was observed that only 70% of the sites that are implemented in the beginning of the month are handed over by its end and thus a target was set for the number of implemented sites and is to be monitored to insure that the project is going to finish by time.
• Number of installed foundations and steel columns: Installed foundations give an indication of the speed of precast units production and highlight whether the speed by which earthworks is going is hindering the progress or not regardless of meeting the deadline/ target. On the other hand comparing the latter number to the number of installed steel columns can give the same insight about the speed of foundation installation. Steel columns are imported and thus monitoring the installation process can raise attention to the other issues the project might encounter. Data about the steel columns stock was not provided to be included.
• Number of handed over sites per week: If the handover process going smoothly then any step after the steel installation is also going as planned. Since these steps may take less than 1 day to accomplish there's not much data available to track the speed of them and the HO sites number was selected.
• The percentage of completion (based on the number of sites) was also calculated to show the relationship between each process on a high level and highlight the one that requires the most attention.

The visuals:

• For the number of earthworks the moving average was calculated and presented by a line chart. The comparison to the period before was done using the average of the current 3 months vs the last 3 months and represented by bars to avoid confusion with the constant line is the weekly target.
• The numbers of implemented sites, steel columns and their fountains are cumulative and were also represented by a line chart. The comparison however could not be presented by bars because it'd irrelevant to the lines.
• The number of handovers per week shows an upward trend that repeats every month because a monthly target is set for handovers affecting the mindset/ behaviour of the team.

Key insights:

• Taking a look at the score cards on the top, we can tell that the earthworks is going at a very fast pace compared to the other processes to the point that it's not a factor in determining the speed of the handover process.
• Taking a closer look at the earthworks below, the moving average shows that the earthworks performance is quite stable, compared to the last period, it is even improved. However, it's not even close to the required performance.
• The umber of implemented sites is continously below the plan. Which requires attention by the management to address the main causes.
• The gap between the installed steel columns and their foundations has increased this period. When investigatKingk, the steel columns actually ran out because of an issue with the factory.
• The handover process ran smoothly so far because the handed over sites are the ones implemented before the highlighted issues but it might not be possible to keep it up in the future.

Comments:

I was not granted access to the PostgreSQL database so extracting the data was not as smooth as expected when dealing with a database. The data was not clean and required restructuring. I also had to export some data from primavera P6 to extract the plan data. The data presented is manipulated for project and company privacy purposes but the wrangling and the model is still real. I have done more dashboards and analysis for this project that cover more areas and I'll be sharing some soon.