Work through our specifically designed Power BI Advanced training course to build and understand:

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

 


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 24-Oct-18 Power BI Advanced Sydney Course confirmed to run. Trainer has been allocated.
Wed 14-Nov-18 Power BI Advanced Sydney Course has been scheduled to run but has not been confirmed.
Fri 07-Dec-18 Power BI Advanced Sydney Course has been scheduled to run but has not been confirmed.
Wed 23-Jan-19 Power BI Advanced Sydney Course has been scheduled to run but has not been confirmed.
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
Fri 26-Oct-18 Power BI Advanced Melbourne Course confirmed to run. Limited number of seats available.
Fri 09-Nov-18 Power BI Advanced Melbourne Course has been scheduled to run but has not been confirmed.
Fri 30-Nov-18 Power BI Advanced Melbourne Course has been scheduled to run but has not been confirmed.
Thu 06-Dec-18 Power BI Advanced Melbourne Course has been scheduled to run but has not been confirmed.
Tue 22-Jan-19 Power BI Advanced Melbourne Course has been scheduled to run but has not been confirmed.
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
Tue 06-Nov-18 Power BI Advanced Brisbane Course confirmed to run. Trainer has been allocated.
Fri 16-Nov-18 Power BI Advanced Brisbane Course confirmed to run. Limited number of seats available.
Wed 19-Dec-18 Power BI Advanced Brisbane Course has been scheduled to run but has not been confirmed.
Tue 22-Jan-19 Power BI Advanced Brisbane Course has been scheduled to run but has not been confirmed.
Mon 04-Feb-19 Power BI Advanced Brisbane Course has been scheduled to run but has not been confirmed.
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 05-Dec-18 Power BI Advanced Perth Course has been scheduled to run but has not been confirmed.
Wed 23-Jan-19 Power BI Advanced Perth Course has been scheduled to run but has not been confirmed.
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
Thu 06-Dec-18 Power BI Advanced Adelaide Course confirmed to run. Limited number of seats available.
Wed 23-Jan-19 Power BI Advanced Adelaide Course has been scheduled to run but has not been confirmed.
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
Wed 17-Oct-18 Power BI Advanced Parramatta Course has been scheduled to run but has not been confirmed.
Fri 02-Nov-18 Power BI Advanced Parramatta Course has been scheduled to run but has not been confirmed.
Thu 29-Nov-18 Power BI Advanced Parramatta Course has been scheduled to run but has not been confirmed.
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
Tue 23-Oct-18 Power BI Advanced Canberra Course confirmed to run. Trainer has been allocated.
Thu 15-Nov-18 Power BI Advanced Canberra Course has been scheduled to run but has not been confirmed.
Thu 06-Dec-18 Power BI Advanced Canberra Course has been scheduled to run but has not been confirmed.
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 Modelling

  • Introduction to Business Intelligence
  • Data Model efficiency & design objectives
  • Data Model Considerations
  • The Star Schema
  • The Snow Flake Schema
  • Other Data Model Options
  • Fact and Dimension table objectives

power-bi-icon_75Intro to Data Analysis eXpression (DAX) 

  • Introduction to DAX
  • Learning DAX
  • Advice when creating DAX
  • Third party tools to assist
  • Dos and Don’ts of DAX
  • The Rules of Evaluation

power-bi-icon_75DAX – Contents

  • Overview of contexts in DAX
  • The Filter Context
  • The Row Context
  • Initial Filter (Query) context
  • Initial Row context
  • Complexity of DAX

power-bi-icon_75DAX – Contexts & Relationships

  • Measures Table
  • Introduction to the dataset
  • Create a measures table and new measures in this table
  • 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 existing filter context
  • The FILTER function
  • 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

  • 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
  • The LOOKUPVALUE function
  • The RELATED function
  • An alternative using an aggregator and why it works

power-bi-icon_75DAX – Functions & Filter

  • Common time intelligence functions
  • Creating our own time intelligence code
  • Date hierarchy in Power BI
  • Create a time intelligence measure
  • The arguments of the DAX YTD function
  • Format of year end date
  • Totals in the matrix
  • Understand the FILTER function – the filter and row contexts within this function
  • Create our own YTD function
  • Why we used an aggregator
  • Extended exercise – totals and using in VALUES

power-bi-icon_75DAX – Multiple Date Columns

  • Overview of multiple dates
  • Import additional date data to our model
  • Creating inactive relationships
  • Activating relationships using USERRELATIONSHIP
  • Using inactive relationships in time intelligence

power-bi-icon_75DAX – Row Context

  • Overview of the row context
  • Simple calculated columns
  • A filter in a calculated column
  • Using FILTER and ALL in the row context
  • Context within CALCULATE
  • Nested row contexts and EARLIER
  • Use EARLIER in a column
  • Simplifying the use of CALCULATE

power-bi-icon_75DAX – Variables & Measures

  • Overview of variables in DAX
  • Features of variables
  • Extend a hard coded expression to use a variable
  • Use variable correctly
  • Use variable with nested row contexts
  • Location of variable evaluation
  • Re-using measures
  • Extend a hard coded expression to use a variable
  • Implicit CALCULATE in measures

power-bi-icon_75DAX – Unrelated Table

  • Overview of using unrelated tables
  • The TREATAS function
  • Table creation and alternatives
  • Create measure using TREATAS to filter from unrelated table
  • Create dynamic display units measure based on slicer

power-bi-icon_75Data Sources – Databases

  • Overview of Databases
  • Introduction to Direct Query
  • Import v Direct Query
  • Import from SQL Azure
  • Data update from SQL Azure
  • Refresh and credentials
  • Schedule Refresh
  • Data updates
  • Direct Query from SQL Azure
  • Data Refresh in DQ
  • Scheduled Cache Refresh

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 – Data Gateway

  • Overview of Data Gateway
  • Data Gateway modes
  • Overview of on-premises
  • Overview of personal mode
  • Download and install the Gateway
  • Configure data sources
  • Observe Data Gateway on PC and connected to Power BI Service
  • Query web data
  • Transform data from web
  • Add refresh timestamp to report
  • Publish to Power BI Service and verify refresh
  • Setup dataset credentials
  • Observe frequent data updates

power-bi-icon_75Data Sources – Streaming

  • Overview of real time streaming data sources
  • Introduction to Push Datasets and Streaming Datasets
  • Uploading Data to Power BI
  • 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

power-bi-icon_75Row Level Security

  • Overview of RLS in Power BI
  • Create dynamic RLS using USERNAME or USERPRINCIPALNAME
  • Load data and enable RLS
  • Publish and assign roles in Power BI Service
  • Testing dynamic RLS in Desktop
  • Allow super users to access all data
  • Security filter direction in RLS
  • Allow data access according to organisation hierarchy

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
  • Own Data Table with a datekey
  • Mark as Date Table feature
  • Download or create a date table
  • 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

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

  • Overview of Power Query M Formula Language
  • 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

 

student_sat

Average rating:  
 8628 reviews

Excellent content and delivery great examples and easy to follow. - SharePoint Site Owner Melbourne

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