What to know before you read.
- Learn to frame a decision and validate data before designing charts.
- SQL, metric design and clear communication are more durable than dashboard-tool memorisation.
- A good portfolio connects every visual to an action, limitation or next question.
Stage 1: Work with tables confidently
Practise sorting, filtering, formulas, lookups, summaries and basic charts in a spreadsheet or data frame. Learn to recognise data types, row grain, missingness and duplicate keys. The milestone is a clean table and a written explanation of what one row represents.
Stage 2: Learn SQL through questions
Use SELECT, WHERE, GROUP BY, joins, CASE expressions and window functions to answer increasingly realistic questions. Before each query, write the intended grain of the result. Validate row counts and totals after joins rather than assuming syntactically correct SQL is analytically correct.
Stage 3: Define metrics and comparisons
Translate a broad objective into a numerator, denominator, timeframe and segment. Compare trends against a baseline, target or prior period. Learn how averages can hide variation and how selection effects can create misleading stories.
- Name the stakeholder
- Define the decision
- Write the metric formula
- Choose the comparison
- State data limitations
Stage 4: Design a decision-first dashboard
Create a hierarchy: headline outcome, diagnostic breakdown and details for action. Remove charts that do not change interpretation. Add definitions and dates so a viewer can trust what is visible. Test the dashboard by asking another person what decision they would make from it.
Stage 5: Publish a portfolio case study
Document the question, source, cleaning, SQL, metric definitions, findings, recommendation and limitation. The Data Analytics Certificate of Specialisation turns this progression into a 30-hour, 2 Month programme with guided labs and a capstone.
Questions readers often ask.
Can I learn data analytics without coding?+
You can begin with spreadsheets and visualisation, but SQL becomes essential for retrieving and shaping real organisational data.
Which tool should I learn first?+
Start with a spreadsheet and SQL. Add a dashboard tool after you understand metrics and data structure.
What should a beginner portfolio include?+
Include one decision-focused analysis with documented data checks, queries, visuals, recommendation and limitations.
