Uploaded March 2024 | Updated November 2026, 1 day ago
π₯ Best Excel Course for Data Analysts - chandoo.org/wp/excel-school-program
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 - youtu.be/x0Cd4TTOgwI
π Day in the life of a Data Analyst - youtu.be/Lc55Y7Ai23Q
π€ Data Analyst Interview Questions - youtu.be/MX6Ee_ubE1s
1οΈβ£ ON EXCEL -
Excel basics - youtu.be/F7aPazuS8QY
Excel Beginner to PRO Data Analysis course - youtu.be/v2oNWja7M2E
Full Excel course - chandoo.org/wp/excel-school-program
2οΈβ£ ON SQL -
SQL basics - youtu.be/yfWcZ6eot4g
SQL Beginner to PRO Data Analysis course - youtu.be/l8DCPaHc5TQ
3οΈβ£ ON BI PLATFORMS -
Learn Power BI in 10 mins - youtu.be/9tF1IrfLflg
Learn Tableau in 10 mins - youtu.be/tNLp_JVipoQ
Full Power BI Course - chandoo.org/wp/power-bi-course
4οΈβ£ ON STATISTICS -
Mean, median and mode explained - youtu.be/LsQKzcu74Mg
How to calculate Z-scores - youtu.be/Ozr44eL-MPg
More on stats in my Excel course - chandoo.org/wp/excel-school-program
5οΈβ£ ON CODING -
Do Data Analysts need coding skills - youtu.be/xIvb8a_-sGg
Python for beginners (masterclass) - youtu.be/uoC48wrJ-yM
VBA for beginners - youtu.be/5k-KpSkrROw
Full VBA Course - chandoo.org/wp/vba-classes
6οΈβ£ ON BUSINESS APPS -
How to use Power Query - youtu.be/UAFExySaSPY
7οΈβ£ ON AI TOOLS -
How to use ChatGPT with Excel - youtu.be/mp18miYmmJY
Top AI features in Excel - youtu.be/xGqH__hLVcU
How to use Copilot in Excel - youtu.be/z_cZ9HZbNrQ
~
ALL THE BEST π
#roadmap #dataanalyst
π₯ Best Excel Course for Data Analysts - chandoo.org/wp/excel-school-program
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 - youtu.be/x0Cd4TTOgwI
π Day in the life of a Data Analyst - youtu.be/Lc55Y7Ai23Q
π€ Data Analyst Interview Questions - youtu.be/MX6Ee_ubE1s
1οΈβ£ ON EXCEL -
Excel basics - youtu.be/F7aPazuS8QY
Excel Beginner to PRO Data Analysis course - youtu.be/v2oNWja7M2E
Full Excel course - chandoo.org/wp/excel-school-program
2οΈβ£ ON SQL -
SQL basics - youtu.be/yfWcZ6eot4g
SQL Beginner to PRO Data Analysis course - youtu.be/l8DCPaHc5TQ
3οΈβ£ ON BI PLATFORMS -
Learn Power BI in 10 mins - youtu.be/9tF1IrfLflg
Learn Tableau in 10 mins - youtu.be/tNLp_JVipoQ
Full Power BI Course - chandoo.org/wp/power-bi-course
4οΈβ£ ON STATISTICS -
Mean, median and mode explained - youtu.be/LsQKzcu74Mg
How to calculate Z-scores - youtu.be/Ozr44eL-MPg
More on stats in my Excel course - chandoo.org/wp/excel-school-program
5οΈβ£ ON CODING -
Do Data Analysts need coding skills - youtu.be/xIvb8a_-sGg
Python for beginners (masterclass) - youtu.be/uoC48wrJ-yM
VBA for beginners - youtu.be/5k-KpSkrROw
Full VBA Course - chandoo.org/wp/vba-classes
6οΈβ£ ON BUSINESS APPS -
How to use Power Query - youtu.be/UAFExySaSPY
7οΈβ£ ON AI TOOLS -
How to use ChatGPT with Excel - youtu.be/mp18miYmmJY
Top AI features in Excel - youtu.be/xGqH__hLVcU
How to use Copilot in Excel - youtu.be/z_cZ9HZbNrQ
~
ALL THE BEST π
#roadmap #dataanalyst










