Tutorial

How to make reports and how to extract structured data from your projects managed with MS Project

The project manager, after creating a project plan, will focus on data collection and monitoring.

Analyzing project performance and updating project status by communicating with stakeholders.

Estimated reading time: 8 minutes

When there is a difference between what is planned and the actual performance of the project, we have a Variation. The variation is measured mainly in terms of time and in terms of cost.

Microsoft Project Monitoring Report

There are different ways to view the activity with the variation, i.e. find evidence of the difference between the estimate and the final balance.

Below we see 4 methods:

1 method - Graphical view through Gantt monitoring

Click on the tab Immagine in the menu bar, in the group Activity views select Gantt verification in the drop-down list Gantt chart.
You can compare the Gantt bars "currently scheduled" with the "initially planned" Gantt bars. You can see which tasks were started later than planned, or required more work to complete.

2 Method - Graphic view for Gantt detail

Click on the tab Immagine in the menu bar, in the group Activity views select Gantt detail in the drop-down list Gantt chart

3 method - Table of variances

Click on the tab Immagine in the menu bar, in the group Data select change in the drop-down list Table

4 method: filters

Click on the tab Immagine in the menu bar, in the group Data select Other Filters in the drop-down list filters, and choose a filter like Late activities, Slipping activity,… etc…
Microsoft Project will filter the task list to show only the activities filtered in this process. So if you select Late activities, only incomplete activities will be displayed. Any activity already completed will not be displayed.

Project Cost Management

To examine the costs in a project life cycle, you should be aware of these terms and what they mean in Microsoft Project

  • Basic costs - All planned costs as saved in the basic plan.
  • actual - Costs incurred for activities, resources or assignments.
  • Remaining costs - Difference between basic / current costs and actual costs.
  • Current costs: when plans are modified due to the allocation or removal of resources or the addition or subtraction of assets, MS Project 2013 will recalculate all costs. This will appear below the fields labeled Cost or Total Cost. If you started tracking the actual cost, it will include the actual cost + the remaining cost (incomplete activity) per activity.
  • Variance - Difference between basic cost and total cost (current or planned cost).

Click on the tab Immagine in the menu bar, in the group Data select Cost in the drop-down list Table

You will be able to view all relevant information. You can also use filters to view activities that exceed your budget.

Click on the tab Immagine in the menu bar, in the group Data select Other filters in the drop-down list Filters. Finally select Cost out of budget and confirm with the button Apply

Report of project resource costs

For some organizations, resource costs are primary costs and sometimes the only cost, so these must be closely monitored.

Click on the tab Immagine in the menu bar, in the group View Resources select Resource List

For costs, click on the tab Immagine in the menu bar, in the group Data select Cost in the drop-down list Table

We can sort the Costs column to see which are the most expensive and least expensive resources.

Innovation newsletter
Don't miss the most important news on innovation. Sign up to receive them by email.

To sort, you need to click on the auto filter arrow in the Cost column header. When the drop-down menu appears, click Order from largest to smallest.

You can use the AutoFilter function for each column, by ordering the Variance column, you will be able to see the variance model.

Automatic filter

Project report

Microsoft Project comes with a pre set of reports and dashboardsdefiniti. You will find them all in the tab Report. You can also create and customize graphical reports for your project.

Dashboard Report (Dashboard)

Click on Report → View group Report → Dashboard.

Resource Report

Click on Report → View group Report → Resources.

Cost report

Click on Report → View group Report → Costs.

Report on work progress

click on Report → View group Report → In progress.

Custom reports

Click on Report → View group Report → New report.

There are four options.

  • Empty: creates a white report. Use the Report Tools - Design tab to add graphics, tables, text and images.
  • Graphic: Creates a graph comparing Actual Work, Remaining Work, and Work by Defaultdefinita. Use the Field List panel to select several fields to compare. You can change the look of the chart by clicking the Chart Tools, Design and Layout tabs.
  • Table: Create a table. Use the Field List panel to choose which fields to display in the table (Name, Start, End, and % Complete appear by defaultdefinita). The outline level box allows you to select the number of levels in the project outline that the table should show. You can change the look of the table by clicking on the Tools tab, Design and Layout tabs.
  • Comparison: creates two graphs side by side. The graphs will have the same data at the beginning. You can click on one of the graphs and select the desired data in the Field List pane to start differentiating them.

FAQ

What is the purpose of Microsoft Project in general?

Microsoft Project aims to help users develop realistic project goals through planning well-considered, budget management and resource distribution. 
Users can create projects, track tasks, and report results. 
Additionally, it gives project managers and project owners significant control over their resources and finances. 
This is achieved through simple processes to assign resources to tasks and budgets to projects.

Microsoft Project Online VS Desktop: What's the Difference?

MS Project Online and Project Desktop differ significantly. 
MS Project Online caters to multiple users who can assign tasks, track time, and review other related project items. 
The desktop version is primarily aimed at project managers who use it for definish and track activities.

How to create and manage project schedule in MS Project Desktop?

When you start a new planning, you add tasks and organize them efficiently so that the project finish date happens as soon as possible. 
To start entering your first schedule and get your first Gantt chart, follow the steps described in this article.

Related Readings

Ercole Palmeri

Innovation newsletter
Don't miss the most important news on innovation. Sign up to receive them by email.

Latest Articles

The Benefits of Coloring Pages for Children - a world of magic for all ages

Developing fine motor skills through coloring prepares children for more complex skills like writing. To color…

May 2, 2024

The Future is Here: How the Shipping Industry is Revolutionizing the Global Economy

The naval sector is a true global economic power, which has navigated towards a 150 billion market...

May 1, 2024

Publishers and OpenAI sign agreements to regulate the flow of information processed by Artificial Intelligence

Last Monday, the Financial Times announced a deal with OpenAI. FT licenses its world-class journalism…

April 30 2024

Online Payments: Here's How Streaming Services Make You Pay Forever

Millions of people pay for streaming services, paying monthly subscription fees. It is common opinion that you…

April 29 2024