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

laptop

Pro Visualisations

browser-4

DAX in tabular models

analytics-4

Data Transformations

analytics-2

Business Intelligence


PowerBI Intermediate Graphic

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

Students will work on data transformations, measures, DAX, Row Level Security, using Power Query and creating Advanced Visualisations.

 


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 Intermediate

Upcoming Dates
Thu 20-Dec-18 Power BI Intermediate Sydney Course confirmed to run. Limited number of seats available.
Fri 11-Jan-19 Power BI Intermediate Sydney Course has been scheduled to run but has not been confirmed.
Tue 22-Jan-19 Power BI Intermediate Sydney Course has been scheduled to run but has not been confirmed.
Wed 13-Feb-19 Power BI Intermediate Sydney Course has been scheduled to run but has not been confirmed.
Thu 28-Feb-19 Power BI Intermediate Sydney Course has been scheduled to run but has not been confirmed.
Thu 21-Mar-19 Power BI Intermediate Sydney Course has been scheduled to run but has not been confirmed.
Wed 10-Apr-19 Power BI Intermediate Sydney Course has been scheduled to run but has not been confirmed.
Thu 23-May-19 Power BI Intermediate Sydney Course has been scheduled to run but has not been confirmed.
Tue 18-Jun-19 Power BI Intermediate 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 Intermediate

Upcoming Dates
Thu 13-Dec-18 Power BI Intermediate Melbourne Course confirmed to run. Trainer has been allocated.
Fri 11-Jan-19 Power BI Intermediate Melbourne Course has been scheduled to run but has not been confirmed.
Mon 21-Jan-19 Power BI Intermediate Melbourne Course confirmed to run. Trainer has been allocated.
Fri 01-Feb-19 Power BI Intermediate Melbourne Course has been scheduled to run but has not been confirmed.
Wed 06-Feb-19 Power BI Intermediate Melbourne Course has been scheduled to run but has not been confirmed.
Fri 22-Feb-19 Power BI Intermediate Melbourne Course has been scheduled to run but has not been confirmed.
Thu 21-Mar-19 Power BI Intermediate Melbourne Course has been scheduled to run but has not been confirmed.
Fri 29-Mar-19 Power BI Intermediate Melbourne Course has been scheduled to run but has not been confirmed.
Fri 26-Apr-19 Power BI Intermediate Melbourne Course has been scheduled to run but has not been confirmed.
Mon 06-May-19 Power BI Intermediate Melbourne Course has been scheduled to run but has not been confirmed.
Fri 17-May-19 Power BI Intermediate Melbourne Course has been scheduled to run but has not been confirmed.
Tue 21-May-19 Power BI Intermediate Melbourne Course has been scheduled to run but has not been confirmed.
Wed 19-Jun-19 Power BI Intermediate 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 Intermediate

Upcoming Dates
Wed 12-Dec-18 Power BI Intermediate Brisbane No more seats are available for this course.
Fri 11-Jan-19 Power BI Intermediate Brisbane No more seats are available for this course.
Wed 16-Jan-19 Power BI Intermediate Brisbane No more seats are available for this course.
Mon 21-Jan-19 Power BI Intermediate Brisbane Course confirmed to run. Limited number of seats available.
Wed 23-Jan-19 Power BI Intermediate Brisbane No more seats are available for this course.
Wed 30-Jan-19 Power BI Intermediate Brisbane No more seats are available for this course.
Fri 01-Feb-19 Power BI Intermediate Brisbane Course has been scheduled to run but has not been confirmed.
Wed 06-Feb-19 Power BI Intermediate Brisbane Course has been scheduled to run but has not been confirmed.
Thu 21-Feb-19 Power BI Intermediate Brisbane No more seats are available for this course.
Fri 22-Feb-19 Power BI Intermediate Brisbane Course has been scheduled to run but has not been confirmed.
Thu 21-Mar-19 Power BI Intermediate Brisbane Course has been scheduled to run but has not been confirmed.
Fri 29-Mar-19 Power BI Intermediate BrisBane Course has been scheduled to run but has not been confirmed.
Fri 26-Apr-19 Power BI Intermediate Brisbane Course has been scheduled to run but has not been confirmed.
Fri 17-May-19 Power BI Intermediate Brisbane Course has been scheduled to run but has not been confirmed.
Tue 21-May-19 Power BI Intermediate Brisbane Course has been scheduled to run but has not been confirmed.
Wed 19-Jun-19 Power BI Intermediate 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 Intermediate

Upcoming Dates
Fri 11-Jan-19 Power BI Intermediate Perth Course confirmed to run. Trainer has been allocated.
Tue 22-Jan-19 Power BI Intermediate Perth Course has been scheduled to run but has not been confirmed.
Wed 13-Feb-19 Power BI Intermediate Perth Course has been scheduled to run but has not been confirmed.
Thu 28-Feb-19 Power BI Intermediate Perth Course has been scheduled to run but has not been confirmed.
Thu 21-Mar-19 Power BI Intermediate Perth Course has been scheduled to run but has not been confirmed.
Wed 10-Apr-19 Power BI Intermediate Perth Course has been scheduled to run but has not been confirmed.
Thu 30-May-19 Power BI Intermediate Perth Course has been scheduled to run but has not been confirmed.
Tue 18-Jun-19 Power BI Intermediate 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 Intermediate

Upcoming Dates
Fri 11-Jan-19 Power BI Intermediate Adelaide Course has been scheduled to run but has not been confirmed.
Tue 22-Jan-19 Power BI Intermediate Adelaide Course has been scheduled to run but has not been confirmed.
Tue 19-Feb-19 Power BI Intermediate Adelaide Course has been scheduled to run but has not been confirmed.
Thu 28-Feb-19 Power BI Intermediate Adelaide Course has been scheduled to run but has not been confirmed.
Thu 21-Mar-19 Power BI Intermediate Adelaide Course has been scheduled to run but has not been confirmed.
Wed 10-Apr-19 Power BI Intermediate Adelaide Course has been scheduled to run but has not been confirmed.
Thu 30-May-19 Power BI Intermediate Adelaide Course has been scheduled to run but has not been confirmed.
Tue 18-Jun-19 Power BI Intermediate 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 Intermediate

Upcoming Dates
Wed 09-Jan-19 Power BI Intermediate Parramatta Course has been scheduled to run but has not been confirmed.
Tue 05-Feb-19 Power BI Intermediate Parramatta Course has been scheduled to run but has not been confirmed.
Wed 20-Feb-19 Power BI Intermediate Parramatta Course has been scheduled to run but has not been confirmed.
Mon 04-Mar-19 Power BI Intermediate Parramatta Course has been scheduled to run but has not been confirmed.
Fri 05-Apr-19 Power BI Intermediate Parramatta Course has been scheduled to run but has not been confirmed.
Mon 06-May-19 Power BI Intermediate Parramatta Course has been scheduled to run but has not been confirmed.
Fri 24-May-19 Power BI Intermediate Parramatta Course has been scheduled to run but has not been confirmed.
Tue 25-Jun-19 Power BI Intermediate 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 Intermediate

Upcoming Dates
Thu 13-Dec-18 Power BI Intermediate Canberra No more seats are available for this course.
Fri 11-Jan-19 Power BI Intermediate Canberra Course has been scheduled to run but has not been confirmed.
Tue 22-Jan-19 Power BI Intermediate Canberra Course confirmed to run. Trainer has been allocated.
Wed 13-Feb-19 Power BI Intermediate Canberra Course has been scheduled to run but has not been confirmed.
Thu 28-Feb-19 Power BI Intermediate Canberra Course has been scheduled to run but has not been confirmed.
Thu 21-Mar-19 Power BI Intermediate Canberra Course has been scheduled to run but has not been confirmed.
Wed 10-Apr-19 Power BI Intermediate Canberra Course has been scheduled to run but has not been confirmed.
Thu 23-May-19 Power BI Intermediate Canberra Course has been scheduled to run but has not been confirmed.
Tue 18-Jun-19 Power BI Intermediate 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 manipulate data and enrich data models to produce powerful interactive dashboards, on our One-day course. After the completion of this course you will be able to work with data from many sources, build calculations in the Data Model to produce intelligent, interactive Dashboards. You will be able to collaborate with colleagues and publish to the web.

What do I need to know to attend?
  • Source data from Excel and some other sources into Power BI service
  • Build reports and dashboards in Power BI, turn data into visuals, format visuals, filter data and visuals
  • Understand the basics of collaborating using Power BI (although not critical for this course)
  • Basic understanding of Power BI Desktop tool (don’t need to use regularly), how to source data and basic preparation of data

tasks

Learning Outcomes -Power BI Intermediate

On completion of this course you should be able to:

  • Understand self-service Business Intelligence
  • Understand Power Query
  • Know how to Transform Data
  • Create Custom Visuals
  • Understand the basics of DAX
  • Understand the basics of “M”
  • How to use Quick Measures
  • Sharing and Security on the Service
Course Details
  • circular-clockCourses will run from 9am – 4pm (approx.)
  • network-1Classes limited to approx 10 people
  • Power BI Intermediate 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_75Power BI

  • Overview
  • When to use Power BI
  • Online Services Power BI connects to
  • Databases Power BI connects to


power-bi-icon_75The BI Process

  • Overview
  • How Power BI fits

power-bi-icon_75Power Query

  • Power Query Process
  • Data Transformation Principles
  • Dimension and Fact Tables

power-bi-icon_75Power Query UI

  • Queries
  • Data View
  • Query Settings
  • Transformations Ribbon
  • M Language Area

power-bi-icon_75Data Source

  • Creating Tables of Data
  • Import Data from Excel
  • Import Data from Web
  • Rename and Group Queries
  • Import from OneDrive

power-bi-icon_75Column Transformations

  • Adding Custom Columns
  • Renaming Query Steps
  • Changing Text Data Column Case
  • Duplicating Columns
  • Renaming Columns
  • Splitting Columns
  • Creating Conditional Column
  • Creating Index Column
  • Reordering Columns
  • Navigate to Column Tool
  • Creating Date Column from Date/Time Columns

power-bi-icon_75Data Transformations

  • Removing rows from Tables
  • Use First Row as Headers
  • Filtering Data
  • Detect and change Data type
  • Filling Null area with Values
  • Trimming Text
  • Replacing Values

power-bi-icon_75Date Transformations

  • Parse Date Column
  • Extract Year
  • Extract Quarter
  • Extract Month
  • Extract Date

power-bi-icon_75Unpivot Data

  • Unpivot Columns
  • Unpivot other Columns
  • Unpivot Selected Columns

power-bi-icon_75Append and Merge Queries

  • Append Queries
  • Merge Queries
  • Merge Query Types

power-bi-icon_75Load Data

  • Including and Excluding Queries in Report Refresh
  • Enable and Disable Query Loading
  • Applying Queries
  • Viewing Query Dependencies

power-bi-icon_75Reinforcement Exercise 1

  • Pulling it all together

 


power-bi-icon_75Data Modelling

  • Introduction to Data Modelling
  • Relationship View
  • Hiding Tables in Report View
  • AutoDetect Relationships
  • Cardinality and Cross Filtering
  • Creating relationships through Manage Relationships
  • Changing Cross Filtering
  • Deleting relationships
  • Drag and drop to create relationships

power-bi-icon_75DAX

  • Introduction to DAX
  • M Language v DAX
  • Comparing Measures to Calculated Columns
  • SUM measures
  • Creating a Calculated Column using the IF function
  • Filter Propagation
  • Filter Context

power-bi-icon_75Functions

  • Functions identical to Excel
  • FORMAT function
  • Sorting Columns
  • Row Context
  • The ‘X’ functions
  • SUMX function
  • AVERAGEX function
  • CALCULATE function
  • DAX Logical Operators
  • CALCULATE with multiple filters
  • Using Measures in Visuals
  • CALCULATE with multiple filters
  • Create a measure using FILTER function
  • MINX function
  • COUNTAX function
  • ALL and ALLSELECTED functions

power-bi-icon_75Time Intelligence Functions

  • Functions that return a single date
  • Using FIRSTDATE function
  • Functions that return a table of dates
  • Using DATEADD function

power-bi-icon_75Quick Measures

  • Enabling Quick Measures
  • Quick Measure – YTD
  • Creating a Financial Year Measure
  • Creating a Quick Measure from a filter

power-bi-icon_75Advanced Visualisations

  • Create filters from Calculated Columns
  • Create variance measures
  • Waterfall chart
  • Drill down time series chart
  • Drill down bar chart
  • Drill down chart interaction
  • Scatter plot animation
  • Creating What IF Parameters
  • Using What IF Parameters
  • Enabling Q & A in Power BI Desktop
  • Create a visual with Q & A
  • Create a drill through process to a focussed report page
  • Using Bookmarks in Power BI Desktop
  • Using Cross Filtering in Reports
  • Using Spotlight for Visualizations

power-bi-icon_75Dynamic Web Queries Using Parameters

  • Importing a web query using parameters
  • Creating a custom function
  • Defining a List to create a new Query
  • Invoking custom functions
  • Using Error checking processes

power-bi-icon_75Reinforced Learning – DAX

  • Pulling it all together – DAX takes practice

 


power-bi-icon_75Power BI Service

  • Create Row Level Security
  • Test Row Level Security in Power BI Desktop
  • Create Multiple Filter Roles
  • Create Workspace Apps
  • Publish to a Workspace
  • Sharing Workspace apps
  • Testing Workspace App in the Power BI service
  • Assigning members to roles
  • Editing Workspace Apps
  • Creating reports in workspace apps
  • Getting Apps from your Organisation
  • Sharing to External Users through Microsoft Azure

power-bi-icon_75Extra Processes

  • Using the Group By feature
  • Removing Rows in a Query by Filtering when your data changes
  • Comparing Multiple Scenarios through Waterfall Charts

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