Roadmap to become a Data Analyst in 2024 🚀

Want to be a data analyst this year? Here are my top tech recommendations to focus on.

1️⃣ Microsoft Excel - Power Query, Tables, Formulas, Pivots, Charts & Sharing
2️⃣ SQL - Database concepts, Select, Where, Joins and Group By
3️⃣ BI Platforms - Tableau or Power BI - Data cleansing, data modelling, calculations, visualization & sharing
4️⃣ Business Maths & Stats - Basic Stats, Hypothesis Testing, Business Modeling
5️⃣ Coding: Python or R - Data cleanup, statistical calculations, ML learning libraries and data visualizations
6️⃣ Business Apps: Outlook, Power Point, Share Point, Github and Automation tools
7️⃣ AI tools: ChatGPT and CoPilot

⏱ IN THIS VIDEO
=============== 
0:00 - Best Tech Stack for Data Analysts in 2024
0:40 - Data Stack Item #1 - the best tech for data analysts
2:30 - (2) Databases & SQL
3:24 - (3) Data Analytics & BI Platform
5:44 - (4) Business Maths & Statistics
7:21 - (5) Coding skills
8:41 - (6) Business Applications
9:55 - (7) AI tools
10:39 - Your next steps

📺 WATCH NEXT
==============

1️⃣ ON EXCEL -

2️⃣ ON SQL -

3️⃣ ON BI PLATFORMS -

4️⃣ ON STATISTICS -

5️⃣ ON CODING -

6️⃣ ON BUSINESS APPS -

7️⃣ ON AI TOOLS -

~

ALL THE BEST 👍

#roadmap #dataanalyst

[nursing_questions-nufy]

1. Excel
2. SQL
3. PowerBI/Tableau
4. Business Math
5. Coding Skills- Optional
6. Business Apps.
7. AI Tools.

[venugopal]

Sir, can you do the complete series videos on Data Analyst.What they do in MNC's.

[petrosagbaleme]

Also I want to learn GitHub, or version control.

[knowledgedoctor]

Hi Bro, Here is Another Chando From Knowledge Doctor 🌻

[peterkasonge]

mr Excellent video appreciate your insights!. but I have a question, can you prepare a class for understanding classes and modules in excel vba, adding controls like labels, button dynamically?

[vandanapatil]

Sir please launch data analyst course according to this video so in real life we can get jobs

Please make a reasonable price according to the Indian country 😅 so everyone will be happy 😊

[ramyasubramanian]

What about having Azure knowledge for data analyst..??

[srinivasbusam]

Hi good evening, will you do freelance as well ?

[HrishikeshBhardwaj-hkxw]

Do you have any connections with ISRO? You are wearing a T shirt with it's logo. If so, can you please make a video on how I can intern at ISRO as a data analyst (non science background)?

[abhishekyadav]

Dear sir everything is here okay but now here in India, every job needs more than 2 5 years experience in even decent salary Could you give any suggestion ??

[explorerunknown]

Superb, you have summarized the whole thing. I got quite interested with data analysis as part of my job. Learnt power query, SQL, power bi and of course advanced excel concepts. Still learning and making it work.

[petrosagbaleme]

I hear tableau, tableau, Chandoo what that is? Please can you reference courses to me, to learn tableau ?

[rahulmistry]

I have a question modeling you have mention how do you build that on power bi or Python?

[magicworldbyjorg]

<<<a cool video keep up the great content.. Thank you…….

[Akshay-ifim]

Sir, can you make a video on domain knowledge, in my case i would start with the healthcare data analysis, I also asked chatgpt but it could fetch me bare minimum foundational knowledge and terms of Healthcare, it would be great if you make a video on building domain knowledge so that it can reflect on our projects and portfolio

[ankit_vlog]

Hello Chandoo, Thank you for sharing this video, Could you please let me know the best way to learn the DAX functions, where and how?

[aunali]

Dear Chando, I have been watching and learning from your video since a long time now, as my destiny has taken me here in Auckland Nz. Could you please suggest how can I take my career ahead?.

[RahulBhatia-pyiv]

Data analyst vs business analyst which one should pursue

[tariqmahmood]

Thanks for providing such a comprehensive and valuable content for the Excel lovers. Thanks Dear Chandoo for the explanation and experience you shared. ❤🎉

[eaansari-]

Hello sir,
I'm really get passionate by you because your are one that i found on social media, who talk and share actually need to do for the data analyst.
And most important thing is I'm completed my Bachelor's in Commerce honours in Accounting & Finance from University of Calcutta in the year of 2021. And after that join one of uncle family business as a operational assistant and marketing assistant. Then spending 2 years i move myself to Saudi Arabia and now I'm working as a Admin Assistant at one of most famous and biggest Catering and Facility Management company CATRION.
So, my question can i become a Data Analyst from non-technical back ground.