All courses available in-class or via remote login

power bi courses nexacu
Power BI Nexacu

Microsoft Power BI Intermediate Training Courses

Learn to work with data, measures, Power Query and more in Power BI.

All courses available in-class or remotely.
To attend remotely, select "Remote Online" as your location on book now.

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

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. View our full Power BI Intermediate course outline below.

Microsoft Power BI Intermediate Training Courses

4.71
see reviews
Power BI Nexacu

Learn to build data models and calculations to produce intelligent dashboards. In-class and remote training.

$595
10 max
1 day
$595
10 max
1 day
$595
10 max
1 day
$595
10 max
1 day
$595
10 max
1 day
$595
10 max
1 day
$595
10 max
1 day
$595
10 max
1 day

Remote

Brisbane

Sydney

Parramatta

Melbourne

Canberra

Adelaide

Perth

Upcoming Courses:
Remote Online
Date
Course
City
Status
Thu 28-Jan-21
Thu 28 Jan
Power BI Intermediate
Remote Online
Status: Confirmed
Confirmed
Book Now
Thu 4-Feb-21
Thu 4 Feb
Power BI Intermediate
Remote Online
Status: Confirmed
Confirmed
Book Now
Tue 9-Feb-21
Tue 9 Feb
Power BI Intermediate
Remote Online
Status: Confirmed
Confirmed
Book Now
Mon 15-Feb-21
Mon 15 Feb
Power BI Intermediate
Remote Online
Status: Confirmed
Confirmed
Book Now
Wed 17-Feb-21
Wed 17 Feb
Power BI Intermediate
Remote Online
Status: Confirmed
Confirmed
Book Now
Thu 18-Feb-21
Thu 18 Feb
Power BI Intermediate
Remote Online
Status: Confirmed
Confirmed
Book Now
Wed 24-Feb-21
Wed 24 Feb
Power BI Intermediate
Remote Online
Status: Confirmed
Confirmed
Book Now
Wed 3-Mar-21
Wed 3 Mar
Power BI Intermediate
Remote Online
Status: Confirmed
Confirmed
Book Now
Fri 12-Mar-21
Fri 12 Mar
Power BI Intermediate
Remote Online
Status: Scheduled
Scheduled
Book Now
Mon 15-Mar-21
Mon 15 Mar
Power BI Intermediate
Remote Online
Status: Scheduled
Scheduled
Book Now
Thu 18-Mar-21
Thu 18 Mar
Power BI Intermediate
Remote Online
Status: Scheduled
Scheduled
Book Now
Fri 19-Mar-21
Fri 19 Mar
Power BI Intermediate
Remote Online
Status: Scheduled
Scheduled
Book Now
Fri 26-Mar-21
Fri 26 Mar
Power BI Intermediate
Remote Online
Status: Scheduled
Scheduled
Book Now
Tue 30-Mar-21
Tue 30 Mar
Power BI Intermediate
Remote Online
Status: Scheduled
Scheduled
Book Now
Fri 9-Apr-21
Fri 9 Apr
Power BI Intermediate
Remote Online
Status: Scheduled
Scheduled
Book Now
Brisbane
Date
Course
City
Status
Thu 28-Jan-21
Thu 28 Jan
Power BI Intermediate
Brisbane
Status: Confirmed
Confirmed
Book Now
Tue 9-Feb-21
Tue 9 Feb
Power BI Intermediate
Brisbane
Status: Confirmed
Confirmed
Book Now
Mon 22-Feb-21
Mon 22 Feb
Power BI Intermediate
Brisbane
Status: Scheduled
Scheduled
Book Now
Wed 3-Mar-21
Wed 3 Mar
Power BI Intermediate
Brisbane
Status: Scheduled
Scheduled
Book Now
Mon 15-Mar-21
Mon 15 Mar
Power BI Intermediate
Brisbane
Status: Scheduled
Scheduled
Book Now
Thu 18-Mar-21
Thu 18 Mar
Power BI Intermediate
Brisbane
Status: Scheduled
Scheduled
Book Now
Tue 30-Mar-21
Tue 30 Mar
Power BI Intermediate
Brisbane
Status: Scheduled
Scheduled
Book Now
Fri 9-Apr-21
Fri 9 Apr
Power BI Intermediate
Brisbane
Status: Scheduled
Scheduled
Book Now
Wed 14-Apr-21
Wed 14 Apr
Power BI Intermediate
Brisbane
Status: Scheduled
Scheduled
Book Now
Fri 16-Apr-21
Fri 16 Apr
Power BI Intermediate
Brisbane
Status: Scheduled
Scheduled
Book Now
Tue 27-Apr-21
Tue 27 Apr
Power BI Intermediate
Brisbane
Status: Scheduled
Scheduled
Book Now
Thu 6-May-21
Thu 6 May
Power BI Intermediate
Brisbane
Status: Scheduled
Scheduled
Book Now
Fri 14-May-21
Fri 14 May
Power BI Intermediate
Brisbane
Status: Scheduled
Scheduled
Book Now
Wed 19-May-21
Wed 19 May
Power BI Intermediate
Brisbane
Status: Scheduled
Scheduled
Book Now
Tue 25-May-21
Tue 25 May
Power BI Intermediate
Brisbane
Status: Scheduled
Scheduled
Book Now
Sydney
Date
Course
City
Status
Wed 24-Feb-21
Wed 24 Feb
Power BI Intermediate
Sydney
Status: Confirmed
Confirmed
Book Now
Fri 19-Mar-21
Fri 19 Mar
Power BI Intermediate
Sydney
Status: Scheduled
Scheduled
Book Now
Tue 27-Apr-21
Tue 27 Apr
Power BI Intermediate
Sydney
Status: Scheduled
Scheduled
Book Now
Thu 13-May-21
Thu 13 May
Power BI Intermediate
Sydney
Status: Scheduled
Scheduled
Book Now
Tue 25-May-21
Tue 25 May
Power BI Intermediate
Sydney
Status: Scheduled
Scheduled
Book Now
Thu 10-Jun-21
Thu 10 Jun
Power BI Intermediate
Sydney
Status: Scheduled
Scheduled
Book Now
Tue 6-Jul-21
Tue 6 Jul
Power BI Intermediate
Sydney
Status: Scheduled
Scheduled
Book Now
Tue 20-Jul-21
Tue 20 Jul
Power BI Intermediate
Sydney
Status: Scheduled
Scheduled
Book Now
Mon 16-Aug-21
Mon 16 Aug
Power BI Intermediate
Sydney
Status: Scheduled
Scheduled
Book Now
Mon 30-Aug-21
Mon 30 Aug
Power BI Intermediate
Sydney
Status: Scheduled
Scheduled
Book Now
Parramatta
Date
Course
City
Status
Wed 17-Feb-21
Wed 17 Feb
Power BI Intermediate
Parramatta
Status: Confirmed
Confirmed
Book Now
Fri 12-Mar-21
Fri 12 Mar
Power BI Intermediate
Parramatta
Status: Scheduled
Scheduled
Book Now
Fri 26-Mar-21
Fri 26 Mar
Power BI Intermediate
Parramatta
Status: Scheduled
Scheduled
Book Now
Tue 20-Apr-21
Tue 20 Apr
Power BI Intermediate
Parramatta
Status: Scheduled
Scheduled
Book Now
Thu 6-May-21
Thu 6 May
Power BI Intermediate
Parramatta
Status: Scheduled
Scheduled
Book Now
Tue 18-May-21
Tue 18 May
Power BI Intermediate
Parramatta
Status: Scheduled
Scheduled
Book Now
Thu 3-Jun-21
Thu 3 Jun
Power BI Intermediate
Parramatta
Status: Scheduled
Scheduled
Book Now
Wed 30-Jun-21
Wed 30 Jun
Power BI Intermediate
Parramatta
Status: Scheduled
Scheduled
Book Now
Fri 9-Jul-21
Fri 9 Jul
Power BI Intermediate
Parramatta
Status: Scheduled
Scheduled
Book Now
Tue 27-Jul-21
Tue 27 Jul
Power BI Intermediate
Parramatta
Status: Scheduled
Scheduled
Book Now
Fri 13-Aug-21
Fri 13 Aug
Power BI Intermediate
Parramatta
Status: Scheduled
Scheduled
Book Now
Wed 25-Aug-21
Wed 25 Aug
Power BI Intermediate
Parramatta
Status: Scheduled
Scheduled
Book Now
Melbourne
Date
Course
City
Status
Thu 28-Jan-21
Thu 28 Jan
Power BI Intermediate
Melbourne
Status: Confirmed
Confirmed
Book Now
Tue 9-Feb-21
Tue 9 Feb
Power BI Intermediate
Melbourne
Status: Confirmed
Confirmed
Book Now
Mon 15-Feb-21
Mon 15 Feb
Power BI Intermediate
Melbourne
Status: Confirmed
Confirmed
Book Now
Thu 18-Feb-21
Thu 18 Feb
Power BI Intermediate
Melbourne
Status: Scheduled
Scheduled
Book Now
Wed 3-Mar-21
Wed 3 Mar
Power BI Intermediate
Melbourne
Status: Scheduled
Scheduled
Book Now
Mon 15-Mar-21
Mon 15 Mar
Power BI Intermediate
Melbourne
Status: Scheduled
Scheduled
Book Now
Thu 18-Mar-21
Thu 18 Mar
Power BI Intermediate
Melbourne
Status: Scheduled
Scheduled
Book Now
Tue 30-Mar-21
Tue 30 Mar
Power BI Intermediate
Melbourne
Status: Scheduled
Scheduled
Book Now
Fri 9-Apr-21
Fri 9 Apr
Power BI Intermediate
Melbourne
Status: Scheduled
Scheduled
Book Now
Wed 14-Apr-21
Wed 14 Apr
Power BI Intermediate
Melbourne
Status: Scheduled
Scheduled
Book Now
Fri 16-Apr-21
Fri 16 Apr
Power BI Intermediate
Melbourne
Status: Scheduled
Scheduled
Book Now
Tue 27-Apr-21
Tue 27 Apr
Power BI Intermediate
Melbourne
Status: Scheduled
Scheduled
Book Now
Thu 6-May-21
Thu 6 May
Power BI Intermediate
Melbourne
Status: Scheduled
Scheduled
Book Now
Fri 14-May-21
Fri 14 May
Power BI Intermediate
Melbourne
Status: Scheduled
Scheduled
Book Now
Wed 19-May-21
Wed 19 May
Power BI Intermediate
Melbourne
Status: Scheduled
Scheduled
Book Now
Canberra
Date
Course
City
Status
Wed 17-Feb-21
Wed 17 Feb
Power BI Intermediate
Canberra
Status: Scheduled
Scheduled
Book Now
Fri 12-Mar-21
Fri 12 Mar
Power BI Intermediate
Canberra
Status: Scheduled
Scheduled
Book Now
Fri 26-Mar-21
Fri 26 Mar
Power BI Intermediate
Canberra
Status: Scheduled
Scheduled
Book Now
Tue 20-Apr-21
Tue 20 Apr
Power BI Intermediate
Canberra
Status: Scheduled
Scheduled
Book Now
Thu 6-May-21
Thu 6 May
Power BI Intermediate
Canberra
Status: Scheduled
Scheduled
Book Now
Tue 18-May-21
Tue 18 May
Power BI Intermediate
Canberra
Status: Scheduled
Scheduled
Book Now
Thu 3-Jun-21
Thu 3 Jun
Power BI Intermediate
Canberra
Status: Scheduled
Scheduled
Book Now
Wed 30-Jun-21
Wed 30 Jun
Power BI Intermediate
Canberra
Status: Scheduled
Scheduled
Book Now
Fri 9-Jul-21
Fri 9 Jul
Power BI Intermediate
Canberra
Status: Scheduled
Scheduled
Book Now
Tue 27-Jul-21
Tue 27 Jul
Power BI Intermediate
Canberra
Status: Scheduled
Scheduled
Book Now
Fri 13-Aug-21
Fri 13 Aug
Power BI Intermediate
Canberra
Status: Scheduled
Scheduled
Book Now
Wed 25-Aug-21
Wed 25 Aug
Power BI Intermediate
Canberra
Status: Scheduled
Scheduled
Book Now
Adelaide
Date
Course
City
Status
Thu 18-Feb-21
Thu 18 Feb
Power BI Intermediate
Adelaide
Status: Confirmed
Confirmed
Book Now
Fri 12-Mar-21
Fri 12 Mar
Power BI Intermediate
Adelaide
Status: Scheduled
Scheduled
Book Now
Fri 26-Mar-21
Fri 26 Mar
Power BI Intermediate
Adelaide
Status: Scheduled
Scheduled
Book Now
Tue 20-Apr-21
Tue 20 Apr
Power BI Intermediate
Adelaide
Status: Scheduled
Scheduled
Book Now
Thu 6-May-21
Thu 6 May
Power BI Intermediate
Adelaide
Status: Scheduled
Scheduled
Book Now
Tue 18-May-21
Tue 18 May
Power BI Intermediate
Adelaide
Status: Scheduled
Scheduled
Book Now
Thu 3-Jun-21
Thu 3 Jun
Power BI Intermediate
Adelaide
Status: Scheduled
Scheduled
Book Now
Wed 30-Jun-21
Wed 30 Jun
Power BI Intermediate
Adelaide
Status: Scheduled
Scheduled
Book Now
Fri 9-Jul-21
Fri 9 Jul
Power BI Intermediate
Adelaide
Status: Scheduled
Scheduled
Book Now
Tue 27-Jul-21
Tue 27 Jul
Power BI Intermediate
Adelaide
Status: Scheduled
Scheduled
Book Now
Fri 13-Aug-21
Fri 13 Aug
Power BI Intermediate
Adelaide
Status: Scheduled
Scheduled
Book Now
Wed 25-Aug-21
Wed 25 Aug
Power BI Intermediate
Adelaide
Status: Scheduled
Scheduled
Book Now
Perth
Date
Course
City
Status
Thu 4-Feb-21
Thu 4 Feb
Power BI Intermediate
Perth
Status: Confirmed
Confirmed
Book Now
Wed 3-Mar-21
Wed 3 Mar
Power BI Intermediate
Perth
Status: Scheduled
Scheduled
Book Now
Fri 26-Mar-21
Fri 26 Mar
Power BI Intermediate
Perth
Status: Scheduled
Scheduled
Book Now
Fri 9-Apr-21
Fri 9 Apr
Power BI Intermediate
Perth
Status: Scheduled
Scheduled
Book Now
Tue 4-May-21
Tue 4 May
Power BI Intermediate
Perth
Status: Scheduled
Scheduled
Book Now
Thu 20-May-21
Thu 20 May
Power BI Intermediate
Perth
Status: Scheduled
Scheduled
Book Now
Thu 27-May-21
Thu 27 May
Power BI Intermediate
Perth
Status: Scheduled
Scheduled
Book Now
Tue 8-Jun-21
Tue 8 Jun
Power BI Intermediate
Perth
Status: Scheduled
Scheduled
Book Now
Thu 24-Jun-21
Thu 24 Jun
Power BI Intermediate
Perth
Status: Scheduled
Scheduled
Book Now
Wed 7-Jul-21
Wed 7 Jul
Power BI Intermediate
Perth
Status: Scheduled
Scheduled
Book Now
Tue 13-Jul-21
Tue 13 Jul
Power BI Intermediate
Perth
Status: Scheduled
Scheduled
Book Now
Tue 27-Jul-21
Tue 27 Jul
Power BI Intermediate
Perth
Status: Scheduled
Scheduled
Book Now
Mon 9-Aug-21
Mon 9 Aug
Power BI Intermediate
Perth
Status: Scheduled
Scheduled
Book Now
Mon 23-Aug-21
Mon 23 Aug
Power BI Intermediate
Perth
Status: Scheduled
Scheduled
Book Now
Scheduled
Taking enrollments.
Confirmed
Taking enrollments.
Few Seats left
Book Now.
Sold Out
Try another date.

Power BI Intermediate Course Details

Price
$595
Duration
1 day
Times
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online
microsoft_gold

Power BI Intermediate Course Details

Price
$595
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
Capped*
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
L10, 333 Adelaide Street, Brisbane QLD 4000

*Limited in-class seats due to COVID-19.
microsoft_gold

Power BI Intermediate Course Details

Price
$595
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
Capped*
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 3, 37 Pitt Street, Sydney NSW 2000

*Limited in-class seats due to COVID-19.
microsoft_gold

Power BI Intermediate Course Details

Price
$595
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
Capped*
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 3, 90 Phillip Street, Parramatta NSW 2150

*Limited in-class seats due to COVID-19.
microsoft_gold

Power BI Intermediate Course Details

Price
$595
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
Capped*
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 3, 466 Little Lonsdale St, Melbourne VIC 3000

*Limited in-class seats due to COVID-19.
microsoft_gold

Power BI Intermediate Course Details

Price
$595
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
Capped*
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Ethos House, Level 1, 28 Ainslie Place, Canberra ACT 2601

*Limited in-class seats due to COVID-19.
microsoft_gold

Power BI Intermediate Course Details

Price
$595
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
Capped*
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 3, 97 Pirie Street, Adelaide SA 5000

*Limited in-class seats due to COVID-19.
microsoft_gold

Power BI Intermediate Course Details

Price
$595
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
Capped*
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 4, 220 St Georges Tce, Perth WA 6000

*Limited in-class seats due to COVID-19.
microsoft_gold

Power BI Course Outlines

Other Courses
Microsoft Office 365 Training Courses
Microsoft Excel Training Courses
Microsoft Teams Training Courses
Microsoft Excel Specialist Training Courses
Power Automate Training Courses
Microsoft SharePoint Training Courses
Microsoft Power Apps Training Courses
Microsoft Project Training Courses
Microsoft Visio Training Courses
Data Analytics Training Courses
Python Training Courses
Dynamics 365 Training Courses
Microsoft PowerPoint Training Courses
Microsoft Word Training Courses
Other Courses
Microsoft Office 365 Training Courses
Microsoft Excel Training Courses
Microsoft Teams Training Courses
Microsoft Excel Specialist Training Courses
Power Automate Training Courses
Microsoft SharePoint Training Courses
Microsoft Power Apps Training Courses
Microsoft Project Training Courses
Microsoft Visio Training Courses
Data Analytics Training Courses
Python Training Courses
Dynamics 365 Training Courses
Microsoft PowerPoint Training Courses
Microsoft Word Training Courses
Course Rating
Microsoft Power BI Training Courses

4.71 5 Microsoft Power BI Training Courses
4.71 out of 5
6695 Student Reviews

Power BI City Pages

Power BI City Pages

BNE Brisbane

MEL Melbourne

SYD Sydney

ADL Adelaide

PER Perth

PAR Parramatta

CBR Canberra

REM Remote Online

Skills Test

Try our short skills test and find out which course is right for you.

skills test nexacu

 skills test

 

Contact Us



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

Power BI Intermediate Learning Outcomes

  • 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

Power BI Intermediate Course Content

  • Power 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

 

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

 

  • Data 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 Query UI
  • Queries Area
  • Data section
  • The Transformations Ribbons
  • Query Settings Area
  • M Language Area

 

  • Data 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

 

  • Column 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

 

  • Data 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

 

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

 

  • Unpivot Data
  • Unpivot Columns

 

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

 

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

 

  • Data 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

 

 

  • DAX
  • 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

 

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

 

  • Time 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

 

  • Advanced 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

 

  • Secure 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

 

  • Extended Topic A – Transformations
  • Opening files and checking connections
  • Examine the underlying data
  • Find and Replace
  • Unpivot & Rename

 

  • Extended 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

 

  • Extended Topic C – Group by
  • Using the Group By feature

 

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

Contact Us

Nexacu Phone Icon phone
Nexacu Envelope Icon Task email
Nexacu Form Icon enquiry

What is Remote Training?

Valued by Individuals

4.8/5
Over 25129 Reviews
Some very helpful tips, definitely things I can use in the future -Word Advanced Brisbane
Millie - Word Advanced, .
Very informative and engaging. Good teacher -Excel Intermediate Brisbane
Alisha - Excel Intermediate, .
was informative and well done -Excel Intermediate Brisbane
Sola - Excel Intermediate, .
thank you great course and facilitator was great -Excel Intermediate Brisbane
Luke - Excel Intermediate, .
very useful. -Excel Intermediate Brisbane
Jennifer - Excel Intermediate, .
Very clear and helpful. Good pace also. Well structured. -Excel Intermediate Brisbane
Aria - Excel Intermediate, .
This course was great. I knew very little about VBA prior to attending and Michael was clear and built knowledge so well that I feel confident attempting to apply this in real work situations. A highly recommended course. -Excel Macros/VBA 2 Day Parramatta
Mary - Excel Macros/VBA 2 Day, .
This course was amazing. Michael was such an engaging teacher and kept the class so informative and so easy to follow. We had a great time learning the content of this course and we loved the small class we were in. We could ask a lot of questions and enjoy the whole course at the same time. This was one of many courses I have attended with Nexacu and all the teachers are great. Michael is my favourite. 5 Stars from me from all perspectives !!! -Excel Macros/VBA 2 Day Parramatta
Jacqueline - Excel Macros/VBA 2 Day, .
Moved a bit quicker than the beginner but showed good examples of what you can do. I certainly need to go away and practice with some real data to apply what I have learned today. Many thanks -Power BI Intermediate Adelaide
Merrin - Power BI Intermediate, .
Thanks for the help! -Power BI Intermediate Adelaide
Bradley - Power BI Intermediate, .
Brilliant - learnt so much. Many thanks Jagg -Power BI Intermediate Adelaide
John - Power BI Intermediate, .
was able to learn new formulas and functions that will help me in the future. -Power BI Intermediate Adelaide
Estelle - Power BI Intermediate, .
Learnt a lot on how to manipulate and clean up data. Learnt to better manage permissions to data. Learnt more on the date functions, though still don't know how to calculate current week/previous week comparisons. -Power BI Intermediate Melbourne
Kristina - Power BI Intermediate, .
Learnt many items with Power Query and DAX, along with row level security which is of particular interest with the types of personnel reports I will need to build. -Power BI Intermediate Melbourne
Kylie - Power BI Intermediate, .
Excellent content, great teacher. Thank you! -Excel Intermediate Melbourne
Linda - Excel Intermediate, .
Steven was incredibly helpful in training us. He took the time to understand our professional roles and relate what we were learning to our day to day tasks. He was patient and professional. Thank you! -Word Intermediate Brisbane
Alison - Word Intermediate, .
I have enjoyed it and learned many tips. -Word Intermediate Brisbane
Kristian - Word Intermediate, .
This was great! -Word Intermediate Brisbane
Courteney - Word Intermediate, .
Well-paced and very informative training. Trainer is very knowledgeable and helpful with any questions. -Power BI Intermediate Brisbane
Emily - Power BI Intermediate, .
Great course. Jason was very clear and easy to understand. Learnt a lot in one day. Thanks! -Power BI Intermediate Brisbane
Ben - Power BI Intermediate, .
View More Reviews

Trusted by Business

Procured by Government

Awards and Accreditations

Map of Australia

Follow us