Infrastructure Projects Scheduling Analysis Framework

Each city has thousands of projects which may not be planned efficiently due to the current limitation of project management software such as Microsoft Project (MS Project). Therefore, it is essential to develop a framework to analyse the scheduling of infrastructure projects through combining the power of Business Intelligence with Project Management algorithms (e.g. Precedence Diagram Method) along with adding built-in algorithms for identifying any scheduling issues. We have accomplished this by merging R and Power BI and using the bests of these two popular worlds.


Below screenshot shows a vertical Gantt chart in Power BI along with various filtering components.

Below screenshot shows a horizontal Gantt chart (we developed this in R) in Power BI along with various filtering components.

Below screenshot shows another version of vertical Gantt chart in Power BI along with various filtering components, cumulative cost, and costs per project category.

Below is an screenshot of MS project for reporting and cross-referencing.

Below is our Precedence Diagram Method (PDM) developed in R for using in Power BI. The purpose was visualizing the relation between projects in a clearer way than MS Project.

Below is a table that shows various calculated parameters from PDM such as Earliest Star, Critical path, and Latest Finish. This table also highlights projects which may have incorrect dependencies and must be reviewed by Project Managers. We developed this in R for using in Power BI to facilitate reporting.

Below are two screenshots of 3D diagram of projects which we developed to identify hidden dependencies (i.e. missed by Project Managers)