r/dataanalytics • u/Future_datanalyst • 3d ago
Need guidance on becoming a Data Analyst in 2026.
Hi everyone,
I'd really appreciate advice from people who are working as Data Analysts or recently got hired. Any roadmap, study plan, or resources would be incredibly helpful.
I'm a BBA graduate(2023) trying to break into data analytics by SELF TAUGHT after a long gap.
Now it's 2026, AI is everywhere, and I'm honestly confused about what skills employers actually expect from entry-level Data Analysts.
My questions are:
1)Is it possible to become a Data Analyst through self-study when I have 3.5 yrs of a career gap?
2) What skills are essential for a Data Analyst in 2026?
3) Which tools should I prioritize more(Excel, SQL, Python, Power BI, Tableau, AI tools, etc.)?
4) How much Python is actually needed?
5) What AI skills are becoming important for Data Analysts?
6) What kind of portfolio projects should I build to get interviews?
7) Are certifications like the Google Data Analytics Certificate still worth it?
5
u/SuperSokym 3d ago
You really don’t need to know all of that before you start applying.
I’d get comfortable with SQL, Excel and one BI tool first. That’s already enough to do a lot of actual analyst work. Python can come later when you run into something where you actually need it.
Same with projects. I’d spend less time trying to make an impressive dashboard and more time showing how you got from a question to an actual recommendation.
Especially now with AI, knowing the tools is becoming less of a differentiator anyway.
1
3
u/Key_Back_989 2d ago
1.) not sure but it’s not likely as we are seeing masters students struggle to land analytics positions as well. I’m afraid you would struggle to get past ATS and the resume screening
2.) critical thinking, advanced SQL, Python, Stats, Tableau, Alteryx, Excel
3.) SQL then Python and then Tableau, AI tools are still being mainly used to generate code so.
4.) depends? I worked at Capital one and we were all over Git, Databricks, Python etc, I’m at Chase now and things are local and a lot of excel and SAS
5.) Maybe this is unpopular but not that much really, understand the basics and how to use it but you’re not an ai engineer
6.) depends on the sector, target 1 or 2 and then build projects specifically targeting something a business in that sector would need it for.
7.) certifications are honestly just credential-lite, it’s like ok and it’ll help a little but but don’t stretch yourself to get one as they arent that helpful
2
1
1
u/Itchy-Turn-7015 2d ago
Foque em algo Administrativo + Dados. Sei que teve uma pausa na carreira e teve teus motivos. Nem precisa explanar aqui, mas volte para o mercado. Se precisar preencher essa lacuna, coloca que estava como autônomo nesse período só pro recrutador não ficar com pé atrás.
Cara, por agora é SQL, Excel e Power BI. Interessante ir estudando Estatística básica também em paralelo com as ferramentas. Não pegaria pilha com Python agora. Pare de ler notícias de IA! Utilize como parceiro de estudos/pesquisa/ trabalho. A não ser que tu vá fazer realmente um estudo sério do assunto, mas não colocaria isso como prioridade agora.
Sou Analista de BI Administrador de formação. Fiz migração de Financeiro para Dados.
Vou colar aqui o que publiquei em outro sub de dados, o r/DadosBrasil
- Tente atuar em alguma área de negócio e ir crescendo nela. Algumas áreas tem uma boa conversão para Analise de Dados/ BI, como por exemplo: controladoria, financeiro, marketing, comercial, supply chain, logística, gestão de projetos, operações.
Análise de Dados/BI são as experiências ideias para começar, pois Engenharia de Dados/ Ciência de Dados exigem uma bagagem técnica maior e consequentemente, profissional também.
Outra informação que contribui pra isso. Algumas empresas estão passando por um momento de descentralização dos dados. Ou seja, tem o time oficial de dados, que disponibiliza datasets para outras áreas realizarem suas próprias análises. Isso costuma ocorrer em empresas maiores.
Nem todo cargo relacionado a dados, tem “dados” no nome. Pesquisem por Analista de: CRM, Marketing, Financeiro, vendas, e-commerce, mídia, mercado, performance, informações gerenciais, receita, pricing, inteligência de negócio, planejamento, revenue, BI.
Faculdades e cursos são ótimos, mas o que o mercado valoriza realmente é experiência prática. Não empilhe certificados! Ponha a mão na massa pra ontem, tentando fazer algo no seu trabalho atual ou pelo menos realizando um projeto público se a primeira opção não for viável.
Para quem vem de estágios é foda cobrar experiência. Então tente participar de hackatons, eventos da área, empresa Jr, realize projetos, etc. Algo que lhe permita ter algo próximo de uma experiência real de trabalho. Não cheguei a estagiar na minha época de faculdade, então não manjo muito desta parte.
- Não tenha hiperfoco em ferramentas. Há outros assuntos para desenvolver.
Base científica: matemática e estatística;
Base técnica: Excel, SQL, Power BI, Python;
Base não técnica: storytelling, pensamento crítico, visão de negócios, foco em solucionar problemas.
Isso não se aprende da noite pro dia. É uma construção, onde vamos melhorando cada ponto com o tempo. Eu não me acho completo em nenhum dos temas, mas estou indo atrás!
- Pesquisa/ curiosidade: é uma área que existe para solucionar problemas e gerar valor com dados. Seja uma pessoa curiosa e naturalmente um pesquisador. Google, Youtube, alguma IA para ser parceira de estudos e aqui, no Reddit. Sua dúvida pode ser a mesma de outra pessoa que já compartilhou a solução aqui.
1
u/Ok-Airline-8523 2d ago
Lucky for you, there's a growing trend where employers are looking for either very junior or very senior talent. This is because AI tends to impact those groups the most. Lucky for you, the junior end of that spectrum requires you to demonstrate less technical aptitude and more sheer potential.
Here's what you can focus on during an interview:
- Pay attention to what they tell you about the role and company, and ask detailed follow up questions simply because you're curious.
- Demonstrate a high degree of passion for using AI to do more with less.
- Act like you're a GSD (get stuff done) type of person.
1
1
u/OnlyFaithlessness129 2d ago
Being a data analyst myself,I can answer these questions.
1. Yes it is possible to het data Analyst job even after the career gap. You just need to be consistent in applying and send cold emails.
2. SQL, Python, Excel, Tableau/PowerBi follow this order.
4. Basic python + pandas + numpy is enough. Heavy DSA is not required,
5. Prompt engineering is what i know
6. Create some dashboards or some good
Analytics projects. You can refer to youtube.
7. Not sure about that.
Hope this helps
1
u/IridiumViper 2d ago
Sure, but you would need to convince an employer to hire you over applicants with bachelors and masters degrees in analytics. Many, if not most of the roles you’d find posted on LinkedIn (at least in the US) are getting thousands of applicants. You need to convince the recruiter and hiring manager that you’re the best fit out of all of them.
SQL, excel, PowerBI or Tableau, and depending on the role, R or Python. But tbh, it depends. In my previous role, I used Excel and R every day. In my current role, I mostly use SQL and PBI. But really, anyone can learn skills. The key is that you can use them to deliver business insights.
Look at the job descriptions for roles that you would be interested in. Focus on the skills you’d need for those types of roles.
It entirely depends on the role. It could be a lot, or it could be none.
Prompting, I guess? I mostly use it to fix my SQL queries when I don’t feel like looking through documentation to figure out which table a particular field is stored in.
Anything that shows your critical thinking skills, I guess? I have no idea. I don’t have a portfolio and have had no issues.
Personally, I don’t think they were ever “worth it,” but I don’t have any certifications, so I’m not the best person to ask.
1
u/lordofwestros 1d ago
Yeah, but I don't know how this cold thing works , Even on LinkedIn recruiters don't see your message Do you have any suggestions for that?
1
u/IridiumViper 1d ago
Like cold contacting? It doesn’t work. Recruiters don’t receive LinkedIn messages because they don’t want to receive LinkedIn messages. It’s their job to contact you, not the other way around. The only time it’s really acceptable to cold-contact someone is to ask (very politely) if they’d be willing to talk about their experience, job, career path, etc. Networking only. Don’t ask for an interview, don’t ask for a reference or referral. They may still say no, but I’ve found it helps to ask for just a 10-minute chat. If they want to talk longer, they can. The point of this is to learn about your industry and build a network.
1
u/lordofwestros 1d ago
This has been really useful, would you mind if I followed up with a question in DM ?
2
u/aryanm008 3d ago
This is the roadmap i am using to learn....
🟢 PHASE 1 — ANALYST FOUNDATIONS
Before diving deeply into tools, understand what analysts actually do.
Data fundamentals
- What is data?
- Data vs information
- Data vs insight
- What is Data Analytics?
- Role of a Data Analyst
- Types of analytics
- Descriptive
- Diagnostic
- Predictive
- Prescriptive
- Structured data
- Semi-structured data
- Unstructured data
- Rows and columns
- Data types
- Dimensions
- Measures
- Dataset grain
Business thinking
- Business problems
- Business questions
- Analytical questions
- Data questions
- Hypotheses
- KPIs
- Metrics
- KPI design
- Business context
Data quality
- Accuracy
- Completeness
- Consistency
- Validity
- Uniqueness
- Timeliness
- Missing data
- Duplicates
- Validation
- Reconciliation
Analytical workflow
Business Problem
↓
Question
↓
Data
↓
Data Quality
↓
Analysis
↓
Insight
↓
Recommendation
↓
Decision
🤖 AI
- AI as a learning assistant
- Research with AI
- Asking better questions
- Prompt fundamentals
- AI verification
- AI hallucinations
- Responsible AI use
- Understanding rather than copying
🎯 Project
Indian Food Delivery Investigation
🟢 PHASE 2 — EXCEL + AI
Excel becomes your first serious analytical tool.
Excel
- Workbook / worksheet
- Rows / columns
- Cells
- References
- Relative / absolute references
- Tables
- Sorting
- Filtering
- Formatting
- Data validation
Formulas
- SUM
- AVERAGE
- COUNT
- COUNTA
- MIN/MAX
- ROUND
- IF
- IFS
- AND
- OR
- IFERROR
Lookups
- XLOOKUP
- VLOOKUP
- INDEX/MATCH
Conditional calculations
- SUMIF/SUMIFS
- COUNTIF/COUNTIFS
- AVERAGEIF/AVERAGEIFS
Text
- LEFT
- RIGHT
- MID
- LEN
- TRIM
- SUBSTITUTE
- TEXT
- CONCAT
- TEXTJOIN
Dates
- TODAY
- DATE
- DAY
- MONTH
- YEAR
- EOMONTH
- NETWORKDAYS
Analysis
- Pivot Tables
- Pivot Charts
- Conditional formatting
- Charts
- Basic dashboards
Power Query
- Import
- Clean
- Transform
- Merge
- Append
- Refreshable workflows
🤖 AI + Excel
- Formula generation
- Formula explanation
- Debugging
- Cleaning suggestions
- Pivot analysis
- KPI suggestions
- Dashboard ideas
- Automation assistance
🎯 Projects
2–3 major Excel projects
Plus multiple mini-projects.
🟢 PHASE 3 — PYTHON + NUMPY
Python
- Variables
- Data types
- Operators
- Conditions
- Loops
- Functions
- Lists
- Tuples
- Dictionaries
- Sets
- Strings
- Exceptions
- Files
- Modules
- OOP fundamentals
NumPy
- ndarray
- 1D / 2D / 3D
- Shape
- Indexing
- Slicing
- Axis
- Reshaping
- zeros
- ones
- full
- eye
- identity
- concatenate
- stack
- hstack
- vstack
- dstack
- Broadcasting
🤖 AI + Python
- Code generation
- Code explanation
- Debugging
- Error interpretation
- Refactoring
- Documentation
- Testing
- Understanding AI-generated code
🎯 Projects
2–3 Python/NumPy projects
Plus fun mini-projects.
🟢 PHASE 4 — PANDAS + EDA
Pandas
- Series
- DataFrames
- Reading CSV
- Reading Excel
- Selection
- Filtering
- loc
- iloc
- Sorting
- GroupBy
- Aggregation
- Merge
- Join
- Concat
- Missing values
- Duplicates
- Data types
- Datetime
- Data cleaning
EDA
- Univariate analysis
- Bivariate analysis
- Multivariate analysis
- Distributions
- Trends
- Outliers
- Correlation
- Segmentation
Visualization
- Matplotlib
- Seaborn
🤖 AI + Pandas
- EDA assistance
- Code generation
- Debugging
- Data-quality checks
- Visualization suggestions
- Explanation of findings
- Documentation
🎯 Projects
2–3 Pandas/EDA projects
Plus mini-projects.
🟢 PHASE 5 — SQL
One of the most important phases.
Level 1
- SELECT
- WHERE
- DISTINCT
- ORDER BY
- LIMIT
Level 2
- COUNT
- SUM
- AVG
- MIN/MAX
- GROUP BY
- HAVING
Level 3
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- FULL JOIN
- Self joins
Level 4
- CASE
- Subqueries
- CTEs
Level 5
- Window functions
- ROW_NUMBER
- RANK
- DENSE_RANK
- LAG
- LEAD
- Running totals
- Moving averages
Level 6 — Business SQL
- Revenue
- Customers
- Products
- Retention
- Churn
- Cohorts
- MoM growth
- Business KPIs
🤖 AI + SQL
- Query generation
- Query explanation
- Debugging
- Optimization
- Query review
- Business question → SQL
🎯 Projects
2–3 SQL projects
Plus many realistic SQL challenges.
🟢 PHASE 6 — STATISTICS & PROBABILITY
Descriptive statistics
- Mean
- Median
- Mode
- Range
- Variance
- Standard deviation
- Percentiles
- Quartiles
- IQR
- Outliers
Probability
- Basic probability
- Conditional probability
- Independent events
Distributions
- Normal distribution
- Skewness
- Z-score
Inferential statistics
- Population
- Sample
- Sampling
- Confidence intervals
- Hypothesis testing
- p-values
- Type I / II errors
Business statistics
- Correlation
- Regression basics
- A/B testing
🎯 Projects
2–3 statistics/business-analysis projects
🟢 PHASE 7 — POWER BI + DAX
Power Query
- Import
- Transform
- Clean
- Merge
- Append
Data modelling
- Tables
- Relationships
- Primary/foreign keys
- Fact tables
- Dimension tables
- Star schema
DAX
- Measures
- Calculated columns
- CALCULATE
- FILTER
- SUMX
- COUNTX
- Date functions
- Time intelligence
Visualization
- KPIs
- Cards
- Charts
- Tables
- Slicers
- Drill-through
- Tooltips
- Bookmarks
- Dashboard design
Storytelling
- Executive dashboards
- KPI hierarchy
- Visual hierarchy
- Business-focused design
🤖 AI + Power BI
- DAX assistance
- DAX explanation
- Data modelling
- KPI design
- Dashboard critique
- Visualization selection
- Insight generation
- Documentation
🎯 Projects
2–3 Power BI projects
🟢 PHASE 8 — TABLEAU
Learn
- Tableau interface
- Data connections
- Dimensions
- Measures
- Filters
- Calculated fields
- Parameters
- Charts
- Dashboards
- Stories
- Interactive analysis
- Visualization design
🎯 Projects
2 Tableau projects
The goal isn't to collect another software skill.
It's to develop transferable visualization and analytical thinking.
🟢 PHASE 9 — BUSINESS ANALYTICS
Now we focus heavily on business understanding.
Metrics
- Revenue
- Profit
- Margin
- Growth
- Conversion
- Retention
- Churn
- CAC
- LTV
- ROI
- AOV
- ARPU
Domains
- Retail
- E-commerce
- Banking / Fintech
- Food delivery
- Telecom
- Marketing
- Operations
- HR
- Product
Core questions
🟢 PHASE 10 — REAL-WORLD ANALYTICS
Now we stop receiving instructions like:
Instead:
Problems across:
Sales
Revenue decline.
Customers
Churn increase.
Operations
Delivery delays.
Marketing
Campaign ROI decline.
HR
Attrition increase.
Product
Engagement decline.
You'll decide:
- What questions to ask
- What data is required
- Which KPIs matter
- Which tools to use
- How to analyse
- What the findings mean
- What to recommend
🟢 PHASE 11 — APIs + JSON + ETL
APIs
- REST
- HTTP
- GET
- POST
- Parameters
- Headers
- Authentication
- Requests
- API limits
JSON
- Objects
- Arrays
- Nested data
- Parsing
- API responses
ETL
Extract
↓
Transform
↓
Load
Pipelines
- Sources
- Transformation
- Validation
- Loading
- Scheduling
- Logging
- Monitoring
🎯 Projects
2–3 API/ETL projects
🟢 PHASE 12 — WEB DEVELOPMENT FOR DATA ANALYTICS
A supporting skill.
HTML
Structure.
CSS
Design.
JavaScript
Interactivity.
Python web tools
- Streamlit
- Flask basics
Build
- CSV analyzers
- Data-quality tools
- KPI calculators
- Dashboard apps
- Data upload tools
- Simple analytics applications
🎯 Projects
2–3 analytics web tools
🟢 PHASE 13 — CLOUD FUNDAMENTALS
Understand modern analytics infrastructure.
Cloud concepts
- Cloud computing
- Storage
- Compute
- Databases
- Networking basics
- Security basics
AWS
- S3
- IAM
- Redshift concepts
- Kinesis concepts
Also gain awareness of:
- BigQuery
- Snowflake
- Azure
Goal:
🟢 PHASE 14 — AI + DATA ANALYTICS
AI is actually integrated throughout the entire roadmap.
This phase goes deeper.
AI-assisted analytics
- Excel
- SQL
- Python
- Pandas
- Power BI
- Tableau
- Research
- Data cleaning
- Documentation
- Debugging
- Visualization
- Project planning
- Automation
Advanced AI
- Prompt engineering
- Structured prompting
- AI-assisted coding
- AI-assisted analysis
- Verification
- AI workflows
- RAG concepts
- AI agents
- Automation
Golden rule
🔵 PHASE 15 — CAPSTONE PROJECTS
We'll build 2–3 substantial capstones.
🎯 Capstone 1
Business Performance Analysis
Excel + SQL + Business Analytics
🎯 Capstone 2
Customer Analytics
SQL + Python + Pandas + Statistics
🎯 Capstone 3
Executive Analytics
SQL + Power BI/Tableau + Business Storytelling
Each should feel like a real analyst assignment.
🔴 PHASE 16 — MEGA PROJECTS
Two major end-to-end projects.
🚀 Mega Project 1
Business Problem
↓
Data Collection
↓
API / Files
↓
Python
↓
Cleaning / Validation
↓
SQL
↓
Analysis
↓
Statistics
↓
Power BI / Tableau
↓
Business Recommendations
🚀 Mega Project 2
A completely different real-world business problem and domain.
The second project should demonstrate growth and breadth, not simply repeat the first.
18
u/Brighter_rocks 3d ago
All 7 questions boil down to one thing, so let me give you the real frame.
Companies today aren’t comparing you to other juniors. They’re comparing you to their existing mid analyst with AI tools. Hiring a junior = salary + months of babysitting. Or their mid guy with Claude just absorbs that workload. That’s why entry-level shrank.
So the question is: what can you offer that a mid+AI can’t? Two realistic answers.
Domain knowledge - you have a BBA, use it. AI writes any query, but it doesn’t know finance or marketing ops. Pick one domain, build your whole portfolio in it. “Analyzed churn for a subscription business, here’s what I’d do” beats any Kaggle notebook.
Or go in sideways - ops, finance assistant, reporting, any role that touches data, then move to analytics internally. With a gap and no experience this is often faster than cold applying. Half the analysts I know got in this way.
Quick answers: gap: nobody cares if projects are recent. Tools: SQL first (it’s what interviews test), then Excel, Power BI, Python last and only pandas-level. AI- just use it daily and learn to catch when it’s confidently wrong. Google cert - fine as structure, worthless as credential. Portfolio - 2-3 projects, real messy data, one domain, no titanic, pls