Power BI Advanced (English)

Average score 9.4
out 1080 reviews

2 days
Per student: € 1.095,00 excl. VAT
Max 10 students

Classroom training
Online training
In-company
Exclusive aftercare

Show schedule and training Locations

Brochure Request quotation

Power BI Advanced (English)

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

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.

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.

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: 02 Nov 2022 till 09 Nov 2022

Show timetable

Online via Microsoft Teams / Taal: EN

Start guarantee

Days and times:

We 02 Nov 2022 09:00 - 16:00
We 09 Nov 2022 09:00 - 16:00

Location: Via Microsoft Teams / Taal: EN
Online via Microsoft Teams / Taal: EN

Start date: 11 Jan 2023 till 18 Jan 2023

Show timetable

Online via Microsoft Teams / Taal: EN Register

Days and times:

We 11 Jan 2023 09:00 - 16:00
We 18 Jan 2023 09:00 - 16:00

Location: Via Microsoft Teams / Taal: EN
Online via Microsoft Teams / Taal: EN

Start date: 07 Jul 2023 till 14 Jul 2023

Show timetable

Online via Microsoft Teams / Taal: EN Register

Days and times:

Fr 07 Jul 2023 09:00 - 16:00
Fr 14 Jul 2023 09:00 - 16:00

Location: Via Microsoft Teams / Taal: EN
Online via Microsoft Teams / Taal: EN

Start date: 08 Dec 2023 till 15 Dec 2023

Show timetable

Online via Microsoft Teams / Taal: EN Register

Days and times:

Fr 08 Dec 2023 09:00 - 16:00
Fr 15 Dec 2023 09:00 - 16:00

Location: Via Microsoft Teams / Taal: EN
Online via Microsoft Teams / Taal: EN

Price of the course Power BI Advanced (English)

Price per participant € 1.095,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.

Individuals

Because we are CEDEO certified you can apply for a STAP budget of up to €1,000 per person per year. This can be used for courses, trainings and schooling. More information.

Want to know more?

Do you have any questions or would you like more information? Feel free to contact us via [email protected] 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.

9

Mijn leerdoel was beter begrip van DAX en de logica erachter verkrijgen. Beter begrijpen in welke hoek de oplossing gezocht moet worden op het moment dat de standaard formules en “snelle metingen” niet de gewenste oplossing bieden. SignOn heeft waargemaakt wat ik zocht, ik beveel deze training aan.

- Menno
9

Ik heb deze training gevolgd als vervolg op de vorige les met als doel om meer gebruik van DAX te gaan maken en handige formules te leren om de maandcijfers te vergelijken, tooltips en opmaak. Ik beveel deze training aan.

- Nadia
10

Mijn werkzaamheden bestaan uit het maken van reports en dashboards. Om deze zo goed mogelijk te maken, wilde ik graag extra kennis opdoen. Dat heb ik bij deze training gedaan!. De training was qua niveau hoger dan wat ik tot nu toe kan, maar goed te volgen. Precies wat ik had gehoopt. Communicatie was tevens helder en goed gestructureerd. Ik heb ontzettend veel geleerd. Freddie is een super trainer! Hij nam de tijd voor vragen en legde alles rustig uit.

- Sanne
10

De trainers zijn zeer capabel en kunnen de kennis goed overbrengen. Ik heb deze training gevolgd om meer kennis te vergaren over het gebruik van Power BI (voornamelijk DAX). Veel anekdoten uit de praktijk, ik beveel deze training aan.

- Anoniem
10

Ik heb deze training gevolgd om formules toe te passen, model beheersbaar te maken en houden en visuals te leren. Top dat alles in blokken wordt uitgelegd en gesaved, makkelijk terug te zoeken. Ik beveel deze training aan.

- Ron
9

Goede training, ervaren en deskundige trainer. Veel aandacht voor vragen vanuit de deelnemers. Wel kwamen de opdrachten erg overeen met wat er uitgelegd werd, waardoor deze opdracht niet erg moeilijk waren en voor mijn gevoel wat minder toevoegden, ook omdat ik tijdens de uitleg zelf aan het meewerken was in powerbi, dus alle handelingen toen al uitvoerde. Dat werkte overigens erg prettig.

- Michiel Thijs van der Meulen
10

De cursus had veel ruimte voor maatwerk en sloot helemaal aan bij het niveau van onze groep. Freddy is een ontspannen trainer en heeft kennis van zaken. Het doel van deze training was om een niveau hoger te komen dan de basis van Power BI.

- Folkert
10

Mijn leerdoel was om Power BI beter onder de knie te krijgen en rapportages te maken van grote datasets en veel bronnen met data. Ik heb voor deze training gekozen vanwege de goede reviews, en een training die langer duurt dan 1 dag. 2 dagen is zelfs nog intensief, zou langer kunnen. Ik beveel deze training aan.

- Paul Bart
10

Ik heb voor deze training gekozen vanwege de goede reviews. Mijn leerdoel was om BI toe te kunnen passen bij onze klanten. Deze training heeft inzicht gegeven om niet alles in query voor te kauwen, maar om snelheid en performance goed te houden de berekeningen met DAX te maken. Ik beveel deze training aan.

- Henk
10

De trainer Freddy heeft veel tijd genomen om zich te verdiepen in casussen die wij hadden aangedragen. En daar veel goede tips voor gegeven. Deze training is aangeraden door een collega, ik beveel deze training aan.

- Anoniem
10

Ik heb deze training gevolgd om meer behendigheid met het programma te verkrijgen. Een best practice voor het gebruik van het programma Power BI. Het doel was om met meerdere collega’s op dezelfde wijze te gaan werken. Wij hebben voor deze training n, omdat we al eerdere ervaring SignOn hadden. Ik beveel deze training aan. .

- Anoniem
10

Na de Power BI Basis training heb ik enige tijd dashboards gebouwd voor onze organisatie. Omdat ik toch meer kennis van DAX nodig had, heb ik wederom via SignOn de Power BI Advanced training gevolgd. Uitstekende training, naslagwerk is duidelijk en up-to-date. De trainer heeft enorm veel kennis van Power BI en enorm veel praktijkervaring. Komend jaar zal ik me verder gaan specialiseren en de Expert training gaan volgen. Ik beveel deze training aan.

- Mischa

View all reviews on springest.nl

Wij gebruiken cookies om onze website en onze service te optimaliseren.

Ik ben op zoek naar

Power BI Advanced (English)

Power BI Advanced (English)

Power BI Advanced Course in English

Skills gained

Who should attend

Prerequisites

Skills gained

Language

Courseware

Certificate

Follow-up course

Course outline – Power BI Advanced (English)

Context

Explanation about various types of context

Data modeling

Calculation function: Dax swiss pocket knife

Influence relationships with DAX

Parameters in Power Query

Parameters in DAX

Cumulative column functions

Time Intelligence functions

Report Design

In-company?

Price of the course Power BI Advanced (English)

No additional costs

In-company group rate

Good to know

Want to know more?

Delivery formats

Classroom live

Virtual classroom

In-company course

Training Power BI Advanced (English)

Meer informatie nodig?

We helpen u graag verder

Ik ben op zoek naar

Power BI Advanced (English)

Power BI Advanced (English)

Microsoft Partner – Silver Data Analytics

STAP-budget

Microsoft Certified Trainers

Cedeo Recognition: What Does It Mean for You?

SignOn and the UWV

Power BI Advanced Course in English

Skills gained

Who should attend

Prerequisites

Skills gained

Language

Courseware

Certificate

Follow-up course

Course outline – Power BI Advanced (English)

Context

Explanation about various types of context

Data modeling

Calculation function: Dax swiss pocket knife

Influence relationships with DAX

Parameters in Power Query

Parameters in DAX

Cumulative column functions

Time Intelligence functions

Report Design

In-company?

Price of the course Power BI Advanced (English)

No additional costs

In-company group rate

Good to know

Want to know more?

Delivery formats

Classroom live

Virtual classroom

In-company course

Training Power BI Advanced (English)

Incompany-training

Request quote - Power BI Advanced (English)

Download brochure

Meer informatie nodig?

We helpen u graag verder