5 key skills you need to become a GREAT Data Analyst ~ Lessons from 15 years of analytics experience

Подписаться 603 тыс.

Просмотров 427 тыс.

50% 1

Do you want to be a GREAT Data Analyst?
In this video, I share what worked & what mistakes I made as a data analyst in my fifteen years of career in analytics. I started as a business analyst with Tata group in India and worked with many Fortune 500 clients all over the world in last 15 years in roles like DATA ANALYST, REPORTING ANALYST, INFORMATION ANALYST and DATA SCIENTIST.
In my recent role as a Senior HR Information Analyst, I worked with New Zealand Treasury.
📄Topics in this video (click to jump around):
=====================================
0:00 - Introduction & about myself
0:44 - The five skills you need to be a GREAT Data Analyst
1:14 - Data Preparation Skills
3:49 - Number Crunching Skills
5:58 - Storytelling Skills
7:54 - Asking Questions
10:20 - Technology Skills
13:40 - How to get the data analyst skills?
DOWNLOAD 5 Skills PDF 💻📕
=========================
Go here 👉 chandoo.org/wp/da5k
Watch these videos next
====================
Data Preparation:
~~~ Getting Started with Power Query - • Power Query Tutorial -...
~~~ Top 10 Quick tips to clean data in Excel - • Data cleaning in Excel...
Data Analysis:
~~~ Make your first 8 pivot reports in ≤10 minutes - • How to use Pivot Table...
~~~ Top 10 Formulas you need for data analysis - • Learn these top 10 Exc...
Storytelling:
~~~ 6 Line charts you need to learn - • 6 Must have line chart...
Data Analysis Playlist:
• 5 key skills you need ...
Advanced Excel Skills: chandoo.org/wp/advanced-excel...

Наука

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

15 май 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 625

@TS-yy6jb 2 года назад

Brilliant video,I just realised what I was doing right and gaps in my role as a data analyst.

@chandoo_ 2 года назад

Thank you Abby.. More awesomeness to you.

@jagatkrishna1543 2 года назад

We know Sir 🙏 You are a Great for us

@Belalrazaa Год назад

sir please make vvideos of powerpoint

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

Hey hi chandoo...this this presentation n explanation in cooly for my kind of knowledge for understanding...awesome im looking /searching diff diff RU-vid channels where in i never follow up as im not satisfied n my mind is alwys empty in getting to learn for data analyst its been 6-7months took... Today i got what exactly how should learn and just now i saw ur started your channel in telugu first building report awesome...great job 👍 I want to be expertise like researching sort in data analyst from end to end .how to learn n want your vedios in both telugu n english ...if you provide your guidelines it will be great help for my career build up.....please let me know Waiting for reply Thank you

@anilkumarkarimbanakkal5043 2 года назад

I am following you since 2008 when I started my career as a Junior Analyst and you've moulded me as a Business Controller now. Trust me, you are amazing.. Really amazing!

@chandoo_ 2 года назад

Wow.... such a lovely testimonial Anil. So happy to hear about your progress over the years. More power to you :)

@dexxxxxxxx 2 года назад

Is power BI alone is enough to get good job or I should learn other softwares too?

@redmashbeats5479 2 года назад

Hi anil sir, looks like u hav lot of experience :) . Any suggestions for beginners?

@sowmyaraykar874 2 года назад

Cool to Hear.. Chandooo Good job ..I am happy for u ...keep Growing

@shreevlogs18 2 года назад

@@dexxxxxxxx it depends on the role you want to work for. For example, for a Business Analyst, you need SQL( intermediate) + PowerBI or Tableau + strong communication and analytical skills and there are other skills too which are not prerequisites but good to learn things.

@lisamack9504 2 года назад

WOW this is a gold mine! Thank you so much!!! I’m looking forward to the series!

@ankitachowdhury1046 Год назад

This is the most precise explanation video I ever came across on a YT channel for beginners. Sir almost everyone recommends your channel for learning about Data science. Thank you for this wonderful channel sir. I wish I could show you the notes that I prepare watching your channel. God bless you, sir.

@raziasultana1966 2 года назад

I really wonder how can a person be genius and so so humble and generous at the same time. You truly motivate, educate and build our skills. Thank you so much Chandoo Sir.

@chandoo_ 2 года назад

😊 Thanks Razia. It is my life's mission to make others awesome in their work. I feel fortunate to have people supporting my work and cheering me all the way. Thank you for your kind words & blessings.

@MuhammadIrfanShaikhOfficial Год назад

You are one of the best teacher in my life

@sarahc172 2 года назад

Thank you for all your videos and your website! I've been utilizing your info for years and you are my #1 Excel go-to! Appreciate you sharing all your knowledge!

@OzduSoleilDATA 2 года назад

That part "Asking Questions" is so so important. Excel skill isn't worth much if the right content isn't captured or presented in a way that's it's needed.

@chandoo_ 2 года назад

So true Oz. 👌

@shreevlogs18 2 года назад

Started following you 1 month ago, you're an awesome tutor, You make videos interesting and the way you explain things are very crisp and clear.

@AnalystTosh 2 года назад

You have clearly mastered the story telling aspect of Data analysis… I like how you have made the video… very engaging

@dataniti9114 2 года назад

It’s great time to jump into data science and analytics. Good luck to all you wonderful people starting now 😊👍

@dexxxxxxxx 2 года назад

Are you in this field? I'm new please guide... 🙏🏻

@juantray Год назад

Really comprehensive. I am going to share with my hungry and awesome team. I’ve been following you since 2014. It’s great to see your progression.

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

besides Data analyst YOU ARE ONE OF THE GREATEST PERSONS IN THE WORLD who are providing free knowledge about a data. May GOD bless you.

@viahttp Год назад

Besides all the Gems you lay out in this lecture,I also love your style of explaination. SImply awesome. A school kid can even grasp in no time. Thank You Chandoo

@corochena 2 года назад

This channel is pure gold, I am in awe

@supermamacita3 Год назад

Chandoo! I looove your videos and I appreciate your humor! I am new to the data analytics world and you have been the best teacher! Thank you for doing what you do!!

@adp29501 Год назад

Just started as a Junior Analyst and your videos and tools and tips are molding me into a great analyst. Thankyou.

@vas2297 Год назад

The fact that you share moments of your life-family, made you and your channel stand out from the thousand other excel sites out there since you become more relatable and your way of presenting - non-urgent, yet incredibly informed and knowledgeable,( as if a friend is explaining excel) takes the stress out of tricky pieces of data learning. Subscribed. Thank you Chandoo!

@faiqahaider8296 Год назад

Absolutely agree!

@joanneenj2042 2 года назад

Thank you so much, Sir Chandoo! I am looking forward to learning excel skills for data analysis from your channel. Thanks for all that you do. Stay blessed. :))

@chandoo_ 2 года назад

Thanks Joanne for your appreciation and blessings.

@MB-wk3he 11 месяцев назад

Thank YOU for sharing your knowledge in such an amazing way, Shandoo: for starters, your sense of humor, tone of voice, pace, detailing and humbleness make the subjects interesting, awakening curiosity to dig further instead of naying it as out of reach matters. The clips you insert are relevant and aid in explaining the subject instead of distracting, which is something I need to avoid as a person dealing with ADHD, and what it makes you more relatable is your attire, which goes with today's times of working from home, it puts aside rigidity. In sum, I feel that I will be able to reach a decent level of DA by watching your videos. Thank you again.

@paulofigueroa2314 Год назад

these are big answers on what data analysts should learn depends on what type of company you are planning to work with. I am currently studying data analytics and my target companies are related to business.. Thanks Sir. Chandoo for sharing us your tips and ideas, big salute to you ☺️

@cinthiacicilio Год назад

This is THE best Data Analysis practical advices channel I've came across. I found you beacause Codebasics recommended your channel. Thanks a lot!

@SpotlightImpact Год назад

Great tips! Thank you for sharing! 🙏🏻

@rajjkumar5146 2 года назад

Pls make data analyst series, this is my kind request ❤️

@chandoo_ 2 года назад

Sure Raj... As you can guess, I am slowly building the videos on this theme and I will make a playlist and / or longer video once I gather enough material. Added on 7 Sep - Here is my data analyst playlist - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-gVr9f1GJdZc.html

@ZahidHasan-cc8tf 2 года назад

Yes please.

@P_J_12334 2 года назад

Yes please

@19_kartikaswal19 2 года назад

Waiting

@cyberchuck4089 2 года назад

@@chandoo_ yes eagerly waiting...

@denalcan403 2 года назад

You're such a blessing and definitely awesome 👍 Thank you Chandoo!

@chandoo_ 2 года назад

Thanks Den for your lovely words. 😍😀

@fokhrulislam2633 2 года назад

Can't say thank you enough for your contribution educating / training us like this. May Allah keep you healthy.

@chandoo_ 2 года назад

You are welcome Fokhrul. It is my mission to help one million people every month. Thanks for your prayers 😀

@Kratikajain511 Год назад

@@chandoo_ every month omg

@Ranu8299 Год назад

More awesomeness to you mate, i have your videos when i get stuck in Excel, cant thank you enough..

@kartikkumarchoudhury4771 4 месяца назад

Thank you so much for this amazing video. I am embarking my journey in this space and you have put all that one needs to know. Woof to Excel.

@sunnytimmu2719 2 года назад

Love You Brother for all your wonderful work. You've been helping us a lot for building great skills. Kudos to you🙌👏❤️

@chandoo_ 2 года назад

You are welcome Sunny bhai...

@classicemmaeasy2292 Год назад

i started following you since 2021, your video are very insightful

@usr1au504 Год назад

Your knowledge-sharing approach and presentation are really AWESOME. Thank You Very Much

@MrSadanand2008 Год назад

You have been amazing chandooo 🎉❤ We all have learned loads of skills from you

@nutanpardhi3317 2 года назад

You are amazing Chandoo. Thank you so much for all your videos. 👍

@wayneedmondson1065 2 года назад

Hi Chandoo. Great tips for both new and old productivity workers! You can never learn too much or too well. Always strive to be better. Thanks for helping everyone on the journey :)) Thumbs up!!

@chandoo_ 2 года назад

Thank you Wayne...

@anirbanc88 Год назад

best guy ever! thank you so much

@RobynLynn07 Год назад

You’re amazing! Thanks for all you do!!

@monitortvibi1990 2 года назад

Awesome video, just the information I need to prepare for my interview. Thank you

@chandoo_ 2 года назад

Best of luck!

@kuuuyajim 2 года назад

I'm pretty confident with my skills as a data analyst but your video somehow gave me a better perspective on what I really need to do to become a better version me (as a data analyst). Thank you!

@chandoo_ 2 года назад

That is great to hear. More awesomeness to you.

@pov920 2 месяца назад

im very invested in your video but the dog behind is pulling all my attention!! your pet guy does very adorable blinks!!

@osamaraheem9524 2 года назад

Really you are a devoted teacher,,, thanks for sharing such an amazing tutorial❤

@chandoo_ 2 года назад

Thanks Raheem :)

@sudhirsingh7999 2 года назад

Just got to know for your channel from codebasics and you simply an amazin tutor i am in love with your creative and so easy content to learn concepts. Not sure why youtube algo is not giving your videos on top when we are searching for data analysis related content.

@debashisahu 2 года назад

My word won't be able to justify your contribution sir, grateful to have such mentor.

@chandoo_ 2 года назад

Thank you Debashis.. :)

@joshualucas89 2 года назад

Love the Friends snippets and references. Great video, Chandoo! Best, Josh

@chandoo_ 2 года назад

Glad you enjoyed it!

@MultiSambit123 Год назад

I love it Chandoo! THANK YOU!

@aniesc3257 2 года назад

Once again, a very easy to follow video! Thank you so much for this!

@chandoo_ 2 года назад

You are welcome :)

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

You are absolutely brilliant. Wish I had discovered your channel earlier. I would have saved so much time.

@missadventure7564 2 года назад

Damn so good explanation for data folks. I wonder how I never came across your channel before. My hardest part is story telling with data. Can you do more on story telling, how to develop and all. thanks a lot

@esperanzafeliciayakubu7794 Год назад

I am also faced with this challenge. It's been 11 months since you posted. Have you found a solution, if yes can you share?

@robertpeters9879 2 года назад

I'm wanting to learn data analyst. You do great job explaining the basic skills needed.

@chandoo_ 2 года назад

Glad it was helpful!

@peterl2866 2 года назад

Awesome, as ever, thanks Chandoo

@ivsonali9017 Год назад

Really getting positive vibrations from your video ..

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

Very informative video. Thank you sir, good job

@scotthartman8390 Год назад

Great video, bravo!!! Very helpful indeed!

@SeemaP83 Год назад

Finding tour videos very helpful. Keep sharing.

@simonidikuchristopher2057 2 года назад

Thank you Chandoo. You are my new mentor

@millicentanyango6005 Год назад

Brilliant and awesome, great work

@relax9286 2 года назад

You're extremely helpful. Thank you.

@elfridhasman4181 2 года назад

Thank You Very Much, May God Bless You and Your Family More and More

@chandoo_ 2 года назад

You are welcome Elfrid 😊

@donlam4101 2 года назад

You know how to communicate . Thanks bro I am seriously learning something from you everyday. I want to start doing the course soon.

@chandoo_ 2 года назад

Glad to hear that. Happy learning Mame.. 😀

@ernestturkson6110 Год назад

That's an awesome video, you have fueled my appetite to study data analysis. Thank wish to get in touch 👌🏽

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

I loved your house's interior and decoration. Also, cute puppy. Thanks, Chandoo for such an informative detail share.

@Abdulaziz-el4jm 2 года назад

Chandoo is taking excel awesomeness to new levels. Oh! I mean Data Analysis!. Actually Both!

@chandoo_ 2 года назад

Thanks Abdul.. I was hesitant to try this new format but I am glad I did.

@shubhamverma865 2 года назад

@@chandoo_ sir plz give me suggestions for Excel, whear i should start and end up for data analyst 🙏

@boykacrazy8976 2 года назад

Kia Ora brother! So good to see fellow Kiwi’s helping others 👍🏾

@chandoo_ 2 года назад

Morena... Good to hear from another kiwi 😀

@muhammadazharilyas9951 2 года назад

Awesome Work ! Going to recommend this video to anyone who want to become an Data Analyst. Keep doing awesome work

@chandoo_ 2 года назад

Thank you so much for liking and spreading good word Azhar...

@allanpaul6122 2 года назад

Hello Chandoo, well I am new to this channel and I really hope to learn a lot from your videos. could you make a video on 5 skills to become a BUSINESS ANALYST? I am perplexed in choosing which role I would be the best fit for.

@sowmyaraykar874 2 года назад

Get me there.. I will be the Happiest person... Such a Great knowledge and easy convey .. Awesome

@zarniwhite6249 2 года назад

You are amazing!! Thank you for sharing blessing of knowledge!!😊

@chandoo_ 2 года назад

You are so welcome

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

Chandoo, you are the best! Like all your teachings and sharing. You planned them well and made it easy to understand. Thank you so much.

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

You are so welcome

@bouchrabouchra7549 2 года назад

Thank you soo much for this informative video It is very clear and simple

@franceleeparis37 2 года назад

Have to say, this guy really was an excel guru… he has some excellent examples on how to build graphs.. highly recommended..🙂

@chandoo_ 2 года назад

Thanks Francelee... 😀

@shivendusharma3592 Год назад

nice presentation thrugh this video. Nice Story Telling skills 🙂. I am thankful to U for the video.

@nanda9395 Год назад

Thanks for the valuable information is sharing to all ..

@krishnkantraj_jp 2 года назад

Very informative video for Data Analyst beginners and pdf is very beautiful designed. Thanks a lot chandi sir 🙏

@chandoo_ 2 года назад

You are most welcome

@sunilkumarsahu6466 2 года назад

i learned so many tricks and functions from your channel, it's so helpful and applicable for me... Please make a series video for Data analyst beginners... it's my humble Request 🙏

@chandoo_ 2 года назад

Thanks Sunil... I will add more DA videos.

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

great work. thank you

@ivlivs.c3666 Год назад

Excellent content! Thanks, Chandoo!

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

Love you Chandoo Sir.. The way of explanation and Expressions ❤, give me more confidence to get into Data Analyst field, I check out your videos all are Awesome.. Insist to learn from you.. Thank you for inspiring

@kyrryl Год назад

you are amazing. very helpful. I am glad I could find you

@coconutious Год назад

Wow! I live in Wellington too!! I have just started my career as an analyst and am going to watch all your videos! Thanks!

@chandoo_ Год назад

Always a pleasure to hear from another Wellingtonian 😀

@AzadAliKhan313 8 месяцев назад

it makes my own life very easy how we learn new skills

@searchbug Год назад

Others see Data Analyst works as intimidating or only for those who have a knack for coding. But others don't realize that there are other ways to be a Data Analyst without having coding skills. That's a plus, yes, but there are data tools that can support you to accomplish the same goal of data cleansing, enrichment, and verification.

@timmytesla9655 2 года назад

Thank you for this great content.

@arpandoshi9878 2 года назад

Always come across by recommendations , finally 🙏

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

Brilliant Man

@Spectixfnbr 2 года назад

Thanks a lot Sir Chandoo!!!! Appreciate your valuable info and resource.

@chandoo_ 2 года назад

My pleasure

@mangeshkamble556 Год назад

Very helpful video thank you!!

@udayreddygurrala9432 Год назад

super video chandoo....you have great clarity about both business analyst and data anaslyst thanks alot ❤

@vidhathamanoharan7470 Год назад

Hi Uday Many I get in touch with you, if you don't mind?

@maggieau4864 2 года назад

Chandoo, you are awesome, my first time here. Many thanks for this video and generous sharing your skill with clear explanation too. Keep up!!

@chandoo_ 2 года назад

Welcome here Maggie. Thanks for your comment and appreciation. 😀

@abhiramroy7003 2 года назад

Oh Chandoo, you and your excel is just awesome. God bless.

@chandoo_ 2 года назад

😍🙏

@Auchley Год назад

Chando you are amazing, and fascinated tutor for me!! i wish u all the best! thank you for your lesson..:))

@The1ShyButterfly 2 года назад

EXCELLENT and useful information, thank you for taking the time to share 😊🤗 Your videos are very helpful and easy to follow - with incredible expertise. Please continue with more videos for those of us who are trying to improve our skills as Data Analysts and develop a btter understanding of the qualities required... I love doing the analysis but have an uphill battle with my boss who believes HE is an expert (far from it). I'm happy to see that I hold strong to keeping data integrity, but easier said than done in my organisation - but I'm like a dog with a bone ... I'll continue to fight to maintain the data integrity - regardless of the opinion of my boss! Thank you again, at least I'm on the right track. But still a way to go 🐐. Blessings to you 😊

@chandoo_ 2 года назад

Few drops of good data ≫ buckets of bad data. Keep the good fight on. I am sure you will learn loads of things along the way. Thanks heaps for your blessings and love 😀😍