Microsoft Project Portfolio Reporting for Public Sector Projects Training Course

Course overview

Public-sector portfolios frequently combine capital works, service transformation, donor-funded programmes and humanitarian interventions, each with different approval gates, funding restrictions, geographic delivery conditions and reporting obligations. Programme offices need more than individual Microsoft Project schedules: they need defensible portfolio views that show commitments, milestones, resource pressure, cost variance, benefits status and delivery risk across departments or implementing partners. This course addresses the practical challenge of converting project-level data into reliable decision packs for steering committees, senior responsible owners, funders and audit teams.

Participants build a structured approach to portfolio reporting using Microsoft Project Professional and Project Online. They learn to standardise schedules, calendars, work breakdown structures, custom fields, enterprise resources and baseline practices so that projects can be compared meaningfully. The course covers master projects, cross-project dependencies, portfolio milestone plans, cost and resource roll-ups, earned value indicators, status-date discipline, exception reporting and dashboard design. Participants also learn to prepare Power BI-ready data extracts and present delivery information against public-sector governance requirements, including transparency, value-for-money and benefits-realisation considerations.

Delivery combines instructor demonstration with guided configuration labs using a realistic public-sector portfolio case: a regional resilience and essential-services programme delivered through multiple agencies. Participants create a portfolio reporting model, build executive views, identify data-quality failures and produce a timed reporting pack. They leave with a reusable Microsoft Project portfolio-reporting template, a field dictionary, a reporting calendar and an action plan for implementing the approach in their own organisation.

The course is suited to professionals who already work with project schedules and now need to consolidate information across projects, programmes, grants or delivery partners. It is equally valuable for managers approving the training because it establishes repeatable reporting controls rather than relying on manually assembled spreadsheets.

Course objectives

By the end of this course, participants will be able to:

• Configure Microsoft Project custom fields, lookup tables and graphical indicators for portfolio-level status reporting
• Standardise work breakdown structures, calendars, milestones and baseline rules across public-sector projects
• Build consolidated master project views with linked subprojects and cross-project dependency controls
• Calculate schedule, cost, resource and earned value variances using status dates and approved baselines
• Create portfolio exception reports that highlight delivery, funding, resource and governance thresholds
• Produce executive portfolio dashboards and drill-down report views using Microsoft Project and Power BI data
• Design a reporting calendar, data-validation checklist and field dictionary for a programme management office
• Present a decision-ready portfolio reporting pack for a steering committee, funder or senior responsible owner

Benefits of attending

Target competencies

Who should attend

• Programme Managers — who need comparable evidence on delivery performance across multiple projects
• Project Management Office Managers — who establish reporting standards, assurance routines and portfolio controls
• Public Sector Project Managers — who must submit accurate schedule, cost and milestone data into central reporting
• Development Programme Coordinators — who consolidate implementing-partner plans, grants and donor commitments
• Portfolio Analysts — who turn project data into executive dashboards, exception reports and investment decisions
• Senior Responsible Owner Support Staff — who prepare governance papers for boards, committees and funders

Requirements and prerequisites

Participants should be comfortable creating and updating schedules in Microsoft Project, including tasks, dependencies, resources, calendars, baselines and basic views. Experience of reporting project status, such as actual dates, percent complete, remaining work or cost data, is expected. Attendees should also understand the difference between a project, programme and portfolio, and be able to work confidently with Excel-style tables. Access to Microsoft Project Professional is strongly recommended for practice. Prior Project Online, Power BI, earned value management or portfolio-office experience is not required; these are introduced and applied during the course.

Training methodology

An instructor leads short, focused demonstrations followed by hands-on configuration in Microsoft Project Professional and Project Online. Participants work with a public-sector case portfolio containing capital, service-delivery and donor-funded projects, including incomplete data and conflicting reporting practices. Individual labs cover fields, baselines, master projects, resource views and reports; small groups test reporting thresholds and design steering-committee messages. Each day closes with a practical artefact. On the final day, participants assemble their reporting pack and create an implementation plan for their own PMO, programme or department.

Course outline

Day 1: Portfolio reporting foundations and data standards

• Public-sector portfolio reporting obligations and governance audiences
• Project, programme and portfolio data models in Microsoft Project
• Work breakdown structure standardisation for comparable reporting
• Enterprise calendars and fiscal-period reporting conventions
• Custom fields, lookup tables and required metadata
• Milestone dictionaries and portfolio stage-gate definitions
• Status-date discipline and data-quality validation rules

Workshop: Participants configure a common schedule template and field dictionary for a multi-agency public-sector portfolio.

Day 2: Schedule consolidation and portfolio control

• Baseline creation, storage and approved change-control practices
• Master projects, inserted subprojects and linked-file management
• Cross-project dependencies and shared milestone controls
• Critical path analysis across consolidated schedules
• Portfolio milestone plans and reporting-period snapshots
• Schedule variance indicators using Start Variance and Finish Variance
• Exception thresholds for delayed approvals, procurement and delivery gates

Workshop: Participants build a master project from six delivery schedules and produce a portfolio milestone exception list.

Day 3: Cost, resources and earned value reporting

• Cost resources, fixed costs and public-sector budget coding
• Enterprise resource pools and shared specialist capacity
• Resource availability, overallocations and capacity views
• Baseline Cost, Actual Cost and Estimate at Completion measures
• Earned value fields including BCWS, BCWP, ACWP, CPI and SPI
• Timephased cost and work data for fiscal reporting
• Interpreting variance without overstating delivery certainty

Workshop: Participants diagnose budget and capacity pressures in a resilience programme and produce a cost-and-resource escalation brief.

Day 4: Executive reports, dashboards and decision packs

• Microsoft Project visual reports and built-in report customisation
• Portfolio-level filters, groups and highlight rules
• Graphical indicators for red-amber-green delivery status
• Project Online views and enterprise reporting tables
• Exporting structured Microsoft Project data for Power BI Desktop
• Dashboard measures for milestones, variance, risks and benefits
• Steering-committee narrative and action-oriented exception reporting

Workshop: Participants create an executive dashboard specification and a two-page decision pack from the case portfolio.

Day 5: Reporting governance and workplace implementation

• Reporting calendars aligned to governance meetings and funder deadlines
• Data ownership roles for project managers, PMOs and delivery partners
• Portfolio data-validation checklists and assurance sampling
• Benefits, outputs and outcome indicators alongside schedule data
• Managing confidential, politically sensitive and donor-restricted information
• ISO 21502 principles for governance and stakeholder reporting
• Implementation roadmap for Microsoft Project portfolio reporting

Workshop: Participants complete a capstone portfolio reporting pack, field dictionary, reporting calendar and 90-day implementation plan.

Tools & standards covered

Microsoft Project Professional, Project Online, Power BI Desktop, ISO 21502

A typical training day

Live online deliveries follow the same structure in the East Africa Time zone, with shorter screen blocks and longer breaks.

What the fee includes

How you can take this course

Certification

Participants who complete the full five days receive the Skillset Development Certificate of Completion, stating the course title, course code, dates and delivery format — suitable for professional-development records and employer reimbursement.

Frequently asked questions