7 Technologies you need to become a Data Analyst in 2024 🚀

💥 Best Excel Course for Data Analysts - chandoo.org/wp/excel-school-p...
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
==============
🚀 Data Analyst Road Map video - • FREE 3 Month Road Map ...
📆 Day in the life of a Data Analyst - • A day in the life of a...
🎤 Data Analyst Interview Questions - • Top 10 Data Analyst In...
1️⃣ ON EXCEL -
Excel basics - • How to use Microsoft E...
Excel Beginner to PRO Data Analysis course - • Beginner to Pro FREE E...
Full Excel course - chandoo.org/wp/excel-school-p...
2️⃣ ON SQL -
SQL basics - • SQL Basics for people ...
SQL Beginner to PRO Data Analysis course - • Learn SQL for Data Ana...
3️⃣ ON BI PLATFORMS -
Learn Power BI in 10 mins - • Your first 10 minutes ...
Learn Tableau in 10 mins - • Learn Tableau in 15 mi...
Full Power BI Course - chandoo.org/wp/power-bi-course/
4️⃣ ON STATISTICS -
Mean, median and mode explained - • KNOW the difference be...
How to calculate Z-scores - • How to find Outliers i...
More on stats in my Excel course - chandoo.org/wp/excel-school-p...
5️⃣ ON CODING -
Do Data Analysts need coding skills - • Do you need "CODING SK...
Python for beginners (masterclass) - • How to code with Pytho...
VBA for beginners - • Learn VBA & Excel Macr...
Full VBA Course - chandoo.org/wp/vba-classes/
6️⃣ ON BUSINESS APPS -
How to use Power Query - • Learn Power Query & Au...
7️⃣ ON AI TOOLS -
How to use ChatGPT with Excel - • DON'T tell my boss, bu...
Top AI features in Excel - • 10x your productivity ...
How to use Copilot in Excel - • Honest review of Excel...
~
ALL THE BEST 👍

[@nursing_questions-nu6fy]

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

[@MohamedSahith87]

Time saver thank you 👍

[@abuzainah1545]

Yes, thank you for summarising.

[@thegryffindor1112]

Does data analytics need cs or stem degree background because I really wish to have a career in this field and I just completed BBA?

[@explorerunknown1126]

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.

[@ceooflonelinessinc.267]

Awesome video chandoo, your videos are the best!!

[@SothearithKONGMrMuyKhmer]

Thank you for sharing this helpful information! 🥰

[@vitoc.1535]

Excellent video appreciate your insights!

[@azamqaim1]

Absolutely right all those skills organization looking for in a data analyst.

[@life_is_great.]

Thank you for a clear guidance.

[@abhilashn2993]

Awesome Chandoo.... Thanks for sharing...

[@waqasakbar9136]

Thanks Chandoo. I always found your videos very informative.

[@arbazahmad7177]

Really helpful... thanks a lot...

[@RahulBhatia-py1iv]

Data analyst vs business analyst which one should pursue

[@soumyajeetmitra6958]

Great ChandooJi! 🙏🙏 Very Important piece of information , much needed one. Actually, was thinking about this particularly.. just a few days ago.. and there you go.. you heard it correctly from the Heart!!....❤

[@consultpunit]

Thanks @Chandoo for this info. Really very helpful!

[@chandoo_]

My pleasure!

[@Kiranmai30]

Very much helpful chandoo

[@tariqmahmood9278]

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

[@aniljain3725]

Hi, thanks a ton for your very very helpful videos.

[@chandrasekar7276]

Perfectly said 💥❤

[@fahimreza2009]

wonderful- highly effective

[@mahfuzaakhter2452]

Thank u sir , It is incredibly insightful, breaking down complex concepts into easy-to-understand steps with practical examples that I'm excited to implement in my own projects

[@sonudamale]

Thank you Chandoo sir! Your videos have always shared great insights and I appreciate all the help you do for us beginners 😊

[@gamechangerrock8403]

My favorite teacher Chandoo I really glad that you have shared a summary of all tools. Can you share some major challenges in your work when working with different groups for the same project.

[@INDYEAH]

Spot On, Nothing More Nothing Less ..

[@venugopal7161]

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

[@el-sayedgamal]

Great video , love your setup, it's always has a hopeful vibe 😀 thank you for this video

[@aahsankhan4502]

Sir, Eagerly waiting for your video❤😊

[@zooni43]

Awesome and comprehensive as always.

[@Sai_Rajzz]

Thanks a lot sir ❤

[@ankit_vlog2347]

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?

[@tarekhusam]

great video, can you give us more about data modeling

[@hamidrezaakbari7611]

that's great 😍

[@peterkasonge7751]

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?

[@user-hz7xh6xl7f]

Hi, Sir, could you make a video on AI's impact on data analyst roles, future prospects, and insights on developing these skills for a potential career choice?

[@mehernesa_kazi]

Hello sir, your contents really helps me a lot since I am working as data analyst. could you please make video on business stats and maths.

[@aunali3651]

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

[@Akshay-if5im]

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

[@srinathp4486]

chandu anna garu namaskaram andi.. iam from hyderabad... mee videos superb andi... chandu garu.. big data medha oka video tutorial cheyandi pls 🙏🙏🙏

[@Pavani_Saikumar]

@chandoo_ నమస్కారం chandoo గారు మీ videos చూసి నేను చాలా insipre అయ్యాను నాకూ 5 years career gap ఉంది. నేను excel,sql,power bi...etc., అన్ని నేర్చుకోని data analyst job చేయవచ్చ.... మీ reply కోసం ఎదురుచూస్తుంట. Thank you so much🙏 sir

[@Kleber_Moreira]

Perfect. Thanks for all

[@chrism9037]

Great break down of the needed skills, thanks Chandoo

[@remembernaveen30]

Thank You guru ji

[@sandavenimadhukaryadav417]

Thanks

[@chandoo_]

Welcome

[@vivekrao514]

Sir can you make video on SAP FICo

[@kedarpande]

I possess adequate proficiency in each of the aforementioned technological platforms. Hence, what do you deem as the optimal choice for me to pursue next:
1) Microsoft Fabric, or 2) Azure AI & ML?

[@lil3thc]

these are what i want to learn

[@abhideeproy4479]

Please prepare few more videos on power bi

[@magicworldbyjorg]

[@sirajuddinsafirshaikh4680]

Sir jee, please recommend the videos for the topic which you are coving in this video that might be helpful for us.

[@mokumdrie4096]

a good round-up of the MS eco system 😆

[@srinivasbusam]

Hi good evening , will you do freelance as well ?

[@vinodkanna2566]

Bro I've been in the share market for the past 4 years i have some sort of profits & losses in my entire portfolio, how should i calculate my net profit after deducting all taxes & charges from start date to till date in excel. please can you make a video about calculation of profit & losses of portfolio in excel.

[@growanglow7115]

Your all videos awesome ❤

[@sanjana3538]

Hi chandoo can u please do videos on R language

[@eaansari-1792]

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.

[@rudi-gruber]

I agree 100% - perfect summary

[@knowledgedoctor3849]

Hi Bro, Here is Another Chando From Knowledge Doctor 🌻

[@arpankumar4487]

Hi can you give me a solution why i'm not able to load xlsb file in powerquery window but same data i can load in xlsx format why it is happening.... in binary format file size reduce that's why we save file in binary format....

[@ramyasubramanian1218]

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

[@HemanthKumar-id1vs]

Do u have any videos to learn M query ?

[@jsaispandana5924]

Is this good decision to change production support role to DataAnalyst in 2024?

[@UdaiKs]

What about Google Data Studio now Looker.

[@sabeelahmed1157]

Office script also required for Data Analyst?

[@abhishekyadav2041]

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

[@abhishekchanda1571]

Upvoted for the ISRO T-Shirt

[@LOFI_WORLD_SONG]

Does data analytics is enough to crack salary of more than 20+ ?

[@thegamingraj1869]

Please suggest list of courses on Udemy to learn Data Analysis from basic to advance 🙏🏻

[@savithrisravanthalabathula1329]

Sir, Are these are enough or we need to learn about AI tools Analysis prompt engg ??

[@savithrisravanthalabathula1329]

Which AI tools??

[@savithrisravanthalabathula1329]

For freshers Learning AI Analysis tools important? Or these are for working employees?

[@chandoo_]

I recommend understanding what ChatGPT can do for you (and your data). Everything else is still nascent at this stage.

[@Kavin.26]

If we doing data analyst job in retail shops… when we need to change companies like MNC’s. Will they consider as an experience ?

[@tuhin1264]

It depends on the EXPERIENCE you have and How you can express and showcase those skills in the interview.

[@saifshaikh106s]

Which retail shop arr you working for?

[@HrishikeshBhardwaj-hk5xw]

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

[@chandoo_]

I don't. It is a t-shirt I bought from Reliance Trends. I admire ISRO for their effort in pushing our understanding of this universe.

[@HrishikeshBhardwaj-hk5xw]

@@chandoo_ I see. Well said, though! Really admire your work. Your teaching style is very simple and fun to follow.

[@nurnabi4897]

Can we wait for your full data analyst course?

[@chandoo_]

Right now, you can get almost everything in this video except SQL in my Power BI + Excel combo pack - chandoo.org/wp/power-bi-course/
I plan to launch SQL program later this year. You will get 50% discount on that if you are part of this combo.

[@nurnabi4897]

@@chandoo_ Dear sir, i'm a bangladeshi student. It will be really helpful for me if you give me some special discount to buy this combo pack course. Many many thanks for your sincere reply.

[@udithakarandana7565]

❤

[@user-ye6xj4oq8e]

🟡🟡Most senior person like you say that python is not a mandatory skill..but most of the job with a decent package are having python either as mandatory or optional atleast.✅✅
In the current market ..even for optional case , if a candidate is not having python ..there is a chance company will prefer the candidate having python skill...whats your take on it 🤔🤔🤔

[@chandoo_]

I disagree. In all my years of working as a DA, I never "HAD to" use Python. I did use it because it made the job simple, but it was never necessary. If you want to learn, go ahead and do it.

[@user-ye6xj4oq8e]

@@chandoo_ I agree with you ..I am not saying that it is required..I am saying most of the job post say you should have python skill..then how can a person who does not have python can gofor it

[@chandoo_]

You answered your own question. Not all, just most. Apply for the jobs that don't say python.

[@91harshjain]

Perfect framework.

[@vandanapatil8182]

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 😊

[@nurnabi4897]

❤❤❤

[@nurnabi4897]

Sir plz

[@ahmadghaffar6213]

@chandoo Sir, Great Video for roadmap to become data analyst. But please do laptop requirements for install all software easily.... Min to maximum

[@Sanatan_shiksha1]

Buy second hand gaming laptop with graphic card you can do anything it will cost only 30-35k

[@ShaileshYadav-yr2mk]

ISRO❤

[@NESW30RAPTI]

sir aapka course very high please low fee

[@abdullahalmahfuz6700]

But you can do Data Analysis by having Julius AI LLM

[@chandoo_]

are you dreaming or working for julius llm as a markerter?

[@abdullahalmahfuz6700]

no, i'm curious about future economy & tech jobs

[@sid828]

​@@chandoo_ bro's is getting paid for it 😂

[@dontbotherme9009]

Bro is definitely getting paid by having Julius AI LLM

[@mohamadafreedpasha8820]

So good but please was I sent a connection to you on LinkedIn kindly request to you, sir.