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!

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

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

[@AnalystTosh]

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

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

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

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

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

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

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

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

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

[@corochena]

This channel is pure gold, I am in awe

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

[@adp29501]

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

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

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

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

[@Ranu8299]

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

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

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

[@denalcan403]

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

[@chandoo_]

Thanks Den for your lovely words. 😍😀

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

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

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

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

[@reenap2286]

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

[@nutanpardhi3317]

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

[@peterl2866]

Awesome, as ever, thanks Chandoo

[@SpotlightImpact]

Great tips! Thank you for sharing! 🙏🏻

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

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

[@RobynLynn07]

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

[@premkumarcreative7143]

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

[@pov920]

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

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

[@classicemmaeasy2292]

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

[@ernestturkson6110]

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

[@anirbanc88]

best guy ever! thank you so much

[@poornisakrabani1563]

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

[@osamaraheem9524]

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

[@chandoo_]

Thanks Raheem :)

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

[@monitortvibi1990]

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

[@chandoo_]

Best of luck!

[@MultiSambit123]

I love it Chandoo! THANK YOU!

[@aniesc3257]

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

[@chandoo_]

You are welcome :)

[@scotthartman8390]

Great video, bravo!!! Very helpful indeed!

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

[@simonidikuchristopher2057]

Thank you Chandoo. You are my new mentor

[@joshualucas89]

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

[@chandoo_]

Glad you enjoyed it!

[@sowmyaraykar874]

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

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

[@The1ShyButterfly]

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

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 😀😍

[@debashisahu]

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

[@chandoo_]

Thank you Debashis.. :)

[@bouchrabouchra7549]

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

[@shivendusharma3592]

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

[@ivsonali9017]

Really getting positive vibrations from your video ..

[@robertpeters9879]

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

[@chandoo_]

Glad it was helpful!

[@zarniwhite6249]

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

[@chandoo_]

You are so welcome

[@behzadghah]

great work. thank you

[@Auchley]

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

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

[@parahiamin6765]

5 key skills... Power Query Power Pivot Power BI Python SQL ...add lots of practice ...create projects ...select the right technology for the project

[@ivlivs.c3666]

Excellent content! Thanks, Chandoo!

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

[@relax9286]

You're extremely helpful. Thank you.

[@millicentanyango6005]

Brilliant and awesome, great work

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

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

[@sparkvibe1319]

Brilliant Man

[@anupamahegde8463]

Very informative video. Thank you sir, good job

[@SeemaP83]

Finding tour videos very helpful. Keep sharing.

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

[@elfridhasman4181]

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

[@chandoo_]

You are welcome Elfrid 😊

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

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

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

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

[@AzadAliKhan313]

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

[@boykacrazy8976]

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

[@chandoo_]

Morena... Good to hear from another kiwi 😀

[@kyrryl]

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

[@arpandoshi9878]

Always come across by recommendations , finally 🙏

[@Manoj-lg5zc]

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

[@chandoo_]

You are welcome Manoj...

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

[@pankajbaviskar4981]

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

[@pascoelarodrigues6124]

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

[@chandoo_]

You are welcome Pascoela...

[@andrewbishop9467]

Another great video, well done.

[@chandoo_]

Glad you enjoyed it Andrew...

[@timmytesla9655]

Thank you for this great content.

[@mangeshkamble556]

Very helpful video thank you!!

[@nanda9395]

Thanks for the valuable information is sharing to all ..

[@Spectixfnbr]

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

[@chandoo_]

My pleasure

[@shantv6467]

One of great video I have ever seen currently I m working as a analyst this will give me more confident that become a data analyst Thanks chandooo

[@chandoo_]

Glad it was helpful!

[@UsmanGhani-vf3ow]

Always super video and very informative 👍

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

[@abhiramroy7003]

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

[@chandoo_]

😍🙏

[@yulianaepianingsih]

Thank you so much, this is helping so much!

[@chandoo_]

You are so welcome!

[@mohitt999]

You're awesome man, keep it up !!

[@chandoo_]

Thanks a lot! 😀

[@signofshinejobs6391]

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

[@chandoo_]

Thank you.