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 !!!
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. 👍
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.
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.
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.
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.
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.
@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?
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
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
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.
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?
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.
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 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?
@@AgileDigest Thanks very much for your response. Have you got any video that shows how this is done in Excel, it will be great to have that please. If you dont, pls can you let me know the add-on that you used to get the 3D shapes for the metrics as I am only able to come up with the 2D shapes. Many thanks.
@@lakush8112 @AgileDigest is using some advanced excel techniques to produce the graphics and gauges on this excellent Scrum KPI dashboard. Niladri mentions in an answer above that they teach Agile, not Excel. However, if you click on the link to the workbook below the video you will find that you can purchase and download the complete workbook presented in this video. I think the price of the excel template is very reasonable versus the time and effort you might need to invest in order to develop the skills to build such a dashboard yourself (which I have also done). If you wish to implement the metrics in this video, the shortest path is to simply buy the excel workbook and hook in your own data. If you are already handy with Excel and you wish to take your skills to the next level to build such a dashboard workbook on your own, then I recommend the Excel Dashboard course by Leila Gharani that is available on Udemy. And if you have the means to invest in both Niladri's excel workbook and Leila's course you will be amazed at the techniques you will add to your toolkit for developing your own awesome dashboards in Excel. If you are unable to make any monetary investments just now (btw Udemy courses are less than US$20), then search youtube for videos on how to develop dashboards in excel and you can pick up a lot of bits and pieces for free. Good luck to you.
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?
Clear measurements, well explained and depicted with right charts. Excellent video!
best channel ever on Agile methodology
Thank You
Short but crisp... Very informative. Thank you very much.
So nice of you
Simply Fab !!! You have gained a Subscriber who is now a BIG Fan of you. Too good Content bro !!!
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 !!!
Glad it was helpful!
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. 👍
Thank you, Siddhartha
Wonderful video. Without your Videos scrum prep is not complete 🙏
Thank You
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.
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.
Each KPIs are very well explained. Very nice.
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.
really nice. I was sceptical, but yes, I find some very valuable stats in here. Thank you very much!
RIP to this man for speaking for 22 minutes straight without breathing.
This video is out of the box. Fantastic explanations with perfect examples and templates. 💯
Superb & Brilliant explaination & Video..Fantastic Job Sir, Thanks for posting it..
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.
Very informative content for people working on Scrum. Thankyou
Thank you
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.
One of the best video. thank you very much Niladri🙏
Very clear demo of KPI measurment and good coverage. Well done.
Thank you very much for sharing this knowledge. Cheers from Ecuador
Thanks! Was just looking out for something like this. Keep up the good work Sir!
Thanks, will do!
Excellent Explanation and very good metrics to measure. Fantastic work !!!
Glad you liked it!
Excellent video on Metrics. Well explained and presented.
Glad you liked it!
Very nice video. Very useful, and clear. Thank you!
This is a very awesome video...What else would some one be looking out for? Great stuff. ✔❤
Thanks so much!
Really a nice compilation and explanation of useful metrics that are comprehensive enough
Thank You
Simple and very informative. Thanks for explaining all metrics very well.
Very brief explanation, good job. Thanks!
Glad it was helpful!
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.
Thank You
Love this! Easy to follow and it make sense.
Thank You
Excellent and well defined..Thanks
Excellent, Its clear, concise, and easy to understand. Thanks for sharing your knowledge.
Excellent video! Thank you so much!
You're very welcome!
Very useful and thank u so much for nice explanation
this is awesome video. very useful
Thank you
This is something I was looking from long, thank you.
Excellent video! Very helpful....
Awesome presentation.. great work.
Thank You
Good pace and to The point !!
Thanks for upload this kind of content! Regards from Argentina :)
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?
All are still there, only the menu positions are changed. Look for self study section
Thanks a lot Sir!!🙏🏻🙏🏻❤️❤️
The video was really informative.
Excellent video. Thanks much for uploading.
Very impressive. Just in time training for me as I am implementing Quality Plan on my project.
Please share link to Part 2, want to see the practical usage and generation of these KPIs
Sorry , I am not sure what you really looking for.
Thank you a lot for explaining!
Thank You
very well thought through ... Can we apply these metrics in SafeAgile world as well ?
Very impressive. Great explanation.
Awesome video
Thanks for the visit
Really Good content ..
Will help in Quality Management for Agile projects
Nice video :-). Can you help me the tools you have used to create such nice graphs and dashboards without using commercial tools ?
Hi Bubunia, Its all in Excel Only.
very well explained
Wonderful, just a quick query, do Jira provides this kinds of metrics or dashboards?
Pls guide on that front.
No jira does not
Super video ..great
@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?
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
wonderful explanation
The concept was explained by very nice and able to understand easily, really useful thanks much
superb video
Thank you so much 😀
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
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.
This is not scrum…don’t even think about doing these metrics. Velocity and burndown charts are enough
Very good video
Thanks
Excellent explanation. thanks for making such wonderful video.
Really Insightful. Thanks for sharing the video.
Thank you
Thank you for sharing this information.,it is very useful and interesting for me.
Very clear and excellent explanation.
Well explained..
It's very useful to me. Thanks
Glad to hear that
Excellent!!!
What's the data set that I need to use to get the "Monitoring the Flucuation"
Just the velocity and individual sprint Completed story point. Make some upper sigma and Lower sigma as tollarance boundary.
Very useful video, Thanks for sharing
My pleasure
In that please give a talk on architect team in agile release
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?
Informative.
Very informative, with visuals, thank you.
Very nice explanation. thanks!
This vid was very helpful. Thank you uploading it.
Hi. Thanks for this tutorial. My Reports are not showing completed issues. Please what could possibly be this problem? Thanks for your response.
Please send us a email to support@agiledigest.com with necessarily detaila
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.
How you are generating these graphs
Excel only
very well explained sir, thanks. Do you plot all these graphs in JIRA or excel sheet?
Excel
They might be a little complex, but excel can do all these a combination of charts styles
very knowledgeable thanks for sharing
Sir please give a talk on Agile release train
you are a lifesaver
Very useful!
and besides giving ways to show how badly certain metrics are going wrong, you also give advice on what might be the probable cause. 👑
Glad it was helpful!
Very helpful and descriptive
Thanks a lot Niladri ....
Can you create another material using story point, using hours to estimate story is obsolete, particularly Velocity and Capacity.
velocity is already there in this template. few practices uses Hours, if they want they can use it. just a reminder don't mix them up
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!
Utilization is correct, variance is how much you estimated and how much the work actually took, over estimation or under estimation.
@@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?
Can we use Story points instead of hours for calculating capacity utilization ?
Useing story point is a better or mature approach, in that case you don't need capacity utilisation
Please share the link for downloading templates
agiledigest.com/product-tag/template/
can we use these metrics across all methodologies ..like kanban or Agile
This is designed for Scrum only.
Awesome !
HI I NEED the presentation please
Awesome! This is great!
Thank You
wow, great content.... keep it coming
Thank you! Will do!
Is it using Monday?
Hi Mihir, Did not got your question , Can you please elaborate?
@@AgileDigest which tool was used for illustration of the charts?
@@mjm001 excel only
@@AgileDigest can this excel template be shared with us ? what is the cost associated with this
Useful information
So nice of you
Do we have any JIRA add-on that can provide these stats?
Hi,
Thanks for sharing this video. I will like to know the best software to use to develop the agile/sprint metrics.
This was developed in Excel
@@AgileDigest Thanks very much for your response. Have you got any video that shows how this is done in Excel, it will be great to have that please. If you dont, pls can you let me know the add-on that you used to get the 3D shapes for the metrics as I am only able to come up with the 2D shapes.
Many thanks.
@@lakush8112 @AgileDigest is using some advanced excel techniques to produce the graphics and gauges on this excellent Scrum KPI dashboard. Niladri mentions in an answer above that they teach Agile, not Excel. However, if you click on the link to the workbook below the video you will find that you can purchase and download the complete workbook presented in this video. I think the price of the excel template is very reasonable versus the time and effort you might need to invest in order to develop the skills to build such a dashboard yourself (which I have also done). If you wish to implement the metrics in this video, the shortest path is to simply buy the excel workbook and hook in your own data. If you are already handy with Excel and you wish to take your skills to the next level to build such a dashboard workbook on your own, then I recommend the Excel Dashboard course by Leila Gharani that is available on Udemy. And if you have the means to invest in both Niladri's excel workbook and Leila's course you will be amazed at the techniques you will add to your toolkit for developing your own awesome dashboards in Excel. If you are unable to make any monetary investments just now (btw Udemy courses are less than US$20), then search youtube for videos on how to develop dashboards in excel and you can pick up a lot of bits and pieces for free. Good luck to you.
Are these JIRA default reports or are you using any reporting plugin?
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?