Creating Power BI Reports (Intermediate)

GENERAL

• Learn to build professional-looking reports

DATA & MODEL LAYERS

• Importing data from a wide range of sources

• Importing vs Live vs Direct Query connections to the data.

• Resolving Data Import Errors

• Building Data Models

  • Creating a Data Model from Scratch

  • Merging data from multiple sources (and issues that may arise)

• Data wrangling in Power BI

  • Transforming and sanitising data using the Query Builder

• Creating Queries, merging and appending Queries.

• Creating custom columns within the Query Builder

  • Includes an introduction to the "M" programming language.

• Creating Quick Measures

• Creating Measures and Calculated Columns

  • An Introduction to DAX

  • Aggregate Functions: SUM, SUMX, COUNT, MIN, MAX, AVERAGE, etc.

  • Use CALCULATE to modify FILTERs

  • Combining Aggregates and modified Filters to give Percent of Total metrics.

• Creating Calculated Tables

• Filter context and row context (introduction to) 

VISUALISATION LAYER

• Building for Mobile

• Creating custom Themes

• Syncing Slicers

• Creating and using Bookmarks

• Drilling Through from one page to the next

• Building and Designing Custom Navigation

• Getting additional visualisations using the App Source (and security considerations)

• Creating custom Report Page Tooltips

• Building Reports with a target audience in mind

• Buttons and Navigation

APP SERVICE 

(The "app service" is Microsoft's name for the web portal https://app.powerbi.com)

• Scheduling Data Refreshes

• Best practices when Publishing and Maintaining Reports

• Collaborating on Power BI Reports

ASSIGNMENT

• Presentation of a Power BI dashboard to peers (final session)