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

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

[@TS-yy6jb]

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

[@chandoo_]

Thank you Abby.. More awesomeness to you.

[@jagatkrishna1543]

We know Sir 🙏 You are a Great for us

[@Belalrazaa]

sir please make vvideos of powerpoint

[@sujjiaa]

Hey hi chandoo...this this presentation n explanation in cooly for my kind of knowledge for understanding...awesome im looking /searching diff diff KZbin 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]

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_]

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

[@dexxxxxxxx]

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

[@redmashbeats5479]

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

[@sowmyaraykar874]

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

[@shreevlogs18]

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

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

[@sarahc172]

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!

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

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

[@raziasultana1966]

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_]

😊 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

[@AnalystTosh]

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

[@shreevlogs18]

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.

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

[@joanneenj2042]

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_]

Thanks Joanne for your appreciation and blessings.

[@denalcan403]

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

[@chandoo_]

Thanks Den for your lovely words. 😍😀

[@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!!

[@corochena]

This channel is pure gold, I am in awe

[@OzduSoleilDATA]

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_]

So true Oz. 👌

[@monitortvibi1990]

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

[@chandoo_]

Best of luck!

[@peterl2866]

Awesome, as ever, thanks Chandoo

[@dataniti9114]

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

[@dexxxxxxxx]

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

[@aniesc3257]

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

[@chandoo_]

You are welcome :)

[@SpotlightImpact]

Great tips! Thank you for sharing! 🙏🏻

[@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!

[@Ranu8299]

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

[@fokhrulislam2633]

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

[@chandoo_]

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

[@Kratikajain511]

@@chandoo_ every month omg

[@RobynLynn07]

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

[@sunnytimmu2719]

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

[@chandoo_]

You are welcome Sunny bhai...

[@scotthartman8390]

Great video, bravo!!! Very helpful indeed!

[@ramdey9366]

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.

[@debashisahu]

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

[@chandoo_]

Thank you Debashis.. :)

[@joshualucas89]

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

[@chandoo_]

Glad you enjoyed it!

[@osamaraheem9524]

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

[@chandoo_]

Thanks Raheem :)

[@nutanpardhi3317]

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

[@kartikkumarchoudhury4771]

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.

[@rajjkumar5146]

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

[@chandoo_]

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 - kzbin.info/www/bejne/nYfVaplnfK-XkMU

[@ZahidHasan-cc8tf]

Yes please.

[@P_J_12334]

Yes please

[@19_kartikaswal19]

Waiting

[@cyberchuck4089]

@@chandoo_ yes eagerly waiting...

[@usr1au504]

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

[@andrewbishop9467]

Another great video, well done.

[@chandoo_]

Glad you enjoyed it Andrew...

[@MB-wk3he]

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.

[@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!

[@missadventure7564]

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?

[@saneeshkrishna3818]

Thank for this video, and we are expecting more videos like this from you.

[@chandoo_]

Thanks Saneesh. I am glad you enjoyed this. I wasn't sure if this new format would work. But looking at all the feedback, I am glad I tried it. I will add more such videos from time to time.

[@ivlivs.c3666]

Excellent content! Thanks, Chandoo!

[@adp29501]

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

[@InsightfulJourney123]

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

[@chandoo_]

You are so welcome

[@MultiSambit123]

I love it Chandoo! THANK YOU!

[@robertpeters9879]

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

[@chandoo_]

Glad it was helpful!

[@poornisakrabani1563]

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

[@wayneedmondson1065]

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_]

Thank you Wayne...

[@Manoj-lg5zc]

Well explained !! Thanks Purna. Waiting for more informative videos.

[@chandoo_]

You are welcome Manoj...

[@krishnkantraj_jp]

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

[@chandoo_]

You are most welcome

[@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 😀

[@sowmyaraykar874]

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

[@franceleeparis37]

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

[@chandoo_]

Thanks Francelee... 😀

[@millicentanyango6005]

Brilliant and awesome, great work

[@sudhirsingh7999]

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.

[@relax9286]

You're extremely helpful. Thank you.

[@kuuuyajim]

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_]

That is great to hear. More awesomeness to you.

[@elfridhasman4181]

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

[@chandoo_]

You are welcome Elfrid 😊

[@anupamahegde8463]

Very informative video. Thank you sir, good job

[@reenap2286]

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

[@pov920]

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

[@ernestturkson6110]

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

[@donlam4101]

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

[@chandoo_]

Glad to hear that. Happy learning Mame.. 😀

[@boykacrazy8976]

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

[@chandoo_]

Morena... Good to hear from another kiwi 😀

[@agneschan339]

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_]

You are so welcome

[@maggieau4864]

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_]

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

[@shivendusharma3592]

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

[@mangeshkamble556]

Very helpful video thank you!!

[@muhammadazharilyas9951]

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

[@chandoo_]

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

[@ivsonali9017]

Really getting positive vibrations from your video ..

[@mohitt999]

You're awesome man, keep it up !!

[@chandoo_]

Thanks a lot! 😀

[@bouchrabouchra7549]

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

[@yulianaepianingsih]

Thank you so much, this is helping so much!

[@chandoo_]

You are so welcome!

[@abhiramroy7003]

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

[@chandoo_]

😍🙏

[@caissa6187]

What outstanding information! Thank you so much!

[@chandoo_]

Glad it was helpful!

[@pankajbaviskar4981]

Great video ...very helpful ...thanks so much sir

[@chandoo_]

🔥🔥🔥 Hello friends... As promised, *here is my Data Analyst Skills Playlist* - kzbin.info/www/bejne/nYfVaplnfK-XkMU

[@PaulasPicks]

You are an international treasure, Chandoo! Many thanks for your teachings!

[@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 ☺️

[@shriram8088]

You have explained each and every points, Thank you chandoo

[@chandoo_]

You are welcome Shriram...

[@pascoelarodrigues6124]

Thank you for sharing your expertise. This is very helpful. God Bless.

[@chandoo_]

You are welcome Pascoela...

[@markstevenson7321]

Great video! Thanks Chandoo!

[@chandoo_]

My pleasure!

[@MrSadanand2008]

You have been amazing chandooo 🎉❤ We all have learned loads of skills from 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?

[@behzadghah]

great work. thank you

[@MickeyAppy]

Very useful and effective. Thank you Sir

[@bgrg]

Great video. Will check out your pdf! Thanks!

[@arpandoshi9878]

Always come across by recommendations , finally 🙏

[@osmanhashim8425]

WOW! just Awesome Video

[@Spectixfnbr]

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

[@chandoo_]

My pleasure

[@anirbanc88]

best guy ever! thank you so much

[@sunilkumarsahu6466]

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_]

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

[@SeemaP83]

Finding tour videos very helpful. Keep sharing.

[@simonidikuchristopher2057]

Thank you Chandoo. You are my new mentor

[@signofshinejobs6391]

This video is really helpful. Such a great work by chandoo👍👍👍

[@chandoo_]

Thank you.

[@kyrryl]

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

[@nanda9395]

Thanks for the valuable information is sharing to all ..

[@Auchley]

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

[@allanpaul6122]

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.

[@samuelkodjoe1645]

You are really the best...Thank You So Much For this Excellent Video

[@chandoo_]

You're most welcome

[@Abdulaziz-el4jm]

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

[@chandoo_]

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

[@shubhamverma865]

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

[@timmytesla9655]

Thank you for this great content.

[@pelumijegede4696]

Thank you Chandoo for always bringing good and interesting content. Very Grateful

[@chandoo_]

My pleasure!