Data Analyst Skills Required | Job-Ready Checklist 🚀🚀

The worst thing that can happen to data analyst aspirants is working hard without knowing where they stand. Use this checklist to know where you stand!
The more boxes you tick, the closer you get to the door to your first data analyst job! 🎯
Checklist: www.linkedin.com/feed/update/...
⭐️ Timestamps ⭐️
00:00 Introduction
00:24 Excel
01:54 PowerBI
03:08 SQL & Python
04:21 AI Enabled Mindset
05:16 Business Acumen
06:22 Communication
07:30 Resume
09:06 LinkedIn & Online Credibility
09:55 Your Project Portfolio
Resources:
a. Business Math & Statistics Using Excel: • Business Math & Statis...
b. SQL Tutorial For Beginners | MySQL Tutorial: • SQL Tutorial For Begin...
c. Codebasics resume project challenge portal:codebasics.io/challenge/codeb...
d. Think School KZbin Channel: / @thinkschool
e. Website for ATS resume: resumeworded.com/
f. STAR method to describe projects: • Data Analyst & Softwar...
Do you want to learn technology from me? Check codebasics.io/?... for my affordable video courses.
Need help building software or data analytics/AI solutions? My company www.atliq.com/ can help. Click on the Contact button on that website.
🎥 Codebasics Hindi channel: / @codebasicshindi
#️⃣ Social Media #️⃣
🔗 Discord: / discord
📸 Dhaval's Personal Instagram: / dhavalsays
📸 Codebasics Instagram: / codebasicshub
🔊 Facebook: / codebasicshub
📱 Twitter: / codebasicshub
📝 Linkedin (Personal): / dhavalsays
📝 Linkedin (Codebasics): / codebasics
🔗 Patreon: www.patreon.com/codebasics?fa...

[@shivangpant9639]

Much needed video to give you overview of all you need to have to become a data analyst and things they need to improve on.

[@sqlchannel]

Good discussion on the relevant topics of data analytics.

[@javshah105]

Thank you so much 👍

[@brendamartinez6955]

Thank you !😊

[@maanug95]

Thank you very informative

[@vishalbaldodia3841]

Thank you so much Dhavel Sir

[@suyash7450]

This video is just amazing..... found it very important you put all relevant things in a basket thanks for making it Dhaval sir ...

[@codebasics]

👍👍🙏

[@chandnirana369]

Thank you sir 🙏

[@mrpavankumar2747]

Thanks You Sir For More Understandable Explanation

[@codebasics]

You are most welcome Pavankumar

[@tusharsingh9027]

Currently I am pursuing codebasics data analyst bootcamp and I love the content. Super easy to understand and their doubt solving support is great.

[@zoha3728]

Which method do you use for payment details plz I am also try to join boot camp but still not it's scam 😮

[@tusharsingh9027]

@@zoha3728 I used UPI. It will take around 5-10 minutes then your course will be added

[@TheRahulMishra]

Hi bro.. they are providing job assistance also? What is the price? Is it is for non tech guy also?

[@TheRahulMishra]

Bhai share your number.

[@tusharsingh9027]

@@TheRahulMishra price is 4800. Talking about job assistance they will help you in building your LinkedIn profile, project portfolio, resume and how you can apply for jobs on different platforms They will also take your resume for job reference. But this course will boost your confidence for sure. Currently I am doing their internship.

[@Mani-jw8yv]

Well said

[@statisticsmanagement522]

Very nice sir I am not having words to express your kindness

[@codebasics]

Glad you liked it. Please download the checklist and start working on it so that you can have many of those items checked 😀

[@FBAWSGermany]

Elegantly Simple...Love from Lahore

[@codebasics]

Glad you found it useful

[@shaaniplays9931]

Thank you for your services. Just wanna know as a complete beginner to this field of data analytics as i have completed Excel learning process and now will start learning power bi. What will be the next step after that? Also should i go ahead and give the pl-300 exam for power bi or is it not that necessary???

[@gamer-flashX]

I have joined the bootcamp. I am in Excel topic now... Looking forward to complete as soon as possible

[@TheRahulMishra]

How is the content? They are providing job assistance also?

[@TheRahulMishra]

Bhai share your number

[@wellsico1168]

same. i started already

[@suru196]

Can you give your contact

[@adityashukla9840]

Sir......Great Video Is CV Important in applying For jobs

[@husseinhadliye2992]

Hi @codebasics ihave a question about data cleaning in excel which way is most effective 1:Power Query 2: Excel Functions and if the are doing same thing whay both is used instead of one

[@pradnyavk9673]

Thank you for your thorough explanation. I'm basically an electrical engineer with 7 years of core experience. Despite holding a Data Science certification, my role transitioned into a Data Analyst position in Digital Marketing field. Regrettably, the job I landed up was only related to basic excel. If I were to acquire proficiency in Power BI and SQL, could this potentially lead me to secure a job with a more fitting profile? Your insights are much appreciated.

[@codebasics]

The answer is Yes

[@SKAMRANPASHA]

Very helpful

[@codebasics]

Glad you think so!

[@SKAMRANPASHA]

@@codebasics I've purchased power BI & python course, now planning to purchase bootcamp by paying the remaining amount, but I observe that python is optional in bootcamp & only half is shared there.. So is it beneficial to pay full amount courses rather than going for data analytics bootcamp?

[@codebasics]

Bootcamp has many additional things such as (1) AI module (2) Portfolio tool that will allow you to build portfolio for free (3) Job assistance (4) Virtual internship. These things are much more important that few additional lectures in Python. Remember that there are many data analyst jobs that do no require Python at all

[@_jugghead]

Can you make a similar checklist for Data scientist and ML engineer? Btw thanks for all the amazing content.❤

[@codebasics]

Yes DS checklist video is coming up soon

[@umak1029]

Waiting for it

[@sunset6109]

@@codebasics Looking up for ML engineer too 🥰

[@malja_a]

Me too. Looking for checklist about Data Scientist, Data Engineer, AI engineer and ML engineer. 🙏

[@aftabmalik2669]

If you could do this type of video for data scientist then it would be very helpful sir

[@codebasics]

Yes it is coming up soon

[@rithishragav4928]

I need statistics course for data analytics when you are going to launch it sir eagerly waiting for it

[@Ritesh-pv4yi]

Sir, but I already know good enough about Tableau for a entry level position l. And I find Tableau much more user Friendly, less cluttered, drag and drop feature makes it easy. Tableau is faster when it comes to big data and provides more features. Except, its desktop version isn't free. I think, the only good thing about powerbi is it's free and get's the work done. Anyways, please do make a video " comparing tableau and powerbi". And which one is preferred in Indian market

[@codebasics]

Ritesh, if you like Tableau then go ahead with it. When you apply for a data analyst job, they will check if you know atleast one BI tool and know the basics of dashboarding. That tool can be either Tableau or power bi. Recruiters know that if a person is smart, learning the second BI tool will be easy for them

[@sujjiaa]

Bro i need urgently the information about power bi administration please

[@Hkr_yalla]

I'm completely non IT graduate but Im trying to change and looking for good domine Please suggest Frontend Web Developer Data analyst Which is good I will learn anyone but my doubt is data analyst having less jobs in market compare to developer jobs And also difficulty level more in data analyst

[@harishgowda2329]

Waiting

[@fazal179]

Waiting sir

[@tiple4635]

AI will not replace your job, A person using AI will - a person A few days Later.... AI will not replace your job, A person using AI will - codebasics

[@alexaa928]

0:00: 📝 This video provides a checklist of technical and non-technical skills required to become a data analyst, with a focus on Excel skills. 2:09: 💡 Learn how to hook up Power BI with your data sources, clean and transform the data, create relationships, and build dashboards. 4:22: 💡 Using AI tools like chat GPT and continuous learning are crucial for staying ahead in the evolving work environment. 6:36: 💼 Improving communication skills in project management and job applications. 8:49: 💼 Building a strong online presence for job search. Recap by Tammy AI

[@pankajjoshi8292]

sir from where will I study Power BI

[@Opq01939]

Sir PLEASE if I'm data analyst Can I transfer to software engineering job?

[@akashgautam1909]

Sir, I have merely one doubt. People say learning these 3 tools: Excel, Power BI, and SQL are sufficient to land a job as a data analyst. However, when it comes to job descriptions, they ask for multiple skills. What to do?

[@Gurjar01]

Same question bro?

[@avinashmirchandani]

add more videos for excel, power bi

[@b1ackwollf]

exactly for excel gantt chart etc we need more. though i m following another channel for this

[@user-kw4fy6go5b]

​@@b1ackwollfmention the channel

[@b1ackwollf]

the office lab channel

[@harshalbaviskar7702]

Cloud ko leke confused hu me. Microsoft Azure cloud ko kaha se sikhe aur Microsoft Azure kk aise do certificate kaun se ha i jinko earn karne ke baad job ke liye achha rahega . Please reply 🙏

[@ndroidLover]

please a video series on power bi for youtube audience

[@codebasics]

Hey, actually I have a lot of power bi videos on youtube in form of end to end projects. Please search in youtube "codebasics sales insights" This project teaches you power bi and it perfect for beginners. I have almost 5 such end to end projects that one can use for learning

[@ndroidLover]

@@codebasics cool.

[@Ritesh-pv4yi]

​@@codebasics Will "The sales insights video playlist" give sufficient knowledge of powerbi to get an entry level data analyst job? Considering, I have all the other technical skills.

[@paingthukyaw5193]

Regards, sir. I've already studied SQL. And I'm getting ready to go on by learning Excel and PowerBi. So, sir, is it sufficient to obtain entry-level data analyst status?

[@NaveenS-fq8rr]

Yes, it is. And you need soft skills as well. Focus on building your project portfolio, just learning tools won't be enough.

[@srinivasagowda1961]

Hello Sir! I'm with a degree in commerce stream (BBA) from Bangalore University pursuing CA inter But I have always been fascinated by Science and Technology and I literally want to pursue a career in data science from basics. Since I'm not from a sound financial background, I would prefer completely free online classes with certification. Please let me know the best YT free classes for Data science. And also suggest me 1.The best books which are required for preparation from basics. 2. From which subjects I should start with 3. What is the duration that I could complete the course with help of only YT. 4.Do I need to join for internship for job ready? Kindly help me 🙏

[@codebasics]

For learning data science using free resources go to youtube and search "codebasics data science roadmap" you will find my video with complete study plan and all the resources included!

[@NS-ym5xg]

I got placed in an software company as a fresher and they put me on to data analyst community instead of software dev community(I am a computer science graduate and I liked to be a dev) what should I do, do I stick to being a data analyst or quit my job and search for another?

[@darshantawte7435]

I would switch to a SDE role asap. Data analysts I feel will soon face a big job crunch issue as AI advances, whereas if you are SDE with some AI knowledge you will remain in demand.

[@alessandrosanches7756]

can you do this for Data Scientist Job and Machine Learning pls?

[@codebasics]

Yes. That video is coming up soon

[@harishgowda2329]

🎉🎉🎉🎉

[@user-xi7rz1mi6c]

Hi sir i heard that there is not much job as a fresher for AI engineer in india only for those who have done phd degree so what we have to do sir plss reply or make video on this topic

[@user-xi7rz1mi6c]

Plss replyyy sirrrr

[@rahulloriya3966]

Is data analyst course worth 62k great deal or bad ? Offline classes

[@b1ackwollf]

no, absolutely not.

[@nadeemmomin7224]

Dhaval patel sahab...namaskar ..maine apko highcarb health par dekha hai..apka subscriber ho kyunke mera ladka it students hai..meri english poor hai mujhe highcarb channel barabar samaj nhi ata ..mujhe ap se sirf itna janna hai ke high carb health ki diet kya hai jaise ke ..healing ke dauran kya hoga aur after healing kya diet hogi agar apke pas pdf hoga unka to plz send it to me...a indian ho ummeed hai ap meri help karo ge sir...

[@codebasics]

Nadeem, aap mereko ek email bhejiye on [e-mail]. Aur ha, agar aap Indian nahi bhi hote to bhi me help karta colitis vagera health ke mamale me. Mene khud bahut suffering Kiya hai to I understand that pain 🙏

[@nadeemmomin7224]

Thank you sir ..

[@udishabhardwaj3210]

Sir i want to do data science course from code basics how to contact you

[@NaveenS-fq8rr]

Glad to know your interest towards our data science bootcamp. Currently, we only have data analyst bootcamp on our website. We will be launching data science bootcamp in a few months. That being said, we have a free data science course playlist on our KZbin channel. Please check it out here - kzbin.info/aero/PLeo1K3hjS3us_ELKYSj_Fth2tIEkdKXvV If you are new to data science and need a roadmap to learn, then here is the codebasics data science roadmap containing free and paid resources kzbin.info/www/bejne/m5KpkneVfqeMjZYfeature=shared

[@karthikaluka4794]

Hello Sir, I'm planning to do my masters in the US and I want to be a Data Analyst. In one of your videos you have said that it is not suitable to do masters for a Data Analyst role. Is it still the case?

[@codebasics]

Right now in the USA job situation is bad. People are having hard time getting a job and for a data analyst role some companies do not sponsor h1b. Things may change in the coming years but if you ask me right now, my answer would be do not come to the USA for data analyst or even software developer position

[@darshantawte7435]

I don't understand the point of doing MS in Data analytics in USA. MS in CS or AI/ML makes sense as still there are tons of jobs for Software Engineer and other SDE roles.

[@sashkhan8220]

Hello Sir I am from Pakistan I want to enroll in your Data Analyst Bootcamp how I can pay Kindly guide your help is appreciated .

[@codebasics]

you can pay using credit card etc. Just click on pay button and it will show various options. Please comment here if it doesn't work. We have many students from Pakistan already!

[@user-pc3pr9ou6q]

I just paid the amount and enrolled still did not get access to my classes after successful payment pls sir help me 🙏🙏🙏

[@codebasics]

It takes few minutes. Can you check now? You should have access. If not drop an email on [e-mail]

[@mahendrashimpi3805]

Anyone know the meaning of that endorse in LinkedIn ...??

[@Deepuu20]

In Simple terms, getting acknowledged by someone that this person really knows and works on the specified skill that is mentioned in their profile.

[@mahendrashimpi3805]

@@Deepuu20 thank you so much👍

[@parthparth1070]

You can add skills that you are know about and anyone who has worked with you, me for example, I will validate that yes Mahendra does have knowledge about this skills and I have worked with him in the past/am working with him in my team, etc.

[@himanshuverma5315]

Bhgawaan banke aya he tu

[@zahed3021]

Dimag ka dahi ho para hai 😢

[@TheRahulMishra]

Kya hua Bhai.. bootcamp purchase Kiya kya?

[@ndroidLover]

@@TheRahulMishra bootcamp purchase karne pe dimaag ka dahi hota hai kya?

[@TheRahulMishra]

@@ndroidLover context ko samjhne ki kosis kro.. kyu ho raha ye maine punchha

[@zahed3021]

@@TheRahulMishra nai bhai purchase nai kiya, hamare life ke problems me jab kuch sikhna chahe toh easy bilkul nai hota

[@umeshtompe6200]

@@zahed3021 take one step 🪜