Power BI Advanced Training Course

Power Bi Advanced Training Course helps business users to meet their work challenges by introducing them to the latest features such as fuzzy matching, AI visuals, and Row Level Security. This course is a complete walk-through of the BI process from data modeling, data cleaning, data manipulation, and data wrangling to data visualization using AI-enhanced visuals and infographics.

What is Included With The Microsoft Power BI Advanced Training Course

Small Class Size

Developed and Guided Learning Content

Certificate of Attendance

Highly Skilled Trainers

Our Price Beat Guarantee

Email Support

About this course:

This course helps business users to meet their work challenges by introducing them to the latest features such as fuzzy matching, AI visuals, and Row Level Security. This course is a complete walk-through of the BI process from data modeling, data cleaning, data manipulation, and data mugging to data visualization using AI-enhanced visuals and infographics. This course also introduces you to DAX and helps you build a sound foundation of DAX in Power BI based on your Excel/SQL knowledge.

Prerequisites:

This course is suitable for users who are familiar with the Power BI tool. The users are expected to have completed the Power BI Essentials course or have equivalent skills. An experience in Excel with Basic VLOOKUP and Pivot table is a plus.

Who should take this course?

This course is suitable for users who want to learn how to implement Business Intelligence solutions using top-notch modeling and visualization techniques. This course is also a perfect choice for users who have developed SQL reports and are looking for ways to develop visually appealing and best-performing dashboards.

Course Duration: 2 Days

Skill Level:  Advanced

Add-ons:

  • Small Class size
  • Developed and Guided learning content
  • Completion certificate
  • Taught by Industry Pros
  • Free re-sit
  • Email support
  • Printed Manual
Training Cities:
  • Sydney, Melbourne, Brisbane, Canberra, Adelaide, Perth
Training Modes  
  • Online
  • Classroom
Ticket Price:  
  • $990 Including Tax
Timings:
  • 9.00 am to 5.00 pm approx
DOWNLOAD COURSE OUTLINE

Send download link to:

Sydney Class Dates

Sydney Class Dates

Days

 Training Mode

30 Nov-01 Dec 23

Thu-Fri

Online Live 

07-08 Dec 23

Thu-Fri

Classroom

11-12 Dec 23

Mon-Tue

Online Live 

18-19 Jan 24

Thu-Fri

Online Live 

22-23 Jan 24

Mon-Tue

Classroom

Melbourne Class Dates

Melbourne Class Dates

Days

 Training Mode

30 Nov-01 Dec 23

Thu-Fri

Online Live

11-12 Dec 23

Mon-Tue

Online Live

13-14 Dec 23

Wed-Thu

Classroom

16-17 Jan 23

Tue-Wed

Classroom

18-19 Jan 24

Thu-Fri

Online Live

Brisbane Class Dates

Brisbane Class Dates

Days

 Training Mode

30 Nov-01 Dec 23

Thu-Fri

Online Live

11-12 Dec 23

Mon-Tue

Online Live

19-20 Dec 23

Tue-Wed

Classroom

15-16 Jan 24

Mon-Tue

Classroom

18-19 Jan 24

Thu-Fri

Online Live

Canberra Class Dates

Canberra Class Dates

Days

 Training Mode

30 Nov-01 Dec 23

Thu-Fri

Online Live

11-12 Dec 23

Mon-Tue

Online Live

18-19 Jan 24

Thu-Fri

Online Live

30-31 Jan 24

Tue-Wed

Online Live

15-16 Feb 24

Thu-Fri

Online Live

Adelaide Class Dates

Adelaide Class Dates

Days

 Training Mode

30 Nov-01 Dec 23

Thu-Fri

Online Live

11-12 Dec 23

Mon-Tue

Online Live

18-19 Jan 24

Thu-Fri

Online Live

30-31 Jan 24

Tue-Wed

Online Live

15-16 Feb 24

Thu-Fri

Online Live

Perth Class Dates

Perth Class Dates

Days

 Training Mode

30 Nov-01 Dec 23

Thu-Fri

Online Live

11-12 Dec 23

Mon-Tue

Online Live

18-19 Jan 24

Thu-Fri

Online Live

30-31 Jan 24

Tue-Wed

Online Live

15-16 Feb 24

Thu-Fri

Online Live

power bi training courses

Learning Experience

Take your data analytics proficiency to the next level with our advanced Power BI training program. Explore the details of fuzzy matching, advanced analytics, data modeling, row-level security, and more. Gain a competitive advantage in the field of data analytics and harness the full potential of Power BI. Join us now and become a master of advanced data-driven insights, equipped to make informed decisions and drive meaningful outcomes. Elevate your expertise and unlock a world of endless possibilities with our comprehensive training program.

Course Outline

✅ Overview of BI Process

✅ Overview of Different Power BI Products

✅ Latest Features and Top Enhancements in Power BI

✅ 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

✅ 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

✅ Using Fuzzy Match to Merge Queries

✅ Changing Similarity Threshold

✅Working with Fuzzy Merge Options

✅ Creating and Using Transformation Table

✅ What is Data Profiling and its use case?

✅ Column Distribution

✅ Column Quality

✅ Column Profile

✅ Duplicate Queries

✅ Removing Columns

✅ Removing Duplicates

✅ Building Relationships

✅ 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 the Snowflake Schema

✅ How does Filter Propagation Work?

✅ Understanding Double Vs Single Cross Filtering Direction

✅ Understanding Active Vs Inactive Relationships

✅ 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

✅ Many to Many Relationship

✅ Applying Security Filters in Both Directions

✅ Working with Views and Perspectives

✅ Composite Model

✅ Writing Properties for Tool Tip

✅ Creating Hierarchies

✅ Understanding DAX Rules and Concepts

✅ Filter Context

✅ Row Context

✅ Calculated Columns

✅ Calculated Measures

✅ Calculated Tables

✅ Related/Related Table function.

✅ Sum function

✅ Count Function

✅ SumX function

✅ Calculate function.

✅ Filter Function

✅ Userelationship function

✅ Using Variables for DAX

✅ Introduction to Quick Measures

✅ Quick Measure – Year to Date

✅ Quick Measure – Filter

✅ Quick Measure – Rolling Average

✅ Quick Measure – Percentage Difference

✅ Drilling through Filters across Reports

✅ Creating KPI Score Card

✅ Working With Uni Char Symbols

✅ Slicer Synchronization across Multiple Pages

✅ Working With the Selection and Bookmarks Pane

✅ Q&A Improvements

✅ Creating infographics

✅ By Background Color

✅ By Font Color

✅ Data Bar

✅ By Rule

✅ By Another Column

✅ Dynamic Chart Titles

✅ Switch DAX Function

✅ For Chart Visuals using Measures

✅ What are AI visuals?

✅ Key Influencer Visual

✅ Clustering using Scatter Chart

✅ 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

✅ 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

✅ Testing Scenarios in Power Bi Service

✅ Creating Workspace Apps

✅ Assigning Permissions in Workspace Apps

✅ Collaborating on Shared Reports

✅ Sharing Reports Using Apps

✅ Create a New Parameter

✅ Importing web query using parameter

✅ Creating functions

✅ Invoking functions

✅ Defining a list

✅ Converting List to Table

✅ Adding Column by invoking custom functions

Related Courses

We are running multiple classes every month across Australia. Please complete the below form and one of our representatives will contact you shortly.

We deliver all our online and classroom courses via our training partner, Dynamic Web Training
Please fill the details below and one of our representative from will get back to you.
We deliver all our online and classroom courses via our training partner, Dynamic Web Training

For more information on upcoming

Power BI Advanced Course

You will be redirected to our official training partner Dynamic Web Training

For Group Discounts

Why Power BI?

Business Intelligence Market

Worldwide Business Intelligence and Analytics market to grow to $22.8 billion in revenue in the next two years – Gartner

Jobs Opportunities

70 percent of the leading companies say that Analytics is integral to how they make decisions – IBM Survey

Career Growth

A Senior Business Intelligence Analyst can earn $89,000 in the United States – PayScale

Some of the companies that experienced Power BI Training With Our Trainers

Extremely informative and interactive, am taking a lot out of this course and this will surely help my business making better and timely decisions.  | Mairaj
It was a definitively a step up from the Essentials of Power BI. It gave me a deeper understanding of the importance of Transforming Data, and how to analyze the model based on essential concepts such us Row context and filter context and the impact on the model. |  Claudia
 
Great instructor, who is very knowledgeable. Trainer was able to explain everything in Power BI, in a very clear way which was easy to understand even for a Power BI novice | kevin
Very good course and great facilitator | Christian
4.6/5
5/5
5/5
4.5/5