Tuesday, April 16, 2024

Portfolio Management: Building An Agile Portfolio Roadmap with MS Project

In my previous articles related to Portfolio Roadmap (Part 1, Part 2), I wrote the following:

“A portfolio roadmap is crucial because it shows the strategic intent of the organization in a visual (graphical) way. Irrespective of the approach used in portfolio management such as predictive (waterfall), adaptive (agile), hybrid or any other, the roadmap acts as an information radiator.”

As you may have noticed, Portfolio Roadmap is also used in adaptive approaches. In this article, we will learn how to have Agile components, using the Scrum framework, in a portfolio roadmap.  

At this stage, I’d strongly recommend that you read the previous two linked articles on the Portfolio Roadmap. Going forward, I’m going to modify that roadmap to include Sprints. Hence, it’s important that you read both.

Our Scenario

For one of the component projects, Project F, the approach used is Agile, specifically Scrum. For Project F, we have three releases and each release will have a number of Sprints. This is depicted below.  

As shown in the above figure, there are many components in our portfolio. The Component Project F consists of three iterations or Sprints. The Sprint length is 4 weeks. The Portfolio Management Office (PfMO) directive is to show all the releases and the Sprints in the portfolio roadmap. 

The Agile Portfolio Roadmap will be similar to the Traditional Roadmap, but differ in visualization. In our case, as noted earlier, we want to have the component project, releases and Sprints.  That said, we will take the following steps. 

Add Agile Custom Flag

To distinguish between the agile and non-agile, we will add another custom Boolean flag - isAgile. This will be in addition to the existing custom flags for component projects, programs and operations.  

Format for Agile Project (Project F)

Next, using the above Boolean flag (isAgile), we will format the Agile related components in the Agile Portfolio Roadmap. The formatting can be done by going to Format tab > Bar Styles group > Format command.  

As shown above, I’ve added an Agile Task above:

  • The appearance is with different color-coding.
  • The conditions applied for the task have the isAgile (flag) enabled.

Now, we are going to add this custom isAgile field and enable it for Project F to be executed in Agile mode.  

As you can see, after I enabled the isAgile custom flag for Project F, the color coding changed. The project has been renamed to Project F (Agile Mode) to make it distinguishable.  

Add Releases to the Component Project (Agile Mode)

In this step, we are going to add the releases to the component project, which is executed in Agile mode. After you add them, we will get the following view. 

As shown above:

  • Project F has three releases – Release 1, Release 2 and Release 3
  • Each release has a 2-month duration. 
  • Each release is highlighted in a separate color.
  • Dependencies among the releases are shown.

You might be wondering about the reason for the change of color of Project F to blue. This is because Project F has now become a Summary Task. Hence, the respective color coding has been applied. 

If you want to keep the same color coding, then you have put the formatting condition below the Summary Task and made some changes to the algorithm.

Add Scrum Custom Flag

To show Sprints under the releases, you can add another custom Boolean flag isScrum, This flag can be added similarly to what we have done for isAgile custom flag.  

Format for Sprints (Project F)

Like we formatted for the releases (Agile mode), similarly, we have to format for the Sprints. You to change the conditions while formatting and applying the Boolean flag isScrum, which we just created.

Next, create the respective Sprints under the releases, and you can see them in the Agile Portfolio Roadmap. This is shown below. 

As shown above:

  • Release 1 has three Sprints – Sprint 1, Sprint 2 and Sprint 3. Release 2 also has three Sprints – Sprint 4, Sprint 5 and Sprint 6.
  • All the Sprints have different formatting and color-coding.
  • Release 3 has no Sprint, and it retains the previous formatting and color coding.
  • With Sprints, Release 1 and Release 2 became Summary Tasks, and hence, they retain the respective formatting and color coding.

Video Demonstration – Portfolio Roadmap 

To have a better understanding, the below video demonstrates further what we have learned so far [Duration: 05m:16s]. 


Sprints are mini-projects with 1 to 4 weeks of duration. As the Sprint length is short, then it’s not necessary to display it in the roadmap. But then, it depends on the organization’s mandate.

Nevertheless, Agile approaches are part of Portfolio Management and if you are preparing for the Portfolio Management Professional (PfMP®) certification exam, then you need to know them, but not extensively.

The Standard for Portfolio Management explicitly notes other approaches as part of Portfolio Management:

“The portfolio management plan (PfMP) may describe or refer to different methodologies or approaches which the organization applies to manage different classes or types of portfolio components, specified in the portfolio roadmap.”

To elaborate further, the PfMP should have sections or reference sections, where different methodologies to be applied are noted. These can be predictive, adaptive (iterative and incremental) or agile, or a hybrid model.

I hope this article gives your needed hands-on information to build an Agile Portfolio Roadmap.


[1] NEW Book – I Want To Be A PfMP, the plain and simple way, by Satya Narayan Dash

[2] Article: Portfolio Management: Building and Managing A Practical Portfolio Roadmap – Part 1, by Satya Narayan Dash

[3] Article: Portfolio Management: Building and Managing A Practical Portfolio Roadmap – Part 2, by Satya Narayan Dash

[4] The Standard for Portfolio Management, by Project Management Institute (PMI)

Friday, April 05, 2024

Portfolio Management: Building and Managing A Practical Portfolio Roadmap with MS Project (Part – 2)

In the earlier part, we discussed the first set of steps needed to build a Portfolio Roadmap with a hands-on software tool, i.e., MS Project. There the following steps were informed:

  • Step – 1: Add the Portfolio Components 
  • Step – 2: Differentiate the Components 
  • Step – 3: Format the Bar Styles for Components

The components, as informed in the previous part, can be projects, programs, operations, business proposals, among others. In this part, we will take the final steps:

  • Step – 4: Apply the Bar Styles for Components
  • Step – 5: Track Progress with Portfolio Roadmap

You will also learn to show the dependencies between the components and the importance of a portfolio roadmap. This part will end with a hands-on video demonstration.

I'd strongly suggest that you read this linked article, before proceeding further. For this part, we will start with Step - 4.

This series: Part – 1


Step – 4: Apply the Bar Styles for Components

Now that we have customized the bar styles, we have to apply them into our Gantt Chart view to have the visualization. To do so, I’ll remove the earlier columns of Duration, Start and Finish, but add two new columns of isProgram and isOps. Remember we just added these two custom fields (columns).

Next, for each program component, the isProgram flag will be enabled and for each operation component, the isOps flag will be enabled. This will result in the following figure.  

As shown:

  • For Program B, the isProgram flag is enabled, but isOps flag is disabled. It’s shown in green colored bars.
  • For Business Area 1 Operations, the isOps flag is enabled, but isProgram flag is disabled. It’s shown in orange colored bars.

To have the name of the portfolio components on the right side of the bar, do ensure that the “Name” field is populated in the bar styles as shown below. 

Isn’t it a much better representation than the earlier one? 

The flag settings with bar style formatting is also very useful when the new portfolio components are added. You have to just enable or disable the flags and the color will automatically change. 

Step – 5: Track Progress with Portfolio Roadmap

Now, a portfolio, if completely new, can be authorized or some of its components can be authorized by the portfolio governing body. Assuming we have a new portfolio and it’s authorized the portfolio is in progress.

As the portfolio components are executed by the resources (financial, equipment, and human), we will have progress reported on the components. Let’s say few of the components are complete and we have to display the progress. For this purpose, we simply have to use the ‘% Complete’ column and show 100% completion. 

When visualized with completed portfolio components, we will have the following view.

As shown:

  • We have three projects, Project A, Project B and Project C, which are complete.
  • We have one program, Program A, which is complete.
  • The completion is shown with a small horizontal line going inside the bar.

For a clear visualization of completion (a line going inside), I’ve increased the size of the bar by going to Format tab > Format group > Layout command and then changing the bar height to 18, instead of default 12.  

Dependencies in the Portfolio Roadmap

As we learned in the beginning, the portfolio roadmap also shows the dependencies among the components and/or across business areas. Dependencies can be easily shown by using the predecessor field of MS Project software.

For example, in the below figure, we have dependencies shown among multiple component projects and programs of the portfolio.  

Portfolio Component Grouping

The Standard for Portfolio Management, also informs that the completed portfolio components can be grouped and displayed on top of the roadmap. This also can be done with MS Project software. 

For this purpose, I’ll use the built-in Complete and Incomplete Tasks group, which can be seen by going to View tab > Data group and selecting this group from the Group drop down menu. In this grouping, we will change the ordering to Descending.

As shown above, only change the order to ‘descending’ and keep the rest of the formatting as it is. Now, when you apply the grouping, we will have the following view. 

Clearly, the components which are 100% complete are shown on top, whereas the ones not complete, or yet to be started are shown towards the bottom of the above view.

Importance of Roadmap *** NEW ***

The importance of portfolio can be understood by the below top points:

  1. Shows both internal dependencies among portfolio components and can also show external dependencies. In fact, in your portfolio review meeting (governance meetings), this will be one of the first artifacts to be shown. 
  2. Shows the milestones and hence important for portfolio value delivery. Milestones are significant events in the portfolio’s timeline. Any delay in a portfolio component’s closure and subsequent benefits realization can have ripple effects on portfolio management.  
  3. Helps in defining the portfolio components, i.e., used specifically in identification, categorization, scoring and ranking of portfolio components. 
  4. Clearly identifies the classes or types of portfolio components. This way, if some of the components are executed in Agile (Adaptive) mode, they can be represented. Hence, it truly helps in communication and risk management approaches as defined in the Portfolio Management Plan. 
  5. An excellent communication tool with others, including portfolio managers, component managers and top executives, including the C-suites in an organization. 

Video Demonstration – Portfolio Roadmap *** NEW ***

To concretize your understanding, I’ve created the following video [duration: 05m:44s] to demonstrate the portfolio roadmap that we just created. This content of this video is referenced from my new PfMP book. Plug-in your earphones for a better audio-visual experience. 


Now that we have clearly understood portfolio and portfolio roadmap, their components and elements, I’ll come back to our opening quote. But I’d slightly rephrase it and say:

Project creates and delivers. Program coordinates and guides. Portfolio decides and drives. 

A portfolio not only decides the components to be taken, but also drives them in order to achieve the organizational strategies and objectives. The portfolio roadmap, on the other hand, is a key deliverable and indispensable tool used in portfolio management. The roadmap shows the strategic mapping, “to-be” vision of the portfolio, priorities, dependencies as well as the high-level plan.

The portfolio roadmap, along with the portfolio strategic plan and portfolio charter, drive the development of the portfolio management plan – the consolidated plan that drives the execution of the portfolio and its components.

I hope this article helps you in preparing for the Portfolio Management Professional (PfMP®) certification exam and also enables to apply your learning on portfolio roadmap in the real-world portfolio management. 

This series: Part – 1


This article was first published by MPUG.com on 12th September, 2023. The current one is an updated version.

Monday, April 01, 2024

Portfolio Management: Building and Managing A Practical Portfolio Roadmap with MS Project (Part – 1)


Project creates, programs guides, portfolio decides. 

    - Quote from bookI Want To Be A PfMP – the plain and simple way

Project is all about deliverables and it creates a unique product, service or result. Program is all about getting benefits by coordinating the components within its scope. Portfolio, on the other hand, is about meeting the strategic business objectives of an organization with a collection of right portfolio components. Hence, it decides. 

It’s portfolio that decides which component project to take and which one to drop, which component program to take and which one to drop. At the portfolio level, you not only authorize the components, but also can deactivate or even terminate a component. Most important of all, it’s portfolio which directly links the organizational strategy to a prioritized set of programs, projects and operations. Portfolio is completely strategic in nature, whereas programs and projects are typically tactical. Because with portfolios, an organization achieves its strategic goals and objectives, which are outlined in the organization’s strategic plan. 

By this time, you would have begun to realize the importance of portfolios and portfolio management. It’s key to have consistent success for an organization, deliver predictably and remain ahead of the curve. 

Now, to successfully enable the portfolio manager and hence, C-suite executives, a widely used artifact or key deliverable is the Portfolio Roadmap. In this article, we will know more on Portfolio Roadmap, and how to build such a roadmap with MS Project software.

This series: Part – 1

Portfolio Roadmap

Let’s start with the definition of portfolio roadmap. As per Project Management Institute (PMI®):

Portfolio roadmap is a document that provides the high-level strategic direction and portfolio information in a chronological fashion for portfolio management and ensures dependencies within the portfolio are established and evaluated.

Illustrating further on the above definition, you can say the following about the portfolio roadmap:

  • Graphically shows all the portfolio components (elements) to achieve organizational strategy and objectives.
  • A high-level plan for your portfolio and based on it, low-level details will be prepared. The low-level details include the low-level schedule and timeline of portfolio components such as projects, programs, operations or other work. 
  • Provides the foundation or initial basis on which internal and external dependencies are established and evaluated.

A portfolio roadmap is crucial because it shows the strategic intent of the organization in a visual (graphical) way. Irrespective of the approach used in portfolio management such as predictive (waterfall), adaptive (agile), hybrid or any other, the roadmap acts as an information radiator.

From Portfolio Strategic Plan to Portfolio Roadmap *** UPDATED ***

The significance of a portfolio roadmap is further emphasized in the flow of processes in portfolio management. A portfolio primarily exists to achieve the strategic business objectives of an organization. The vision, goals, strategies and objectives of a portfolio are listed in the Portfolio Strategic Plan (PfSP), which is created in Develop Portfolio Strategic Plan process. The PfSP drives the development of Portfolio Charter (PfC), created in the Develop Portfolio Charter process. 

The PfC links the portfolio to organizational strategy and formally authorizes the portfolio and portfolio structure. Next, PfC drives the development of the Portfolio Roadmap (PfRM), which is created with Define Portfolio Roadmap process. With the PfRM, the portfolio structure is visualized in a chronological manner. This is shown in the below figure. 

As shown above:

  • Organizational strategy and objectives drive the creation of PfSP.
  • PfSP, in turn, drives the development of PfC.
  • Next, PfC drives the definition and development of PfRM. 
  • All three above, i.e., the PfSP, PfC and PfRM drive the development of the Portfolio Management Plan (PfMP), which is another key deliverable in portfolio management. 

A Practical Portfolio Roadmap

With this background and fundamentals, let’s learn how to build a practical portfolio roadmap in a step-by-step manner. I’ll be using the sample given in PMI’s Standard for Portfolio Management, third edition and build on it with the MS Project software tool. 

To build the portfolio roadmap, we will have the following steps.

Step – 1: Add the Portfolio Components 

As noted earlier, a portfolio can have a number of components or initiatives. For our case, we have the following components:

  • Projects: Project A, B, C, D, E, F and G
  • Programs: Program A, B, C, D, E and F
  • Operations: Business Area 1, 2 and 3 Operations

Each of these components are to be added as tasks into the MS Project plan (.mpp) file. As you add, you should also provide the high-level timeline for each component as shown below. 

As shown above:

  • We have multiple projects, programs and operations added into the initial Portfolio Roadmap.
  • For each portfolio component, we have duration, start and finish dates. These are high-level details. The portfolio roadmap is prepared iteratively and repeatedly adapted. 
  • On the right side of the Gantt Chart, we have portfolio components represented as horizontal bars.

Also, do ensure that the timescale is properly customized. To do so, go to the timescale part of the Gantt Chart’s graphical side (on top), right click and choose “Timescale…”. 

As shown above:

  • We have just one tier (middle). 
  • Units used are “Months”.
  • Label used is “Jan ‘09”.

Adjusting the timescale will result in a better visualization for your roadmap.

Step – 2: Differentiate the Components 

In this step, we will differentiate the components to have more clarity in our graphical representation. For this purpose, I’ll add two custom fields by going to the Format tab > Columns group > Custom Fields command. Both the custom fields are of Boolean type. 

As shown above, we now have two Boolean custom fields: isProgram and isOps. These will be used in the next step.

Step – 3: Format the Bar Styles for Components

In this step, we will add two more bar styles by going to Format tab > Bar Styles group > Format drop down menu > Bar Styles command. 

For our program components, we will have green color-coded bars with the isProgram flag applied, whereas for the operation components, we will have orange color-coded bars with the isOps flag applied. 

In addition, for all the portfolio component bars, we will have the end shape changed to inverted triangles, along with the type and color. This is shown and highlighted below.  

As shown above:

  • For the project components, we have the default blue colored bars. The end shape has been changed. For the program components, we have the green colored bars. And for the operation, we have orange colored bars.
  • The respective conditions applied for the components are:
    • Normal, Active, Not Manually Scheduled (project components)
    • Normal, Active, Flag1, Not Manually Scheduled (program components)
    • Normal, Active, Flag2, Not Manually Scheduled (operation components)
  • For all bar styles, the end shapes have been changed. This clearly shows the finish time of the respective components. 

In the next part of this series, we will do more customization of the Portfolio Roadmap, which will make clear distinctions among component programs, component projects and component operation.

We will also have a video demonstration of this Practical Portfolio Roadmap.

This series: Part – 2

Sunday, March 24, 2024

CHAMP Success Story: A Niche Certification – Never Seen Anything Like This Before

 By Ravi O’Reilly, CHAMP


Before getting into CHAMP certification, I had a face-to-face, virtual meet-up with Satya, where I asked what I should pursue first. As per his suggestion, I started my journey by first completing the MS Project Agile course.

The CHAMP certification was a natural progression and I also really wanted the full certification for its credibility as it is a niche skill.

Own Study – CHAMP Certification

To achieve my CHAMP credential, I diligently followed the videos in the order set out and made time whenever I could. They are nice and short; hence it makes it easily digestible. 

In the course, all the videos are clearly explained and they are very thorough so you get to repeat the steps in subsequent videos. 

Review – CHAMP Certification Course

The course is very niche, extremely detailed and uses MS Project toolsThe certification is a unique selling point (USP) in itself. I have not seen anything like this before and it truly gives you all the learnings.  

Once you get to grips with adding the data and setting up the Hybrid Agile plan, I found the reporting topics were useful, as you get to slice and dice the data in different ways i.e., how to report on earned value management (EVM), the baselines for the traditional part and resourcing.

Throughout the course, there are lots of opportunities to recap and take the short tests. After completing the whole course, a full set of questions and answers (Q&A) helped me to see how much I learned and what parts I needed to go over again. 

CHAMP Exam Experience

After completing the course, I believed I was prepared for the CHAMP exam. I asked Satya to provide me with the online link for the test. The exam has 50 questions to be taken in 1 hour (60 minutes). 

For the exam, my strategy was simple. I just made sure I read the questions properly and not rush them. I knew some of the questions straight away. However, for some of the others, I needed to go back and check on them.

After completing, I thought I didn’t clear the exam and thought I have to retake the test. But Satya informed me that I’ve cleared as I have scored 70%, which is needed to be CHAMP certified!  I received my certificate afterwards.

Suggestions for CHAMP Aspirants


  • If you like this style of learning (hands-on) and also want to get certified in a niche skill, then I would suggest you just go for it.


  • If you are not managing Agile/Hybrid-Agile projects, you may not need it. 


The CHAMP certification is of high standard and to be a CHAMP, you need to be well prepared. The course is so practical! You can apply your learnings in your day-to-day projects in a hands-on manner.

Brief Profile: Ravi O’Reilly, CHAMP, Programme Planning Manager, UK Transport and Govt. related projects.

Wednesday, March 20, 2024

ManagementYogi’s Hybrid-Agile (CHAMP) Certification: Multiple Sprint Management in Hybrid-Scrum Projects

In a recent article for managing the Retrospective Board Hybrid-Scrum project, there was an offline question about multi-Sprint management in Hybrid-Scrum project, along with certain other questions. The questions are:

  • How do you manage multiple-Sprints in Hybrid-Scrum projects?
  • Can they be managed in parallel, if you have separate teams?
  • How do you manage the Sprint Burndown and Burnup charts in such projects?

The answers to the above questions are yes, yes and yes. It’s definitely possible to run multiple Sprints in a Hybrid-Scrum project. One can plan, manage and track them to completion. 

The content of this course is taken from ManagementYogi’s Certified Hybrid-Agile Master Professional (CHAMP) course. In-depth explanation, a number of reports and metrics as well as downloadable .mpp files are part of this certification course. 

Current Scenario

Let’s take the scenario created in the linked article about Retrospective Boards in Hybrid-Scrum Projects. I've modified it to show the status date as of mid-Sprint 2.  

As shown, above:

  • There are five Sprints planned, from Sprint 1 to Sprint 5
  • Sprint 1 under Scrum Development phase has been completed.
  • Sprint 2 is underway and we have completed some of the items.
  • Our status date is mid-Sprint 2.

As this stage, I’d also suggest that you read this article on how to manage multiple Sprints in a plain Scrum project. 

The Planned Sprints

In this case, we have 5 Sprints planned. This can be done with the Manage Sprints commands available under the Project tab.  

All the planned Sprints will be integrated into the Hybrid-Scrum project. The planned Sprints are:

  • Sprint 1: From Monday 13th Oct, 25 to Sunday 26th Oct, 25
  • Sprint 2: From Monday 27th Oct, 25 to Sunday 9th Nov, 25
  • Sprint 3: From Monday 10th Nov, 25 to Sunday 23rd Nov, 25
  • Sprint 4: From Monday 24th Nov, 25 to Sunday 7th Dec, 25
  • Sprint 5: From Monday 8th Dec, 25 to Sunday 21st Dec, 25

Integrated Plan for Hybrid-Scrum Project

The integrated Hybrid-Scrum project plan is shown below. 
(Please click on the images for enlarged views)

In the figure show above, at the end of Sprint 1 (24th Oct, 25) a number of predictive as well as Agile elements. The Sprint 1 events such as Sprint 1 Planning, Daily Scrum (Sprint 1), Sprint 1 Review and Retrospective are complete. The features taken for this Sprint 1, i.e., Smart Entry and Smart Alarm are also complete.

This can also be seen in the Current Sprint Sheet view. It must be noted that the Current Sprint Sheet view is only for the Sprint 1 items.   

Plan for Upcoming Sprints (Sprint 2, 3, 4 and 5)

As shown below, we have features associated for rest of the 4 Sprints. This can be done by going the to the Sprint Planning Board view and just dragging and dropping the work items across the board.  

For Sprint 2, we have Feature – Smart App Integration

Add did you notice Sprint 1? It’s empty because Sprint 1 has been completed. 

Building the Plan for Sprint 2

We are going to take this feature (Smart App Integration) and break it down to individual tasks. We are also going to add various Sprint Events into the Sprint 2 plan. In other words, we are going to the build the Sprint 2 Backlog

We will break the Smart App Integration features into the following tasks:

  • Integrate with smarty entry – 4 days
  • Integrate with smart alarm – 3 days 
  • Test the integrated smart apps – 2 days
  • Deploy and closeout – 1 day

We will also add the following events or ceremonies. 

  • Sprint 2 Planning of 0.5 day
  • Sprint 2 Review of 0.25 day
  • Sprint 2 Retrospective of 0.25 day
  • Daily Scrum (Sprint 2) 
    • Each meeting will be of 15 minutes.

After we add all the above ones, we will have the following view.  

As shown above:

  • The Sprint 2 for the Hybrid-Scrum project is fully planned. It’s highlighted in orange color.
  • There are elements under Test summary task, which are the predictive parts. It’s highlighted in blue color
  • The other Sprints such as Sprint 3, 4 and 5 are not at all planned now.

This can also be visualized in the Current Sprint 2 Board view by going to Sprint Tools > Sprints tab > Views group > Sprint command and then choosing the Current Sprint.  

As you execute the above command, the Current Sprint 2’s Board view will be visible. The Sprint Backlog for Sprint will be available with all the work items. It’s shown below.  

Next, we are going to track the Sprint 2 Backlog. Do note that the above workflow states are changed, but you can go with the existing available ones such as Next Up, In Progress and Done. You can also add as many workflow states as needed. 

Tracking the Sprint 2 Plan

Before you track, set your status date to mid-Sprint. In this case, I’ve set it to Monday, November 3, 25. To track, you have to take the cards and drop them in the respective columns. 

Post tracking, we have the following view. This view clearly shows the Spint 2 board along with the tracked work items.

As you go to the Gantt Chart view one can visualize the tracked Hybrid-Scrum project in detail. 


As we just learned, managing multiple Sprints can be easily done with MS Project Agile software. Multiple Sprints are not only applicable for Hybrid-Scrum projects, but also for Hybrid-Kanban or Hybrid-ScrumBan projects. 

However, to do really learn Hybrid-Agile Management, you need to have the right course and content. In the marketplace, though there are many courses or certification, rarely few will show you how to do in a hands-on manner with principles of Hybrid-Agile management, the roles and responsibilities used, and the tricks or tips needed to succeed in such an environment. 

Finally, the more you practice Hybrid-Agile Management, the better you will get at it!


[1] Certification Course: Certified Hybrid-Agile Master Professional (CHAMP), by Satya Narayan Dash

[2] Article - Working with the Retrospective Board in Hybrid-Scrum Projects, by Satya Narayan Dash, first published by MPUG.com 

[3] Online Course: Mastering MS Project Agile, by Satya Narayan Dash

[4] Online Course: ACP Live Lessons – Guaranteed Pass, by Satya Narayan Dash

[5] Online Course: Microsoft Project Live Lessons, by Satya Narayan Dash

Tuesday, March 12, 2024

Sprints at Scale: Working with 10, 100, 1000, or More Sprints in A Scrum Project

A Sprint is a mini-project and usually has a length of 2 weeks, though it can vary from 1 to 4 weeks. While running Sprints for a big project using Scrum framework, one can run 10, 100, 1000, or more Sprints. The number of Sprints goes-up when the Sprint length is shorter – say 1 week. This scenario highly possible.

Do not confuse Sprints at Scale with Agile at Scale, where multiple teams can work on multiple Sprints.

Now, questions can be:

  • How do you manage so many Sprints?
  • If you are using a software tool, how do you manage them?
  • Is it possible to have the current Sprint being shown first in the tool?
    (with all other Sprints)
  • Is it possible to show the work items for the current Sprint first?
    (a view showing all the Sprints)

These questions are very pertinent for any Scrum Master, Product Owner or an Agile Project Manager. In fact, recently I received such questions from Agile practitioners, who have been using my courses.

Let’s see how to manage a large number of Sprints and the answers to the above questions. 

Our Plan with Epics and Features

Our current plan is shown below and at a high-level:

  • There are 5 epics, from Epic 1 to Epic 5.
  • Each epic is broken into 10 features. In total, there are 50 features.
  • These features will be associated with the respective Sprints. 
  • One feature will be completed in one Sprint. For example, feature 50 will be done in Sprint 50. 

This is shown below in the Gantt Chart view of MS Project. 

These you can add in the Gantt Chart view or you can use the Sprint Planning Board or Sprint Planning Sheet views. 

As shown, we have features numbering up-to Feature 50. When you switch to the Sprint Planning Sheet, you will get the following view. 

Plan for the Sprints

To associate with Sprints, we need to create the Sprints first. These can be done using Project tab > Properties group > Manage Sprints command. 

As you can see, we have 50 Sprints planned now. 

Associate with the Sprints

One can use various possible views to associate the feature items with Sprint, but the most used ones (and recommended by my courses) are the Sprint Planning Board and Sprint Planning Sheet views of MS Project Agile software tool.

Using the Sprint Planning Board, for example, I’ve associated a number of features items as shown.

You have to simply drag and drop the items from the No Sprint column to the respective Sprint column. But then we have some constraints here!

  • When it reaches Sprint 5, then the board view on the left does not show the feature items. If you have to associate with Sprint 50, then you have to drag it all the way up-to Sprint 50, which is on the extreme right.
  • If you want to see only the last 3 Sprint items, i.e., Sprint 48, Sprint 49 and Sprint 50, then we also have to use the horizontal scrollbar to the end.

Hence, the better view to use in this case of having a large number of Sprints will be the Sprint Planning Sheet view. This is shown below. 

As shown, you have to just scroll down and associate the Sprint in the popped-up, drop-down or show-up list. Isn’t is very easy this way?

Show the Latest 3 Sprint Items first

Another issue is to show the last 3 Sprint items first. This cannot be done using the Sprint Planning Board view as the filters, groups are disabled in this view.

But you can circumvent it using the Sprint Planning Sheet view and applying the built-in Sprint group.  

Do note the change in order from from Ascending to Descending. That way, the latter Sprints will be shown on top. 

Sprint Grouped View

As you apply the above modified Sprint group, you will have the latter Sprints and the associate work items shown on top. The initial Sprints such as Sprint 1, Sprint 3 or Sprint 5, will be shown towards the bottom.  

Another Way to Show

Some of you may not want to apply to the Sprint group, but just want to see the latter Sprint items on top for quick usage. In that case, you have to change the sorting and sort it by Sprint ID as shown below. 

The Sort command dialog box can be seen by going to View tab > Data group > Sort > Sort By... command. 

Do note the change the order of sorting to Descending. That way, the latter Sprints and associated work items will come on top. 

When you apply this sorting, the Sprint Planning Sheet will come as shown below. 

As shown:

  • The work items for Sprint 50, Sprint 49 and Sprint 48 are shown on top.
  • The work items for Sprint 1, Sprint 2 etc. are towards the bottom.
In this case, we didn't apply any group, but just sorted items with Sprint ID field.


[1] Online Course: Mastering MS Project Agile, by Satya Narayan Dash 

[2] Certification Course: Certified Hybrid-Agile Master Professional (CHAMP), by Satya Narayan Dash