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

Поділитися
Вставка
  • Опубліковано 12 вер 2024
  • 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...

КОМЕНТАРІ • 113

  • @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

  • @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

  • @mrsumit5149
    @mrsumit5149 15 днів тому +1

    Really helpful 😀.. thanks from the bottom of my heart..

  • @jayarathore2096
    @jayarathore2096 4 роки тому +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  4 роки тому +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 🙏🙏🙏

  • @biswajitmahali7006
    @biswajitmahali7006 4 роки тому +1

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

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  4 роки тому

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

  • @jildrichvasquez3360
    @jildrichvasquez3360 3 роки тому +1

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

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  3 роки тому

      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

  • @lapisstories
    @lapisstories 20 днів тому

    Thanks, I have remembered this analysis been a while for me.

  • @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

  • @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

  • @ChinnaThambi-iw4ub
    @ChinnaThambi-iw4ub 9 місяців тому +1

    Hey bro, Good explain thanks a lot

  • @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

  • @Akbarkhan-qv1ih
    @Akbarkhan-qv1ih 3 роки тому +1

    Awesome👏... Keep going brother

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  3 роки тому

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

  • @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

  • @mavicgabayan9967
    @mavicgabayan9967 3 роки тому +1

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

  • @rajannamelodies
    @rajannamelodies 2 роки тому +1

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

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  2 роки тому +1

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

  • @ravik669
    @ravik669 4 роки тому +2

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

  • @nidhibharti7357
    @nidhibharti7357 3 роки тому +1

    awesome job done by him...👌👍

  • @B-Cool1988
    @B-Cool1988 2 місяці тому +1

    Nice

  • @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

  • @ahmedmarliesjunaveeantocan3656
    @ahmedmarliesjunaveeantocan3656 2 місяці тому +1

    this is really helpful

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  2 місяці тому

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

  • @amer9058
    @amer9058 2 роки тому +1

    Crisp and Clear

  • @jayarathore2096
    @jayarathore2096 4 роки тому +1

    Really helpful...great

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  4 роки тому +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 🙏🙏🙏

  • @DeepakKumar-qt3hl
    @DeepakKumar-qt3hl 4 роки тому +1

    Bhai ek no. 👌👌👌

  • @dsourabhpatil
    @dsourabhpatil 2 роки тому +1

    To the point. Nice!

  • @chandanishah9411
    @chandanishah9411 3 роки тому +1

    Very nice video

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  3 роки тому

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

  • @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 😄😄

  • @nayyumkhanpathan9662
    @nayyumkhanpathan9662 3 роки тому +1

    Excellent

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  3 роки тому +1

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

  • @nikitayadav8547
    @nikitayadav8547 5 місяців тому +1

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

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  5 місяців тому +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

  • @kunwarkapilsinghpanwar6286
    @kunwarkapilsinghpanwar6286 3 роки тому +1

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

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  3 роки тому +2

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

  • @jayarathore2096
    @jayarathore2096 4 роки тому +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  4 роки тому +2

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

    • @jayarathore2096
      @jayarathore2096 4 роки тому +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  4 роки тому +1

      @@jayarathore2096 sure

    • @jayarathore2096
      @jayarathore2096 4 роки тому

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

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  4 роки тому

      @@jayarathore2096 sure will post it

  • @saggynation7136
    @saggynation7136 Рік тому +1

    Good work bro

  • @SeedPops
    @SeedPops 2 роки тому +1

    I just subscribed. Can u please do projected lift

  • @just2learn971
    @just2learn971 4 роки тому

    Its is veryy helpful thankz buddy
    🤟🤟👍

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  4 роки тому

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

  • @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 3 роки тому

      Cumulative Frequency

  • @avinashkumarsingh1028
    @avinashkumarsingh1028 Рік тому

    great 👍

  • @rohitarrnoj
    @rohitarrnoj 2 роки тому +1

    Helpful

  • @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

  • @vartikasrivastava4651
    @vartikasrivastava4651 3 роки тому +1

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

  • @nidhibharti7357
    @nidhibharti7357 2 роки тому +1

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

  • @yatinsharma95
    @yatinsharma95 2 роки тому +1

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

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  2 роки тому +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

  • @sulthanashafi2022
    @sulthanashafi2022 4 роки тому +1

    Thank a lot sir

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  4 роки тому +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 4 роки тому +1

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

    • @sulthanashafi2022
      @sulthanashafi2022 4 роки тому +1

      Sir I need video on skill issues and will issues

  • @carryet
    @carryet 9 місяців тому +1

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

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  9 місяців тому +1

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

  • @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

  • @user-nk2rr7zd7y
    @user-nk2rr7zd7y Місяць тому

    can i have your personal guidance regarding 7 qc tools?

  • @shobhasrivastava6003
    @shobhasrivastava6003 4 місяці тому +1

    i need stratification scatter diagram histogram control chats

    • @BPOInterviewTutorials
      @BPOInterviewTutorials  4 місяці тому

      Hi Check out videos ua-cam.com/play/PLZnXFwmcYXFBjsrQVgn9QDBQYuixpiBrY.html&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