Data Analyst from Zero

Turn messy spreadsheets into answers a business acts on.

Start with Excel for Data Analytics - Full Course for Beginners (660 min, Luke Barousse), then Excel Tutorial for Beginners (16 min, Kevin Stratvert). All 40 lessons in Data Analyst from Zero are free. No degree. A laptop; Google's certificate is optional. A starter kit costs about $270. Data roles grow about 34% this decade (BLS); entry jobs often start near $60k.

To start: No degree. A laptop; Google's certificate is optional. Earning: Data roles grow about 34% this decade (BLS); entry jobs often start near $60k.

1. Excel and spreadsheets

   Formulas, lookups and pivot tables.

   • Excel for Data Analytics - Full Course for Beginners (660 min, Luke Barousse, Beginner)
   • Excel Tutorial for Beginners (16 min, Kevin Stratvert, Beginner)
   • Python in Excel Tutorial for Beginners (=PY, pandas, Charts) (19 min, Leila Gharani, Beginner)
   • Excel Tutorial for Beginners | How to Use Excel (16 min, Leila Gharani, Beginner)
   • Excel Basics 1: Introduction To Excel 1: Formatting, Formulas, Cell References, Page Setup (63 min, ExcelIsFun, Beginner)
   • How to use Microsoft Access - Beginner Tutorial (31 min, Kevin Stratvert, Beginner)

2. SQL

   Ask a database questions.

   • SQL Course for Beginners [Full Course] (190 min, Programming with Mosh, Beginner)
   • you need to learn SQL RIGHT NOW!! (SQL Tutorial for Beginners) (24 min, NetworkChuck, Beginner)
   • MySQL - The Basics // Learn SQL in 23 Easy Steps (17 min, Fireship, Beginner)
   • SQL Full Course for free 🐬 (180 min, Bro Code, Intermediate)
   • SQL for Data Analytics - Learn SQL in 4 Hours (249 min, Luke Barousse, Intermediate)
   • How I use SQL as a Data Analyst (16 min, Luke Barousse, Intermediate)

3. Dashboards that people read

   Power BI or Tableau, and charts that make a point.

   • Power BI for Data Analytics - Full Course for Beginners (505 min, Luke Barousse, Beginner)
   • Power BI from ZERO to Your First Dashboard (in 20 Minutes) (23 min, Leila Gharani, Beginner)
   • How to use Microsoft Power BI - Tutorial for Beginners (28 min, Kevin Stratvert, Beginner)
   • End to End Data Analytics Project | Power BI Project | Hospitality Domain (97 min, codebasics, Intermediate)
   • Learn Power BI in Under 3 Hours | Formatting, Visualizations, Dashboards + Full Project (125 min, Alex The Analyst, Intermediate)
   • 10 Power BI Tips for Better Dashboards | Are you using these in your Power BI reports? (13 min, Leila Gharani, Intermediate)

4. Python for analysis

   Pandas for the jobs spreadsheets cannot do.

   • Python for Beginners - Learn Coding with Python in 1 Hour (60 min, Programming with Mosh, Beginner)
   • Python Full Course for Beginners (122 min, Programming with Mosh, Beginner)
   • Python Full Course for free 🐍 (720 min, Bro Code, Intermediate)
   • How to Become a Data Analyst in 2023 (Completely FREE!) (14 min, Alex The Analyst, Intermediate)
   • Become a DATA ANALYST with NO degree?!? The Google Data Analytics Professional Certificate (12 min, Luke Barousse, Intermediate)
   • Data Science Roadmap 2024 | Data Science Weekly Study Plan | Free Resources to Become Data Scientist (29 min, codebasics, Intermediate)

5. Your portfolio

   Three projects that get interviews.

   • Data Analyst Roadmap 2023 | Learn data analytics skills in 3 months (26 min, codebasics, Intermediate)
   • Google vs IBM Data Analyst Certificate - BEST Certificate for Data Analysts (10 min, Luke Barousse, Intermediate)
   • Top Courses to Become a Data Analyst (14 min, Luke Barousse, Intermediate)
   • Data Analyst Roadmap 2024 | Data Analyst Weekly Study Plan | Free Resources to Become Data Analyst (29 min, codebasics, Intermediate)
   • How I Would Become a Data Analyst if I had to Start Over in 2024 | 6 Month Plan (11 min, Alex The Analyst, Intermediate)
   • How I Would Learn Data Science (If I Had to Start Over) (9 min, Ken Jee, Intermediate)

6. Get hired

   A CV that gets read, interviews you are ready for, and the first offer negotiated.

   • Career Change to Code - The Complete Guide [Full Course for Aspiring Developers] (203 min, freeCodeCamp.org, Beginner)
   • If Your Job Interviewer Asks You THIS, BEWARE! (11 min, A Life After Layoff, Intermediate)
   • Write an Incredible Resume: 5 Golden Rules! (9 min, Jeff Su, Intermediate)
   • Can't Get A Job? You May Be On The "Do Not Hire" List! (18 min, A Life After Layoff, Intermediate)
   • Top 5 LinkedIn Profile Tips! (10 min, Jeff Su, Intermediate)
   • A Job Recruiter Critiques 5 Real Audience Resumes (23 min, The Financial Diet, Intermediate)

7. Money basics for your first pay

   Budget it, save it, and start investing early.

   • Investing 101 (20 min, Ben Felix, Beginner)
   • Using Your Money To Be Happier (21 min, Ben Felix, Intermediate)
   • 5 Things You Need To Do If You Make Less Than $100k (21 min, The Financial Diet, Intermediate)
   • 9 Things To Stop Spending On By 30 (26 min, The Financial Diet, Intermediate)