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 Dates
-
Sydney Class Dates
Book NowLevel 11, 32 Walker Street, North Sydney , NSW 2060
25 - 26 May 22 Wed - Thu Online Live 30 - 31 May 22 Mon - Tue Classroom 02 - 03 Jun 22 Thu - Fri Online Live 14 - 15 Jun 22 Tue - Wed Online Live 27 - 28 Jun 22 Mon - Tue Online Live 30 Jun - 01 Jul 22 Thu - Fri Classroom 14 - 15 Jul 22 Thu - Fri Online Live 25 - 26 Jul 22 Mon - Tue Online Live 25 - 26 Jul 22 Mon - Tue Classroom 11 - 12 Aug 22 Thu - Fri Online Live 22 - 23 Aug 22 Mon - Tue Online Live 25 - 26 Aug 22 Thu - Fri Classroom 08 - 09 Sep 22 Thu - Fri Online Live 19 - 20 Sep 22 Mon - Tue Classroom 19 - 20 Sep 22 Mon - Tue Online Live 06 - 07 Oct 22 Thu - Fri Online Live 17 - 18 Oct 22 Mon - Tue Online Live 20 - 21 Oct 22 Thu - Fri Classroom 02 - 03 Nov 22 Wed - Thu Online Live 14 - 15 Nov 22 Mon - Tue Classroom 17 - 18 Nov 22 Thu - Fri Online Live 28 - 29 Nov 22 Mon - Tue Online Live 12 - 13 Dec 22 Mon - Tue Classroom 12 - 13 Dec 22 Mon - Tue Online Live -
Melbourne Class Dates
Book NowLevel 12, 379 Collins Street, Melbourne , VIC 3000
23 - 24 May 22 Mon - Tue Classroom 25 - 26 May 22 Wed - Thu Online Live 02 - 03 Jun 22 Thu - Fri Online Live 14 - 15 Jun 22 Tue - Wed Online Live 23 - 24 Jun 22 Thu - Fri Classroom 27 - 28 Jun 22 Mon - Tue Online Live 14 - 15 Jul 22 Thu - Fri Online Live 20 - 21 Jul 22 Wed - Thu Classroom 25 - 26 Jul 22 Mon - Tue Online Live 11 - 12 Aug 22 Thu - Fri Online Live 18 - 19 Aug 22 Thu - Fri Classroom 22 - 23 Aug 22 Mon - Tue Online Live 08 - 09 Sep 22 Thu - Fri Online Live 14 - 15 Sep 22 Wed - Thu Classroom 19 - 20 Sep 22 Mon - Tue Online Live 06 - 07 Oct 22 Thu - Fri Online Live 10 - 11 Oct 22 Mon - Tue Classroom 17 - 18 Oct 22 Mon - Tue Online Live 02 - 03 Nov 22 Wed - Thu Online Live 10 - 11 Nov 22 Thu - Fri Classroom 17 - 18 Nov 22 Thu - Fri Online Live 28 - 29 Nov 22 Mon - Tue Online Live 07 - 08 Dec 22 Wed - Thu Classroom 12 - 13 Dec 22 Mon - Tue Online Live -
Brisbane Class Dates
Book NowLevel 6, 371 Queen Street, Brisbane , QLD 4000
25 - 26 May 22 Wed - Thu Online Live 02 - 03 Jun 22 Thu - Fri Online Live 06 - 07 Jun 22 Mon - Tue Classroom 14 - 15 Jun 22 Tue - Wed Online Live 27 - 28 Jun 22 Mon - Tue Online Live 28 - 29 Jun 22 Tue - Wed Classroom 14 - 15 Jul 22 Thu - Fri Online Live 25 - 26 Jul 22 Mon - Tue Online Live 27 - 28 Jul 22 Wed - Thu Classroom 11 - 12 Aug 22 Thu - Fri Online Live 22 - 23 Aug 22 Mon - Tue Online Live 22 - 23 Aug 22 Mon - Tue Classroom 08 - 09 Sep 22 Thu - Fri Online Live 19 - 20 Sep 22 Mon - Tue Online Live 20 - 21 Sep 22 Tue - Wed Classroom 06 - 07 Oct 22 Thu - Fri Online Live 17 - 18 Oct 22 Mon - Tue Online Live 20 - 21 Oct 22 Thu - Fri Classroom 02 - 03 Nov 22 Wed - Thu Online Live 16 - 17 Nov 22 Wed - Thu Classroom 17 - 18 Nov 22 Thu - Fri Online Live 28 - 29 Nov 22 Mon - Tue Online Live 12 - 13 Dec 22 Mon - Tue Online Live 13 - 14 Dec 22 Tue - Wed Classroom
-
Canberra Class Dates
Book NowAll courses facilitated in, Online Live format ,
25 - 26 May 22 Wed - Thu Online Live 02 - 03 Jun 22 Thu - Fri Online Live 14 - 15 Jun 22 Tue - Wed Online Live 27 - 28 Jun 22 Mon - Tue Online Live 14 - 15 Jul 22 Thu - Fri Online Live 25 - 26 Jul 22 Mon - Tue Online Live 11 - 12 Aug 22 Thu - Fri Online Live 22 - 23 Aug 22 Mon - Tue Online Live 08 - 09 Sep 22 Thu - Fri Online Live 19 - 20 Sep 22 Mon - Tue Online Live 06 - 07 Oct 22 Thu - Fri Online Live 17 - 18 Oct 22 Mon - Tue Online Live 02 - 03 Nov 22 Wed - Thu Online Live 17 - 18 Nov 22 Thu - Fri Online Live 28 - 29 Nov 22 Mon - Tue Online Live 12 - 13 Dec 22 Mon - Tue Online Live -
Adelaide Class Dates
Book NowAll courses facilitated in, Online Live format ,
25 - 26 May 22 Wed - Thu Online Live 02 - 03 Jun 22 Thu - Fri Online Live 14 - 15 Jun 22 Tue - Wed Online Live 27 - 28 Jun 22 Mon - Tue Online Live 14 - 15 Jul 22 Thu - Fri Online Live 25 - 26 Jul 22 Mon - Tue Online Live 11 - 12 Aug 22 Thu - Fri Online Live 22 - 23 Aug 22 Mon - Tue Online Live 08 - 09 Sep 22 Thu - Fri Online Live 19 - 20 Sep 22 Mon - Tue Online Live 06 - 07 Oct 22 Thu - Fri Online Live 17 - 18 Oct 22 Mon - Tue Online Live 02 - 03 Nov 22 Wed - Thu Online Live 17 - 18 Nov 22 Thu - Fri Online Live 28 - 29 Nov 22 Mon - Tue Online Live 12 - 13 Dec 22 Mon - Tue Online Live -
Perth Class Dates
Book NowAll courses facilitated in, Online Live format ,
25 - 26 May 22 Wed - Thu Online Live 02 - 03 Jun 22 Thu - Fri Online Live 14 - 15 Jun 22 Tue - Wed Online Live 27 - 28 Jun 22 Mon - Tue Online Live 14 - 15 Jul 22 Thu - Fri Online Live 25 - 26 Jul 22 Mon - Tue Online Live 11 - 12 Aug 22 Thu - Fri Online Live 22 - 23 Aug 22 Mon - Tue Online Live 08 - 09 Sep 22 Thu - Fri Online Live 19 - 20 Sep 22 Mon - Tue Online Live 06 - 07 Oct 22 Thu - Fri Online Live 17 - 18 Oct 22 Mon - Tue Online Live 02 - 03 Nov 22 Wed - Thu Online Live 17 - 18 Nov 22 Thu - Fri Online Live 28 - 29 Nov 22 Mon - Tue Online Live 12 - 13 Dec 22 Mon - Tue Online Live
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
(5.00 out of 5) Natalie [ 16 May, 2022 ]
Very knowledgeable - Loved how you used the red pen. You could do the visulisations slower and with more red arrows.
(5.00 out of 5) Sean C [ 16 May, 2022 ]
Really valuable course for me in my Power BI learning. Ali was very knowledgeable and engaging in his presentations
(4.50 out of 5) Liam S [ 16 May, 2022 ]
A nice next step from the Power BI Essentials course. Provides depth on important concepts to understand Power BI fundamentals. particularly useful information on DAX formulas versus columnar data. I will need to practice a lot to retain knowledge.
(5.00 out of 5) David W [ 16 May, 2022 ]
Ali was a very knowledgeable instructor and easy to follow. I came away with a much better understanding of how to adapt my data sources and workflows to take advantage of the full capabilities of Power BI.
Enquire Now
Fill in your details to have a training consultant contact you to discuss your training needs.