Power BI Advanced – Day 1 (English) - Dag

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.

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.

Objectives

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.

Program guide

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

• 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

Course schedule

Characteristics

Short program

Commercial partners