Intermediate levelData and IT
Reporting in Power BI
Connecting sources, Power Query, the data model, DAX measures and a management report, built on your own data.
- Hours
- 40
- Length
- 8–10 weeks
- Group
- up to 18 people
- Format
- In class, 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 |
|---|---|---|---|---|---|
| Sat 31 Oct – Sat 9 Jan10 lessons | Days and timeSaturday 10:00–14:00 | LanguageIn Russian | FormatIn class | Seats7 seats leftGroup confirmed | Enrol in this group |
| Tue 10 Nov – Tue 5 Jan16 lessons | Days and timeTue, Thu 19:00–21:30 | LanguageIn Azerbaijani | FormatIn class | Seats2 seats leftGroup confirmed | Enrol in this group |
| Sat 12 Dec – Sat 20 Feb10 lessons | Days and timeSaturday 10:00–14:00 | LanguageIn Russian | FormatIn class | Seats9 seats leftGroup confirmed | Enrol in this group |
| Mon 14 Dec – Wed 3 Feb16 lessons | Days and timeMon, Wed 19:00–21:30 | LanguageIn Azerbaijani | FormatLive online | Seats4 seats leftGroup confirmed | Enrol in this group |
| Tue 22 Dec – Tue 16 Feb16 lessons | Days and timeTue, Thu 19:00–21:30 | LanguageIn Azerbaijani | FormatIn class | Seats3 seats leftGroup confirmed | Enrol in this group |
| Sat 23 Jan – Sat 3 Apr10 lessons | Days and timeSaturday 10:00–14:00 | LanguageIn Russian | FormatIn class | Seats2 seats leftGroup confirmed | Enrol in this group |
Programme
- Power BI Desktop and the service: a report’s journey6 h
- Power Query: data from Excel, SQL and folders8 h
- The data model: star schema, relationships, a date table8 h
- DAX: measures, CALCULATE, time intelligence10 h
- Visuals, report design, sharing and access8 h
- Total40 h
After the course you will be able to
- Build a report that refreshes itself from several sources
- Write DAX measures for sales, costs and plan versus actual
- Share the report with the team and set who sees what
What you need first
Working with Excel pivot tables; no SQL needed.
Tools
- Power BI Desktop
- Power Query
- DAX
- Microsoft Excel
Final project and certificate
A management report on your own or a given dataset: three pages, more than ten DAX measures, scheduled refresh.
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
Roya Ahmadova
«Reporting in Power BI» for completing the course
Length: 40 hours · Final project: 91/100
No. PS-2026-0417 · 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 consultation
Before and after this course
All courses in the field: Data and ITQuestions
Do I need a Power BI licence?
Power BI Desktop is free. For sharing we use a trial account of the service, and explain which licence you would need at work.
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.