COURSE INFORMATION

This course is aimed at Business Analysts who want to expand on their knowledge of Power BI Desktop.

  • Themes
  • Further Visualisation tools
  • Further DAX Functions
  • Data Management
  • Publishing to Power BI Service

Themes

  • Apply a theme to a report
  • Create a custom theme
  • Create a template with a theme and standard pages

Visualising Data

  • Additional Visuals
  • Hierarchies
  • Format Pane
  • Conditional Formatting
  • Sparklines
  • Edit Interactions

Further DAX

  • What if Analysis using DAX logic
  • Time Intelligence Functions
  • Quick measures
  • Debugging DAX Functions
  • Using Variables
  • Formatting DAX measures
  • SUMX Function

Data Management

  • Import vs Direct Query
  • Setting up a Schema
  • Creating a single set of values
  • Different ways to create a Date Table
  • Measures v Calculated Columns
  • Publish Reports with Power BI Service (requires Power BI service licence)
  • Implementing Row Level Security
  • Define roles and rules
  • Publish report to Power BI Service
  • Create Dashboards
  • Add tiles to Dashboards
  • Add other data to a Dashboard
  • Using Insights
  • Sharing Dashboards

Report Management (requires Power BI service licence)

  • Implementing Row Level Security
  • Define roles and rules
  • Manage security in Power BI Service
  • It is recommended you have completed the Introduction to Power BI desktop course.
  • £495
  • One day trainer led or virtual