Тёмный

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

AYT India Academy
Подписаться 169 тыс.
Просмотров 97 тыс.
50% 1

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
..............................................

Опубликовано:

 

14 апр 2020

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 177   
@ambkumar
@ambkumar Год назад
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.
@VijayKumar-vf1th
@VijayKumar-vf1th 3 года назад
Very easy language... Easy to understand 👍 thanx lot
@prathmeshmane6133
@prathmeshmane6133 11 месяцев назад
Thank you so much sir👌👌🙏🙏very easy to understand with your teaching skills.
@chilldancer8139
@chilldancer8139 Год назад
It's good video with all relevant details
@ankamshreyash968
@ankamshreyash968 Год назад
SUPERB SIR!! sab cocnept direct dimag me fit ho jata he
@aytindia
@aytindia Год назад
Thanks keep watching and sharing
@relaxationmusickavita6889
@relaxationmusickavita6889 3 года назад
Nice video,its really helpfull
@MI-gr6lg
@MI-gr6lg 3 года назад
Awesome Explaination
@preetigera4185
@preetigera4185 2 года назад
Full knowledgeable thanks
@darpansingh6404
@darpansingh6404 Год назад
Thnx .....for sharing info
@sujitdable5907
@sujitdable5907 День назад
Thanku Sir Very Nice Information
@saurabhmishra6590
@saurabhmishra6590 Год назад
Outstanding explanation sir I need to learn many more from you...👍👍👍
@aytindia
@aytindia Год назад
Thanks,, Keep Watching
@gajananjadhav9189
@gajananjadhav9189 17 дней назад
Thank you sir it's a really very good knowledge sharing video for the community like us
@aytindia
@aytindia 13 дней назад
Thanks, keep watching and sharing
@santmun2008
@santmun2008 2 года назад
Thank you so much sir ji...
@arjunchauhan499
@arjunchauhan499 2 года назад
Good Explained..
@puranbhandari2504
@puranbhandari2504 9 месяцев назад
Very nice demonstration. Thank you
@aytindia
@aytindia 9 месяцев назад
Glad it was helpful!
@KA-oi4yf
@KA-oi4yf Год назад
Thanks a ton. This is useful for CMA US 🇺🇸 students too
@aytindia
@aytindia Год назад
Thanks and you're welcome
@abhisonic
@abhisonic Год назад
Thanks for an amazing way of teaching
@aytindia
@aytindia Год назад
You're welcome
@shabirkhan9961
@shabirkhan9961 2 года назад
The way you explain it, its so easy to understand
@aytindia
@aytindia 2 года назад
Thanks
@amanupadhyaya696
@amanupadhyaya696 3 года назад
Thank you so much sir
@gurpritsingh11
@gurpritsingh11 2 года назад
Thank you so much buddy
@jesh5504
@jesh5504 6 месяцев назад
Thank you so much sir 🙏
@Mathematicswithrahul
@Mathematicswithrahul 9 месяцев назад
Thanks sir apne bahut hi simple tareeke se samjhaya hai aur mujhe bilkul samajh me aa gaya hai
@aytindia
@aytindia 9 месяцев назад
Thank you, Keep Watching and Sharing
@manishprasad6166
@manishprasad6166 Год назад
Bahut Badiya!!
@aytindia
@aytindia Год назад
Dhanywad...
@tateraopanchal3822
@tateraopanchal3822 4 года назад
Nice Explaination and Presentation
@aytindia
@aytindia 4 года назад
Thanks for the feedback
@vinayakdoiphode7550
@vinayakdoiphode7550 2 года назад
Mast simple and best
@babyChitransh7252
@babyChitransh7252 2 года назад
Sir your all videos amazing
@aytindia
@aytindia 2 года назад
Thanks & Keep watching
@mohammadshabbir7775
@mohammadshabbir7775 2 года назад
Very Helpful sir..
@aytindia
@aytindia 2 года назад
Keep watching
@user-rt7us7qj9t
@user-rt7us7qj9t Год назад
Bohat khub brother I have learnt now pareto chart making. Anas Raza from karachi pakistan
@aytindia
@aytindia Год назад
Thanks,, keep watching and sharing
@pritikhairnar5638
@pritikhairnar5638 2 года назад
Very effective
@Tapzzzzz_007
@Tapzzzzz_007 Год назад
Thank yo so much
@AlishaAli0825
@AlishaAli0825 Год назад
Keep it up god bless u ❤
@aytindia
@aytindia Год назад
Thanks. Keep watching and sharing
@annuranjan3218
@annuranjan3218 2 месяца назад
Great
@prashantsingh8327
@prashantsingh8327 Год назад
Well explained sir 👏
@aytindia
@aytindia Год назад
Keep watching
@dheerajkumargupta7009
@dheerajkumargupta7009 2 года назад
Awesome
@anjukaur7619
@anjukaur7619 3 года назад
Good explanation sir
@aytindia
@aytindia 3 года назад
Keep watching & Share with Friends
@vishwassharma6635
@vishwassharma6635 8 месяцев назад
Good 👍
@ExcusemeNIKKI
@ExcusemeNIKKI 3 года назад
You have give me full information regarding this thanks
@aytindia
@aytindia 3 года назад
Thanks for your feedback
@job_in_gj
@job_in_gj 2 года назад
Nice Sir
@narendranarendravs287
@narendranarendravs287 Год назад
Good explanation
@aytindia
@aytindia Год назад
Keep watching
@PRAVINYADAV-os4je
@PRAVINYADAV-os4je 3 года назад
Good explanation and Presentation. Please share work sheet on it.
@aytindia
@aytindia 3 года назад
Share your email id
@ghasiramsaini1151
@ghasiramsaini1151 5 месяцев назад
Very good 👍
@aytindia
@aytindia 5 месяцев назад
Most welcome ! Keep Watching
@sureshkandekar4140
@sureshkandekar4140 10 месяцев назад
Thanks Sir
@aytindia
@aytindia 10 месяцев назад
Glad it was helpful! Keep Watching and Sharing
@mishras.k.2896
@mishras.k.2896 4 месяца назад
Nice
@nileshpagar5000
@nileshpagar5000 3 года назад
👍
@ashishbhosale5046
@ashishbhosale5046 Год назад
Thank you
@aytindia
@aytindia Год назад
You're welcome
@priyankachoubeyarora
@priyankachoubeyarora 10 месяцев назад
Amazing
@aytindia
@aytindia 10 месяцев назад
Thanks
@avinashchougale2510
@avinashchougale2510 11 месяцев назад
very effective ,sir please sharer worksheet
@aytindia
@aytindia 11 месяцев назад
bzxqj.courses.store/371667?Dother%26Dtutor-course-referral%26Dcourse-overview-webapp
@ajeetrajbhar2633
@ajeetrajbhar2633 3 года назад
Dear sir, Thanks for making the video, I learned very easily, pls share work sheet
@aytindia
@aytindia 3 года назад
Share your email address
@imgauravchauhan
@imgauravchauhan 2 года назад
Pls reply me
@imgauravchauhan
@imgauravchauhan 2 года назад
Share the worksheet
@kubersingh1432
@kubersingh1432 2 года назад
Thanks a lot for the useful video 👍👍👍😊👏👏
@SauravKumar-wv3kf
@SauravKumar-wv3kf 9 месяцев назад
Nice video
@aytindia
@aytindia 9 месяцев назад
Thank you, Keep Watching and Sharing
@ashulittlestar3933
@ashulittlestar3933 2 года назад
Sir, similarly make video on all tools .. Please.
@aytindia
@aytindia 2 года назад
ok
@sourabhdubey3920
@sourabhdubey3920 Год назад
Good
@aytindia
@aytindia Год назад
Thanks
@kalyanrao8634
@kalyanrao8634 2 месяца назад
Looking at the video, I have enrolled in a course -on AYT website -Machine supervison course.
@aytindia
@aytindia 2 месяца назад
Best of luck!
@karukumarchaudhari2454
@karukumarchaudhari2454 Год назад
sir, please suggest me how to match secondary axis to first axis
@aytindia
@aytindia Год назад
Pl watch complete Video
@sandilyatripathi4962
@sandilyatripathi4962 2 года назад
Please share the worksheet.
@paprimondal5238
@paprimondal5238 Год назад
Thank you sir.. Do u give six sigma training
@aytindia
@aytindia Год назад
Not available, as of now
@careervision1162
@careervision1162 3 года назад
Hello sir excel me right click krne pr secondary axis ka option ni aa rha h
@yatendrayadav9
@yatendrayadav9 2 года назад
Sir please share work sheet
@rajnishkumarrai3743
@rajnishkumarrai3743 11 месяцев назад
Please share this work sheet
@TAPASKOLEY
@TAPASKOLEY 6 месяцев назад
Please share the pareto chart drawing method
@aytindia
@aytindia 6 месяцев назад
bzxqj.on-app.in/app/oc/371667/bzxqj?Dcopy-link%26Dtutor-course-referral%26Dcourse-overview-app
@imgauravchauhan
@imgauravchauhan 2 года назад
Worksheet Chahiye sir g
@sujitdable5907
@sujitdable5907 День назад
Sir Plz Send Work sheet
@viralvideo...7464
@viralvideo...7464 2 года назад
Kis key se data select kar rhe hi.. Please tell me
@mohibaziz6024
@mohibaziz6024 Месяц назад
😇
@aytindia
@aytindia Месяц назад
Thanks , Keep watching and Sharing
@bhagvandas9545
@bhagvandas9545 2 года назад
Ji Sir Hamen worksheet chahie
@devendrasarna1056
@devendrasarna1056 2 года назад
Great pls share work sheet
@aytindia
@aytindia 2 года назад
Pl share your Email ID
@Shravanbhardwaj2332
@Shravanbhardwaj2332 11 месяцев назад
Please share this sheet
@jyotithakur7301
@jyotithakur7301 Год назад
Hlo sir can you share ppt and worksheet of this
@aytindia
@aytindia Год назад
pl send mail on smohd@aytindia.com
@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
@arifsaeed7914
@arifsaeed7914 4 месяца назад
Sir mujhe work sheet ki need hai
@aytindia
@aytindia 4 месяца назад
bzxqj.courses.store/371667?Dother%26Dtutor-course-referral%26Dcourse-overview-webapp
@careervision1162
@careervision1162 2 года назад
= D1/last and slect last then freez f4 click
@annuranjan3218
@annuranjan3218 2 месяца назад
Please share worksheet with me.regards
@aytindia
@aytindia 2 месяца назад
bzxqj.courses.store/371667?Dother%26Dtutor-course-referral%26Dcourse-overview-webapp
@avanishtiwari6975
@avanishtiwari6975 Год назад
Sir mujhe vi work seet cahiye
@aytindia
@aytindia Год назад
pl mail on smohd@aytindia.com
@eliyasahmed9435
@eliyasahmed9435 Год назад
I need this worksheet
@aytindia
@aytindia Год назад
pl write on smohd@aytindia.com
@shubhampandey-mv6hy
@shubhampandey-mv6hy 3 месяца назад
Sir Plz share this exel sheet
@aytindia
@aytindia 3 месяца назад
bzxqj.courses.store/371667?Dother%26Dtutor-course-referral%26Dcourse-overview-webapp
@mohanmunda7039
@mohanmunda7039 2 года назад
Dear sir Yah mujhe work chiye urgent hai
@aytindia
@aytindia Год назад
Pl send mail on smohd@aytindia.com
@yoginderkumar4370
@yoginderkumar4370 Год назад
Sir, Please share work sheet
@aytindia
@aytindia Год назад
Pl send a mail on smohd@aytindia.com
@nirajchauhan1995
@nirajchauhan1995 Год назад
Sir worksheet chahiye
@aytindia
@aytindia Год назад
pl mail on smohd@aytindia.com
@vj-ct2cr
@vj-ct2cr Год назад
pl share the work sheet
@aytindia
@aytindia Год назад
Pl write a mail on smohd@aytindia.com
@amolbaviskar8118
@amolbaviskar8118 5 месяцев назад
Pls share work sheet
@aytindia
@aytindia 5 месяцев назад
bzxqj.on-app.in/app/oc/371667/bzxqj?Dcopy-link%26Dtutor-course-referral%26Dcourse-overview-app
@vivek4484
@vivek4484 Год назад
Please share work sheet
@aytindia
@aytindia Год назад
Pl send a mail on smohd@aytindia.com
@abhisheksharma5483
@abhisheksharma5483 Год назад
Sir plz send this sheet 🙏
@aytindia
@aytindia Год назад
Please write mail on smohd@aytindia.com
@yogendramanjhi4972
@yogendramanjhi4972 Год назад
i need chart
@aytindia
@aytindia Год назад
send request mail on smohd@aytindia.com
@gulshankhan6714
@gulshankhan6714 Год назад
What is PFD
@aytindia
@aytindia Год назад
process flow diagram
@Vinodbhardwaj92
@Vinodbhardwaj92 2 месяца назад
sir pls send work sheet
@aytindia
@aytindia 2 месяца назад
bzxqj.courses.store/371667?Dother%26Dtutor-course-referral%26Dcourse-overview-webapp
@aytindia
@aytindia 2 месяца назад
bzxqj.courses.store/371667?Dother%26Dtutor-course-referral%26Dcourse-overview-webapp
@sahilsingh-em7yq
@sahilsingh-em7yq 2 года назад
Watched lots of videos on parreto chart but after watching your video my all doubts have been removed.
@vikasgautam2498
@vikasgautam2498 2 года назад
Share this excel sheet
@aytindia
@aytindia 2 года назад
docs.google.com/forms/d/e/1FAIpQLSeCZgM3HehFwHoFOcamOipVN92HJrTCcw721YNXhhOjSnX8rA/viewform
@punamsasmal3624
@punamsasmal3624 10 месяцев назад
Pplease share
@aytindia
@aytindia 10 месяцев назад
Pl check here : bzxqj.courses.store/371667?Dother%26Dtutor-course-referral%26Dcourse-overview-webapp
@user-wf4dm5rg7d
@user-wf4dm5rg7d Год назад
Need data sheet
@aytindia
@aytindia Год назад
mail request on smohd@aytindia.com
@balasahebtate4699
@balasahebtate4699 4 месяца назад
Share me pareto sheet
@aytindia
@aytindia 4 месяца назад
Pl check here bzxqj.courses.store/371667?Dother%26Dtutor-course-referral%26Dcourse-overview-webapp
@dssharma474
@dssharma474 Год назад
Work sheet required
@aytindia
@aytindia Год назад
Pl check : bzxqj.courses.store/371667?Dother%26Dtutor-course-referral%26Dcourse-overview-webapp
@Rajeevkumar-qo1be
@Rajeevkumar-qo1be Год назад
Sheet dedo
@yoginderkumar4370
@yoginderkumar4370 Год назад
Hello sir, Very simple and most important learning.
@aytindia
@aytindia Год назад
Thanks and welcome
@rajeshbhedi4384
@rajeshbhedi4384 Год назад
Please send me
@aytindia
@aytindia Год назад
Pl Check : bzxqj.courses.store/371667?Dother%26Dtutor-course-referral%26Dcourse-overview-webapp
@shabddayalkhokhar3684
@shabddayalkhokhar3684 9 месяцев назад
Sir aapka no kya h ji
@aytindia
@aytindia 9 месяцев назад
mentioned in videos
@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
@kalyanrao8634
@kalyanrao8634 2 месяца назад
Good
@aytindia
@aytindia 2 месяца назад
Thanks
@VimalKumar-to1fi
@VimalKumar-to1fi Год назад
Please share work sheet
@aytindia
@aytindia Год назад
pl send 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.
Далее
Pareto Analysis Chart  In Excel Hindi
12:14
Просмотров 248 тыс.
Why-Why Analysis? - Root Cause Analysis Tool
11:53
Просмотров 404 тыс.