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

Course Details

  • Price: $595
  • 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
Tue 27-Aug-19 Power BI Intermediate Sydney No more seats are available for this course. FULL
Wed 04-Sep-19 Power BI Intermediate Sydney Course has been scheduled to run but has not been confirmed.BOOK
Thu 12-Sep-19 Power BI Intermediate Sydney Course confirmed to run. Trainer has been allocated.BOOK
Wed 18-Sep-19 Power BI Intermediate Sydney Course has been scheduled to run but has not been confirmed.BOOK
Fri 27-Sep-19 Power BI Intermediate Sydney Course confirmed to run. Trainer has been allocated.BOOK
Tue 08-Oct-19 Power BI Intermediate Sydney Course has been scheduled to run but has not been confirmed.BOOK
Tue 15-Oct-19 Power BI Intermediate Sydney Course has been scheduled to run but has not been confirmed.BOOK
Wed 23-Oct-19 Power BI Intermediate Sydney Course has been scheduled to run but has not been confirmed.BOOK
Thu 31-Oct-19 Power BI Intermediate Sydney Course has been scheduled to run but has not been confirmed.BOOK
Fri 15-Nov-19 Power BI Intermediate Sydney Course has been scheduled to run but has not been confirmed.BOOK
Tue 26-Nov-19 Power BI Intermediate Sydney Course has been scheduled to run but has not been confirmed.BOOK
Tue 03-Dec-19 Power BI Intermediate Sydney Course has been scheduled to run but has not been confirmed.BOOK
Wed 11-Dec-19 Power BI Intermediate Sydney Course has been scheduled to run but has not been confirmed.BOOK
Thu 19-Dec-19 Power BI Intermediate Sydney Course has been scheduled to run but has not been confirmed.BOOK
Tue 07-Jan-20 Power BI Intermediate Sydney Course has been scheduled to run but has not been confirmed.BOOK
Wed 22-Jan-20 Power BI Intermediate Sydney Course has been scheduled to run but has not been confirmed.BOOK
Fri 07-Feb-20 Power BI Intermediate Sydney Course has been scheduled to run but has not been confirmed.BOOK
Tue 18-Feb-20 Power BI Intermediate Sydney Course has been scheduled to run but has not been confirmed.BOOK
Wed 04-Mar-20 Power BI Intermediate Sydney Course has been scheduled to run but has not been confirmed.BOOK
Fri 13-Mar-20 Power BI Intermediate Sydney Course has been scheduled to run but has not been confirmed.BOOK
Thu 19-Mar-20 Power BI Intermediate Sydney Course has been scheduled to run but has not been confirmed.BOOK
Tue 31-Mar-20 Power BI Intermediate Sydney Course has been scheduled to run but has not been confirmed.BOOK
Wed 15-Apr-20 Power BI Intermediate Sydney Course has been scheduled to run but has not been confirmed.BOOK
Mon 20-Apr-20 Power BI Intermediate Sydney Course has been scheduled to run but has not been confirmed.BOOK
Wed 29-Apr-20 Power BI Intermediate Sydney Course has been scheduled to run but has not been confirmed.BOOK
Thu 30-Apr-20 Power BI Intermediate Sydney Course has been scheduled to run but has not been confirmed.BOOK
Fri 08-May-20 Power BI Intermediate Sydney Course has been scheduled to run but has not been confirmed.BOOK
Thu 14-May-20 Power BI Intermediate Sydney Course has been scheduled to run but has not been confirmed.BOOK
Tue 26-May-20 Power BI Intermediate Sydney Course has been scheduled to run but has not been confirmed.BOOK
Mon 01-Jun-20 Power BI Intermediate Sydney Course has been scheduled to run but has not been confirmed.BOOK
Wed 10-Jun-20 Power BI Intermediate Sydney Course has been scheduled to run but has not been confirmed.BOOK
Thu 25-Jun-20 Power BI Intermediate Sydney Course has been scheduled to run but has not been confirmed.BOOK
  • 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.

Course Details

  • Price: $595
  • 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
Tue 27-Aug-19 Power BI Intermediate Melbourne Course confirmed to run. Limited number of seats available.BOOK
Wed 04-Sep-19 Power BI Intermediate Melbourne Course confirmed to run. Limited number of seats available.BOOK
Wed 18-Sep-19 Power BI Intermediate Melbourne Course has been scheduled to run but has not been confirmed.BOOK
Tue 08-Oct-19 Power BI Intermediate Melbourne Course has been scheduled to run but has not been confirmed.BOOK
Tue 15-Oct-19 Power BI Intermediate Melbourne Course has been scheduled to run but has not been confirmed.BOOK
Wed 23-Oct-19 Power BI Intermediate Melbourne Course has been scheduled to run but has not been confirmed.BOOK
Thu 31-Oct-19 Power BI Intermediate Melbourne Course has been scheduled to run but has not been confirmed.BOOK
Fri 15-Nov-19 Power BI Intermediate Melbourne Course confirmed to run. Trainer has been allocated.BOOK
Mon 25-Nov-19 Power BI Intermediate Melbourne Course has been scheduled to run but has not been confirmed.BOOK
Tue 03-Dec-19 Power BI Intermediate Melbourne Course has been scheduled to run but has not been confirmed.BOOK
Wed 11-Dec-19 Power BI Intermediate Melbourne Course has been scheduled to run but has not been confirmed.BOOK
Thu 19-Dec-19 Power BI Intermediate Melbourne Course has been scheduled to run but has not been confirmed.BOOK
Tue 07-Jan-20 Power BI Intermediate Melbourne Course has been scheduled to run but has not been confirmed.BOOK
Wed 22-Jan-20 Power BI Intermediate Melbourne Course has been scheduled to run but has not been confirmed.BOOK
Fri 07-Feb-20 Power BI Intermediate Melbourne Course has been scheduled to run but has not been confirmed.BOOK
Tue 18-Feb-20 Power BI Intermediate Melbourne Course has been scheduled to run but has not been confirmed.BOOK
Wed 04-Mar-20 Power BI Intermediate Melbourne Course has been scheduled to run but has not been confirmed.BOOK
Fri 13-Mar-20 Power BI Intermediate Melbourne Course has been scheduled to run but has not been confirmed.BOOK
Thu 19-Mar-20 Power BI Intermediate Melbourne Course has been scheduled to run but has not been confirmed.BOOK
Tue 31-Mar-20 Power BI Intermediate Melbourne Course has been scheduled to run but has not been confirmed.BOOK
Wed 15-Apr-20 Power BI Intermediate Melbourne Course has been scheduled to run but has not been confirmed.BOOK
Mon 20-Apr-20 Power BI Intermediate Melbourne Course has been scheduled to run but has not been confirmed.BOOK
Wed 29-Apr-20 Power BI Intermediate Melbourne Course has been scheduled to run but has not been confirmed.BOOK
Thu 30-Apr-20 Power BI Intermediate Melbourne Course has been scheduled to run but has not been confirmed.BOOK
Fri 08-May-20 Power BI Intermediate Melbourne Course has been scheduled to run but has not been confirmed.BOOK
Thu 14-May-20 Power BI Intermediate Melbourne Course has been scheduled to run but has not been confirmed.BOOK
Tue 26-May-20 Power BI Intermediate Melbourne Course has been scheduled to run but has not been confirmed.BOOK
Mon 01-Jun-20 Power BI Intermediate Melbourne Course has been scheduled to run but has not been confirmed.BOOK
Wed 10-Jun-20 Power BI Intermediate Melbourne Course has been scheduled to run but has not been confirmed.BOOK
Thu 25-Jun-20 Power BI Intermediate Melbourne Course has been scheduled to run but has not been confirmed.BOOK
  • 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.

Course Details

  • Price: $595
  • 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
Tue 27-Aug-19 Power BI Intermediate Brisbane No more seats are available for this course. FULL
Wed 04-Sep-19 Power BI Intermediate Brisbane Course confirmed to run. Trainer has been allocated.BOOK
Thu 12-Sep-19 Power BI Intermediate Brisbane Course confirmed to run. Limited number of seats available.BOOK
Fri 20-Sep-19 Power BI Intermediate Brisbane Course has been scheduled to run but has not been confirmed.BOOK
Fri 27-Sep-19 Power BI Intermediate Brisbane Course has been scheduled to run but has not been confirmed.BOOK
Tue 08-Oct-19 Power BI Intermediate Brisbane Course has been scheduled to run but has not been confirmed.BOOK
Tue 15-Oct-19 Power BI Intermediate Brisbane Course has been scheduled to run but has not been confirmed.BOOK
Wed 23-Oct-19 Power BI Intermediate Brisbane Course has been scheduled to run but has not been confirmed.BOOK
Thu 31-Oct-19 Power BI Intermediate Brisbane Course has been scheduled to run but has not been confirmed.BOOK
Fri 15-Nov-19 Power BI Intermediate Brisbane Course has been scheduled to run but has not been confirmed.BOOK
Mon 25-Nov-19 Power BI Intermediate Brisbane Course has been scheduled to run but has not been confirmed.BOOK
Tue 03-Dec-19 Power BI Intermediate Brisbane Course has been scheduled to run but has not been confirmed.BOOK
Wed 11-Dec-19 Power BI Intermediate Brisbane Course has been scheduled to run but has not been confirmed.BOOK
Thu 19-Dec-19 Power BI Intermediate Brisbane Course has been scheduled to run but has not been confirmed.BOOK
Tue 07-Jan-20 Power BI Intermediate Brisbane Course has been scheduled to run but has not been confirmed.BOOK
Wed 22-Jan-20 Power BI Intermediate Brisbane Course has been scheduled to run but has not been confirmed.BOOK
Fri 07-Feb-20 Power BI Intermediate Brisbane Course has been scheduled to run but has not been confirmed.BOOK
Tue 18-Feb-20 Power BI Intermediate Brisbane Course has been scheduled to run but has not been confirmed.BOOK
Wed 04-Mar-20 Power BI Intermediate Brisbane Course has been scheduled to run but has not been confirmed.BOOK
Fri 13-Mar-20 Power BI Intermediate Brisbane Course has been scheduled to run but has not been confirmed.BOOK
Thu 19-Mar-20 Power BI Intermediate Brisbane Course has been scheduled to run but has not been confirmed.BOOK
Tue 31-Mar-20 Power BI Intermediate Brisbane Course has been scheduled to run but has not been confirmed.BOOK
Wed 15-Apr-20 Power BI Intermediate Brisbane Course has been scheduled to run but has not been confirmed.BOOK
Mon 20-Apr-20 Power BI Intermediate Brisbane Course has been scheduled to run but has not been confirmed.BOOK
Wed 29-Apr-20 Power BI Intermediate Brisbane Course has been scheduled to run but has not been confirmed.BOOK
Thu 30-Apr-20 Power BI Intermediate Brisbane Course has been scheduled to run but has not been confirmed.BOOK
Fri 08-May-20 Power BI Intermediate Brisbane Course has been scheduled to run but has not been confirmed.BOOK
Thu 14-May-20 Power BI Intermediate Brisbane Course has been scheduled to run but has not been confirmed.BOOK
Tue 26-May-20 Power BI Intermediate Brisbane Course has been scheduled to run but has not been confirmed.BOOK
Mon 01-Jun-20 Power BI Intermediate Brisbane Course has been scheduled to run but has not been confirmed.BOOK
Wed 10-Jun-20 Power BI Intermediate Brisbane Course has been scheduled to run but has not been confirmed.BOOK
Thu 25-Jun-20 Power BI Intermediate Brisbane Course has been scheduled to run but has not been confirmed.BOOK
  • 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.

Course Details

  • Price: $595
  • 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
Tue 03-Sep-19 Power BI Intermediate Perth Course confirmed to run. Limited number of seats available.BOOK
Tue 10-Sep-19 Power BI Intermediate Perth Course confirmed to run. Limited number of seats available.BOOK
Wed 18-Sep-19 Power BI Intermediate Perth Course confirmed to run. Limited number of seats available.BOOK
Thu 03-Oct-19 Power BI Intermediate Perth Course has been scheduled to run but has not been confirmed.BOOK
Fri 18-Oct-19 Power BI Intermediate Perth Course has been scheduled to run but has not been confirmed.BOOK
Wed 30-Oct-19 Power BI Intermediate Perth Course has been scheduled to run but has not been confirmed.BOOK
Tue 19-Nov-19 Power BI Intermediate Perth Course has been scheduled to run but has not been confirmed.BOOK
Wed 04-Dec-19 Power BI Intermediate Perth Course has been scheduled to run but has not been confirmed.BOOK
Thu 19-Dec-19 Power BI Intermediate Perth Course has been scheduled to run but has not been confirmed.BOOK
Tue 07-Jan-20 Power BI Intermediate Perth Course has been scheduled to run but has not been confirmed.BOOK
Wed 22-Jan-20 Power BI Intermediate Perth Course has been scheduled to run but has not been confirmed.BOOK
Wed 19-Feb-20 Power BI Intermediate Perth Course has been scheduled to run but has not been confirmed.BOOK
Tue 03-Mar-20 Power BI Intermediate Perth Course has been scheduled to run but has not been confirmed.BOOK
Wed 18-Mar-20 Power BI Intermediate Perth Course has been scheduled to run but has not been confirmed.BOOK
Thu 02-Apr-20 Power BI Intermediate Perth Course has been scheduled to run but has not been confirmed.BOOK
Wed 15-Apr-20 Power BI Intermediate Perth Course has been scheduled to run but has not been confirmed.BOOK
Tue 28-Apr-20 Power BI Intermediate Perth Course has been scheduled to run but has not been confirmed.BOOK
Fri 15-May-20 Power BI Intermediate Perth Course has been scheduled to run but has not been confirmed.BOOK
Thu 28-May-20 Power BI Intermediate Perth Course has been scheduled to run but has not been confirmed.BOOK
Wed 10-Jun-20 Power BI Intermediate Perth Course has been scheduled to run but has not been confirmed.BOOK
Fri 26-Jun-20 Power BI Intermediate Perth Course has been scheduled to run but has not been confirmed.BOOK
  • 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.

Course Details

  • Price: $595
  • 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
Tue 03-Sep-19 Power BI Intermediate Adelaide Course confirmed to run. Trainer has been allocated.BOOK
Wed 18-Sep-19 Power BI Intermediate Adelaide Course has been scheduled to run but has not been confirmed.BOOK
Thu 03-Oct-19 Power BI Intermediate Adelaide Course has been scheduled to run but has not been confirmed.BOOK
Fri 18-Oct-19 Power BI Intermediate Adelaide Course has been scheduled to run but has not been confirmed.BOOK
Wed 30-Oct-19 Power BI Intermediate Adelaide Course has been scheduled to run but has not been confirmed.BOOK
Tue 19-Nov-19 Power BI Intermediate Adelaide Course has been scheduled to run but has not been confirmed.BOOK
Wed 04-Dec-19 Power BI Intermediate Adelaide Course has been scheduled to run but has not been confirmed.BOOK
Thu 19-Dec-19 Power BI Intermediate Adelaide Course has been scheduled to run but has not been confirmed.BOOK
Tue 07-Jan-20 Power BI Intermediate Adelaide Course has been scheduled to run but has not been confirmed.BOOK
Wed 22-Jan-20 Power BI Intermediate Adelaide Course has been scheduled to run but has not been confirmed.BOOK
Wed 19-Feb-20 Power BI Intermediate Adelaide Course has been scheduled to run but has not been confirmed.BOOK
Tue 03-Mar-20 Power BI Intermediate Adelaide Course has been scheduled to run but has not been confirmed.BOOK
Wed 18-Mar-20 Power BI Intermediate Adelaide Course has been scheduled to run but has not been confirmed.BOOK
Thu 02-Apr-20 Power BI Intermediate Adelaide Course has been scheduled to run but has not been confirmed.BOOK
Wed 15-Apr-20 Power BI Intermediate Adelaide Course has been scheduled to run but has not been confirmed.BOOK
Tue 28-Apr-20 Power BI Intermediate Adelaide Course has been scheduled to run but has not been confirmed.BOOK
Wed 13-May-20 Power BI Intermediate Adelaide Course has been scheduled to run but has not been confirmed.BOOK
Tue 26-May-20 Power BI Intermediate Adelaide Course has been scheduled to run but has not been confirmed.BOOK
Wed 10-Jun-20 Power BI Intermediate Adelaide Course has been scheduled to run but has not been confirmed.BOOK
Tue 23-Jun-20 Power BI Intermediate Adelaide Course has been scheduled to run but has not been confirmed.BOOK
  • 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.

Course Details

  • Price: $595
  • 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
Tue 03-Sep-19 Power BI Intermediate Parramatta Course confirmed to run. Trainer has been allocated.BOOK
Thu 03-Oct-19 Power BI Intermediate Parramatta Course has been scheduled to run but has not been confirmed.BOOK
Fri 18-Oct-19 Power BI Intermediate Parramatta Course has been scheduled to run but has not been confirmed.BOOK
Wed 30-Oct-19 Power BI Intermediate Parramatta Course has been scheduled to run but has not been confirmed.BOOK
Tue 19-Nov-19 Power BI Intermediate Parramatta Course has been scheduled to run but has not been confirmed.BOOK
Wed 04-Dec-19 Power BI Intermediate Parramatta Course has been scheduled to run but has not been confirmed.BOOK
Thu 19-Dec-19 Power BI Intermediate Parramatta Course has been scheduled to run but has not been confirmed.BOOK
Tue 07-Jan-20 Power BI Intermediate Parramatta Course has been scheduled to run but has not been confirmed.BOOK
Wed 22-Jan-20 Power BI Intermediate Parramatta Course has been scheduled to run but has not been confirmed.BOOK
Wed 19-Feb-20 Power BI Intermediate Parramatta Course has been scheduled to run but has not been confirmed.BOOK
Tue 03-Mar-20 Power BI Intermediate Parramatta Course has been scheduled to run but has not been confirmed.BOOK
Wed 18-Mar-20 Power BI Intermediate Parramatta Course has been scheduled to run but has not been confirmed.BOOK
Thu 02-Apr-20 Power BI Intermediate Parramatta Course has been scheduled to run but has not been confirmed.BOOK
Wed 15-Apr-20 Power BI Intermediate Parramatta Course has been scheduled to run but has not been confirmed.BOOK
Tue 28-Apr-20 Power BI Intermediate Parramatta Course has been scheduled to run but has not been confirmed.BOOK
Wed 13-May-20 Power BI Intermediate Parramatta Course has been scheduled to run but has not been confirmed.BOOK
Thu 28-May-20 Power BI Intermediate Parramatta Course has been scheduled to run but has not been confirmed.BOOK
Wed 10-Jun-20 Power BI Intermediate Parramatta Course has been scheduled to run but has not been confirmed.BOOK
Fri 26-Jun-20 Power BI Intermediate Parramatta Course has been scheduled to run but has not been confirmed.BOOK
  • 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.

Course Details

  • Price: $595
  • 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 18-Sep-19 Power BI Intermediate Canberra Course has been scheduled to run but has not been confirmed.BOOK
Thu 03-Oct-19 Power BI Intermediate Canberra Course has been scheduled to run but has not been confirmed.BOOK
Fri 18-Oct-19 Power BI Intermediate Canberra Course has been scheduled to run but has not been confirmed.BOOK
Wed 30-Oct-19 Power BI Intermediate Canberra Course has been scheduled to run but has not been confirmed.BOOK
Tue 19-Nov-19 Power BI Intermediate Canberra Course has been scheduled to run but has not been confirmed.BOOK
Wed 04-Dec-19 Power BI Intermediate Canberra Course has been scheduled to run but has not been confirmed.BOOK
Thu 19-Dec-19 Power BI Intermediate Canberra Course has been scheduled to run but has not been confirmed.BOOK
Tue 07-Jan-20 Power BI Intermediate Canberra Course has been scheduled to run but has not been confirmed.BOOK
Wed 22-Jan-20 Power BI Intermediate Canberra Course has been scheduled to run but has not been confirmed.BOOK
Wed 19-Feb-20 Power BI Intermediate Canberra Course has been scheduled to run but has not been confirmed.BOOK
Tue 03-Mar-20 Power BI Intermediate Canberra Course has been scheduled to run but has not been confirmed.BOOK
Wed 18-Mar-20 Power BI Intermediate Canberra Course has been scheduled to run but has not been confirmed.BOOK
Thu 02-Apr-20 Power BI Intermediate Canberra Course has been scheduled to run but has not been confirmed.BOOK
Wed 15-Apr-20 Power BI Intermediate Canberra Course has been scheduled to run but has not been confirmed.BOOK
Tue 28-Apr-20 Power BI Intermediate Canberra Course has been scheduled to run but has not been confirmed.BOOK
Fri 15-May-20 Power BI Intermediate Canberra Course has been scheduled to run but has not been confirmed.BOOK
Tue 26-May-20 Power BI Intermediate Canberra Course has been scheduled to run but has not been confirmed.BOOK
Wed 10-Jun-20 Power BI Intermediate Canberra Course has been scheduled to run but has not been confirmed.BOOK
Tue 23-Jun-20 Power BI Intermediate Canberra Course has been scheduled to run but has not been confirmed.BOOK
  • 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 $595
  • 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

  • An introduction to the different Power BI Products
  • When to use Power BI Desktop
  • Power BI licensing
  • Online Services Power BI connects to
  • Databases Power BI connects to


power-bi-icon_75The BI Process

  • The Business Intelligence process
  • How Power BI relates to the standard BI processes.


power-bi-icon_75Data Model & Transformation

  • The Power Query process
  • Data transformation principles
  • Manual data clean-up example
  • A demonstration of how Power Query helps with efficient use of data query
  • Dimension and Fact Tables
  • Data Model considerations
  • Common Data Models

power-bi-icon_75Power Query UI

  • Queries Area
  • Data section
  • The Transformations Ribbons
  • Query Settings Area
  • M Language Area

power-bi-icon_75Data Source

  • Introduction to the data source used in this course
  • Creating Tables of Data
  • Import data from Excel
  • Import data from Web
  • Renaming Queries
  • Grouping Queries

power-bi-icon_75Column Transformations

  • Adding Custom Columns
  • Renaming Query Steps
  • Changing Text Data Column Case
  • Duplicating Columns
  • Renaming Columns
  • Splitting Columns
  • Creating Conditional Columns
  • Creating Index columns
  • Reordering Columns
  • Using the Navigate to Column tool
  • Creating Date columns 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

  • Disabling Auto Date/Time
  • Extracting year
  • Extracting quarter
  • Extracting month
  • Extracting date
  • Filter dates

power-bi-icon_75Unpivot Data

  • Unpivot Columns

power-bi-icon_75

Append and Merge Queries

  • Append Queries
  • Merge Queries
  • Merge Query Types
  • Cleaning the resulting query

power-bi-icon_75Load Data

  • Including and Excluding Queries in report refresh
  • Enabling or disabling Query loading
  • Applying Queries
  • Viewing Query dependencies

power-bi-icon_75Data Modelling

  • Introduction to data modelling
  • Relationship view
  • Auto detecting 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
  • Comparing M Language to DAX
  • Comparing Measures to Calculated Columns
  • Referring to and Using Measures and Calculated Columns
  • Creating a simple SUM measure
  • Creating a Calculated column using the IF function
  • Simple DAX functions
  • The X Functions as iterators
  • Comparing SUM to SUMX
  • A use for AVERAGEX

power-bi-icon_75Quick Measures

  • Introduction to Quick Measures
  • Quick Measure Categories
  • Aggregate per Category
  • Filters
  • Fine tuning the Quick Measure
  • Totals
  • Arithmetic
  • Text

power-bi-icon_75Time Intelligence Functions

  • Visuals for Date / Time Reporting
  • Create a column for abbreviated month
  • Mark as Date Table
  • Quick Measure for Year to Date
  • Quick Measure for YTD with different year end
  • Quick Measure on an existing measure using YTD

power-bi-icon_75Advanced Visualisations

  • Introduction to Waterfall charts
  • Create variance measures
  • Using variance measures in a Waterfall chart
  • Create drill down time series chart
  • Drill down chart interaction
  • Create drill down bar chart
  • Creating What if Parameters
  • Using What if parameters in a chart
  • Enabling Q & A in Power BI Desktop
  • Create a visual with Q & A
  • Using Bookmarks in Power BI Desktop
  • Bookmarks to filter data
  • Bookmarks to change visuals
  • Add buttons to access bookmarks

power-bi-icon_75Secure and Share Data

  • Introduction to Row Level Security
  • Create Row Level Security roles
  • Test Row Level Security in Power BI Desktop
  • Overview of Online Sharing
  • Create Workspace Apps
  • Publish to a Workspace
  • Sharing workspace apps
  • Testing Workspace App in the Power BI service
  • Testing RLS in the App
  • Assigning Members to roles
  • Editing Workspace Apps
  • Creating reports in workspace apps
  • Delete Workspaces
  • Unpublish App

power-bi-icon_75Extended Topic A – Transformations

  • Opening files and checking connections
  • Examine the underlying data
  • Find and Replace
  • Unpivot & Rename

power-bi-icon_75Extended Topic B – Query Parameters (Dynamic Web Query)

  • 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
  • Cleaning queries
  • Create measures and visualise queried data

power-bi-icon_75Extended Topic C – Group by

  • Using the Group By feature

power-bi-icon_75Data Normalisation Appendix

  • The Normal Forms
  • 1st Normal Form
  • 2nd Normal Form
  • 3rd Normal Form
  • Primary Key
  • Relationships

student_sat
Average rating:  
 14655 reviews

Well Done. informative. - Power BI Beginner

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