Microsoft Power BI Intermediate

This intermediate course is ideal for those seeking to create a solid dataset underlying Power BI’s reports and dashboards.

1 day course
What you will learn:
  • Get data from various sources: Web, SharePoint, Cloud source, SQL Server
  • Map visualisations
  • Advanced data Transformation in Query Editor
  • Create Calculated Tables
  • Common DAX Functions including FILTER, SUMX, CALCULATE, COUNTAX
  • Utilise Workspaces for collaboration in Power BI Service
  • Determine best method of data refresh for your data sources
What you'll get:
Workbook
Refreshments
Capped class size
eCertificate
Course prerequisites

Users who have attended Odyssey Training’s Power BI Introduction course will be ready to attend this intermediate course. Concepts from this course assume you can do the following:

  • pull data in from Excel into Power BI Desktop
  • create basic transformation in Query Editor
  • add simple visualisations to a report
  • apply filters to a visual, page, or report
  • add simple columns and DAX Measures
  • publish a report to Power BI Service, and pin tiles to create a dashboard

Do I need to bring my own laptop?

Participants are not required to bring their own laptops as our dedicated computer training labs are equipped with the programs and files you will need access to on your training day.

Topics covered in this training course
  • Web import
  • OneDrive
  • SharePoint list
  • SQL Server
  • What you need for mapping
  • Bubble Map
  • Filled Map
  • What IF Parameters
  • Create a visual with Q & A
  • Create filters from Calculated Columns
  • Create variance measures
  • Rename Query steps
  • Removing rows from Tables
  • Filtering Data
  • Filling Null area with Values
  • Trimming Text
  • Replacing Values
  • Parse Date Column
  • Extract Year, Qtr, Month, Date
  • Create date table in Power Query
  • Use parameter to specify date table
  • Dynamic start and end date ranges
  • Create date table with DAX
  • Using CALENDARAUTO in DAX
  • Comparing Measures to Calculated Columns
  • Create a quick measure
  • Creating a Quick Measure from a filter
  • SUM measures
  • Creating a Calculated Column using IF function
  • FORMAT function
  • SUMX function
  • AVERAGEX function
  • CALCULATE function
  • DAX Logical Operators
  • CALCULATE with multiple filters
  • Using Measures in Visuals
  • Create a measure using FILTER function
  • MINX function
  • COUNTAX function
  • ALL and ALLSELECTED functions
  • FIRSTDATE function
  • DATEADD function
  • Create Workspace Apps
  • Publish to a Workspace
  • Sharing Workspace apps
  • Assigning members to roles
  • Editing Workspace Apps
  • Creating reports in workspace apps
  • Understanding Data Refresh and what type of refresh is required
  • Refresh on demand
  • Automatic refresh
  • Refresh on schedule
  • Refresh from a local file
  • Refresh from a cloud-based file
    Reset options
- +
Need your training approved? Get a quote