Only logged in customers who have purchased this product may leave a review.
Check our Upcoming SAFe Training Calendar
This Template is prepared to create and manage Scrum Metrics and KPI. See more details below.
Please Note : If you are using Office 2010 or lower version,You may get some formatting issue.
Downloadable products are not Refundable.
Max : Sprint Count in Trend : 6
Watch the video tutorial to know how it works. The Video Tutorial is to target the version 1 only
Note :
1. Change Worksheet Zoom to adjust the visible area, based on your screen resolution
2. If the Speedometer border is not sync with the Graph Use the Other Excel Sheet Suffix with NSC (No Speedometer Circle)
Only logged in customers who have purchased this product may leave a review.
This Template is prepared to create and manage Scrum Metrics and KPI. See more details below.
Available Metrics |
||||
1 | Commitment Reliability | Shows the percentage of story points completed against its commitment for every sprint. With Trend record among last 6 completed sprints. | ||
2 | Capacity Utilization | Represent the team capacity in hours and committed hours for each sprint, measured in effort hours. With Trends among last 6 sprints | ||
3 | Velocity | Represents total number of story points completed each sprint, with trend analysis for last 6 sprints. | ||
4 | Velocity Fluctuation | Represents the velocity variance from average with relation to max and min tolerance. | ||
5 | Scope Change | Sprint over Sprint, for Last 6 sprint, amount of story points added to the sprint or amount of story points removed from the sprint, After Sprint Started. | ||
6 | Defect Leakage | Amount of Defects detected after development, You can calculate it as defects detected by development team Vs Defects detected by Product Owner / or UAT. | ||
7 | Effort Estimation Variance | Effort estimated Vs Actual, shows Overestimation hours and under estimation hours | ||
8 | Backlog Health | Shows the health of backlog in as total number of Story Points available in backlog Vs Average Velocity (last 6 months). The speedometer shows the current backlog health is below 1 time of Average Velocity, at least 1 time of Average velocity, at least 2 times of average velocity or more than 3 times of average velocity. | ||
Customization |
||||
All the Possible Customizations are under worksheet Definition | ||||
Team Name | Name of the Team | |||
Commitment Reliability | Can Customize the color coding Range for Red , Amber, Green. By defining the From and to % for each color | |||
Velocity Fluctuation | Upper limit and lower limit Percentage from average velocity | |||
Defect Leakage | Can Customize the color coding Range for Red , Amber, Green. By defining the From and to % for each color | |||
Data Capture |
||||
Sprint Data needs to be captured under Sprint Trend Data worksheet and PB Groom History worksheet. The Graph will automatically pick the last 6 sprint information. It is capable to capture 30 Sprints, after that you can simple clean the past information. | ||||
Information needed to capture to get all the metrics populated – Under Sprint Trend Date | ||||
1 | Sprint | |||
2 | Committed Story Points | |||
3 | Accepted Story Points | |||
4 | Added Story Points | |||
5 | Descoped Story Points | |||
6 | Available Capacity (Day 1) | |||
7 | Estimated Hours | |||
8 | Actual Hours | |||
9 | Defects Captured during Sprint | |||
10 | Defects Captured After Sprint or PO verification | |||
11 | Defects Captured After Sprint or PO verification | |||
Information needed to capture to get all the metrics populated – Under Backlog Grooming | ||||
1 | Date of Capture | |||
2 | Story Points available for future sprint | |||
Dashboard worksheet Reference |
||||
Dashboard | 8 Metrics, 6 Sprint Trend | |||
Any One Sprint Dashboard | 7 Metrics of specific sprint as per selection | |||
Commitment Reliability | 6 Speedometer an 1 Trend | |||
Capacity Utilization | 6 Cylindrical Column Trend | |||
Velocity | 6 sprint velocity trend, and 6 sprint velocity fluctuation | |||
Defect Leakage | 6 Speedometer an 1 Trend | |||
Estimation Variance | 6 Sprint Estimation variance trend | |||
Video Tutorial |
||||
Understanding the Metrics https://youtu.be/O_gzadW_Sb8Understanding the Excel https://youtu.be/tnhQmpIkGmk |
||||
Contact Us |
||||
support@agiledigest.com | ||||
WhatsApp us
Event Type
All
Become a Scrum Master
Meetup
Online Training
SAFe
SAFe-Virtual
Technical Training
Webinar
Event Type 2
All
Agile
Certification Workshop
DevOps
Dockers
Jira
POPM
Portfolio
PTSM
PTSM-8
SA
SASM
Scrum
SDP
Sprint Simulation
SSM
Event Location
All
Bangalore
Gurugram
NAGARRO, GURUGRAM
Nehru Place -
Nehru Place - New Delhi
Online
Pune
Event Tag
All
Agile
Agile Estimation
Agile Metrics
Atallasian
Complexity bucket
Confluence
Jira
Jira Administration
Jira Portfolio
Jira Project Planning
Kanaban
Kanban Game
Leading SAFe
Meetup
Planning Poker
POPM
Portfolio planning
Product Owner Product Manager
Relative sizeings
release planning
SA
SAFe
Safe Agilist
SAFe Certification
SAFe POPM
SAFe Scrum Master
Scaled Agile
Scaled Agilist
Scrum
Scrum Reporting
Sprint Simulation
SSM
Story Points
Past & Future Events
All
Only Past Events
Only Future Events
march
An Extensive Course (Online) for all those who wants to become Scrum Master, Which will be very extensive, about 45 hours of Training’s to gain Complete Knowledge from
An Extensive Course (Online) for all those who wants to become Scrum Master, Which will be very extensive, about 45 hours of Training’s to gain Complete Knowledge from What is agile and the details of Scrum and Kanban Framework, with details of each and every Scrum Events/ ceremony, Reports, Communication, followed by hands on practical Based Training on Jira. And at the stage three we will blend the knowledge of Scrum and Jira with a Live Project and simulate a Sprint. And finally will have Debates, Question Answer Sessions, Interview Preparation and Mock Interview.
more
(Monday) 7:00 am - 9:00 am View in my time
Online
RUN
Event has already taken place!
You are the moderator of this event. Access the live stream
During this two-day Virtual course, attendees gain the knowledge necessary to lead a Lean-Agile enterprise by leveraging the Scaled Agile Framework® (SAFe®) and its underlying principles derived from Lean, systems
During this two-day Virtual course, attendees gain the knowledge necessary to lead a Lean-Agile enterprise by leveraging the Scaled Agile Framework® (SAFe®) and its underlying principles derived from Lean, systems thinking, Agile development, product development flow, and DevOps.
Participants gain insights into mastering Business Agility in order to thrive in the competitive market. They discuss how to establish team and technical agility and organize and re-organize around the flow of value. They also learn and practice the skills for supporting and executing PI Planning events and coordinating multiple Agile Release Trains (ARTs). Participants in the class explore the importance of adopting a customer-centric mindset and design thinking approach to agile product delivery. Learners also develop an understanding for implementing a Lean Portfolio Management function in their enterprise.
more
6 (Saturday) 4:30 pm - 7 (Sunday) 11:59 pm View in my time
Online
RUN
Event has already taken place!
You are the moderator of this event. Access the live stream
During this two-day Virtual course, attendees gain the knowledge necessary to lead a Lean-Agile enterprise by leveraging the Scaled Agile Framework® (SAFe®) and its underlying principles derived from Lean, systems
During this two-day Virtual course, attendees gain the knowledge necessary to lead a Lean-Agile enterprise by leveraging the Scaled Agile Framework® (SAFe®) and its underlying principles derived from Lean, systems thinking, Agile development, product development flow, and DevOps.
Participants gain insights into mastering Business Agility in order to thrive in the competitive market. They discuss how to establish team and technical agility and organize and re-organize around the flow of value. They also learn and practice the skills for supporting and executing PI Planning events and coordinating multiple Agile Release Trains (ARTs). Participants in the class explore the importance of adopting a customer-centric mindset and design thinking approach to agile product delivery. Learners also develop an understanding for implementing a Lean Portfolio Management function in their enterprise.
more
13 (Saturday) 4:30 pm - 14 (Sunday) 11:59 pm View in my time
Online
Course Name : SAFe® Scrum Master Applying the Scrum Master role within a SAFe® enterprise A Certified SAFe® Scrum Master (SSM) is a team-based servant leader who helps teams self-organize, self-manage, and
20 (Saturday) 4:30 pm - 21 (Sunday) 12:00 am View in my time
Online
RUN
You are the moderator of this event. Access the live stream
During this two-day Virtual course, attendees gain the knowledge necessary to lead a Lean-Agile enterprise by leveraging the Scaled Agile Framework® (SAFe®) and its underlying principles derived from Lean, systems
During this two-day Virtual course, attendees gain the knowledge necessary to lead a Lean-Agile enterprise by leveraging the Scaled Agile Framework® (SAFe®) and its underlying principles derived from Lean, systems thinking, Agile development, product development flow, and DevOps.
Participants gain insights into mastering Business Agility in order to thrive in the competitive market. They discuss how to establish team and technical agility and organize and re-organize around the flow of value. They also learn and practice the skills for supporting and executing PI Planning events and coordinating multiple Agile Release Trains (ARTs). Participants in the class explore the importance of adopting a customer-centric mindset and design thinking approach to agile product delivery. Learners also develop an understanding for implementing a Lean Portfolio Management function in their enterprise.
more
27 (Saturday) 4:30 pm - 28 (Sunday) 11:59 pm View in my time
Online
RUN
You are the moderator of this event. Access the live stream
april
Portfolio for Jira helps you build a plan, see the big picture, track progress, and easily share with stakeholders. Below listed down few benefits of Jira Portfolio Create a visual timeline Get
Portfolio for Jira helps you build a plan, see the big picture, track progress, and easily share with stakeholders. Below listed down few benefits of Jira Portfolio
Create a visual timeline
Get visibility across each of your teams and projects in a single place. See work at a high or granular level.
See whether your plan is on track
Plan when your release will ship or determine whether or not it’s realistic to hit a specific release date.
Manage the capacity of your team
Understand the feasibility of the work scoped over a given period of time, based on your teams’ bandwidth.
Manage dependencies
Set and review cross-project and cross-team dependencies so you can avoid bottlenecks.
Communicate your plans and progress
Easily share live status updates with your management team or any of your teammates.
more
3 (Saturday) 5:00 pm - 4 (Sunday) 9:00 pm IST View in my time
Online
An Extensive Course (Online) for all those who wants to become Scrum Master, Which will be very extensive, about 45 hours of Training’s to gain Complete Knowledge from
An Extensive Course (Online) for all those who wants to become Scrum Master, Which will be very extensive, about 45 hours of Training’s to gain Complete Knowledge from What is agile and the details of Scrum and Kanban Framework, with details of each and every Scrum Events/ ceremony, Reports, Communication, followed by hands on practical Based Training on Jira. And at the stage three we will blend the knowledge of Scrum and Jira with a Live Project and simulate a Sprint. And finally will have Debates, Question Answer Sessions, Interview Preparation and Mock Interview.
more
(Monday) 9:30 pm - 11:30 pm India Time View in my time
Online
Course Name : SAFe® Scrum Master Applying the Scrum Master role within a SAFe® enterprise A Certified SAFe® Scrum Master (SSM) is a team-based servant leader who helps teams self-organize, self-manage, and
(Saturday) 4:30 pm - 12:00 am View in my time
Online
Key Topics Jira Over View Jira Navigation Jira Releases & Components Jira Issues Jira Artifacts Jira Reporting Jira Filters and JQL Jira Dashboards Jira Boards Managing Sprints in Jira Working in
Key Topics
(Saturday) 4:30 pm - 11:59 pm India Time View in my time
Online
This Jira Training will give you confidence to Work in Jira as any Agile Role to manage Agile Life cycle This Jira Training will give you the learning to collaborate with
Explore more at : Visit Mastering Jira Page
17 (Saturday) 4:30 pm - 18 (Sunday) 11:59 pm View in my time
Online
Sprint Simulation – Instructor Led Group Exercise with Live Project 6 day total 11 hours, Training within a group of 5 to 9 members (a distributed Scrum team) to simulate the
6 day total 11 hours, Training within a group of 5 to 9 members (a distributed Scrum team) to simulate the full scrum cycle, using Jira.
Which will give a hands on understanding and chance of practice to learn
We have scheduled our next Sprint simulation online class on January 2020. If you want to practice one sprint cycle by experiencing all sprint events like Planning, daily stand up, Review & retrospective, backlog refinement, story point estimation by Planning Poker, prioritization, Preparing Report and metrics. you can register now.
All details will be available in the provided link. Feel free to ask any question by sending an email to support@agiledigest.com
more
(Monday) 9:30 pm - 11:30 pm View in my time
Online
april 20, 2021 9:30 pm - april 20, 2021 11:30 pmapril 21, 2021 9:30 pm - april 21, 2021 11:30 pmapril 22, 2021 9:30 pm - april 22, 2021 11:30 pmapril 26, 2021 9:30 pm - april 26, 2021 11:30 pmapril 27, 2021 9:30 pm - april 27, 2021 11:30 pm
During this two-day Virtual course, attendees gain the knowledge necessary to lead a Lean-Agile enterprise by leveraging the Scaled Agile Framework® (SAFe®) and its underlying principles derived from Lean, systems
During this two-day Virtual course, attendees gain the knowledge necessary to lead a Lean-Agile enterprise by leveraging the Scaled Agile Framework® (SAFe®) and its underlying principles derived from Lean, systems thinking, Agile development, product development flow, and DevOps.
Participants gain insights into mastering Business Agility in order to thrive in the competitive market. They discuss how to establish team and technical agility and organize and re-organize around the flow of value. They also learn and practice the skills for supporting and executing PI Planning events and coordinating multiple Agile Release Trains (ARTs). Participants in the class explore the importance of adopting a customer-centric mindset and design thinking approach to agile product delivery. Learners also develop an understanding for implementing a Lean Portfolio Management function in their enterprise.
more
24 (Saturday) 4:30 pm - 25 (Sunday) 11:59 pm View in my time
Online
may
Course Name : SAFe® Product Owner/Product Manager Delivering value through effective Program Increment execution A Certified SAFe® Product Owner (PO) serves as the customer proxy for the team and works with Product Management
A Certified SAFe® Product Owner (PO) serves as the customer proxy for the team and works with Product Management and other stakeholders—including other Product Owners—to define and prioritize stories in the Team Backlog so that the system or solution effectively addresses program priorities while maintaining the technical integrity of the features or components the team is responsible for creating. The PO has a significant role in quality and is the only team member empowered to accept stories as done.
A Certified SAFe® Product Manager (PM) serves as the internal voice of the customer for the Agile Release Train (ART) and works with Product Owners to continually develop and communicate the customer vision to the development teams. The Product Manager provides an economically prioritized backlog for the ART, defines the features of the system to ensure that the solution meets relevant standards and other system quality requirements, and participates in the validation of the proposed feature benefit hypotheses.
more
1 (Saturday) 4:30 pm - 2 (Sunday) 11:59 pm View in my time
Online
Aftre 3 stages of Path to become scrum Master, Once you have sufficient knowledge on working as Scrum Master, and ready for Interview, Lets Brush up and give
Aftre 3 stages of Path to become scrum Master, Once you have sufficient knowledge on working as Scrum Master, and ready for Interview, Lets Brush up and give it a final touch. It will be around 6 to 8 Hours based on the progress and readiness. Read More : https://agiledigest.com/product/final-touch-scrum-master-interview/
more
(Monday) 9:30 pm - 11:30 pm View in my time
Online
Course Name : SAFe® Scrum Master Applying the Scrum Master role within a SAFe® enterprise A Certified SAFe® Scrum Master (SSM) is a team-based servant leader who helps teams self-organize, self-manage, and
8 (Saturday) 4:30 pm - 9 (Sunday) 12:00 am View in my time
Online
Course Name : SAFe® Advanced Scrum Master Advancing Scrum Master servant leadership with SAFe® A Certified SAFe® Advanced Scrum Master (SASM) is a servant leader who has a broader, systems view of
A Certified SAFe® Advanced Scrum Master (SASM) is a servant leader who has a broader, systems view of the Scrum Master role and provides integrated practices for facilitating multiple team, program, and enterprise success in larger programs. Advanced Scrum Masters understand Agile and Scrum anti-patterns and facilitate cross-team interactions to support program execution and relentless improvement. Providing this experience and servant leadership helps teams improve flow and quality of work, resulting in cohesive, high-performing Lean-Agile teams that deliver continuous value.
more
15 (Saturday) 4:30 pm - 16 (Sunday) 11:59 pm View in my time
Online
During this two-day Virtual course, attendees gain the knowledge necessary to lead a Lean-Agile enterprise by leveraging the Scaled Agile Framework® (SAFe®) and its underlying principles derived from Lean, systems
During this two-day Virtual course, attendees gain the knowledge necessary to lead a Lean-Agile enterprise by leveraging the Scaled Agile Framework® (SAFe®) and its underlying principles derived from Lean, systems thinking, Agile development, product development flow, and DevOps.
Participants gain insights into mastering Business Agility in order to thrive in the competitive market. They discuss how to establish team and technical agility and organize and re-organize around the flow of value. They also learn and practice the skills for supporting and executing PI Planning events and coordinating multiple Agile Release Trains (ARTs). Participants in the class explore the importance of adopting a customer-centric mindset and design thinking approach to agile product delivery. Learners also develop an understanding for implementing a Lean Portfolio Management function in their enterprise.
more
22 (Saturday) 4:30 pm - 23 (Sunday) 11:59 pm View in my time
Online
june
No Events
july
No Events
Reviews
There are no reviews yet.