How to create a project management dashboard?
The project management dashboard: why and for which objectives?
- To avoid the numerous pitfalls of project management
43% of projects end up outside of objectives. That's almost half! And it is not a hazard. It is very difficult to manage a project successfully because many pitfalls make management complex throughout the project. The causes of failure of a project can be caused by many factors: costs are higher than those of the budget, communication problems set in, lack of visibility on the load extends deadlines, objectives lack clarity from management...
You can find more details on the main causes of project failure
The most effective way to avoid project failure is to monitor it effectively, from its start and regularly until its completion.
- To be able to see and share the project situation
This monitoring must make it possible to identify possible risks of failure throughout the project in order to carry out corrective actions as soon as possible. Monitoring allows you to be alerted when a risk materializes and to understand where the risk comes from.
It is also an instrument of communication. It allows all project stakeholders to be informed sufficiently in advance to streamline decisions and avoid unpleasant surprises. The more a problem is communicated upstream, the higher the chances of finding a solution. No one wants to have unpleasant surprises at the end of a project, and this is how well-executed project monitoring allows you to fulfill this role as a communication tool.
- To empower stakeholders
For a project to be successful, responsibility must be shared. Responsibility for tasks must be distributed to the different project stakeholders. Distributing responsibility involves appointing a person responsible for each task and clarifying the objectives: achievement, quality and deadline. The project manager then becomes the conductor who helps the entire team move forward, and who streamlines the exchanges so that everything takes shape. If stakeholders are not held accountable, the burden will be too heavy for a single project manager, and the risks of failure will be greater.
- It allows for clear communication that is understood by everyone.
The project monitoring table must make it possible to share the project situation at a given date, with information that is clear and understood by everyone.
Everyone must be able to understand how the project is going in the blink of an eye. That topics that are progressing well can be celebrated, and those that need correction can be identified and prioritized.
Following a project in a table format allows everyone to recognize an identical format from one period to another. It brings efficiency to the exchanges between the different stakeholders of the project and allows a situation to be documented clearly.
- To improve performance: respect for deadlines, quality, profitability
The project dashboard is also intended to keep the project aligned with the objectives. Depending on the priorities, different objectives are set:
-
- Respect of deadlines for the different phases of the project
- Expected quality level and potential customer validation
- Level of project costs that must remain aligned with the project budget
The dashboard compares the situation to date, the forecast situation at the end of the project, and the budget for these different objectives.
Noticing possible risks of deviating from objectives, project managers take the necessary corrective actions: restructuring project tasks to shorten it, renegotiation with the client, reallocation of tasks to improve efficiency, etc.
What KPIs should be included in a project dashboard?
Set priorities: deadline, quality, profitability? To define the KPIs to be integrated into the project dashboard, you must first determine the priorities with the project sponsors. Although it is possible to monitor numerous KPIs, we must avoid falling into systematic monitoring of all indicators. We must focus on KPIs that align with the priorities determined with the project sponsors. It is therefore necessary to determine whether the priority lies more in:
- Respect of deadlines : tasks and sub-tasks must respect specified deadlines and any overrun presents a risk for the project. KPI : show a progress rate and a number of days remaining before the deadline
- Compliance with an expected level of quality : the various tasks must be controlled and rated according to expectations in terms of quality. The project dashboard should display the achieved score vs the expected score. KPI : show a quality score for each task and a comparison with the expected
- Profitability : project costs must fit within a certain envelope set by a project budget. KPI : show the costs of the project which take into account what has been achieved and what remains to be done, and compare it to the budget
Here is our selection of KPIs for project monitoring .
-
Analytical dashboard
The project monitoring table must then provide a performance analysis. Displaying major key performance indicators allows you to take the temperature of the project, but you need to go further to understand the reasons for overperformance or underperformance.
For example, you must display the differences between the overall objective compared to the last estimate and give the same information with detail task by task or manager by manager. This allows us to understand where the discrepancies come from and what their causes may be.
Analysis of gaps between the initial plan and reality – Analysis by profile type
A comparison of the project's performance compared to other similar projects also provides an interesting analysis. Next to the project indicators, display an average indicator for similar projects to compare performance.
-
Strategic dashboard
By consolidating the different project monitoring tables, it is possible to provide strategic information that helps make better decisions at the company level.
By consolidating the planned load on the different projects, it is possible to have a complete view of the team's load. Know who is overstaffed or understaffed. This information makes it possible to optimize the overall workload and to know whether it is necessary to recruit certain profiles who will be under capacity in the future.
The financial data of the project and its progress make it possible to calculate the turnover and margins that will be generated in the months to come. Consolidation makes it possible to put forward an income statement for the entire activity.
By comparing the different project monitoring, it is possible to identify interesting trends: which tasks most often lead to underperformance? what is the deviation rate from the average budget? Statistics make it possible to better prepare and cost projects in the future and improve margins.
To learn more about project monitoring, consult our guide.
Limits to using Excel files for project monitoring
The most frequent limitations to using Excel to create project monitoring tables are as follows:
Excel | Dedicated tool | |
---|---|---|
Teamwork | Difficulty working with several people at the same time on the file | Concurrent connections and actions. Sending workflows and notifications. |
Maintenance | Problem of managing a complex file. Creator-related maintenance | Maintenance supported by the publisher. Ensure licenses offer rolling maintenance |
Agility of views | Big. Excel still provides a lot of flexibility but it is the last save that determines the view | Views and analysis angles can be saved so that each user can find their preferences |
Time saving | Excel does not always allow you to automate actions. It is therefore not uncommon for its use to result in double entry. | Dedicated tools allow processes to be connected to each other via API, for example. Which avoids double entries |