Posts

Example of a Weekly Project Status Report for Professional Services Organizations

What is a Weekly Project Status Report?

Weekly Project Status Reports are considered status tracking tools and are used by Project Managers (PMs) and Consulting Managers to display a quick status on each active project to give leaders internal dashboards and reports to show the overall health (e.g. green, yellow, red) across projects. Some of the main functionality in this type of report is that it can reduce or eliminate the need for other, manual project status tracking to give managers a quick health check on the company’s active projects. The report displays the status as a color (seen as the background color in the first columns) along with key project data. Fields to display can include: Client, Project status, Consulting, Light (status), PMO assigned, Consultant, Priority, Start date, and Last update. You find an example of this type of report below.

Purpose of Weekly Project Status Reports

Professional Services organizations use Weekly Project Status Reports to give service leaders a clear picture of the health of their delivery services. When used as part of good business practices in PMO and Consulting departments, a company can improve its ability to easily inform managers about project statuses across all clients to speed up tactical decisions, and it can reduce the chances that managers don’t notice important issues as early as possible.

Example of a Weekly Project Status Report

Here is an example of a Weekly Project Status Report with color coding and comments.

Example of a Weekly Project Status Report for Professional Services Organizations

You can find hundreds of additional examples here

Who Uses This Type of Report?

The typical users of this type of report are: Service Leaders, Project Managers, Consultants.

Other Reports Often Used in Conjunction with Weekly Project Status Report

Progressive PMO and Consulting departments sometimes use several different Weekly Project Status Report, along with Consultant billing reports, billing revenue dashboards, project dashboards, detailed project and summary reports, revenue forecast models, annual budget models and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from enterprise resource planning (ERP) systems like: Microsoft Dynamics 365 (D365) Finance, Microsoft Dynamics 365 Business Central (D365 BC), Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP, Microsoft Dynamics SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Acumatica, Netsuite and others.

In analyses where budgets or forecasts are used, the planning data most often originates from in-house Excel spreadsheet models or from professional corporate performance management (CPM/EPM) solutions.

What Tools are Typically used for Reporting, Planning and Dashboards?

Examples of business software used with the data and ERPs mentioned above are:

  • Native ERP report writers and query tools
  • Spreadsheets (for example Microsoft Excel)
  • Corporate Performance Management (CPM) tools (for example Solver)
  • Dashboards (for example Microsoft Power BI and Tableau)

Corporate Performance Management (CPM) Cloud Solutions and More Examples

Example of a Project Status Dashboard for Professional Services Organizations

What is  Project Status Dashboard?

Project Status Dashboards are considered monitoring tools and are used by project leaders and executives to track how well the delivery teams are doing with active projects. Some of the main functionality in this type of dashboard is that it is parameter driven so the user can run the report for the current period or any historical months. The dashboard itself is very simple but powerful as it uses graphics to display the following: 1) Percent of all project with red, yellow and green status. Red means there are significant issues, yellow means there are some issues, and green means everything is on track, 2) The middle chart shows specifically which clients has red status, and 3) The right chart shows which clients has yellow status. You find an example of this type of dashboard below.

Purpose of Project Status Dashboards

Professional Services organizations use Project Status Dashboards to give managers a snapshot of the general health of their projects using simple indicators like red, yellow and green. When used as part of good business practices in Project Management Offices (PMO) and in consulting departments, a company can improve its project strategies and profitability, and it can reduce the chances that a number of projects go off track without any well known warning signals.

Example of a Project Status Dashboard

Here is an example of a Project Status Report with metrics for overall project health across all clients as well as percentage of projects with red and yellow status.

Professional Services – Project Status Dashboard

You can find hundreds of additional examples here

Who Uses This Type of Dashboard?

The typical users of this type of dashboard are: Service Leaders, Project Managers.

Other Reports Often Used in Conjunction with Project Status Dashboards

Progressive Project Management departments sometimes use several different Project Status Dashboards, along with detailed project reports, project dashboards, project budgets, project forecast models, utilization reports, billing reports, financial statements and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from enterprise resource planning (ERP) systems like: Microsoft Dynamics 365 (D365) Finance, Microsoft Dynamics 365 Business Central (D365 BC), Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP, Microsoft Dynamics SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Acumatica, Netsuite and others.

In analyses where budgets or forecasts are used, the planning data most often originates from in-house Excel spreadsheet models or from professional corporate performance management (CPM/EPM) solutions.

What Tools are Typically used for Reporting, Planning and Dashboards?

Examples of business software used with the data and ERPs mentioned above are:

  • Native ERP report writers and query tools
  • Spreadsheets (for example Microsoft Excel)
  • Corporate Performance Management (CPM) tools (for example Solver)
  • Dashboards (for example Microsoft Power BI and Tableau)

Corporate Performance Management (CPM) Cloud Solutions and More Examples

Example of a Project Dashboard for a Professional Services Company

What is a Project Dashboard for a Professional Services Company?

Project Dashboards are considered operational monitoring tools and are used by executives and project managers to analyze consulting resources and project performance. Some of the main functionality in this type of dashboard is that it enables analysis of KPIs and other metrics from six different perspectives: 1) Project manager ranked by billings and with billable amount, billable hours and nonbillable hours, 2) Consultants ranked by billable amount and with billable hours and nonbillable hours, 3) Number of projects by project manager (PM), 4) Percent of projects with green, yellow and red status, 5) Monthly trend in billable amounts, and 6) Monthly trend in billable hours. You find an example of this type of dashboard below.

Purpose of Project Dashboards

Professional service organizations use Project Dashboards to gives consulting leaders an easy way to understand how project managers, consultants and projects are performing. When used as part of good business practices in Financial Planning & Analysis (FP&A) and Consulting departments, an organization can improve its decision speed as it relates to projects and professional resources, and it can reduce the chances that poor performance goes undetected with likely resulting loss in revenues.

Example of a Project Dashboard

Here is an example of a Project Dashboard with metrics of PMs and their team members as well as project status.

Example of a Project Dashboard for a Professional Services Company

Example of a Project Dashboard for a Professional Services Company

You can find hundreds of additional examples here

Who Uses This Type of Dashboard?

The typical users of this type of dashboard are: Executives, CFOs, consulting managers, project managers.

Other Reports Often Used in Conjunction with Project Dashboards

Progressive Financial Planning & Analysis (FP&A) and Consulting departments sometimes use several different Project Dashboards, along with profit & loss reports, project dashboards, revenue dashboards, detailed billing and utilization reports, project budget models, billing forecast models and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from enterprise resource planning (ERP) systems like: Microsoft Dynamics 365 (D365) Finance, Microsoft Dynamics 365 Business Central (D365 BC), Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP, Microsoft Dynamics SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Acumatica, Netsuite and others.

In analyses where budgets or forecasts are used, the planning data most often originates from in-house Excel spreadsheet models or from professional corporate performance management (CPM/EPM) solutions.

What Tools are Typically used for Reporting, Planning and Dashboards?

Examples of business software used with the data and ERPs mentioned above are:

  • Native ERP report writers and query tools
  • Spreadsheets (for example Microsoft Excel)
  • Corporate Performance Management (CPM) tools (for example Solver)
  • Dashboards (for example Microsoft Power BI and Tableau)

Corporate Performance Management (CPM) Cloud Solutions and More Examples