Data and analytics
Analytics Engineer
Also called: dbt Developer, Data Modeller, BI Engineer
Sits between data engineers and analysts: models warehouse data into trusted, tested tables the business can query.
- Skill Packs
- 13
- Class hours
- 343
- At 6 hours a week
- about 15 months
- Free certifications
- 19
- Library resources
- 78
- Interview questions
- 145
✓ All 143 lessons expert reviewed
Your route. Follow the path in order and finish the capstone before you apply. Your goal is a portfolio project and interview practice you can show in the next few months.
Industry 5.0 · this path teaches 0 of 3 pillars
+ 🤝 Human-centred: add I50-HUM+ 🌱 Sustainable: add I50-SUS+ 🛡️ Resilient: add I50-RES
1. Foundation
5 packs · 138 hours
The base every pack after it builds on.
-
1
Python programming FND-01 Beginner
37 hours 15 lessons 🎓 4 free certifications 📚 8 library resources ✓ Expert reviewed ❓ 18 interview questions
-
2
Developer toolkit: command line, Git and AI coding assistants FND-02 Beginner
16 hours 8 lessons 🎓 1 free certification 📚 8 library resources ✓ Expert reviewed ❓ 11 interview questions
-
3
SQL and databases FND-03 Beginner
32 hours 13 lessons 🎓 3 free certifications 📚 8 library resources ✓ Expert reviewed ❓ 16 interview questions
-
4
Excel and spreadsheets for analysis DAT-01 Beginner
26 hours 11 lessons 📚 6 library resources ✓ Expert reviewed ❓ 10 interview questions
-
5
Data wrangling with NumPy and pandas DAT-02 Beginner
27 hours 11 lessons 🎓 1 free certification 📚 8 library resources ✓ Expert reviewed ❓ 11 interview questions
2. Core skills
4 packs · 95 hours
The skills the job is made of.
-
6
Database design and internals DBD-01 Beginner
30 hours 11 lessons 🎓 1 free certification 📚 8 library resources ✓ Expert reviewed ❓ 6 interview questions
-
7
Data visualisation, metrics and storytelling DAT-04 Beginner
18 hours 8 lessons 🎓 2 free certifications 📚 7 library resources ✓ Expert reviewed ❓ 8 interview questions
-
8
Business intelligence with Power BI, Fabric and Tableau DAT-05 Beginner
26 hours 10 lessons 🎓 1 free certification 📚 6 library resources ✓ Expert reviewed ❓ 10 interview questions
-
9
Data engineering and big data DAT-06 Advanced
21 hours 9 lessons 🎓 2 free certifications 📚 8 library resources ✓ Expert reviewed ❓ 11 interview questions
3. Specialise
2 packs · 60 hours
The depth that sets you apart in interviews.
-
10
PostgreSQL and MySQL in depth PGS-01 Advanced
32 hours 11 lessons 🎓 2 free certifications 📚 7 library resources ✓ Expert reviewed ❓ 6 interview questions
-
11
Shell and PowerShell scripting SHL-01 Beginner
28 hours 12 lessons 🎓 1 free certification 📚 4 library resources ✓ Expert reviewed ❓ 6 interview questions
4. Prove it
2 packs · 50 hours
A capstone project, then portfolio, resume and interview practice.
-
12
Capstone project CAP-01 Advanced
24 hours 9 lessons ✓ Expert reviewed ❓ 8 interview questions
-
13
Career readiness: portfolio, resume and interviews CAR-01 Beginner
26 hours 15 lessons 🎓 1 free certification ✓ Expert reviewed ❓ 24 interview questions
Add your edge
Optional packs that make you the candidate for a particular sector or degree.
Your branch · Pick the one that matches your degree.
Your industry · Pick the sector you want to work in.
Sign up free to see the free certifications and interview preparation for this role
It takes a minute with your email. AiTeky Pass (₹999/month or ₹9,999/year) is free for your first 30 days.