Beginner levelData and IT
Data analyst programme
Six months, four tools: Excel, SQL, Power BI and Python, with a job-ready project at the end of each stage.
- Hours
- 120
- Length
- 24 weeks
- Group
- up to 16 people
- Format
- Hybrid, Live online
- Taught in
- AZ, RU
Next groups
A group is certain to run once six people enrol. Enrolment closes at 18:00 the day before the first lesson.
| Dates | Days and time | Language | Format | Seats | Enrol in this group |
|---|---|---|---|---|---|
| Mon 26 Oct – Wed 21 Apr48 lessons | Days and timeMon, Wed 19:00–21:30 | LanguageIn Azerbaijani | FormatHybrid | Seats11 seats left | Enrol in this group |
| Tue 17 Nov – Thu 6 May48 lessons | Days and timeTue, Thu 19:00–21:30 | LanguageIn Russian | FormatLive online | Seats1 seat leftGroup confirmed | Enrol in this group |
| Mon 21 Dec – Mon 14 Jun48 lessons | Days and timeMon, Wed 19:00–21:30 | LanguageIn Azerbaijani | FormatHybrid | Seats8 seats leftGroup confirmed | Enrol in this group |
| Tue 12 Jan – Thu 1 Jul48 lessons | Days and timeTue, Thu 19:00–21:30 | LanguageIn Russian | FormatLive online | Seats7 seats leftGroup confirmed | Enrol in this group |
| Mon 15 Feb – Mon 9 Aug48 lessons | Days and timeMon, Wed 19:00–21:30 | LanguageIn Azerbaijani | FormatHybrid | Seats4 seats leftGroup confirmed | Enrol in this group |
| Tue 9 Mar – Thu 26 Aug48 lessons | Days and timeTue, Thu 19:00–21:30 | LanguageIn Russian | FormatLive online | Seats9 seats leftGroup confirmed | Enrol in this group |
Programme
- Excel for analysts: cleaning, pivots, Power Query24 h
- SQL: from queries to window functions28 h
- Power BI: the model, DAX and the report28 h
- Analysis with Python and pandas28 h
- From business question to answer: presenting, the portfolio, the interview12 h
- Total120 h
After the course you will be able to
- Meet the requirements of a junior data analyst job
- Go to interviews with a four-project portfolio
- Answer a business question with numbers and present it to a manager
What you need first
Comfortable with a computer; Excel basics help but are not required.
Tools
- Microsoft Excel
- PostgreSQL
- Power BI Desktop
- Python
Final project and certificate
A project at the end of each stage, then a final piece using all four tools and a ten-minute presentation of it.
The certificate goes to those who attend 80% of the lessons and score above 60 on the final project. It is the academy’s own certificate, not a state document; its number can be checked on this site.
Check a certificateCertificate
Awarded to
Name Surname
«Data analyst programme» for completing the course
Length: 120 hours · Final project: 91/100
No. PS-2026-···· · verify at pilleakademiya.az/certificates
Instructors
Farid Aliyev
Power BI and SQL
Data team lead at a telecom operator, 12 years in the trade
Profile and a free consultationElvin Huseynzade
Python for data analysis
Data scientist in a bank’s risk department, 8 years in the trade
Profile and a free consultationNargiz Rzayeva
Excel and reporting
Reporting analyst at a retail chain, 9 years in the trade
Profile and a free consultation
Before and after this course
All courses in the field: Data and ITQuestions
Do you help with finding a job?
We do not promise a job. The last module works on your CV and portfolio with interview practice, and we pass on vacancies from employers we know.
Can I get my money back if I change my mind?
Until the first lesson you get back everything you paid. After the start, the lessons not yet held are refunded, to the card within 10 working days. Cancel on the “Your enrolment” page with the number and your phone.
Can I move to another group?
Yes, once and free, until 3 days before the start: choose another group of the same course on the “Your enrolment” page.
This course for your team
We can run the course at your office or online for your staff only, with examples from your company’s own data.