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

💥 Best Excel Course for Data Analysts - https://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 to Learn Advanc...  
📆 Day in the life of a Data Analyst -    • A day in the life of a data analyst i...  
🎤 Data Analyst Interview Questions -    • Top 10 Data Analyst Interview Questio...  


1️⃣ ON EXCEL -

Excel basics -    • How to use Microsoft Excel - Beginner...  
Excel Beginner to PRO Data Analysis course -    • Beginner to Pro FREE Excel Data Analy...  
Full Excel course - https://chandoo.org/wp/excel-school-p...

2️⃣ ON SQL -

SQL basics -    • SQL Basics for people with no prior k...  
SQL Beginner to PRO Data Analysis course -    • Learn SQL for Data Analysis in one ho...  

3️⃣ ON BI PLATFORMS -

Learn Power BI in 10 mins -    • Your first 10 minutes of Power BI - A...  
Learn Tableau in 10 mins -    • Learn Tableau in 15 minutes and creat...  
Full Power BI Course - https://chandoo.org/wp/power-bi-course/


4️⃣ ON STATISTICS -

Mean, median and mode explained -    • KNOW the difference between AVERAGE /...  
How to calculate Z-scores -    • How to find Outliers in Your Data Eas...  
More on stats in my Excel course - https://chandoo.org/wp/excel-school-p...

5️⃣ ON CODING -

Do Data Analysts need coding skills -    • Do you need "CODING SKILLS" for Data ...  
Python for beginners (masterclass) -    • How to code with Python - Beginner to...  
VBA for beginners -    • Learn VBA & Excel Macros in 20 minute...  
Full VBA Course - https://chandoo.org/wp/vba-classes/

6️⃣ ON BUSINESS APPS -

How to use Power Query -    • Learn Power Query & Automate Boring D...  

7️⃣ ON AI TOOLS -
How to use ChatGPT with Excel -    • DON'T tell my boss, but ChatGPT made ...  
Top AI features in Excel -    • 10x your productivity with these AI t...  
How to use Copilot in Excel -    • Honest review of Excel CoPilot - What...  

~

ALL THE BEST 👍