Microsoft BI Intermediate

A one-day Microsoft Power BI training course to further develop the skills of the Power BI worker. The intention of this course is to improve data modelling skills, introduce the DAX Expression language and to look at methods of creating more flexible business intelligence. Delegates must have completed our Introduction to Power BI or be comfortable with the course objectives covered at Introduction level.

Format: One day, max capacity 6

Wireless Computer Accessories
power BI.png

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