Career profile
Data Analyst
Turn raw business data into clear answers and decisions.
Typical career progression
- 1Junior Data Analyst
- 2Data Analyst
- 3Senior Data Analyst
- 4Analytics Lead / Manager
Titles and timelines vary by company, location and individual experience.
What a Data Analyst does
Data Analysts collect, clean and analyse data to answer business questions. They build reports and dashboards, track KPIs and explain what the numbers mean so teams can act on them.
Day-to-day responsibilities
- 01Gather and clean data from spreadsheets, databases and business systems
- 02Write SQL queries to extract and aggregate the data a team needs
- 03Build and maintain dashboards and recurring reports
- 04Track KPIs and flag unusual trends early
- 05Run ad-hoc analysis to answer stakeholder questions
- 06Present findings clearly with charts and short narratives
Learning roadmap
Stage 1
Excel
- Formulas
- Pivot tables
- Charts
Stage 2
SQL
- Joins
- Aggregations
- Window functions
Stage 3
Python
- Pandas
- EDA
- Visualization
Stage 4
Power BI
- Dashboards
- DAX
- Data modelling
Stage 5
Business Insights
- KPIs
- Storytelling
- Reporting