Power BI Advanced Course
(4.89 out of 5) 1126 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. Familiarity with interface and navigation of Microsoft Power BI Desktop tool is required.
Course Details
$990 incl GST
- Duration:2 Days
- Max. Class Size:10
- Avg. Class Size:5
-
Study Mode:
Classroom Online Live
- Level:Advanced
- CPD Hours:12 hours
- Course Times: Classroom: 9.00am to 5.00pm approx(Local Time) Online Live: 9.00am to 5.00pm approx(AEST or AEDT)
- Download Course PDF
Course Dates
Looking for Power BI Advanced dates?
There are currently no scheduled dates matching your selected filter, but we'd love to assist. Get in touch with our team to discuss your individual training needs or corporate group requirements, and we'll explore available options with you.
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
Training Packages
Power BI Training Package
Related Courses
Student Reviews
Perfectly paced - Danny was very prepared and succinct whilst also taking the time to check everyone was OK before moving on. He was able to answer student questions quickly.
The course was great. I use Power Bi daily within my role in a Learning and Development team to generate reports on our training records. The examples used throughout the course were awesome as they opened my eyes to alternative ways that I could use Power Bi. I would appreciate if someone from the Dynamic Web Training team could contact me about the DAX workshops. Myself and a colleague had paid for the DAX course as part of a package around a year ago but were unable to attend at the time. It would be great to be able to resit this course, and if possible with Adam as the facilitator.
Great course and instructor. The course was practical, well-structured, and highly valuable. Adam was an excellent instructor - knowledgeable, engaging, and patient throughout the training.
Great way to learn more skills in Power BI using useful AND relatable examples to apply the concepts.
Enjoyed the course. Danny was engaging and was able to provide answers to queries I had during the course.
I found the course to be very useful. Dany was able to answer all my questions. I think we are better prepared for our upcoming migration project due to this course.
The Power BI Advanced Training was extremely valuable and easy to follow. The facilitator explained concepts clearly and worked through examples at a pace that allowed participants to fully understand the content. A standout aspect of the training was the delivery of measures / formulas. Unlike some previous Power BI training sessions, the instructor did not rush through these more complex topics. Instead, they took the time to explain the logic behind the formulas, demonstrate practical applications, and answer questions along the way. The training was well-structured, engaging, and provided practical skills that can be immediately applied in the workplace. I would highly recommend this training to anyone looking to further develop their Power BI capabilities.
Great course with lots of valuable hands-on examples as well as helpful tips and tricks. Instructor was engaging, knowledgeable and created an upbeat and inclusive learning environment. Will be recommending to my colleagues!
awesome, definitely learnt more on day 2, but day one helped consolidate learning from essentials and reporting units. Danny - Fantastic assistance particularly on the many questions.
Adam was again very interactive and patient! Adding this course to the other Power Bi courses is very valuable, connecting the dots!
This was a resit from last year. It was incredibly valuable as my team are currently moving from Excel to Power BI models. It helped to remind me of a few things I had forgotten how to do (date tables and date intelligence functions) and gave me a broader perspective of data cleaning, how to correct issues and setting up the star schema. I did lose my pace at one stage due to the file not saving, but Gordana helped me to recover my lost work in the break time. Thankyou!!!
Great session. This is definitely for advanced users where a certain amount of foundation is required but the instructor also went over the fundamentals for the other students. Went over really good tips and tricks learning powerful functions to overcome problems such as cross functions. Went over performance analysis of DAX vs M language. Powerful tool for real world problems
Course was well structured. One suggestion is having a 30 min introduction on the basics in PowerBI to have the continuity in going through the advanced course.
The course was comprehensive but still easy to follow and immediately applicable. Our instructor did a really good job running the two days and answering questions, offering extension information where appropriate and being flexible to the needs/interests of our group.
It was a great course with lots of concepts covered in good time. The instructor, was very excellent. I found a lot of value in this and will be applying all the concepts learned over the last 2 days in my work place.
Enquire Now
Fill in your details to have a training consultant contact you to discuss your training needs.
Note: Form fields marked with * are required.
Book our 4 core Power BI course together and
SAVE $330
For more info please
Call 1300 888 724