Career Roadmap

1. 1

   Student

   Pick a direction and understand the role.

   • Read 10 data analyst job posts and list repeated skills
   • Talk to one working analyst
2. 2

   Foundation

   Learn the core skills employers screen for.

   • Spreadsheets: lookups, pivots, charts
   • SQL: joins, group by, window functions
   • Basic statistics
3. 3

   Projects

   Build proof you can show.

   • Dashboard on a public dataset
   • SQL analysis with a written summary
   • Python cleaning notebook
4. 4

   Internship

   Get real-world experience.

   • Apply to 20+ targeted roles
   • Track applications in a sheet
5. 5

   Portfolio

   Make your work easy to find and judge.

   • GitHub with READMEs for each project
   • One-page resume with measurable results
6. 6

   Interview

   Prepare for how you'll be tested.

   • Timed SQL practice
   • Case: 'How would you measure X?'
   • Two-minute project walkthrough
7. 7

   Job

   Land the role and keep growing.

   • Compare offers on learning, not just pay
   • Keep a brag document from day one

Want the details? Read the full data analyst roadmap.