Work through our specifically designed Power BI Advanced training course to learn:

laptop

Data Analysis Expressions (Power BI DAX training)

browser-4

Data Sources (API – Gateway -Databases)

analytics-4

Calculated Columns and Measures

analytics-2

Date Dimension & Row Level Security


Power BI Advanced Graphic

Check out our Power BI Advanced Course diagram for a visual guide of the content we deliver in our Power BI Advanced course.

The course focuses on DAX; Row Context, Functions, Calculated Columns, Measures and working with Various Data Sources.

 


SydneyMelbourneBrisbanePerthAdelaideParramattaCanberra

BOOK NOW

Course Details

  • Price: $605
  • Duration: 1 day
  • Time: 9am – 4pm (approx)
  • Class Size (max): 10
  • Class Size (avg): 5
  • Reference manuals: Provided
  • Training computer: Provided
  • CPD hours: 6 hours

Course Content

PDFPower BI Advanced

Upcoming Dates
Wed 23-Jan-19 Power BI Advanced Sydney Course confirmed to run. Trainer has been allocated.
Fri 01-Mar-19 Power BI Advanced Sydney Course has been scheduled to run but has not been confirmed.
Thu 11-Apr-19 Power BI Advanced Sydney Course has been scheduled to run but has not been confirmed.
Fri 24-May-19 Power BI Advanced Sydney Course has been scheduled to run but has not been confirmed.
Wed 19-Jun-19 Power BI Advanced Sydney Course has been scheduled to run but has not been confirmed.
  • Scheduled
  • Confirmed
  • Few seats
  • Class full

Course scheduled to run. Taking enrolments.
Course will run. Taking further enrolments.
Course will run. Limited seats available.
Sold out. Try another date.

BOOK NOW

Course Details

  • Price: $605
  • Duration: 1 day
  • Time: 9am – 4pm (approx)
  • Class Size (max): 10
  • Class Size (avg): 5
  • Reference manuals: Provided
  • Training computer: Provided
  • CPD hours: 6 hours

Course Content

PDFPower BI Advanced

Upcoming Dates
Tue 22-Jan-19 Power BI Advanced Melbourne Course confirmed to run. Trainer has been allocated.
Mon 04-Feb-19 Power BI Advanced Melbourne Course has been scheduled to run but has not been confirmed.
Tue 05-Mar-19 Power BI Advanced Melbourne Course has been scheduled to run but has not been confirmed.
Fri 22-Mar-19 Power BI Advanced Melbourne Course has been scheduled to run but has not been confirmed.
Mon 08-Apr-19 Power BI Advanced Melbourne Course has been scheduled to run but has not been confirmed.
Mon 29-Apr-19 Power BI Advanced Melbourne Course has been scheduled to run but has not been confirmed.
Fri 24-May-19 Power BI Advanced Melbourne Course has been scheduled to run but has not been confirmed.
Thu 20-Jun-19 Power BI Advanced Melbourne Course has been scheduled to run but has not been confirmed.
  • Scheduled
  • Confirmed
  • Few seats
  • Class full

Course scheduled to run. Taking enrolments.
Course will run. Taking further enrolments.
Course will run. Limited seats available.
Sold out. Try another date.

BOOK NOW

Course Details

  • Price: $605
  • Duration: 1 day
  • Time: 9am – 4pm (approx)
  • Class Size (max): 10
  • Class Size (avg): 5
  • Reference manuals: Provided
  • Training computer: Provided
  • CPD hours: 6 hours

Course Content

PDFPower BI Advanced

Upcoming Dates
Thu 13-Dec-18 Power BI Advanced Brisbane No more seats are available for this course.
Fri 14-Dec-18 Power BI Advanced Brisbane Course confirmed to run. Limited number of seats available.
Wed 19-Dec-18 Power BI Advanced Brisbane No more seats are available for this course.
Tue 22-Jan-19 Power BI Advanced Brisbane Course confirmed to run. Trainer has been allocated.
Mon 04-Feb-19 Power BI Advanced Brisbane Course confirmed to run. Trainer has been allocated.
Tue 05-Mar-19 Power BI Advanced Brisbane Course has been scheduled to run but has not been confirmed.
Fri 22-Mar-19 Power BI Advanced Brisbane Course has been scheduled to run but has not been confirmed.
Mon 08-Apr-19 Power BI Advanced Brisbane Course has been scheduled to run but has not been confirmed.
Mon 29-Apr-19 Power BI Advanced Brisbane Course has been scheduled to run but has not been confirmed.
Fri 24-May-19 Power BI Advanced Brisbane Course has been scheduled to run but has not been confirmed.
Thu 20-Jun-19 Power BI Advanced Brisbane Course has been scheduled to run but has not been confirmed.
  • Scheduled
  • Confirmed
  • Few seats
  • Class full

Course scheduled to run. Taking enrolments.
Course will run. Taking further enrolments.
Course will run. Limited seats available.
Sold out. Try another date.

BOOK NOW

Course Details

  • Price: $605
  • Duration: 1 day
  • Time: 9am – 4pm (approx)
  • Class Size (max): 10
  • Class Size (avg): 5
  • Reference manuals: Provided
  • Training computer: Provided
  • CPD hours: 6 hours

Course Content

PDFPower BI Advanced

Upcoming Dates
Wed 23-Jan-19 Power BI Advanced Perth Course confirmed to run. Trainer has been allocated.
Fri 01-Mar-19 Power BI Advanced Perth Course has been scheduled to run but has not been confirmed.
Thu 11-Apr-19 Power BI Advanced Perth Course has been scheduled to run but has not been confirmed.
Fri 31-May-19 Power BI Advanced Perth Course has been scheduled to run but has not been confirmed.
Wed 19-Jun-19 Power BI Advanced Perth Course has been scheduled to run but has not been confirmed.
  • Scheduled
  • Confirmed
  • Few seats
  • Class full

Course scheduled to run. Taking enrolments.
Course will run. Taking further enrolments.
Course will run. Limited seats available.
Sold out. Try another date.

BOOK NOW

Course Details

  • Price: $605
  • Duration: 1 day
  • Time: 9am – 4pm (approx)
  • Class Size (max): 10
  • Class Size (avg): 5
  • Reference manuals: Provided
  • Training computer: Provided
  • CPD hours: 6 hours

Course Content

PDFPower BI Advanced

Upcoming Dates
Wed 23-Jan-19 Power BI Advanced Adelaide Course confirmed to run. Trainer has been allocated.
Fri 01-Mar-19 Power BI Advanced Adelaide Course has been scheduled to run but has not been confirmed.
Thu 11-Apr-19 Power BI Advanced Adelaide Course has been scheduled to run but has not been confirmed.
Fri 31-May-19 Power BI Advanced Adelaide Course has been scheduled to run but has not been confirmed.
Wed 19-Jun-19 Power BI Advanced Adelaide Course has been scheduled to run but has not been confirmed.
  • Scheduled
  • Confirmed
  • Few seats
  • Class full

Course scheduled to run. Taking enrolments.
Course will run. Taking further enrolments.
Course will run. Limited seats available.
Sold out. Try another date.

BOOK NOW

Course Details

  • Price: $605
  • Duration: 1 day
  • Time: 9am – 4pm (approx)
  • Class Size (max): 10
  • Class Size (avg): 5
  • Reference manuals: Provided
  • Training computer: Provided
  • CPD hours: 6 hours

Course Content

PDFPower BI Advanced

Upcoming Dates
Thu 10-Jan-19 Power BI Advanced Parramatta Course has been scheduled to run but has not been confirmed.
Tue 05-Mar-19 Power BI Advanced Parramatta Course has been scheduled to run but has not been confirmed.
Mon 08-Apr-19 Power BI Advanced Parramatta Course has been scheduled to run but has not been confirmed.
Wed 26-Jun-19 Power BI Advanced Parramatta Course has been scheduled to run but has not been confirmed.
  • Scheduled
  • Confirmed
  • Few seats
  • Class full

Course scheduled to run. Taking enrolments.
Course will run. Taking further enrolments.
Course will run. Limited seats available.
Sold out. Try another date.

BOOK NOW

Course Details

  • Price: $605
  • Duration: 1 day
  • Time: 9am – 4pm (approx)
  • Class Size (max): 10
  • Class Size (avg): 5
  • Reference manuals: Provided
  • Training computer: Provided
  • CPD hours: 6 hours

Course Content

PDFPower BI Advanced

Upcoming Dates
Wed 23-Jan-19 Power BI Advanced Canberra Course has been scheduled to run but has not been confirmed.
Fri 01-Mar-19 Power BI Advanced Canberra Course has been scheduled to run but has not been confirmed.
Thu 11-Apr-19 Power BI Advanced Canberra Course has been scheduled to run but has not been confirmed.
Fri 24-May-19 Power BI Advanced Canberra Course has been scheduled to run but has not been confirmed.
Wed 19-Jun-19 Power BI Advanced Canberra Course has been scheduled to run but has not been confirmed.
  • Scheduled
  • Confirmed
  • Few seats
  • Class full

Course scheduled to run. Taking enrolments.
Course will run. Taking further enrolments.
Course will run. Limited seats available.
Sold out. Try another date.

Are you looking to understand the advantages of Power BI Pro?
student

Learn how to use the powerful modelling and data sourcing capabilities to become a Power BI power user in our one-day course. In this course we focus heavily on the complex theory of DAX and how to work with different Data sources. Take your Business Intelligence analysis to the next level with our Power BI Advanced course.

What do I need to know to attend?
  • Use Power BI Desktop to source and transform data, primarily though the user interface / ribbon
  • Basic understanding of and using simple data modelling through, mostly through the user interface / ribbon
  • Knowledge of how to create simple calculated columns and very rudimentary measures using DAX
  • Appreciation of intermediate data modelling techniques such as the use of time intelligence functions, basic data modelling and correct use of table relationships
  • Good understanding of data security and knowledge of simple row level security capabilities in Power BI
  • Advanced Excel skills is desired, knowledge of programming / scripting concepts will be an advantage

tasks

Learning Outcomes -Power BI Advanced

On completion of this course you should be able to:

  • The Business Intelligence Process
  • Data Modelling for Business Intelligence
  • Foundation of Data Analysis Expression (DAX)
  • Import from a variety of Data Sources
  • Understand DAX Relationships
  • Work with Calculated Columns
  • Work with Time Intelligence Function
  • Understand variables in DAX
Course Details
  • circular-clockCourses will run from 9am – 4pm (approx.)
  • network-1Classes limited to approx 10 people
  • Power BI Advanced costs $605
  • book-2Reference Manuals provided
  • maps-and-flags-1Central city locations
Each Student receives
  • book-1Reference Workbooks
  • e-Certificate of attendance
  • customer-service-2Complimentary post course training e-support
  • dart-boardTrained by a Microsoft Certified Expert
  • likeSatisfaction guarantee or repeat FREE within 6mths
Course Content

power-bi-icon_75Course Introduction

  • Overview of Power BI

power-bi-icon_75Data Model

  • Data Modelling in the Real World
  • Dataset for these Exercises

 


power-bi-icon_75Data Analysis eXpression (DAX) – Intro

  • Introduction to DAX
  • Learning DAX
  • Advice when creating DAX
  • Third party tools to assist
  • Measures Table
  • Create a Table for Measures

power-bi-icon_75DAX – Evaluation Contexts

  • Overview of contexts in DAX
  • The Filter Context
  • The Row Context
  • Initial Filter (Query) context
  • Initial Row context
  • Create a simple measure in the Measures table
  • Rules of Evaluation
  • Exploring the Rules

power-bi-icon_75DAX – Contexts & Relationships

  • Introduction to Relationships
  • Filter context follows relationships
  • Explore the filter context
  • How filter context follows relationships
  • Filter context against relationships
  • The Both cross-filter direction
  • Modify the filter direction
  • The CROSSFILTER function
  • Impact on totals

power-bi-icon_75DAX – Filter Context Modification

  • The CALCULATE function
  • How CALCULATE works
  • Modify the filter context
  • Modify existing filter context
  • Limitations of CALCULATE
  • The FILTER function
  • FILTER returning a table
  • Modify existing filter context with both FILTER and CALCULATE
  • Difference between these methods
  • Using ALL function in FILTER
  • Identical CALCULATE and FILTER
  • Extended exercise – ALL functions

power-bi-icon_75DAX – Context in Calculated Columns

  • Introduction to columns
  • Row context in Calculated Columns
  • Relationships in row context
  • Row to Filter context transformation
  • The RELATEDTABLE function
  • Calculated column in a fact table
  • Options to resolve these errors
  • Steps to debug an error
  • The RELATED function
  • Extended exercise – the LOOKUP function

power-bi-icon_75DAX – Functions in Context

  • Common time intelligence functions
  • Date hierarchy in Power BI
  • Create a time intelligence measure
  • The arguments of the DAX YTD function
  • Format of year end date
  • Alternate Financial year end
  • Rules of evaluation quiz
  • Dynamic totals
  • Test for totals row in a matrix
  • Toggle display of totals in the measure

 


power-bi-icon_75DAX – Row Context in Measures

  • Overview of the row context
  • Simple iterator in a measure
  • Row context and a related table
  • Extended exercise to calculate costs
  • Re-using measures
  • Implicit CALCULATE in a measure
  • How to work with implicit CALCULATE

power-bi-icon_75DAX – Variables

  • Overview of variables in DAX
  • Creating and using variables
  • Use variables to store a constant
  • Use variables to avoid repetition
  • Location of variable evaluation
  • Use variables to simplify an expression
  • Where to from here

power-bi-icon_75Row Level Security

  • Overview of RLS in Power BI
  • Create dynamic RLS using USERNAME or USERPRINCIPALNAME
  • Load data and enable RLS
  • Testing dynamic RLS in Desktop
  • RLS data access according to organisation hierarchy
  • DAX parent-child functions
  • Publish and assign roles in Power BI Service
  • Create App Workspace

power-bi-icon_75Report Features

  • Introduction to advanced features
  • Overview of Drill-through
  • Create report page with drill-through filters
  • Interacting with drill-through
  • Overview of custom report tooltips
  • Modify standard tooltip display
  • Create a custom tooltip
  • Apply the tooltip to a field
  • Apply the tooltip to a visual
  • Overview of Grouping and Binning
  • Create a group
  • Create a bin
  • Binning a date field

power-bi-icon_75Date Dimension

  • Overview of Date Dimension in BI
  • Power BI Desktop settings
  • Download or Create own table Data Table with a DateKey
  • Convert a DateKey to a Date
  • Create date table in Power Query
  • Extended exercise – Use parameter to specify date table start and end
  • Create date table with DAX
  • Using CALENDARAUTO in DAX

power-bi-icon_75Data Sources – App / API

  • Overview of Web and API data sources
  • Query an API data source
  • HTTP and JSON terminology
  • Transform a JSON response
  • Publish to Power BI Service and setup refresh schedule

power-bi-icon_75Data Sources – Streaming

  • Overview of real time streaming data sources
  • Push Datasets and Streaming Datasets
  • Pushing data into a dataset
  • Query data from PubNub stream
  • Configure Dashboard tile to show streaming data from PubNub
  • Create a REST API to push data into Power BI
  • Create JSON object to insert data via this API
  • Push data to created API using web based HTTP Post
  • Create Dashboard tile to show updating data

power-bi-icon_75Data Sources – Folder

  • Overview of using a folder data source
  • Query a folder containing multiple source files
  • Column consistency
  • Specify a template file to define columns
  • View created queries / functions and dependencies
  • Understand the created process of querying the folder
  • Extended exercise – introduce additional files and unwanted files

power-bi-icon_75Additional Study –Power Query M Formula Language

  • Overview of Power Query M Formula Language
  • Basics of Power Query M
  • Values, Records, Lists
  • Operators
  • Conditional Testing
  • Error handling
  • Accessing table data
  • More advanced Power Query M
  • Each Expression
  • Refer to other queries
  • Understand a web query
  • Remove Rows by Filter

 

student_sat

Average rating:  
 9735 reviews

Great Course as an introduction. Functions were explained in a simplified manner. Would recommend! - Power BI Beginner Melbourne

Page 1 of 9735:
«
 
 
1
2
3
 
»
 
Download Course Content Here