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

Подписаться 613 тыс.

Просмотров 48 тыс.

50% 1

💥 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 👍

Наука

Опубликовано:

13 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 106

@nursing_questions-nu6fy 3 месяца назад

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

@MohamedSahith87 2 месяца назад

Time saver thank you 👍

@abuzainah1545 18 дней назад

Yes, thank you for summarising.

@thegryffindor1112 18 дней назад

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?

@SothearithKONGMrMuyKhmer 3 месяца назад

Thank you for sharing this helpful information! 🥰

@vitoc.1535 3 месяца назад

Excellent video appreciate your insights!

@azamqaim1 3 месяца назад

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

@explorerunknown1126 3 месяца назад

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 3 месяца назад

Awesome video chandoo, your videos are the best!!

@life_is_great. 3 месяца назад

Thank you for a clear guidance.

@waqasakbar9136 3 месяца назад

Thanks Chandoo. I always found your videos very informative.

@abhilashn2993 2 месяца назад

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

@consultpunit 3 месяца назад

Thanks @Chandoo for this info. Really very helpful!

@chandoo_ 3 месяца назад

My pleasure!

@arbazahmad7177 3 месяца назад

Really helpful... thanks a lot...

@aniljain3725 3 месяца назад

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

@tariqmahmood9278 3 месяца назад

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

@soumyajeetmitra6958 3 месяца назад

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

@Kiranmai30 3 месяца назад

Very much helpful chandoo

@fahimreza2009 21 день назад

wonderful- highly effective

@mahfuzaakhter2452 3 месяца назад

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

@chandrasekar7276 3 месяца назад

Perfectly said 💥❤

@gamechangerrock8403 3 месяца назад

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.

@sonudamale 2 месяца назад

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

@venugopal7161 3 месяца назад

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

@INDYEAH 3 месяца назад

Spot On, Nothing More Nothing Less ..

@aahsankhan4502 3 месяца назад

Sir, Eagerly waiting for your video❤😊

@Sai_Rajzz 3 месяца назад

Thanks a lot sir ❤

@ankit_vlog2347 3 месяца назад

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 2 месяца назад

great video, can you give us more about data modeling

@el-sayedgamal 3 месяца назад

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

@juanignaciolarrouyet3715 20 минут назад

Hi, are you going to make a looker studio tutorial at some point? Thanks :)

@zooni43 3 месяца назад

Awesome and comprehensive as always.

@vivekrao514 3 месяца назад

Sir can you make video on SAP FICo

@hamidrezaakbari7611 3 месяца назад

that's great 😍

@RahulBhatia-py1iv 12 дней назад

Data analyst vs business analyst which one should pursue

@hrutikaparkar4997 4 дня назад

Hi, can you please suggest some videos or websites to learn Business math and Statistics? Thank you.

@user-hz7xh6xl7f 3 месяца назад

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?

@mokumdrie4096 3 месяца назад

a good round-up of the MS eco system 😆

@mehernesa_kazi 2 месяца назад

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.

@chrism9037 3 месяца назад

Great break down of the needed skills, thanks Chandoo

@Akshay-if5im 3 месяца назад

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

@lil3thc 3 месяца назад

these are what i want to learn

@aunali3651 3 месяца назад

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

@remembernaveen30 3 месяца назад

Thank You guru ji

@peterkasonge7751 3 месяца назад

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?

@abhideeproy4479 3 месяца назад

Please prepare few more videos on power bi

@sirajuddinsafirshaikh4680 3 месяца назад

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

@srinathp4486 22 дня назад

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

@magicworldbyjorg 3 месяца назад

@sandavenimadhukaryadav417 Месяц назад

Thanks

@chandoo_ Месяц назад

Welcome

@sanjana3538 3 месяца назад

Hi chandoo can u please do videos on R language

@UdaiKs 3 месяца назад

What about Google Data Studio now Looker.

@arpankumar4487 3 месяца назад

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

@kedarpande 3 месяца назад

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?

@ramyasubramanian1218 3 месяца назад

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

@srinivasbusam 3 месяца назад

Hi good evening , will you do freelance as well ?

@HemanthKumar-id1vs 3 месяца назад

Do u have any videos to learn M query ?

@Kleber_Moreira 3 месяца назад

Perfect. Thanks for all

@vinodkanna2566 3 месяца назад

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.

@abhishekyadav2041 2 месяца назад

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 3 месяца назад

Upvoted for the ISRO T-Shirt

@jsaispandana5924 3 месяца назад

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

@Pavani_Saikumar Месяц назад

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

@knowledgedoctor3849 3 месяца назад

Hi Bro, Here is Another Chando From Knowledge Doctor 🌻

@sabeelahmed1157 3 месяца назад

Office script also required for Data Analyst?

@LOFI_WORLD_SONG 3 месяца назад

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

@rudi-gruber 3 месяца назад

I agree 100% - perfect summary

@growanglow7115 3 месяца назад

Your all videos awesome ❤

@eaansari-1792 2 месяца назад

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.

@savithrisravanthalabathula1329 3 месяца назад

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

@savithrisravanthalabathula1329 3 месяца назад

Which AI tools??

@savithrisravanthalabathula1329 3 месяца назад

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

@chandoo_ 3 месяца назад

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

@thegamingraj1869 3 месяца назад

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

@udithakarandana7565 3 месяца назад

❤

@Kavin.26 3 месяца назад

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 2 месяца назад

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 3 месяца назад

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_ 3 месяца назад

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 3 месяца назад

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

@vandanapatil8182 3 месяца назад

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 3 месяца назад

❤❤❤

@nurnabi4897 3 месяца назад

Sir plz

@91harshjain 3 месяца назад

Perfect framework.

@user-ye6xj4oq8e 3 месяца назад

🟡🟡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_ 3 месяца назад

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 3 месяца назад

@@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_ 3 месяца назад

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

@nurnabi4897 3 месяца назад

Can we wait for your full data analyst course?

@chandoo_ 3 месяца назад

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 3 месяца назад

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