Power BI Advanced – Day 1 (English)
First day of the 2-day Power BI Advanced course
- Klassikaal of online
- 2 verschillende leslocaties
- Duur 1 dag
In het kort
This first day of the 2-day course, builds on your existing experience with Power BI and takes your skills to the next level. You will deepen your understanding of data modeling and analysis, learn how to create databases and query external data sources, and discover how to transform information into clear and meaningful insights. After completing the training, you will be able to design professional dashboards, apply corporate styles, and make more effective use of management information.
This first day of the 2-day course, builds on your existing experience with Power BI and takes your skills to the next level. You will deepen your understanding of data modeling and analysis, learn how to create databases and query external data sources, and discover how to transform information into clear and meaningful insights. After completing the training, you will be able to design professional dashboards, apply corporate styles, and make more effective use of management information.
Certificate
When completing this course you will recieve the certificate of participation ‘Power BI Advanced – Day 1 (English)’.
Your result
After completing day 1, you will be able to:
- Import and transform data from various sources, including SQL Server, using Power Query, parameters, and merged queries
- Model and analyze data with DAX formulas, applying key concepts like row and filter context
- Create effective calculated columns and measures for data analysis
- Use RELATED, LOOKUPVALUE, and variables to build advanced data models
- Apply time intelligence and CALCULATE for period comparisons and benchmarking
- Manage date tables and role-playing dimensions using USERELATIONSHIP
Audience
This course is intended for professionals with basic experience in Power BI who wish to further develop their skills in data modeling, analysis, and visualization. It is particularly suitable for those responsible for turning organizational data into clear insights and professional dashboards to support informed decision-making.
Prior knowledge
You have completed the Power BI Introduction course and would like to deepen your knowledge with advanced Power BI topics.
Course material
You will have access to the online learning environment, e-Connect, which contains all required training materials as well as additional resources. The platform also enables you to easily communicate with fellow participants.
Approach
This Power BI Advanced course consists of practical assignments, discussions, and hands-on exercises. The experienced trainer will provide thorough guidance in linking the content to your own professional practice.
Follow-up options
The follow-up for this course is PowerBI Advanced – Day 2 (English).
Wat ga je leren?
Content
- Importing data with PowerQuery
- Importing data from databases: SQL Server
- Using parameters
- Merging queries
- Analyzing and modeling data
- DAX formulas
- Difference between row context and filter context
- Calculated columns and measures: when to use which
- Looking up values in other tables: RELATED and LOOKUPVALUE
- Advanced logic with variables and the SWITCH statement
- Time intelligence to compare data with a previous period or the same period last year
- Benchmarking data with the CALCULATE formula
- Date table linked to multiple date fields: role-playing dimensions and USERELATIONSHIP
Alle kosten in één overzicht
Weet precies waarvoor je betaalt, zodat je zonder zorgen aan je opleiding kunt beginnen.
Bovengenoemde kosten zijn voor de gehele opleiding bij betaling in 1 termijn. Je kunt bij langere opleidingen ook per jaar of per maand betalen.
Studie- en lesmateriaal
Je ontvangt alles wat je nodig hebt om succesvol te studeren, waaronder:
- Boeken, readers en werkboeken
- Toegang tot het online leerplatform
*Arrangement- & locatiekosten
Volg je de opleiding op locatie? Dan zorgen wij voor een inspirerende leeromgeving met koffie, thee en een uitgebreid lunchbuffet. De kosten hiervoor hangen af of je voor de dag- of avondvariant kiest. Vraag hiervoor het kostenoverzicht aan. Kies je voor de online variant? Dan betaal je uiteraard geen arrangementskosten.
Bekijk beschikbare startdata!
Bekijk hieronder onze actuele lesplanning en schrijf je in voor een startdatum naar keuze.
Eerstvolgende startdatum
Hulp nodig bij je opleidingskeuze?
Heb je na het lezen van alle informatie vragen of twijfel je nog ergens over? Onze opleidingsadviseurs geven je graag gratis en vrijblijvend persoonlijk studieadvies, op basis van jouw leerdoelen en behoeften. Laat je gegevens achter en wij nemen zo spoedig mogelijk contact met je op om het advies te bespreken. Heb je specifieke vereisten voor je deelname aan de training? Laat het ons vooraf weten, dan zorgen we samen voor een passende oplossing. We helpen je graag!