Power BI Level 3 NI Webinar

Summary

This course covers the essential skills in Power BI, Extracting, Transforming and Loading data into the Data Model, then Visualising it with a rich set of Graphics, Charts and Dashboards. We also cover the use of DAX in Excel and how that can feed data to Power BI and be combined in Dashboards and Visualisations.

Venue details:  
Virtual Classroom, ,
Start date & time:  
28 May 2020 09:30
End date & time:  
28 May 2020 16:30
Price:  
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
7.00
CPD hours:  
7.00
Speaker details
First nameLast name
Mullan Training

Description

Product type:  
CPD online course
Category:  
Technology and data

Login details for this session will be sent by email two hours before the start time

Who should attend?


You should have a good working knowledge of Power BI or have completed our Power BI Level 1 & 2 course.

Key learning Outcomes

  • Understanding BI Data
  • Creating Data Models
  • Using DAX Functions
  • Using Dates Correctly
  • Shaping Reports

Course Overview 

Understanding BI Data

  • Business Intelligence Data Sources
  • Data Source Types
  • Table Roles

Functionality Review

  • Review Of Calculated Column
  • PivotTable Function
  • Review Of Measure
  • Rules Of DAX Measure
  • Evaluation Context
  • Formatting DAX Code


Controlling Content & Values

  • Controlling Values
  • Error Handling

Context Control Functions

  •  Filter Function
  •  All Function
  •  Earlier Function
  •  Calculate Function
  •  Additional Uses Of The All Function

  • Contexts In Relationships
  • Working With Many Tables
  •  Row Context & Relationships
  •  Filter Context & Relationships
  •  Values Function


Advanced Concepts

  • Circular Dependencies
  •  Controlling Totals
  •  Advanced Hierarchy Concept


Time Intelligence Calculations

  • Working With Date Tables
  •  Calculating Operating Periods
  •  Working With Missing Periods
  •  DAX Date Functions
  •  Advanced Date Functions
  •  Prior Year Functions
  •  Moving Averages


DAX Dashboard Techniques

  • Parameter Tables
  •  Banding
  •  Ranking
  •  Advanced Slicer Techniques