Power BI for Advanced course

Power BI for Advanced

This course is for advanced users of Power BI who want to deepen their knowledge in data preparation and analysis. You will learn how to combine and clean data from different sources, and how to make complex calculations with DAX.

Topics PowerBI for advanced users

• Connect and integrate data sources
• Collect data from various sources
• Preparing data for reporting purposes
• Transformation of data for analytical purposes
• Applying queries for data modeling
• Designing data models
• Perform standard query operations
• Using the query editor
• Management of diverse data relationships
• Optimization of data models
• Creating calculated columns, dimensions and tables
• Analyze temporal data
• Working with DAX functionalities
• Understanding contexts: row, query and filter
• Explore types of DAX calculations
• Applying DAX functions
• Using variables in DAX expressions
• Table relationships and their role in DAX
• DAX tables and filter applications
• Use visualization tools
• Create and customize visual displays
• Design slicers
• Use of matrices and tables in reports
• Creating scatter, waterfall and funnel charts
• Customize page layout and style
• Data exploration for insight
• Dashboard configuration and sharing
• Developing customized Q&A suggestions
• Editing tile information
• Integrate widgets and utilize dashboard space

Learning objectives of the PowerBI course for advanced students

After training you will be able to:

• Do you have extensive expertise in DAX?
• Are you able to consult and integrate various datasets?
• Successfully create advanced and complex reports.

Also check out our other related courses, such as the

Microsoft Excel Power Query training 1 Day

Microsoft Excel Basic training 1 day