pareto analysis - how to create a pareto chart in ms excel (problem solving tool)

Поделиться
HTML-код
  • Опубликовано: 15 авг 2020
  • Pareto Chart originated in 1897 by an Italian economist named Vilfredo Pareto
    He told that in Italy 80% of wealth is with 20% of rich people.
    80/20 Rule:. 80 percent of the effects come from 20 percent of the causes
    In terms of BPO: Our 80% dent is because of 20% of causes in process, if we work on that 20% automatically there will be process improvement.
    In real life, 80% of the problem is because 20% of causes.
    What is Pareto analysis?
    what is the 80 20 rule?
    what is the Pareto principle?
    What is flow chart in BPO- Live BPO Example || Latest 2020
    80/20 rule
    80-20 rule
    Pareto Analysis in excel
    Pareto Analysis in Six Sigma
    Pareto Analysis in Lean Management
    Pareto Chart with example
    Pareto Analysis with example
    Introduction to Quality Analyst in BPO.
    Roles & Responsibilities in Quality Analyst in BPO
    BPO company interview questions and answers
    BPO top 10 questions for an interview.
    How to crack the Quality Analyst interview in the BPO company?
    bpo interview questions and answers for freshers
    #BPOInterviewTutorial #BPO #QualityAnalyst
    Must Watch some MS Excel videos:
    How to calculate count if in excel: • How to use COUNTIF in ...
    How to do VlookUP in Excel : • What is VlookUp in exc... q
    How to upload document & pdf in Excel Sheet:
    • How to upload document...
    How to add calculate field in Excel
    • MS Excel - how to add ...
    Yellow belt Six Sigma Certification videos:
    What is Kaizen : • what is KAIZEN ? live...
    What is 3M (mura, muri, muda) : • what is Mura, Muri, Mu...
    What is six sigma: • What is Six Sigma in B...
    Types of Waste : • 8 types of waste in Le...
    Poke Yoke in lean : • What is Poka Yoke -- A...
    Lean History : • what is lean and learn...
    DMAIC in six sigma : • What is DMAIC in Six S...
    / bpo-interview-yutorial...

Комментарии • 106

  • @deepaksronja7694
    @deepaksronja7694 3 года назад +9

    Hello, i don't usually comment but, this video and the effort of creator deserve some appreciation. i am looking forward to all your vedios buddy

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  3 года назад

      Thank u, so, much for your feedback and i really felt gud that, my videos are much effective. I want some help plz share the videos in your groups and help me with more subscribers

  • @jayarathore2096
    @jayarathore2096 3 года назад +2

    I must say your video is really awesome it's very easy and specially it's completely related to QA work from BPO....I m really happy that you made something like this..

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  3 года назад +1

      Thanks a lot I hope u will, share with your frndz n ask them to subscribe the channel and, share on whatsap group fb everywhere 🙏🙏🙏

  • @jildrichvasquez3360
    @jildrichvasquez3360 2 года назад +1

    Thank you for the simple and better explanation of this analysis. It really helps for my upcoming presentation.

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  2 года назад

      Thanks for the feedback, I hope u will help me in sharing my videos on social media n with your friends who are looking for job

  • @biswajitmahali7006
    @biswajitmahali7006 3 года назад +1

    The way u explained about Pareto analysis is superb.. keep it up bhai.

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  3 года назад

      Thanks a lot buddy. Hope u will share this with your frndz and ask them to subscribe.

  • @RahulKR20
    @RahulKR20 2 года назад +4

    Simply awesome! pls upload more videos related to 7qc tools graph analysis and Six sigma

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  2 года назад

      Hey, thanks for the feedback, plz watch out the play list and share the videos and help me with more subscribers

  • @ahmedmarliesjunaveeantocan3656
    @ahmedmarliesjunaveeantocan3656 23 дня назад +1

    this is really helpful

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  23 дня назад

      Thanks for the feedback kindly share videos and help me with more subscribers

  • @nidhibharti7357
    @nidhibharti7357 3 года назад +1

    awesome job done by him...👌👍

  • @rajannamelodies
    @rajannamelodies Год назад +1

    Thank you so much for detail explanation, it's very useful.

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  Год назад +1

      Thanks for the feedback, please share and help m with more viewers and at least 5 subscribers

  • @mavicgabayan9967
    @mavicgabayan9967 2 года назад +1

    well explained....thank you so much for sharing...

  • @lalitadogra94
    @lalitadogra94 2 года назад +1

    Well Done !
    Really easy to understand..
    Keep it up!!!

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  2 года назад +1

      Thank you, plz share and help me with more subscribers and follow us on Instagram n fb

  • @B-Cool1988
    @B-Cool1988 24 дня назад +1

    Nice

  • @shivanisharma7887
    @shivanisharma7887 3 года назад +1

    Hii Bro, this comment is there to appreciate your work. Watched bunch of your videos and I must say, videos are very specific and informative cosidering that time frame.
    It was very helpful for me. A big thank you from my side. And All the very best. Keep doing the great work. You are meant to be successful. I assume you spare time from your daily schedules for uploading these informations, which is worst the time and purpose.At last, Thank you again

  • @just2learn971
    @just2learn971 3 года назад

    Its is veryy helpful thankz buddy
    🤟🤟👍

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  3 года назад

      Thanks a lot hope u will, share with your frndz n ask, them to subscribe the channel

  • @kiranyeluru7392
    @kiranyeluru7392 2 года назад +1

    wow super great explanation

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  2 года назад

      Thank you, plz share my videos with your office mates and help me with mote subscribers

  • @Akbarkhan-qv1ih
    @Akbarkhan-qv1ih 2 года назад +1

    Awesome👏... Keep going brother

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  2 года назад

      Thanks for the feedback, plz share video with other on social media and help me with more subscribers

  • @jayarathore2096
    @jayarathore2096 3 года назад +1

    Really helpful...great

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  3 года назад +2

      Thanks a lot I hope u will, share with your frndz n ask them to subscribe the channel and, share on whatsap group fb everywhere 🙏🙏🙏

  • @ChinnaThambi-iw4ub
    @ChinnaThambi-iw4ub 7 месяцев назад +1

    Hey bro, Good explain thanks a lot

  • @dsourabhpatil
    @dsourabhpatil 2 года назад +1

    To the point. Nice!

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  2 года назад

      Thanks for the feedback, plz help me with more views and subscribers

  • @DeepakKumar-qt3hl
    @DeepakKumar-qt3hl 3 года назад +1

    Bhai ek no. 👌👌👌

  • @amer9058
    @amer9058 2 года назад +1

    Crisp and Clear

  • @ravik669
    @ravik669 3 года назад +2

    Hi , thanks for doing this video, it's very helpful and easy to understand, if possible come up with excel shortcuts.

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  3 года назад +1

      Thanks a lot Dr.।।। Working on more videos related excel.।

  • @avinashkumarsingh1028
    @avinashkumarsingh1028 Год назад

    great 👍

  • @saggynation7136
    @saggynation7136 Год назад +1

    Good work bro

  • @SalmanAhmed-or3vn
    @SalmanAhmed-or3vn 3 года назад +2

    Bro your videos & content are very helpful as well knowledgeable too, keep up the good work 🙂👍
    But I hav 1 suggestion for you like specially when you are explaining practical things in excel do it a little bit slowly so viewers can understand even more better & also if possible try to make excel part in high definition clarity so that alphabetical & numerics wil look more clear.

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  3 года назад +1

      Sure will work on it ☺, morrover please share with your friends, social media, whatsApp group and help m with more subscribers 🙏

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  2 года назад +1

      Please watch the latest video on six sigma

  • @nayyumkhanpathan9662
    @nayyumkhanpathan9662 2 года назад +1

    Excellent

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  2 года назад +1

      Thanka please share with your friends, social media, whatsApp group and help m with more subscribers 🙏

  • @Jojo.Darling
    @Jojo.Darling 3 года назад

    amazing man

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  3 года назад

      Thank u please share the video with your friends, social media etc and help me with more subscribers

  • @chandanishah9411
    @chandanishah9411 2 года назад +1

    Very nice video

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  2 года назад

      Thanks for the feedback, please share video with your friends and social media, help me with more subscribers

  • @rohitarrnoj
    @rohitarrnoj Год назад +1

    Helpful

  • @sulthanashafi2022
    @sulthanashafi2022 3 года назад +1

    Thank a lot sir

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  3 года назад +1

      Most welcome dear 💕 I hope you will share with your friends who are looking for job and ask them for subscribe to my channel more videos

    • @sulthanashafi2022
      @sulthanashafi2022 3 года назад +1

      Sure Sir.... Even I am looking for the change of job

    • @sulthanashafi2022
      @sulthanashafi2022 3 года назад +1

      Sir I need video on skill issues and will issues

  • @kunwarkapilsinghpanwar6286
    @kunwarkapilsinghpanwar6286 2 года назад +1

    Please make a video on histogram also that is a part of quality analyst work cycle

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  2 года назад +2

      Definitely, plz share my videos on Facebook, whatsap and other social media, support me for more viewers & subscriber

  • @vinodsasalatti3387
    @vinodsasalatti3387 3 года назад +1

    Super

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  3 года назад +1

      Thanks for your feedback, please share it with your friends and help me with more subscribers

  • @mohdsayeedurrahmanrahman310
    @mohdsayeedurrahmanrahman310 Год назад +1

    Hey bro! Can you also bring new initiatives activity which can be done to improve the Efficiency metrics in workplace.

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  Год назад +1

      Sure will work on it, keep, sharing videos expecting good numbers of subscribers from you

  • @vinodraobr3202
    @vinodraobr3202 3 года назад +1

    Hi thank you very much you provided a practical knowledge, one thing is may i know what is CF (commutative frequency)

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  3 года назад

      Surely will upload video on it. Plz share the video and help me with more subscription 🙏

    • @Mohit-ho3gr
      @Mohit-ho3gr 2 года назад

      Cumulative Frequency

  • @SeedPops
    @SeedPops 2 года назад +1

    I just subscribed. Can u please do projected lift

  • @jayarathore2096
    @jayarathore2096 3 года назад +2

    Can you please make one video for critical and non critical data in terms of BPO for QA.. please make it.. it's request ☺️🙏🙏🙏🙏🙏🙏🙏🙏

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  3 года назад +2

      Will post it soon dr hope u will help for subscribers as well 😄

    • @jayarathore2096
      @jayarathore2096 3 года назад +1

      @@BPOInterviewTutorials 😊☺️ yes definitely...I was searching this type of video from last 7 months, finally I got it..... please make videos as I requested you..I wish you will get lot's of subscriber...

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  3 года назад +1

      @@jayarathore2096 sure

    • @jayarathore2096
      @jayarathore2096 3 года назад

      @@BPOInterviewTutorials I am requesting for 2 videos related to QA profile for BPO.. 1 fish bone 2. Critical and non critical data.. 😊☺️👍

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  3 года назад

      @@jayarathore2096 sure will post it

  • @nidhibharti7357
    @nidhibharti7357 2 года назад +1

    sir plz explain what is CP And CF? cumulative percentage n cumulative

  • @tanmoysaha701
    @tanmoysaha701 2 года назад +1

    Excellent video.. One question is that is the pareto prepatiin completed??.. Uske baad aur kuch hai kya ya aur koi finishing?

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  2 года назад +2

      Just highlighting 20%(100, to 80%)is the final task and mention note in below that need to work on above 20% occuring defect so that my 80% issue will get solved

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  2 года назад

      Tanmoy sir I am expecting more subscribers & viewer from your side, plz support keep sharing

    • @tanmoysaha701
      @tanmoysaha701 2 года назад +1

      @@BPOInterviewTutorials sure will recommend other also.. Just by curiosity I may know ur designation and role in quality?.. So described sso well that's why asked.

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  2 года назад +1

      Team lead Quality

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  2 года назад

      I am expecting 25 subscribers from you 😄😄

  • @vartikasrivastava4651
    @vartikasrivastava4651 2 года назад +1

    Sir can we get download on TNI preparation.. How to make TNI??

  • @yatinsharma95
    @yatinsharma95 Год назад +1

    How you calculated 5 parameters out of 12 as 20%?

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  Год назад +1

      See at 80% u can see it's covering 5 parameters so i considered those 5 as my top defect parameter, that is all about 80 20 rule

  • @carryet
    @carryet 7 месяцев назад +1

    But then how come these 5 parameters are a problem ? It's apology ?

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  7 месяцев назад +1

      It was an example, you will get your results by checking 80% coverage in the graph

  • @nikitayadav8547
    @nikitayadav8547 3 месяца назад +1

    Sir,Without Pareto analysis can't we identify defects by running pivot only why Pareto analysis is required?????

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  3 месяца назад +1

      U can find defect but will u focus on all Or top defaulters.
      If top defaulters then pareto will help u as the analysis say 80% of issue are because of 20% problems
      If we don't follow this rule we will get zumbled in resolving all errors

  • @shobhasrivastava6003
    @shobhasrivastava6003 2 месяца назад +1

    i need stratification scatter diagram histogram control chats

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  2 месяца назад

      Hi Check out videos ruclips.net/p/PLZnXFwmcYXFBjsrQVgn9QDBQYuixpiBrY&si=38zYkxSD60d-dOek

  • @ankleshyadav4722
    @ankleshyadav4722 3 года назад

    Bhai NPS Ke Baare Me Samjaaoo

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  3 года назад

      Thank u please share the video with your friends, social media etc and help me with more subscribers

    • @ankleshyadav4722
      @ankleshyadav4722 3 года назад

      @@BPOInterviewTutorials Sure Bro.
      Please Share Job For QA