Skip to content

DataNotesCareers

How to Become Data Analyst in 2026 (Zero To Lead)

Baraa Khatib Salkini7 min read

Subscribe to DataNotes

Join 213,000+ curious readers.

Subscribe takes you to Substack to confirm, and you can unsubscribe anytime (privacy policy).

Subscribe to DataNotes

Subscribe takes you to Substack to confirm, and you can unsubscribe anytime (privacy policy).

In this issue7 min left

Hey friends!👋

I was looking at a bunch of “data analyst roadmaps” the other day, and I noticed something. Most of them are super tool-based. They basically say: learn SQL, Excel, Power BI, Python… and that’s it.

But tools are only one piece of the job. The bigger skill is learning how to think like an analyst: how to break down messy questions, understand the business, and turn data into decisions.

So I built my own roadmap. I’ll take you slowly through every phase, starting from total beginner, all the way to getting hired, then what to focus on after you get the job, and how to grow into senior and lead roles.

This roadmap is based on my 17 years working in real data teams, and what companies actually expect in the market today.

Here are the resources 👇

  • I explained the full roadmap step by step in this video
  • And I shared the Notion template with all phases, resources, and a clear step by step guide
How I’d Become Data Analyst in 2026 From Zero to Lead (Built by Expert)26 min

1. The Hiring Journey

This journey is about building the right skills to get you ready for your first data analyst role.

Phase 0 Absolute Beginner

This phase is about understanding what data analytics really is and deciding whether this career is right for you.

Mindset: Mindset: Is data analytics the right career for me?

Just spend like few days reading watching about it and make then decision

  • Understand the Role: You clearly understand what a data analyst actually does before investing time and effort.
  • Check 10 Job Posting: Scan job postings to see what companies actually ask for and to align your learning with the market.
  • Make Decision: Decide if data engineering is the right long-term career for you.

Remember: Ask yourself: “Would I enjoy this work every week?” Be honest with yourself. This phase saves you years later.

Phase 1 Core Technical Skills

This phase is about getting you ready by focusing on core skills one by one, so working with data and code starts to feel natural before you even think about data engineering.

Mindset: I can work with Data

How to Learn: Learn Theory, Basics and Deep dive into Advanced Topics, Do Projects

  • Data & Analytics Terminology: Learn core terms like metrics, KPIs, BI, and data quality.
  • SQL: Explore, clean, and join data to answer real business questions.
  • EDA Project: Analyze a real dataset to find patterns, trends, and issues.
  • Power BI / Tableau: Build dashboards that clearly communicate insights.
  • Dashboard Project: Create an end-to-end dashboard using real data to show your skills.

Remember: Practice more than you consume content

  • Learn one skill at a time
  • Focus on understanding, not memorizing, Always ask “why” before “how”
  • Use AI only to explain concepts, not to write code for you

Phase 2 Data Analytics Skills

This phase is about how analysts think, not which tools they use. You move beyond writing queries and dashboards and start focusing on reasoning, interpretation, and decision-making.

Mindset: I can think like an analyst!

How to Learn: Just read about it no need to deep dive

  • Statistics: Understand distributions, variability, and relationships. Focus on meaning, not formulas.
  • Communication (Storytelling): Turn analysis into clear insights non-technical people understand.
  • Analytical Thinking and Problem Solving: Break vague questions into measurable problems and challenge assumptions.
  • Data Modeling and Metrics Design: Build meaningful metrics that reflect real business logic, not vanity numbers.

Remember: Clear thinking beats fancy dashboards

  • Your main task is to answer business questions, not only to write queries or build charts
  • You work with non-technical people, so clarity matters more than complexity
  • Numbers are useless without context, assumptions, and impact

Phase 3 Stand Out Go Beyond the Basics

This phase is about differentiation, not requirements. You already have what you need to get hired. These skills help you stand out, work faster, and handle more complex data, but they are not required for a data analyst role.

Mindset: I add extra value without losing sight of the core role.

How to Learn it: Learn the core concepts first, then practice only the basics. Avoid deep dives. Depth comes later on the job.

🛑Important Note: These are large topics. Do not get lost in tools or delay job applications. This phase is optional and exists only to help you stand out, not to block your progress.

  • Python (Pandas, Numpy, Plotly): Use Python to explore data and automate repetitive work.
  • Databricks For Data Analytics: Learn how analysts explore large datasets on modern platforms.
  • AI Prompt Engineering: Use AI to speed up analysis, SQL, and documentation.
  • AI Models (High-Level): Understand what AI models do, their limits, and how analysts use them.

Phase 4 Prepare & Get Hired

At this point, you won’t know 100% of data engineering, and that’s completely normal. The good news is you already have around 70% of the skills needed to start applying. There’s no reason to wait anymore. Now it’s time to prepare yourself, put your profile together, and start applying for jobs.

Mindset: I am ready to enter the market!

  • Get Certified: Validate skills with relevant certifications. You increase trust and visibility in the market.
  • Build Clean Resume: Present skills and projects clearly. Recruiters quickly understand your value.
  • Optimize LinkedIn Profile: Make your profile searchable and attractive. Recruiters can find and contact you.
  • Build Portfolio: Showcase real projects publicly. You stand out beyond certificates and courses.
  • Start Applying for Jobs: Apply consistently and interview actively. You gain interview experience and land offers.
  • Improve & Learn: Fix gaps while applying and interviewing. You continuously improve until you get hired.

Remember: You don’t need 100% to start applying.

  • Apply before you feel fully ready
  • Rejections are part of the process
  • Treat interviews as learning sessions
  • Focus on explaining, not impressing
  • Keep improving while applying
  • Do not compare yourself to seniors

End of The Hiring Journey

If you got a job, congratulations. I’m really proud of you and happy for you.

From here, I’ll guide you on how to grow as a data analyst and build real experience on the job.

If you’re still searching, don’t worry. You will get one. Just keep pushing.

In the meantime, you can already start looking at the next skills, and if you have time, pick a few to strengthen your profile while you keep applying.

2. The Growth Journey

This journey is about what happens after you get hired: learning on the job, making mistakes, and growing into a strong data analyst.

Phase 5 Junior Data Analyst

At this stage, you are officially working as a data analyst, but you will not know everything and that is completely normal. Most of your real learning happens on the job. You will ask questions, make mistakes, fix them, and slowly start connecting the dots.

Mindset: I am learning by doing

  • Understand the business and stakeholders: Understand how the company makes money and who uses your work.
  • Explore and Understand Data (EDA): Explore data, ask questions, and build intuition.
  • Build Domain Knowledge: Learn the business domain to add context to your analysis
  • Maintain and Improve Existing Reports: Maintain existing reports and improve clarity and metrics.

Remember: Making mistakes is part of the job.

  • Ask questions early
  • Focus on reliability over clever solutions
  • Quality is always better than speed
  • Learn company data and business context
  • Take feedback seriously, not personally

Phase 6 Senior/Lead Data Analyst

At this stage, you are no longer just executing tasks. You are trusted with complex business problems, ambiguous questions, and high-impact decisions. You influence stakeholders, shape metrics, and guide others.

A senior or lead data analyst focuses less on producing reports and more on driving clarity, alignment, and decisions across the business.

Mindset: I take ownership of complex problems and help others see the full picture.

  • Mentor Juniors: Review work, give clear feedback, and help juniors improve their thinking.
  • Impact Thinking: Move from “what was asked” to “what really matters.” Prioritize work based on impact, not volume.
  • Improve data quality and governance: Ensure trusted, consistent metrics across teams.
  • Advanced Data Modeling: Build scalable metrics for long-term decisions.
  • System-Level Analytics Architecture: Understand how data flows across analytics systems.

Remember: Delegate simple tasks and focus on complex, high-impact problems.

  • Let juniors handle repetitive analysis and reporting
  • Own the hardest business questions
  • Review work to raise the overall analytics quality
  • Balance insight quality, speed, and trust
  • Help stakeholders make better decisions, not just faster ones

So my friends,

You can start this path with no degree and no prior experience. I have seen it happen many times. The roadmap is simple. Learn the core skills, build real projects, create proof of your work, and keep improving while you apply. It takes time and patience, but it works.

If you want a clear structure to follow, you can use the full Notion Data Engineering Roadmap hereIt includes all phases, resources, and guidance to help you move step by step.

Thank you for taking the time to read this. I hope it brought you clarity and helped you feel more confident about your next move.

Have a wonderful day❤️

Baraa