Technical / ITData & AI▶ Live code
Data analyst
Excel, SQL, Power BI and basic statistics — turn data into decisions.
Who it’s for: Graduates from any stream who like numbers and want analytics roles.
Roadmap
What you’ll learn
Follow the modules in order. Finish a small project at the end of each one.
-
01
Excel for analysis
2 weeks- Formulas, lookups (XLOOKUP)
- Pivot tables and charts
- Data cleaning
- Conditional formatting
-
02
SQL
3 weeks- SELECT, WHERE, ORDER BY
- JOINs and GROUP BY
- Subqueries
- Window functions
-
03
Power BI / Tableau
3 weeks- Importing and modelling data
- DAX measures
- Interactive dashboards
- Publishing and sharing
-
04
Statistics & storytelling
2 weeks- Mean, median, distributions
- Correlation vs causation
- Choosing the right chart
- Presenting insights
Tools
Tools & skills to learn
- Excel
- SQL
- Power BI
- Tableau
- Python (pandas, optional)
Certifications
Useful certifications
- Microsoft Power BI Data Analyst (PL-300)Paid; widely recognised
- Google Data Analytics Professional CertificateOn Coursera; financial aid available
Certificates support your profile — interviewers still ask what you built. Check current fees and rules on the official site.
Practice
Projects to build
Put these on your resume — they give you real stories for interviews.
- 1Sales dashboard from a public dataset
- 2SQL analysis of an employees database
- 3HR attrition analysis with insights deck
Live code
Practise right here
Run examples and try the 🏆 challenges — your answers are checked automatically.
Preview
Console
Sample tables: employees(id, name, dept_id, salary, joined) · departments(id, name) · users(id, email)
Result
Press Run to see the result.
Output
Code runs only in your browser. Press Ctrl/⌘ + Enter to run. Pick a 🏆 Challenge from the Example list to get your answer checked automatically.
Next steps
Interview & jobs
Get job alerts for this field