‘Power BI Advanced’ Overview
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.
Course Code: PBIADV
Duration: 2 Days
‘Power BI Advanced’ Audience
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.
‘Power BI Advanced’ 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.
'Power BI Advanced' Modules
Module 1: Introduction
- Overview of BI Process
- Overview of Different Power BI Products
- Latest Features and Top Enhancements in Power BI
Module 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
Module 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
Module 4: Fuzzy Match
- Using Fuzzy Match to Merge Queries
- Changing Similarity Threshold
- Working with Fuzzy Merge Options
- Creating and Using Transformation Table
Module 5: Data Profiling
- What is Data Profiling and its use case?
- Column Distribution
- Column Quality
- Column Profile
Module 6: Converting Flat File into a Data Model
- Duplicate Queries
- Removing Columns
- Removing Duplicates
- Building Relationships
Module 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
Module 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
Module 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
Module 10: DAX Introduction and Core Concepts
- Understanding DAX Rules and Concepts
- Filter Context
- Row Context
- Calculated Columns
- Calculated Measures
- Calculated Tables
Module 11: Common DAX Functions
- Related/Related Table function
- Sum function
- Count Function
- SumX function
- Calculate function
- Filter Function
- Userelationship function
- Using Variables for DAX
Module 12: Quick Measures
- Introduction to Quick Measures
- Quick Measure – Year to Date
- Quick Measure – Filter
- Quick Measure – Rolling Average
- Quick Measure – Percentage Difference
Module 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
Module 14: Conditional Formatting in Power BI
- By Background Colour
- By Font Colour
- Data Bar
- By Rule
- By Another Column
- Dynamic Chart Titles
- Switch DAX Function
- For Chart Visuals using Measures
Module 15: AI Enhanced Visualization
- What are AI visuals?
- Key Influencer Visual
- Clustering using Scatter Chart
Module 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
Module 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
Module 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
Module 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
Related Courses…
Course Inclusions…
Certified Trainers
All our trainers are Microsoft 365 experts in their own right, and must first be qualified to teach in our own World Education Alliance (WEA) Training Certification Program before delivering any of our courses.
We feel that it is important that all of the trainers and instructors can take their real-world experiences into the classroom, in order to ensure that they are well equipped to respond to any queries and questions which may be put their way, as well as give accurate and relevant guidance in the most appropriate methods to leverage the technology which SharePoint and its related tools provide.
Course Materials Provided
Our Microsoft 365 courseware is known as being some of the best training materials in the world.
FREE Email Support
We offer free post-course support with all of our courses, available via email, telephone, or our Viva Engage community.
FREE Re-sits within 10 Months
Once you've attended any of our public courses, you can re-sit the same course as many times as you like within the next 10 months, as long as your re-sit course has reached the minimum number of paid attendees required to go ahead.
Certificate of Completion
Anyone attending a 3grow course will be provided with a personalised certificate of completion.
Get Hands-on Experience
All 3grow courses include plenty of hands-on experience, delivered via a combination of instructor-led follow-along demos and comprehensive lab exercises.
Personal Class Sizes
Although we allow a maximum of only 10 attendees on our public courses, the average is around 5 students, therefore each participant will leave the course feeling like they received the personal attention they deserve.
Power BI FAQs
What is Power Query?
Power Query is a data connection technology that enables you to discover, connect, combine, and refine data across a wide variety of sources.
What is DAX?
DAX (Data Analysis Expressions) is a formula language used in Power BI for creating custom calculations in your data models.
What types of visualizations can I create in Power BI?
You can create various visualizations including bar charts, line charts, pie charts, maps, and more. The course covers how to customize these visuals to best represent your data.
Can I share my reports and dashboards with others?
Yes, Power BI allows you to publish and share your reports and dashboards with colleagues and stakeholders through Power BI Service.
What is data modeling in Power BI?
Data modeling involves creating relationships between different data tables and using DAX to create calculated columns and measures. This helps in organizing and structuring your data for better analysis.
