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.

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.

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.

Follow-up options

The follow-up for this course is PowerBI Advanced – Day 2 (English).

Certificate

When completing this course you will recieve the certificate of participation ‘PowerBI Advanced – Day 1 (English)’. 

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