Microsoft Power BI Advanced:

This course will help to further develop your Power BI skills by improving data modelling, using the DAX Expression language and to look at methods of creating more flexible business intelligence. Delegates must be comfortable with the course objectives covered at Introduction level.

Course Outline
Microsoft Power BI Advanced

Introducing DAX and Computations in Power BI

• Starter Exercise, Importing Data and Creating a Simple Report
• Applying Conditional Formats
• Creating Computed Columns
• Creating Measures
• Grouping Data and Creating Visualisations
• Creating KPIs
• Creating Conditional Columns

Modelling Data

• Using relationships to improve the ability to analyse data
• Pivoting and Grouping Data
• Creating Conditional Columns
• Creating Tables from existing Data
• Importing Data via a database query
• Exploring DAX further – 3 useful expression templates

Improving Reports and Outputs

• Working with multiple report pages
• Adding Graphics and drawing elements to Reports
• Exporting data to CSV
• Exporting data to PowerPoint
• Exporting Data to Excel
• Creating a Power BI Template
• Creating a Power BI App