Published On Mar 4, 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 👍