1300 888 724 8.30am to 5:30pm AEST (Mon-Fri) info@dynamicwebtraining.com.au

Power BI Advanced Course

(4.80 out of 5) 24 Student Reviews

About the Course

This 2-day course covers the latest functionalities and updates in Power BI while diving deep into practical solutions of the common challenges faced by a business user while performing analytics. During this course, students will learn how to perform more sophisticated data manipulations, best practices and do’s and don’ts of data modelling, AI-enhanced features and visuals and managing the security to build an enterprise-level solution.

Who should do this course?

This course is suitable for business users who wants to implement BI to create reports and dashboard or SQL Server report creators who are interested in alternative methods of presenting data.

Prerequisites

This Power BI course is suitable for the people who have completed the Power BI essentials course or have equivalent skills. To benefit most from this course, participants must have some expertise in using excel functions such as VLOOKUP and Pivot table and are familiar with interface and navigation of Microsoft Power BI tool.

Course Details

  • $990 incl GST
  • Duration: 2 Days
  • Max. Class Size: 10
  • Avg. Class Size: 5
  • Study Mode: In Class Live Online
  • Level: Advanced
  • Times: 9.00am to 5.00pm approx
  • Download Course PDF
  • Enquire Book Now
    Pay later

Online Live - Course Dates

  • Online Live Class Dates

    Book Now
    03 - 04 Sep 20 Thu - Fri
    10 - 11 Sep 20 Thu - Fri
    13 - 14 Oct 20 Tue - Wed
    30 Nov - 01 Dec 20 Mon - Tue

  • To inquire about Live Online Classes, please

    Call 1300 888 724

In-Class - Course Dates

  • Sydney Class Dates

    Book Now

    Level 11, 32 Walker Street, North Sydney , NSW 2060

    20 - 21 Aug 20 Thu - Fri
    17 - 18 Sep 20 Thu - Fri
    01 - 02 Oct 20 Thu - Fri
    05 - 06 Nov 20 Thu - Fri
    03 - 04 Dec 20 Thu - Fri

  • Melbourne Class Dates

    Book Now

    Level 12, 379 Collins Street, Melbourne , VIC 3000

    10 - 11 Sep 20 Thu - Fri
    08 - 09 Oct 20 Thu - Fri
    29 - 30 Oct 20 Thu - Fri
    24 - 25 Nov 20 Tue - Wed
    14 - 15 Dec 20 Mon - Tue

  • Brisbane Class Dates

    Book Now

    Level 6, 371 Queen Street, Brisbane , QLD 4000

    03 - 04 Sep 20 Thu - Fri
    15 - 16 Oct 20 Thu - Fri
    26 - 27 Nov 20 Thu - Fri
    07 - 08 Jan 21 Thu - Fri
    18 - 19 Feb 21 Thu - Fri

  • Canberra Class Dates

    Book Now

    Level 4, 54 Marcus Clarke Street, Canberra , ACT 2601

    27 - 28 Aug 20 Thu - Fri
    12 - 13 Nov 20 Thu - Fri
    17 - 18 Dec 20 Thu - Fri
    11 - 12 Feb 21 Thu - Fri
    08 - 09 Apr 21 Thu - Fri
    03 - 04 Jun 21 Thu - Fri

  • Adelaide Class Dates

    Book Now

    19 Young Street, Adelaide , SA 5000

    19 - 20 Nov 20 Thu - Fri
    28 - 29 Jan 21 Thu - Fri
    25 - 26 Mar 21 Thu - Fri
    20 - 21 May 21 Thu - Fri

  • Perth Class Dates

    Level 1, 140 St Georges Terrace, Perth , WA 6000

    Classes scheduled on demand in Perth

    Please Join our waitlist and we'll notify you when a new class is scheduled or contact us to disucss your training needs.

Course Units

Expand full topic list

Unit 1: Introduction

  • Overview of BI Process
  • Overview of Different Power BI Products
  • Latest Features and Top Enhancements in Power BI

See more

Unit 2: Power Query - Advanced Data Transformation

  • Data Transformation Principle
  • Pivot and Unpivot
  • Merging Queries
  • Appending Queries
  • Using Basic Group By functionality
  • Using Advanced Group by Functionality
  • Choosing Columns
  • Duplicating a Query
  • Referencing a Query
  • Difference between Duplicate and Reference
  • Extracting Columns
  • Formatting Columns
  • Copying Queries across reports

See more

Unit 3: Power Query - Creating Columns

  • Creating Date Columns
  • Creating Standard Columns
  • Creating Scientific Columns
  • Creating Statistical Columns
  • Creating Information Columns
  • Creating Index Columns
  • Creating Conditional Columns
  • Creating Custom Columns
  • Creating Columns by Examples

See more

Unit 4: Fuzzy Match

  • Using Fuzzy Match to Merge Queries
  • Changing Similarity Threshold
  • Working with Fuzzy Merge Options
  • Creating and Using Transformation Table

See more

Unit 5: Data Profiling

  • What is Data Profiling and its use case?
  • Column Distribution
  • Column Quality
  • Column Profile

See more

Unit 6: Converting Flat File into a Data Model

  • Duplicate Queries
  • Removing Columns
  • Removing Duplicates
  • Building Relationships

See more

Unit 7: Data Modelling - Fundamental Concepts

  • Understanding a Data Model
  • Understanding a Fact Table
  • Understanding a Data Table
  • What Is a Dimension?
  • Working with Look-Up Table
  • Understanding Star Schema
  • Understanding Snow Flake Schema
  • How Filter Propagation Work?
  • Understanding Double Vs Single Cross Filtering Direction
  • Understanding Active Vs Inactive Relationships

See more

Unit 8: Data Modelling - Common Issues and Solutions

  • What Questions To Ask Before Starting?
  • Good Practices of Data Modelling
  • Having No Unique Identifier
  • Relation between Two Different Dimensions
  • Understanding Loops
  • Creation of Surrogate Key
  • Creation of Bridge/Fact-Less Fact Table
  • Creation of Calculated Tables
  • Building Calendar Table

See more

Unit 9: Latest Features in Data Modelling

  • Many to Many Relationship
  • Applying Security Filter in Both Direction
  • Working with Views and Perspectives
  • Composite Model
  • Writing Properties for Tool Tip
  • Creating Hierarchies

See more

Unit 10: DAX Introduction and Core Concepts

  • Understanding DAX Rules and Concepts
  • Filter Context
  • Row Context
  • Calculated Columns
  • Calculated Measures
  • Calculated Tables

See more

Unit 11: Common DAX Functions

  • Related/Related Table function
  • Sum function
  • Count Function
  • SumX function
  • Calculate function
  • Filter Function
  • Userelationship function
  • Using Variables for DAX

See more

Unit 12: Quick Measures

  • Introduction to Quick Measures
  • Quick Measure - Year to Date
  • Quick Measure - Filter
  • Quick Measure - Rolling Average
  • Quick Measure - Percentage Difference

See more

Unit 13: Data Visualization

  • Drilling through Filters across Reports
  • Creating KPI Score Card
  • Working With Uni Char Symbols
  • Slicer Synchronization across Multiple Pages
  • Working With Selection and Book Marks Pane
  • Q&A Improvements
  • Creating infographics

See more

Unit 14: Conditional Formatting in Power BI

  • By Back Ground Colour
  • By Font Colour
  • Data Bar
  • By Rule
  • By Another Column
  • Dynamic Chart Titles
  • Switch DAX Function
  • For Chart Visuals using Measures

See more

Unit 15: AI Enhanced Visualization

  • What are AI visuals?
  • Key Influencer Visual
  • Clustering using Scatter Chart

See more

Unit 16: Performance Analyzer

  • What is Performance Analyzer?
  • Start Recording
  • Understanding the Results
  • Drilling Down into the Visual
  • Renaming the visual using Selection Pane
  • Analyze Results to Modify Slicer
  • Analyze Results to Refresh a Particular Visual

See more

Unit 17: Working with Row Level Security

  • Creating Roles
  • Writing Table Filter Expressions for a Single Field
  • Writing Table Filter Expressions for Multiple Fields
  • Viewing as Roles
  • Creating Dynamic Row Level Security
  • Creating Dynamic Row Level Security According to
  • Reporting Line
  • Assigning Members to Roles
  • URL Filtering
  • Dynamic URL Filtering

See more

Unit 18: Work Space App

  • Testing Scenarios in Power Bi Service
  • Creating Work Space Apps
  • Assigning Permissions in Work space Apps
  • Collaborating on Shared Reports
  • Sharing Reports Using Apps

See more

Unit 19: Working with Parameters and Functions

  • Create New Parameter
  • Importing web query using parameter
  • Creating functions
  • Invoking functions
  • Defining a list
  • Converting List to Table
  • Adding Column by invoking custom functions

See more

Related Courses

Course Reviews

(4.70 out of 5) Andrew C [ 06 August, 2020 ]
Instructor was great and engaging. Was clear with explaining concepts and instructions. The course itself was also well put together. I would say that it could probably be condensed into 1 and a half days instead of 2 full days. Thanks!
(5.00 out of 5) Kelly D [ 30 July, 2020 ]
Excellent course. Content was great and Adam was very thorough with explaining all concepts and features.
(4.80 out of 5) Sophy M [ 30 July, 2020 ]
Very easy to follow and comprehensive coverage of concepts and material. Made time for questions which were answered diligently. Some explanations were too quick especially around relationships which would make it easy to miss a step but overall pace was ideal. Overall great experience.
(4.50 out of 5) Melony B [ 30 July, 2020 ]
This course was very well laid out and presented. I appreciated the effort and the information provided by the trainer and his engagement with the students. Some of the concepts and information seemed to be skewed more towards intermediate use than advanced. Still, I learned some new things, and I would absolutely recommend it to others.

Read all course reviews

Enquire Now

Fill in your details to have a training consultant contact you to discuss your training needs.

Your details

Other Ways To Get In Touch

You can also Book Online or call us on 1300 888 724

Back to Top