What is PARETO ANALYSIS & Howto MAKE a PARETO CHART in MS Excel Explained in Hindi (हिंदी में )

Поделиться
HTML-код
  • Опубликовано: 16 сен 2024
  • What is PARETO ANALYSIS & Howto MAKE a PARETO CHART in MS- Excel Explained in Hindi (हिंदी में )
    इस विडियो में बताया गया है पेरेटो चार्ट क्या होता है, इसे इस्तेमाल में कैसे लाया जाता है और इसे हम एक्सेल में कैसे बना सकते है
    In this video it has been explained about the PARETO CHART, one of the seven basic quality tools.
    Also How you can a draw a Pareto chart in Excel without use of any software like MINI TAB .
    Hope You will Like the Video....................
    ----------------------------------------------
    For more details and other videos click on the link: / @aytindia
    Lean Manufacturing & Toyota Producytion System Training Videos: • LEAN Manufacturing
    ---------------------------------------------------
    Music: www.bensound.com
    -------------------------------------------------------
    About Myself: Shakir Mohd (B.TECH)
    • I am a B.Tech in Mechanical Engineering
    • I have total working Experience of Around 7 Years in Training, Execution and Implementations of Various Lean Tools and Techniques (such as VSM, KAIZEN, TPM, 5S, Visual Management, Poka-yoke, SMED etc.) in approx. 100 Units.
    • I have a wide exposure for Implementation of Lean Manufacturing Tools & Techniques to different industries like Automobile, Engineering, Food Industries, Leather Handicrafts, Leather Garments, Garments, Printing, Packaging, Shoes Industries, Plastic Injection Moulding, Aluminum Die Casting, CNC Machining, Conventional Machining, Tool Room, Press Shop, Fan Industry, Bicycle Industry, Fabrication & Sheet Metal etc. for improving their Productivity, Reducing Manufacturing cost & Rejection, 5S Levels, Employees Trainings with proper resource utilization and Implementation of various Kaizens (Improvements).
    Key Skills:
    • Value Stream Mapping (VSM), TIMWOOD (Seven Wastages), PQCDSME (Seven Benefits) Productivity Improvement, Time & Motion Study,
    • TPM (Total Productive Maintenance), FUGAI Tags, 8 Pillars of TPM , Elimination of Six Big Losses (SSSMCB) through TPM
    • 5S, KAIZEN, 7 QC Tools, VA/NVA Activities, Root cause analysis, SMED, Safety Improvements, Visual Management, etc.
    ----
    SOME OF MY ONSITE PROJECT OF TRAINING & CONSULTANCY, COMLETED/ UNDER-PROCESS ARE:
    Ultratech Cement (4 Plants)- Truck Turn Around Time (TAT) Prject
    Combit Shoes, Bahadurgarh (HR)- Plant Layout Setup Project
    Printsmith (Infinity Advertising Pvt. Ltd.),Faridabad
    MSME- Faridabad Engineering Cluster No.1 (9 Units)- LMCS Cluster
    MSME- Faridabad Engineering Cluster No.2 (6 Units)- LMCS Cluster
    MSME- Faridabad Engineering Cluster No.4 (7 Units)- LMCS Cluster
    MSME- Yamuna Nagar Engineering & Fabrication Cluster (9 Units)- LMCS Cluster
    MSME- Ludhiana Cycle Parts Cluster No.2 (7 Units)- LMCS Cluster
    MSME- Manesar, Leather Handicraft Cluster No.1 (7 Units)- LMCS Cluster
    MSME- Bahadurgarh Footwear Cluster (6 Units)- LMCS Cluster
    MSME- GZB Food Cluster (9 Units)- LMCS Cluster
    Raga Engineers- Core Pins Productivity Improvement Project, Faridabad (HR)
    Raga Engineers- Crack Toyota Project, Faridabad (HR)
    Technomech Industries, Faridabad (HR)
    Woodpecker Systems, Faridabad
    Falcon Vacuum Pumps, Faridabad
    Welcome Footwear, Bahadurgarh
    RKP Packers, Delhi
    Presto Stantest Pvt., Faridabad
    United Cores Private Limited, Faridabad
    PMT Engineers, Faridabad
    UD food Products Pvt. Ltd., Ghaziabad
    GK Industries, Faridabad
    Durga Engineering Works, Faridabad
    ..............................................

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

  • @amolpawar6462
    @amolpawar6462 19 дней назад

    Sir ajj ki date me knowledge koe share nhi karta but asa Kam karke ap garib logo ki baoot helf our knowledge bad Rahi hai thanks sir ❤❤

  • @ambkumar
    @ambkumar Год назад +3

    Thank you for creating and sharing such a useful video. Your willingness to share your knowledge and expertise with the world is truly inspiring, and I know that many people, myself included, have benefited greatly from this. Your generosity and dedication to helping others is truly appreciated. Thank you for making a difference and for all that you do to help others.

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

    SUPERB SIR!! sab cocnept direct dimag me fit ho jata he

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

      Thanks keep watching and sharing

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

    Thank you so much sir👌👌🙏🙏very easy to understand with your teaching skills.

  • @KA-oi4yf
    @KA-oi4yf 2 года назад +3

    Thanks a ton. This is useful for CMA US 🇺🇸 students too

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

      Thanks and you're welcome

  • @Mathematicswithrahul
    @Mathematicswithrahul 11 месяцев назад

    Thanks sir apne bahut hi simple tareeke se samjhaya hai aur mujhe bilkul samajh me aa gaya hai

    • @aytindia
      @aytindia  10 месяцев назад

      Thank you, Keep Watching and Sharing

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

    Thanks for an amazing way of teaching

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

    Bohat khub brother I have learnt now pareto chart making.
    Anas Raza from karachi pakistan

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

      Thanks,, keep watching and sharing

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

    The way you explain it, its so easy to understand

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

    Thank you sir it's a really very good knowledge sharing video for the community like us

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

      Thanks, keep watching and sharing

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

    It's good video with all relevant details

  • @tateraopanchal3822
    @tateraopanchal3822 4 года назад +1

    Nice Explaination and Presentation

    • @aytindia
      @aytindia  4 года назад

      Thanks for the feedback

  • @MI-gr6lg
    @MI-gr6lg 3 года назад +1

    Awesome Explaination

  • @puranbhandari2504
    @puranbhandari2504 10 месяцев назад

    Very nice demonstration. Thank you

    • @aytindia
      @aytindia  10 месяцев назад

      Glad it was helpful!

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

    Very Helpful sir..

  • @VijayKumar-vf1th
    @VijayKumar-vf1th 3 года назад

    Very easy language... Easy to understand 👍 thanx lot

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

    Good Explained..

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

    Thnx .....for sharing info

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

    Outstanding explanation sir
    I need to learn many more from you...👍👍👍

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

      Thanks,, Keep Watching

  • @sujitdable5907
    @sujitdable5907 Месяц назад

    Thanku Sir Very Nice Information

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

    You have give me full information regarding this thanks

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

      Thanks for your feedback

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

    Good explanation

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

    Mast simple and best

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

    Keep it up god bless u ❤

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

      Thanks. Keep watching and sharing

  • @annuranjan3218
    @annuranjan3218 4 месяца назад

    Great

  • @ghasiramsaini1151
    @ghasiramsaini1151 7 месяцев назад

    Very good 👍

    • @aytindia
      @aytindia  7 месяцев назад

      Most welcome ! Keep Watching

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

    Full knowledgeable thanks

  • @vishwassharma6635
    @vishwassharma6635 9 месяцев назад

    Good 👍

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

    Thank you so much sir

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

    Bahut Badiya!!

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

    Good

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

    very effective ,sir please sharer worksheet

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

      bzxqj.courses.store/371667?Dother%26Dtutor-course-referral%26Dcourse-overview-webapp

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

    Good explanation sir

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

      Keep watching & Share with Friends

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

    Thank you so much buddy

  • @sureshkandekar4140
    @sureshkandekar4140 11 месяцев назад

    Thanks Sir

    • @aytindia
      @aytindia  11 месяцев назад

      Glad it was helpful! Keep Watching and Sharing

  • @jesh5504
    @jesh5504 7 месяцев назад

    Thank you so much sir 🙏

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

    Sir your all videos amazing

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

      Thanks & Keep watching

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

    Hello sir,
    Very simple and most important learning.

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

    Nice video,its really helpfull

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

    Very effective

  • @SauravKumar-wv3kf
    @SauravKumar-wv3kf 11 месяцев назад

    Nice video

    • @aytindia
      @aytindia  10 месяцев назад

      Thank you, Keep Watching and Sharing

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

    Amazing

  • @mishras.k.2896
    @mishras.k.2896 6 месяцев назад

    Nice

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

    Well explained sir 👏

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

    Thank you

  • @PRAVINYADAV-os4je
    @PRAVINYADAV-os4je 3 года назад +1

    Good explanation and Presentation. Please share work sheet on it.

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

      Share your email id

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

    Thank you sir.. Do u give six sigma training

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

      Not available, as of now

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

    Thank yo so much

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

    Nice Sir

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

    Dear sir,
    Thanks for making the video, I learned very easily, pls share work sheet

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

    Sir, similarly make video on all tools .. Please.

  • @kalyanrao8634
    @kalyanrao8634 4 месяца назад

    Looking at the video, I have enrolled in a course -on AYT website -Machine supervison course.

    • @aytindia
      @aytindia  4 месяца назад

      Best of luck!

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

    Thanks a lot for the useful video 👍👍👍😊👏👏

  • @TAPASKOLEY
    @TAPASKOLEY 7 месяцев назад

    Please share the pareto chart drawing method

    • @aytindia
      @aytindia  7 месяцев назад

      bzxqj.on-app.in/app/oc/371667/bzxqj?Dcopy-link%26Dtutor-course-referral%26Dcourse-overview-app

  • @sahilsingh-em7yq
    @sahilsingh-em7yq 2 года назад +1

    Watched lots of videos on parreto chart but after watching your video my all doubts have been removed.

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

    sir,
    please suggest me how to match secondary axis to first axis

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

      Pl watch complete Video

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

    Great pls share work sheet

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

      Pl share your Email ID

  • @annuranjan3218
    @annuranjan3218 4 месяца назад

    Please share worksheet with me.regards

    • @aytindia
      @aytindia  4 месяца назад

      bzxqj.courses.store/371667?Dother%26Dtutor-course-referral%26Dcourse-overview-webapp

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

    Hlo sir can you share ppt and worksheet of this

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

      pl send mail on smohd@aytindia.com

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

    👍

  • @viralvideo...7464
    @viralvideo...7464 2 года назад

    Kis key se data select kar rhe hi.. Please tell me

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

    Within 80 consider krna hai ki within 90.... because jo third hai wo to 87.02 hai....
    I just wanted to ask ki ek bar chart ki frequency 43% and agle ki 80% then third wala jiski 86% hai use bhi analysis mei include krna hai??

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

      top 3 bhi le sakte h

  • @mohibaziz6024
    @mohibaziz6024 3 месяца назад

    😇

    • @aytindia
      @aytindia  3 месяца назад

      Thanks , Keep watching and Sharing

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

    Sir,
    Please share work sheet

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

      Pl send a mail on smohd@aytindia.com

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

    Worksheet Chahiye sir g

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

    I need this worksheet

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

      pl write on smohd@aytindia.com

  • @sujitdable5907
    @sujitdable5907 Месяц назад

    Sir Plz Send Work sheet

    • @aytindia
      @aytindia  Месяц назад

      bzxqj.courses.store/371667?Dother%26Dtutor-course-referral%26Dcourse-overview-webapp

  • @shubhampandey-mv6hy
    @shubhampandey-mv6hy 5 месяцев назад

    Sir Plz share this exel sheet

    • @aytindia
      @aytindia  5 месяцев назад

      bzxqj.courses.store/371667?Dother%26Dtutor-course-referral%26Dcourse-overview-webapp

  • @arifsaeed7914
    @arifsaeed7914 6 месяцев назад

    Sir mujhe work sheet ki need hai

    • @aytindia
      @aytindia  6 месяцев назад

      bzxqj.courses.store/371667?Dother%26Dtutor-course-referral%26Dcourse-overview-webapp

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

    Please share this work sheet

  • @amolbaviskar8118
    @amolbaviskar8118 7 месяцев назад

    Pls share work sheet

    • @aytindia
      @aytindia  6 месяцев назад

      bzxqj.on-app.in/app/oc/371667/bzxqj?Dcopy-link%26Dtutor-course-referral%26Dcourse-overview-app

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

    Please share the worksheet.

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

    Hello sir excel me right click krne pr secondary axis ka option ni aa rha h

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

    Sir mujhe vi work seet cahiye

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

      pl mail on smohd@aytindia.com

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

    Sir worksheet chahiye

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

      pl mail on smohd@aytindia.com

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

    Dear sir
    Yah mujhe work chiye urgent hai

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

      Pl send mail on smohd@aytindia.com

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

    What is PFD

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

      process flow diagram

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

    = D1/last and slect last then freez f4 click

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

    Sir plz send this sheet 🙏

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

      Please write mail on smohd@aytindia.com

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

    Ji Sir Hamen worksheet chahie

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

    Please share this sheet

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

    i need chart

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

      send request mail on smohd@aytindia.com

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

    Share this excel sheet

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

      docs.google.com/forms/d/e/1FAIpQLSeCZgM3HehFwHoFOcamOipVN92HJrTCcw721YNXhhOjSnX8rA/viewform

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

    Work sheet required

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

      Pl check : bzxqj.courses.store/371667?Dother%26Dtutor-course-referral%26Dcourse-overview-webapp

  • @AbdulHanan-l4t
    @AbdulHanan-l4t Год назад

    Need data sheet

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

      mail request on smohd@aytindia.com

  • @balasahebtate4699
    @balasahebtate4699 5 месяцев назад

    Share me pareto sheet

    • @aytindia
      @aytindia  5 месяцев назад

      Pl check here bzxqj.courses.store/371667?Dother%26Dtutor-course-referral%26Dcourse-overview-webapp

  • @chiragpatel3226
    @chiragpatel3226 Месяц назад

    Send me worksheet

    • @aytindia
      @aytindia  Месяц назад

      bzxqj.courses.store/371667?Dother%26Dtutor-course-referral%26Dcourse-overview-webapp

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

    Pplease share

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

      Pl check here : bzxqj.courses.store/371667?Dother%26Dtutor-course-referral%26Dcourse-overview-webapp

  • @Rajeevkumar-qo1be
    @Rajeevkumar-qo1be Год назад

    Sheet dedo

  • @shabddayalkhokhar3684
    @shabddayalkhokhar3684 11 месяцев назад

    Sir aapka no kya h ji

    • @aytindia
      @aytindia  10 месяцев назад

      mentioned in videos

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

    Please send me

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

      Pl Check : bzxqj.courses.store/371667?Dother%26Dtutor-course-referral%26Dcourse-overview-webapp

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

    Q

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

    Sir, please don't use the background music in your videos

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

      it is my old video.. in new videos there is no background music after such feedbacks, thanks

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

    Thank you so much sir ji...

  • @kalyanrao8634
    @kalyanrao8634 4 месяца назад

    Good

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

    Awesome

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

    Sir please share work sheet

  • @VimalKumar-to1fi
    @VimalKumar-to1fi Год назад

    Please share work sheet

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

      pl send mail on smohd@aytindia.com

  • @vj-ct2cr
    @vj-ct2cr Год назад

    pl share the work sheet

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

      Pl write a mail on smohd@aytindia.com

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

    Sir worksheet chahiye plz

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

      Pl send a mail on smohd@aytindia.com

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

      Good presentation, sir worksheet required.