Рет қаралды 43,507
💥 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 - • Watch this before usin...
~
ALL THE BEST 👍