Terug naar het overzicht 
Show schedule and training Locations 
Brochure 
Power BI Advanced (English)
- Per deelnemer: € 1.195,00 excl. VAT
-
2 days - Max 10 students
- Register now
Klanten geven ons een 9.4 (1.325 reviews)
Ik ben op zoek naar
-
2 days -
Per student: € 1.195,00 excl. VAT -
Max 10 students
- Power BI course in English
- Online training
- In-company
- Exclusive aftercare
- Blended Learning
Power BI Advanced Course in English
The Power BI Advanced training course is a 2-days practice-oriented course in which we elaborate on the use of Power BI Desktop and is the follow-up to the Power BI Basics Course. Among other things, we pay attention to the proper design of a model and choices for column calculations or measurements. DAX is a formula language with which you can perform all kinds of calculations with your data in Microsoft Power BI. The language is comparable, sometimes even identical, to Excel formulas. But with DAX even more is possible and the usage is a bit more complex. Working with DAX functions is lifted to a higher level, and we will work out the extra visualizations further in the training.
Skills gained
During the 2-day course Power BI Advanced you will receive, in addition to many exercises, various practical examples to work with. This allows you to use the advanced components of Power BI after following this course, such as DAX.
Who should attend to this Power BI training course?
- Users who have to combine and consult various data collections
- Users who want to visualize data outside of Excel
- Users who have to share data visualization and overviews online
- Users who want to learn how to edit larger data collections
- Users who want to know more about DAX functions, such as:
- Filter functions
- Information functions
- Logical functions
- Statistical functions
- Mathematical and trigonometric functions
- Text functions
- Functions for Time Intelligence Measurement
- And much more……..
- Controllers who will make Forecasting models
Prerequisites
You have knowledge of Excel Advanced and Power BI Desktop and Online. If you have not followed Power BI Basics Course (in English) or have not followed Excel Advanced training, enter the knowledge test here and determine your starting level immediately.
Are you unsure whether this training suits your knowledge and skills? Then contact us for advice or call us on 020-820 83 62.
Blended Learning at SignOn
The ‘classroom live’ and ‘virtual classroom’ Power BI course is supported by the digital SignOn Learning Environment with an introduction video, up-to-date course materials, various exercises and a handy Power BI installation document so you can briefly prepare your training. At SignOn, learning does not stop after attending this two-day training course. You can ask questions to our trainers for one year and get access to the learning portal for one year with additional exercises, useful tips & tricks, monthly update videos on the latest Power BI features and an invitation to a free webinar.
Skills gained
- Context
- Set up a repetition of a data model and create a date table
- Tables for measurements
- Calculation function: DAX’s Swiss army knife
- Using passive (inactive) relationships
- Understanding extended relationships, many to many, cardinality (Cardinality)
- Use of variable in DAX
- Help or Send Tables
- What If Parameters [What If]
- Top 10 DAX functions used
- Dynamic titles
- Targets (month) vs Actuals (day)
- Renewed Items
- Templates
- Parameters
- Cumulative Columns (running total)
- Extra Visualizations and additions new versions
- Histogram
- Forecasting models (Forecast)
- Dax Advanced: Extra Column Functions
- Dax Advanced: Extra Time Intelligence Measurements
- DAX Advanced (Advanced)
- Additional DAX functions
- Extra Parts
Language
The standard language during the course is English. In-company tailor-made training is also given in other languages. This basic training is also given in Dutch, see Power BI Basic course in Dutch.
Courseware
SignOn always provides all participants with the comprehensive current Power BI course material. As a result, you also have a handy reference work after the training.
Certificate
After the training you will receive a certificate.
Follow-up course
Do you want to follow a follow-up course after this Power BI Fundamentals course? Then the Power BI Expert Course (in English) course is highly recommended.
Meet your trainer
This training is given by one of our Power BI experts. They have years of experience and current knowledge. They know what you encounter every day and provide useful tips and tricks. Because they not only provide training but also work as Power BI consultants. Meet our Power BI trainers:
Jeroen
Freddy
Bart
Valerie
Course outline – Power BI Advanced (English)
During this 2-days Power BI Advanced course we will take a closer look to the more advanced features of Power BI. It focusses on creating good data models, using DAX to create advanced measures and calculations and create more advanced visualizations.
Context
Context is an important part for use of the correct DAX functions.
Explanation about various types of context
- Driving context
- Selection context
- Filter context
Data modeling
- Set up a good data model
- Use DAX Studio (Basic)
- Making a date table in DAX vs. Power Query
- Other table functions such as filter & AddColumns
- When do you use a measuring table?
- How do you set a measuring table?
- Use DisplayFolders
- Difference between measurements and calculated columns
- When do you use Dax and when Power Query
- When an implicit or explicit measurement?
- Formating measurements
- Documentation of measurements
Calculation function: Dax swiss pocket knife
- Extensive use of calculating in combination with other filters
- Calculate with OR & AND.
- Calculate with various filters options
- Calculate with all-selected function
- Calculate with all calcification function
- Calculate with Values
function
Influence relationships with DAX
- UserElatationShip function
- Cross filter functions
Parameters in Power Query
- Making dynamic parameter
- Use dynamic parameter
- Use parameters in a template file
Parameters in DAX
- Create & use Dax parameters
Cumulative column functions
- Cumulative columns via calculate, filter and max
- Counting and cumulative columns via Rankx, filter and earlier
- Use topn function
Time Intelligence functions
- Create YTD / MTD functions
- Compare periods (YOY / MOM ETC)
- Apply Isinscope & Hasonvalue
- Calculate continuous averages
Report Design
- Use bookmarks
- Add buttons and navigation
- Theme design
- Use tool tips
- Make Drill-Through pages
- Row Level Security Apply
Start dates Location
Start date: 07 May 2025 till 14 May 2025 Online via Microsoft Teams / Taal: EN 
Start guarantee Register
Show timetable
Online via Microsoft Teams / Taal: EN Start guarantee Days and times:
Online via Microsoft Teams / Taal: EN
- We 07 May 2025 09:00 - 16:00
- We 14 May 2025 09:00 - 16:00
Online via Microsoft Teams / Taal: EN
Start date: 05 Sep 2025 till 12 Sep 2025 Online via Microsoft Teams / Taal: EN Start guarantee Register
Show timetable
Online via Microsoft Teams / Taal: EN Start guarantee Days and times:
Online via Microsoft Teams / Taal: EN
- Fr 05 Sep 2025 09:00 - 16:00
- Fr 12 Sep 2025 09:00 - 16:00
Online via Microsoft Teams / Taal: EN
Start date: 03 Dec 2025 till 10 Dec 2025 Online via Microsoft Teams / Taal: EN Start guarantee Register
Show timetable
Online via Microsoft Teams / Taal: EN Start guarantee Days and times:
Online via Microsoft Teams / Taal: EN
- We 03 Dec 2025 09:00 - 16:00
- We 10 Dec 2025 09:00 - 16:00
Online via Microsoft Teams / Taal: EN
Price of the course Power BI Advanced (English)
Price per participant € 1.195,00 excl. VAT
Max. participants: 10
No additional costs
The mentioned course rates are per person, excluding 21% VAT (VAT number is stated on the invoice), including all current teaching materials, a reference work (PDF) and a certificate of participation. So there are no additional costs afterwards.
In-company group rate
If you register with a group of five or more people for a course at the company location (in-company), we can offer an attractive group rate. For information about our group rates, contact us and request a quote or call 020 – 820 83 62.
Good to know
Tax-deductible
The government stimulates knowledge and skills in the Netherlands. That is why SignOn’s courses are (partially) tax-deductible. How much you can deduct depends on your situation. Do you want to know more? Check the website of the Tax Authorities.
Employers
As an employer you can deduct the full training costs for employees as operating costs. This applies to the training itself, but also to other costs such as books, registration fees, administrative costs, the certificate or extra supervision. At SignOn all these costs are already included in the price.
Want to know more?
Do you have any questions or would you like more information? Feel free to contact us via info@signon.nl or call 020 – 820 83 62.
Delivery formats
Choose a delivery format that suits you best. The following delivery formats are available for this course:
-
Classroom live
A face-to-face training on a location in the Netherlands. Employees from different companies are present during this classroom training. Fully catered for, including an extensive lunch.
-
Virtual classroom
Attend a the virtual classroom course from any location (workplace or home). You learn from a live instructor and are in contact with other participants. The instructor has the possibility to look at your screen (if necessary) to answer all your questions. This training will take place via Microsoft Teams (free of use).
-
In-company course
Our in-company training is tailored to your company. The specialized trainer only deals with what is important for your company and work situation. That makes our tailor-made training very effective. We provide these training courses in Dutch, English and German. The choice for an in-company training provides an attractive discount. Depending on the number of participants, the discount can be as much as 50% compared to participation in an open training. More information or request a quote.
-
Ik ben de training gaan volgen om inzicht te krijgen in het gebruik van DAX. Ik vond dat de trainer een goede uitleg gaf en dat er een goede sfeer hing.
-
Ik heb de training erg prettig ervaren, ik heb eerder ook de basis cursus gevolgd. Doordat de basis training me goed is bevallen was ik ook benieuwd naar deze training en die is wederom goed bevallen.
-
Ik ben deze training gaan volgen om het programma power Bi en de mogelijkheden daarbinnen te leren kennen. Ik ben zeer tevreden met de cursus, ik heb hiervoor ook al een andere training van SignOn gevolgd.
-
Rustig en duidelijk uitleg incl. voorbeelden. Er waren veel oefeningen. Er is ruimte voor eigen vragen en inbreng en gebruik van eigen data. Het zorgt ervoor dat je nog beter en sneller gebruik maakt van Power BI en dat je niet in de bron zelf bewerkingen gaat doorvoeren.
-
Goed niveau! De training geeft vooral inzicht in de mogelijkheden die er zijn binnen PowerBI en om daar vervolgens zelf meer gedetailleerd onderzoek naar te doen of mee te oefenen
-
Ik ben zeer tevreden over zowel training als trainer. Ik wilde graag meer te weten komen over DAX en handige andere functies binnen power BI. De training heeft absoluut waargemaakt wat ik zocht!
-
Mijn leerdoel was het verder kennismaken met DAX nadat ik de Power BI Basis training heb gevolgd. De voorbereiding in de online omgeving en de handson aanpak zodat je gewoon zelf met de vingers aan de knoppen bent.
-
Alles vanuit Jeroen en de training zelf als zeer positief ervaren. Mijn leerdoel was om mijn kennis te verdiepen en weer nieuwe kennis op te doen. Absoluut waar gemaakt tijdens deze training!
-
Tevreden over de eerste basis training, en de goede trainers, waardoor ik nu opnieuw voor SignOn heb gekozen. Ook bij deze training weer een prettig en geduldige trainer. Kan heel goed uitleggen en voordoen. Is zeer deskundig.
-
Locatie was perfect. Eten en andere faciliteiten waren super geregeld. Had niet beter kunnen vragen. Inhoud en niveau sloten exact aan op wat ik had verwacht en gehoopt, dus dat was helemaal goed. Trainer was erg enthousiast en kon goed en geduldig uitleggen.
-
Mijn leerdoel was meer kennis krijgen over de mogelijkheden van Power BI. Ik heb een hoop geleerd en de training heeft me geholpen om makkelijker en beter dashboarden te bouwen en het gebruiken van formules.
-
Ik wilde meer kennis over hoe PowerBI denkt en welke functies je zou kunnen aanroepen. Inhoud en niveau sloot exact aan op wat ik had verwacht en gehoopt. Trainer was erg enthousiast en kon goed en geduldig uitleggen.
View all reviews on springest.nl
Training Power BI Advanced (English)
Average score
out 1366 reviews
