How to Become a Data Analyst
Turn raw numbers into business decisions. No degree required.
Overview
Data analysts sit at the intersection of numbers and decisions. Your core job is to take raw, messy data from spreadsheets, databases, and business systems, and turn it into clear insights that help managers and executives act. Every company that has customers, inventory, or finances generates data, which is why demand for analysts consistently outpaces supply across finance, healthcare, retail, logistics, and tech.
The good news is that the analyst learning path is one of the most accessible in tech. You do not need a computer science degree. The tools (Excel, SQL, Power BI, and Python) are all learnable through free courses, and the portfolio projects you will build along the way are concrete enough to demonstrate your skills to any hiring manager.
Roles You Can Get
Skills You Will Build
Technical Skills
- Microsoft Excel (VLOOKUP, pivot tables, macros)
- SQL (queries, joins, aggregations)
- Power BI (dashboards, DAX basics)
- Python (pandas, data cleaning)
- Data visualisation
- Database concepts & normalisation
Soft Skills
- Attention to detail
- Structured problem-solving
- Clear written communication
- Stakeholder presentation
The Roadmap
Master the Spreadsheet Foundation
4–6 weeksExcel is the lingua franca of data analysis. Before touching SQL or Python, you need to be genuinely fast and confident in a spreadsheet. Employers test Excel skills in almost every entry-level analyst interview: VLOOKUP, IF statements, pivot tables, and basic charting are non-negotiable. Pair this with an introduction to how databases work so you understand why SQL exists and what problem it solves.
Stage milestone: You can clean, analyse, and present data in Excel. You understand the difference between flat files and relational databases.
Learn SQL: The Language of Data
6–8 weeksSQL is the single most important technical skill for a data analyst. Almost every analyst role requires you to query a database directly, whether that's pulling a sales report, joining customer tables, or filtering records by date. This stage takes you from understanding database concepts to writing real queries using T-SQL and SQL Server, the flavour used most widely in corporate environments.
Databases - DML Statements and SQL Server Administration
Stage milestone: You can write SELECT, JOIN, GROUP BY, and WHERE queries to extract and aggregate data from multi-table databases.
Build Dashboards with Power BI
4–5 weeksKnowing the numbers is only half the job. The other half is communicating them. Power BI is the most in-demand business intelligence tool in corporate South Africa and globally. After this stage you will be able to connect Power BI to a data source, transform raw data, and build the kind of interactive dashboards that companies use in boardroom presentations.
Stage milestone: You have built at least one end-to-end Power BI dashboard from a raw dataset and published it for stakeholder access.
Add Python for Serious Data Work
8–10 weeksPython elevates you from junior to mid-level analyst. While Excel and SQL handle most day-to-day tasks, Python (specifically the pandas library) allows you to automate repetitive cleaning tasks, handle datasets that are too large for Excel, and run more complex analyses. This stage is what separates analysts who can only report on data from those who can transform and model it.
Stage milestone: You can load, clean, filter, and summarise a CSV dataset using Python and pandas, and export the results for visualisation.
Understand the Business Context
2–3 weeksTechnical skills alone do not make a great analyst. Hiring managers consistently say they want analysts who understand how the business works: how financial statements are structured, how information systems support decisions, and how data flows through an organisation. This stage ensures you can speak the language of the stakeholders you will serve.
Stage milestone: You can read a basic income statement and balance sheet, and explain how management information systems support organisational decision-making.
Certifications Worth Getting
Microsoft Power BI Data Analyst (PL-300)
Microsoft
The most employer-recognised BI certification for analysts. Exam costs roughly R2,500 but significantly differentiates your CV.
Google Data Analytics Certificate
Google / Coursera
Well-recognised by non-technical hiring managers. Available via Coursera financial aid at no cost.
Alison Diploma in Data Analytics
Alison
Free CPD-accredited diploma. Useful as a visible credential while you work towards paid certifications.
Portfolio Project Ideas
Employers want proof, not promises. Build at least two of these before applying for jobs, and document each one publicly on GitHub or a personal portfolio.
- 1
Sales performance dashboard in Power BI connected to a public retail dataset (e.g. Kaggle Superstore)
- 2
SQL query library: 10 business questions answered against a public database (e.g. Northwind or Chinook)
- 3
Python data cleaning script that takes a messy CSV and outputs a structured, analysis-ready dataset
- 4
Excel financial model: build a 12-month budget vs actuals tracker with variance analysis
- 5
End-to-end capstone: pick one public dataset, clean it in Python, query it in SQL, and visualise it in Power BI
Accelerate Your Career
Join over 10,000+ learners. Get early access to new courses, exclusive career guides, and platform updates delivered straight to your inbox.
By subscribing, you agree to our Terms of Service and Privacy Policy. Unsubscribe anytime.
Ready to start applying?
The Data Analyst interview prep guide covers the exact CV tips and interview questions SA employers use to screen candidates for this role.