Becoming a data analyst in 2023 can be hard, time consuming, stressful. You’re unsure where to start, what to learn and what looks good on your resume. So this is how I would learn data analysis in 2023, if I could start over.
Resources Mentioned
Khan Academy's Intro to SQL: www.khanacademy.org/computing...
SQLBolt - Interactive Tutorial: sqlbolt.com/
Mode Analytics - Practice SQL: app.mode.com/
Udacity’s Intro to Python Course: www.udacity.com/course/introd...
Learn python the hard way by Zed Shaw: (Google)
freeCodeCamp - Introduction to Data Analysis: www.freecodecamp.org/learn/da...
Tableau Free Training Videos: www.tableau.com/learn/trainin...
Udacity’s Data Visualization in Tableau: www.udacity.com/course/data-v...
Tableau’s Sample Workbooks: www.tableau.com/trial/tableau...
Tableau’s Makeover Monday: www.makeovermonday.co.uk/
Links Mentioned
Kaggle for Datasets: www.kaggle.com/
Stackoverflow for Questions: stackoverflow.com/
Github to host code: github.com/
⌚️Timestamps:Timestamps:
0:00 Introduction
0:21 Soft Skills Needed
1:04 Overview of Technical Skills
1:21 Learning SQL
1:52 Khan Academy’s Intro to SQL
2:06 SQL Bolt Interactive Tutorial
2:38 Mode Analytics to Practice SQL
3:10 Learning Python
3:52 Udacity’s Intro to Python
4:11 Learn Python the Hard Way
4:25 Data Analytics Libraries in Python
4:35 Numpy Library
4:48 Pandas Library
4:59 MatPlotLib Library
5:35 Stackoverflow for Answers
5:53 Using Tableau
6:47 Tableau’s Free Training Videos
7:00 Udacity’s Intro to Tableau
7:23 Tableau Sample Workbook
7:37 Setting up a Portfolio
8:08 Project 1 Analyze Airbnb Listings
8:49 Project 2 Analyze Sales Data
9:23 Using Github to host code
9:31 Showcasing your projects online