Understanding Scrum Metrics and KPIs - Agile Digest

[@sidguda173]

I saw someone's comment stating that why should we need many metrics when working software itself is a metric and that's alone is good enough to have. Look at this analogy - Goal is to stay healthy (refer to: Goal is to deliver working software). To achieve this, you need to measure the current or past health condition. You cannot control or improve when you cannot measure. There Metrics will help to understand the current status, which in-turn helps to analyze on improvements and reflects our progress towards goal. One cannot simply say out of the box, I achieved my goal and I am healthy. You should be able to significantly show the improvement from your previous condition to the current improved condition. Metrics will help to - Understand the current status Analyse the insights on improvements Reflects our efforts if they are moving in expected direction or not.

[@mrneeraj111111]

Agile is empirical and decisions are made based on facts and also on progress. So KPIs are the facts which help in taking important decisions to make sure more value has been received by the users after each increment.

[@sumitghosh7178]

Short but crisp... Very informative. Thank you very much.

[@AgileDigest]

So nice of you

[@xoloandro4883]

best channel ever on Agile methodology

[@AgileDigest]

Thank You

[@Donotidentify]

Wonderful video. Without your Videos scrum prep is not complete 🙏

[@AgileDigest]

Thank You

[@siddharthanandy3798]

Being a Scrum Master with 5+ years of Agile experiences, I am delighted to see such an insightful and authentic representation of these various useful Metrics in this presentation. I must say, this is well thought of, properly researched as per Organization standards and clearly explained. This video is not just useful to make one 'interview ready' rather to be appreciated beyond its effectiveness for the real world work in the industries. Kudos to Niladri for his dedicated hard work. My strong recommendation to Agile practitioners, consider this is as a 'must watch (follow)' video for your knowledge-bank. 👍

[@AgileDigest]

Thank you, Siddhartha

[@womanlikeme33]

this is absolutely enlightening. thank you for breaking this down so much so that i now understand what the Scrum Metrics are and how they are calculated.

[@kalyanbasak5344]

This video is out of the box. Fantastic explanations with perfect examples and templates. 💯

[@kalvasuraj21]

Very well Presented, Usually we deal with Burn-down, Burn-up, Through-put, Risk Matrix, But this is more valuable and covers all of the essential KPI's. Great Job !!!

[@AgileDigest]

Glad it was helpful!

[@sudiptapanda]

Each KPIs are very well explained. Very nice.

[@skyboomshield]

In terms KPIs and metrics, I was only aware of Release & Sprint burn-down charts till date, but now I learned other things as well. Brilliant tutorial as it gives a vivid picture of data & facts driven Scrum framework. Thanks a lot.

[@raviprasad88]

Simply Fab !!! You have gained a Subscriber who is now a BIG Fan of you. Too good Content bro !!!

[@mausumisamantaray6428]

This video is just marvelous. It describes very import concepts which normally we don't get to know. Thank you so very much for sharing your knowledge with us.

[@thorstenspeil5951]

really nice. I was sceptical, but yes, I find some very valuable stats in here. Thank you very much!

[@adamkidwell6407]

RIP to this man for speaking for 22 minutes straight without breathing.

[@bbala79]

Very clear demo of KPI measurment and good coverage. Well done.

[@sureshpatil7005]

Very informative content for people working on Scrum. Thankyou

[@AgileDigest]

Thank you

[@srinidhibg]

Superb & Brilliant explaination & Video..Fantastic Job Sir, Thanks for posting it..

[@joni89qe]

Very nice video. Very useful, and clear. Thank you!

[@v.ar1234]

Excellent video on Metrics. Well explained and presented.

[@AgileDigest]

Glad you liked it!

[@hemantchiplunkar]

Excellent Explanation and very good metrics to measure. Fantastic work !!!

[@AgileDigest]

Glad you liked it!

[@Makeovertime.]

One of the best video. thank you very much Niladri🙏

[@sunitanair6166]

Thanks! Was just looking out for something like this. Keep up the good work Sir!

[@AgileDigest]

Thanks, will do!

[@danielalcivar6395]

Thank you very much for sharing this knowledge. Cheers from Ecuador

[@amitsaxena9492]

Really a nice compilation and explanation of useful metrics that are comprehensive enough

[@AgileDigest]

Thank You

[@sakshipal6812]

Simple and very informative. Thanks for explaining all metrics very well.

[@lakmalsl]

Awesome video overall, super helpful. Small correction on the Over Estimation and Under estimations formula. It should be subtracted by 100 not multiplied by. Over Estimation: (E-A/E) - 100 Under Estimation: (A-E/E)-100

[@ireshrie]

Love this! Easy to follow and it make sense.

[@AgileDigest]

Thank You

[@srinivasthanuku7459]

Excellent, Its clear, concise, and easy to understand. Thanks for sharing your knowledge.

[@heukeselectricpvt.ltd.715]

Excellent and well defined..Thanks

[@kronik9755]

Very brief explanation, good job. Thanks!

[@AgileDigest]

Glad it was helpful!

[@rameshsegavalu]

Awesome presentation.. great work.

[@AgileDigest]

Thank You

[@viveklatthe3517]

This is something I was looking from long, thank you.

[@GodLeads4Life]

This is a very awesome video...What else would some one be looking out for? Great stuff. ✔❤

[@AgileDigest]

Thanks so much!

[@sivaiyer4017]

Good pace and to The point !!

[@anahash3221]

i must thank u for the awesome video what an explanation, i hope to see more such videos by u , great job👍thanks a lot.

[@AgileDigest]

Thank You

[@0109TK]

Very impressive. Just in time training for me as I am implementing Quality Plan on my project.

[@learnanythingforfree2131]

Excellent video! Very helpful....

[@mehektesur]

Excellent video. Thanks much for uploading.

[@mohanparthasarathy1777]

Very impressive. Great explanation.

[@angieboosey2797]

Right at the beginning (26 seconds) you say this is video part 1, and in part 2 you will cover how you can generate and adapt this data in Excel. How do I find part 2 please?

[@coffeetalk1000]

Excellent video! Thank you so much!

[@AgileDigest]

You're very welcome!

[@jyothir5158]

Very useful and thank u so much for nice explanation

[@jagadeeshkumar9745]

this is awesome video. very useful

[@AgileDigest]

Thank you

[@thedubaiworld413]

Awesome work sir, It will help us a lot to build and understand the Scrum in our professional career. I just want to know how to take data into sheet and create matrix into spread sheet. If possible please share video or sheet.

[@Skidrowsk]

This is not scrum…don’t even think about doing these metrics. Velocity and burndown charts are enough

[@utubesb2088]

very well thought through ... Can we apply these metrics in SafeAgile world as well ?

[@rujutakulkarni3563]

Very well explained! Earlier there was article by you on the same topic on your portal. Don't see that anymore. Where can we get it?

[@AgileDigest]

All are still there, only the menu positions are changed. Look for self study section

[@arielrbv0]

Thanks for upload this kind of content! Regards from Argentina :)

[@ronakkotak7346]

Really Insightful. Thanks for sharing the video.

[@AgileDigest]

Thank you

[@shenizer]

Please share link to Part 2, want to see the practical usage and generation of these KPIs

[@AgileDigest]

Sorry , I am not sure what you really looking for.

[@prabhatiirm]

Really Good content .. Will help in Quality Management for Agile projects

[@psysoul]

Thank you a lot for explaining!

[@AgileDigest]

Thank You

[@SaravanaKumar-zw6vr]

The concept was explained by very nice and able to understand easily, really useful thanks much

[@bubuniapatra7438]

Nice video :-). Can you help me the tools you have used to create such nice graphs and dashboards without using commercial tools ?

[@AgileDigest]

Hi Bubunia, Its all in Excel Only.

[@hemlaful]

This is very helpful but for some kpis we are considering task hours and some SPs as per convenience. We can't confuse the stakeholders with two different measurement units.

[@backester_singhaman6914]

very knowledgeable thanks for sharing

[@rumachakrabarty3896]

very well explained

[@gopikrishnapalempally6893]

Excellent explanation. thanks for making such wonderful video.

[@abhishes]

Very nice explanation. thanks!

[@bivansuhota8276]

Thanks a lot Sir!!🙏🏻🙏🏻❤️❤️ The video was really informative.

[@atharvrgupta5335]

Awesome video

[@AgileDigest]

Thanks for the visit

[@nims83]

Hi Niladri, First of all I would like to thank you on behalf of all the guys who really want to learn more precise things on KPIs and this is the Bang on Target. I have subscribed your channel . For this particular video, can you please share the link from where we can download the sample excel sheet with this charting done ? It will be HUGE help for me. Your help here would be very much appreciated. Looking forward to have more great videos like this one. Thanks, Nimesh

[@AgileDigest]

The Links are mentioned under description.

[@nims83]

@@AgileDigest I found it paid. Can I get the sheet only free ?

[@lolalolaosman6717]

Thank you for sharing this information.,it is very useful and interesting for me. Very clear and excellent explanation.

[@shwetaiyengar4738]

wonderful explanation

[@deepikaraj9431]

Very useful video, Thanks for sharing

[@AgileDigest]

My pleasure

[@nehemiahmbapinyi5531]

Excellent!!!

[@chinaprise]

wow, great content.... keep it coming

[@AgileDigest]

Thank you! Will do!

[@rgumma1]

Clear and Informative

[@gopisatyasingswing-freesty7180]

very well explained sir, thanks. Do you plot all these graphs in JIRA or excel sheet?

[@AgileDigest]

Excel

[@ThorMaximus]

They might be a little complex, but excel can do all these a combination of charts styles

[@vijayareddy4494]

Awesome video! Truly appreciate your work in helping others. I'm still confused with 2 things here. Between Capacity Utilization and Estimation Variance. Capacity Utilization measured considering efforts in hours team actual capacity (220). However, team committed (which means team used) (130). Am I correct? Estimation Variance again measured considering efforts in hours team committed (130). But, only worked for 40 hrs? What did they do for rest of the 90 hrs? Meaning in total team should work for 220 hrs but only worked for 40 hrs? Is my understanding correct? I'm new to these metrics, hope you can help me in clarifying the question. Thank you!

[@AgileDigest]

Utilization is correct, variance is how much you estimated and how much the work actually took, over estimation or under estimation.

[@vijayareddy4494]

@@AgileDigest So basically, at the end, team only worked for 40 hrs, because that's the time it took for them to finish the work. Be it over or under estimation, whatever the reason it. Right?

[@prashantdeshpande8622]

Very good video

[@AgileDigest]

Thanks

[@HimalayaGarg]

Very informative, with visuals, thank you.

[@ManishPatel-kg6hg]

Very helpful and descriptive

[@tusharverma3834]

Wonderful, just a quick query, do Jira provides this kinds of metrics or dashboards? Pls guide on that front.

[@AgileDigest]

No jira does not

[@abhishekanand7]

superb video

[@AgileDigest]

Thank you so much 😀

[@revanthkhambampati7249]

This is very informative. I have a query for a project if we estimate by story points. Still do we take hours too? And in case of story point estimation what is the relevance of burndown chart?

[@dmitry7070]

Hi. Awesome video and graphical explanation! Have a question regarding scope change. There are examples if we adding only or descoping only. But no example if we commit, remove something (because we have to add something) and descope something and all in one sprint.

[@AgileDigest]

Did not got the question

[@sureshmamidi3069]

Very good video. It was very crisp and clear. But i have a question, while calculating the velocity trends, you have explained about the upper bracket and the lower bracket. How do we take that? Please clarify.

[@AgileDigest]

Please define your average velocity as 100%, and make the upper bracket and lower bracket as defined, if it is 15%, then upper bracket will be 115% and lower will be 85%.

[@chess2k148]

It's very useful to me. Thanks

[@AgileDigest]

Glad to hear that

[@vishalkushwaha.official]

Well explained..

[@Swamysurya141]

In that please give a talk on architect team in agile release

[@LeighFish]

@agiledigest if you are using hours tor work out capacity utilization does that mean you estimate in hours too? Or has capacity uitilization not related to estimation at all? Because if we estimate in story points, where do hours come into play now?

[@AgileDigest]

This is for the teams who are transitioning from traditional way to story point estimation. Here they estimate in hours. Though the advice is to leave hourly estimation to story point over time, there are many organizations still feel comfortable using hourly estimation

[@saurabht09]

Super video ..great

[@surajitchakraborty5692]

Thanks a lot Niladri ....

[@kuchumubi]

This vid was very helpful. Thank you uploading it.

[@snehap2127]

simple , short yet effective information, thank you .. can you provide more videos on domain specific scenarios such as any online banking or telecom , retail domain project , how to prepare project plan, project charter, how to define KPI etc.. by taking sample detailed project per domain ? end to end project cycle type something if possible ..

[@haitosajith]

Regarding the defect leakage, are we talking about the same defect which is raised both within the Sprint & SIT phase or are we talking about defects which are identified newly during SIT phase?

[@AgileDigest]

new defects

[@randomthought6681]

you are a lifesaver

[@7piki]

Hi Very clear and informative explanation. Have a doubt for scope metrics. If in a single sprint a few story points are added & also a few are descoped. How to use Ur formula then??

[@AgileDigest]

any changes on commitment should be counted. plus 2 and minus 2 will not make it zero. It will show both as scope changed.

[@amtopmnow]

Hi Niladri I really enjoy your very detailed videos and learning a lot. My question is that is this particular video made all in XLS including the graphs or is it part XLS and part PPT merged together ? Can you guide how you generate the graphs please ? Thanks

[@AgileDigest]

Hi Ahmad, Its pure Excel, there is no PPT, Unfortunately we only provide training only on Agile or other technical subjects. We dont provide trainings on Excel.

[@Meggie8290]

@@AgileDigest Hi, did you get the effort estimation graph on Excel too?

[@MsZaaG]

Excellent! Congratulations.

[@VanessaKlinger]

Awesome! This is great!

[@AgileDigest]

Thank You

[@sunnysiu7955]

Hi Niladri, I have a question,,, If planned SPs = say 40 SP and scope added = 5 SP, the commitment reliability should be calculated upon initial planned SPs ie 40 or on worked upon SPs ie 45?

[@sunnysiu7955]

Very Nice Video, .. I have a small question, In my project we donot assign hours to tasls, we just go by story points... so burndown reports doesn't give a good picture.... is there any other report which can help us in tracking the progress on daily basis!!!!

[@AgileDigest]

for sprint burndown, Hours is better

[@anuyadav384]

hey ... very detailed and thorough explanation. However, I have one question which tool do you use to create such metrics? I mean any tool where we can provide the input and get the automated required metrics .... Please revert asap... Thanks in advance

[@AgileDigest]

Thank you Anu. You can get the excel template here agiledigest.com/product/scrummetricstemplate/

[@nga.6310]

Hi. Thanks for this tutorial. My Reports are not showing completed issues. Please what could possibly be this problem? Thanks for your response.

[@AgileDigest]

Please send us a email to [e-mail] with necessarily detaila

[@vandhanapu]

Thanks for the video. A good and clean explanation. I have a question on the commitment reliability KPI. Could you please explain what are available hours in this valuation ? How do you calculate the available number of hours - by adding each resource total number of available hours that he/she could have worked on? Is that right ? Please clarify. But number of hours is different form story points. Is in't it. hours should not be mixed with story points in calculations. Isn't it ? Thanks in advance for the answer

[@AgileDigest]

Hi Kishore, I think you are mixing Commitment Reliability and Capacity Utilization. Commitment reliability does not have any thing to do with Hours.

[@mrtijuana99]

Informative.

[@esumitkumar]

Awesome !

[@humairimam]

How do scrum metric integrate with traditional management KPI for management to use for budget and finance? How are these KPI used by management to manage?

[@Swamysurya141]

Sir please give a talk on Agile release train