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

Рет қаралды 427,751

Күн бұрын

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

Пікірлер: 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 Жыл бұрын

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

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

@lisamack9504 2 жыл бұрын

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

@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

@AnalystTosh 2 жыл бұрын

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

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

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

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

@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

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

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

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

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

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

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

@adp29501 Жыл бұрын

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

@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

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

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

@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 - kzfaq.info/get/bejne/nbyibMlirLDIipc.html

@ZahidHasan-cc8tf 2 жыл бұрын

Yes please.

@P_J_12334 2 жыл бұрын

Yes please

@19_kartikaswal19 2 жыл бұрын

Waiting

@cyberchuck4089 2 жыл бұрын

@@chandoo_ yes eagerly waiting...

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

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

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

@corochena 2 жыл бұрын

This channel is pure gold, I am in awe

@denalcan403 2 жыл бұрын

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

@chandoo_ 2 жыл бұрын

Thanks Den for your lovely words. 😍😀

@Ranu8299 Жыл бұрын

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

@monitortvibi1990 2 жыл бұрын

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

@chandoo_ 2 жыл бұрын

Best of luck!

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

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

@aniesc3257 2 жыл бұрын

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

@chandoo_ 2 жыл бұрын

You are welcome :)

@joshualucas89 2 жыл бұрын

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

@chandoo_ 2 жыл бұрын

Glad you enjoyed it!

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

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

@MrSadanand2008 Жыл бұрын

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

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

@peterl2866 2 жыл бұрын

Awesome, as ever, thanks Chandoo

@debashisahu 2 жыл бұрын

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

@chandoo_ 2 жыл бұрын

Thank you Debashis.. :)

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

@osamaraheem9524 2 жыл бұрын

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

@chandoo_ 2 жыл бұрын

Thanks Raheem :)

@robertpeters9879 2 жыл бұрын

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

@chandoo_ 2 жыл бұрын

Glad it was helpful!

@boykacrazy8976 2 жыл бұрын

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

@chandoo_ 2 жыл бұрын

Morena... Good to hear from another kiwi 😀

@nutanpardhi3317 2 жыл бұрын

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

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

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

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

@pov920 2 ай бұрын

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

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

@SpotlightImpact Жыл бұрын

Great tips! Thank you for sharing! 🙏🏻

@usr1au504 Жыл бұрын

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

@reenap2286 9 ай бұрын

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

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

@sowmyaraykar874 2 жыл бұрын

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

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

@MultiSambit123 Жыл бұрын

I love it Chandoo! THANK YOU!

@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

@RobynLynn07 Жыл бұрын

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

@ernestturkson6110 Жыл бұрын

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

@andrewbishop9467 2 жыл бұрын

Another great video, well done.

@chandoo_ 2 жыл бұрын

Glad you enjoyed it Andrew...

@poornisakrabani1563 10 ай бұрын

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

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

@elfridhasman4181 2 жыл бұрын

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

@chandoo_ 2 жыл бұрын

You are welcome Elfrid 😊

@scotthartman8390 Жыл бұрын

Great video, bravo!!! Very helpful indeed!

@ivlivs.c3666 Жыл бұрын

Excellent content! Thanks, Chandoo!

@ivsonali9017 Жыл бұрын

Really getting positive vibrations from your video ..

@shantv6467 4 ай бұрын

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_ 4 ай бұрын

Glad it was helpful!

@shivendusharma3592 Жыл бұрын

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

@saneeshkrishna3818 2 жыл бұрын

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

@chandoo_ 2 жыл бұрын

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.

@zarniwhite6249 2 жыл бұрын

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

@chandoo_ 2 жыл бұрын

You are so welcome

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

@Manoj-lg5zc 2 жыл бұрын

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

@chandoo_ 2 жыл бұрын

You are welcome Manoj...

@yourbuddy4344 2 жыл бұрын

Actually, I was searching for a good data analyst trainer since long. Now, I think I found it. I have been recommending you to many of my friends. You are the best.

@chandoo_ 2 жыл бұрын

Thanks buddy. 😀

@abhiramroy7003 2 жыл бұрын

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

@chandoo_ 2 жыл бұрын

😍🙏

@simonidikuchristopher2057 2 жыл бұрын

Thank you Chandoo. You are my new mentor

@classicemmaeasy2292 Жыл бұрын

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

@signofshinejobs6391 2 жыл бұрын

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

@chandoo_ 2 жыл бұрын

Thank you.

@SeemaP83 Жыл бұрын

Finding tour videos very helpful. Keep sharing.

@bouchrabouchra7549 2 жыл бұрын

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

@caissa6187 2 жыл бұрын

What outstanding information! Thank you so much!

@chandoo_ 2 жыл бұрын

Glad it was helpful!

@millicentanyango6005 Жыл бұрын

Brilliant and awesome, great work

@anupamahegde8463 6 ай бұрын

Very informative video. Thank you sir, good job

@markstevenson7321 2 жыл бұрын

Great video! Thanks Chandoo!

@chandoo_ 2 жыл бұрын

My pleasure!

@mohitt999 2 жыл бұрын

You're awesome man, keep it up !!

@chandoo_ 2 жыл бұрын

Thanks a lot! 😀

@shriram8088 2 жыл бұрын

You have explained each and every points, Thank you chandoo

@chandoo_ 2 жыл бұрын

You are welcome Shriram...

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

@anirbanc88 Жыл бұрын

best guy ever! thank you so much

@Spectixfnbr 2 жыл бұрын

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

@chandoo_ 2 жыл бұрын

My pleasure

@pelumijegede4696 Жыл бұрын

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

@chandoo_ Жыл бұрын

My pleasure!

@pascoelarodrigues6124 2 жыл бұрын

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

@chandoo_ 2 жыл бұрын

You are welcome Pascoela...

@relax9286 2 жыл бұрын

You're extremely helpful. Thank you.

@vishnu-mk 2 жыл бұрын

These 5 points are important and very useful..thanks Chandoo

@chandoo_ 2 жыл бұрын

You're welcome 😊

@Auchley Жыл бұрын

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

@felipe4181 2 жыл бұрын

Great Advice Chandoo, Thanks you!

@chandoo_ 2 жыл бұрын

Thank you Felipe... This mindset has worked great for me and many of my students.

@felipe4181 2 жыл бұрын

@@chandoo_ it’s very well structured, impressive!!! I’ll work more on develop this pathway! Thanks 😊

@lakbaylaboy2644 2 жыл бұрын

Chandoo.u r one of my topnotch teacher in youtube . Shoutout from uae

@chandoo_ 2 жыл бұрын

Thank you Lakbay....

@yulianaepianingsih 2 жыл бұрын

Thank you so much, this is helping so much!

@chandoo_ 2 жыл бұрын

You are so welcome!

@pankaj5080 2 жыл бұрын

By far the best video on this topic

@chandoo_ 2 жыл бұрын

Thank you Pankaj...

@vaibhavmhaske173 2 жыл бұрын

Brilliant video sir.i needed this kind of video from long time.thank you so much sir.

@chandoo_ 2 жыл бұрын

Glad you liked it

@vaibhavmhaske173 2 жыл бұрын

I am glad you replied to my comment sir...your videos are really path changing for me.

@MickeyAppy 2 жыл бұрын

Very useful and effective. Thank you Sir

@premkumarcreative7143 8 ай бұрын

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