Level 2: Advanced Power BI

You’ll go in-depth to take your Power BI reporting to the next level.

Step-by-Step we’ll look at advanced:

  • Data Modeling
  • Report & Dashboard Interactivity
  • Security Features & More..

You’ll be left with an advanced skill set that’ll be highly valuable for you and your organisation.

Course Details

Formats: In-person, Live online, eLearning
Ave. Class Size: 5
Level: Intermediate – Advanced
Times: Starts Weekly
Price: Starting from $295
Includes:
Certificate of Completion
Course PDF Guide & Notes

Course Outline

Module 1: Advanced Overview

  • Overview of BI Process
  • Overview of Different Power BI tools
  • New Features in Power BI
  • Latest updates in Power BI

Module 2: Advanced Power Query Transformations

  • Duplicate a Query
  • Reference a Query
  • Difference between Duplicate & Reference
  • Extract Columns
  • Format Columns
  • Copy Queries to other reports

Module 3: Create Columns in Power Query

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

Module 4: Use Fuzzy Match

  • Use Fuzzy Match to Merge Queries
  • Change Similarity Threshold
  • Work with Fuzzy Merge Options
  • Create and Use a Transformation Table

Module 5: Data Profiling

  • Why use Data Profiling
  • Column Distribution
  • Column Quality
  • Column Profile

Module 6: Converting Flat File into a Data Model

  • Duplicate Queries
  • Remove Columns
  • Remove Duplicates
  • Build Relationships

Module 7: Data Modelling Concepts

  • Key Data Modelling concepts
  • How Filter Propagation Work
  • Understand Double Vs Single Cross Filtering Direction
  • Understand Active Vs Inactive Relationships

Module 8: Data Modelling – Solving Problems

  • 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: Data Modelling Advanced

  • Many to Many Relationships
  • Applying Security Filter in Both Direction
  • Working with Views and Perspectives
  • Composite Model
  • Write Properties for Tool Tip
  • Create Hierarchies

Module 10: DAX Core Concepts

  • Understand DAX Rules & Concepts
  • Filter Context
  • Row Context
  • Calculated Columns
  • Calculated Measures
  • Calculated Tables

Module 11: Useful DAX Functions

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

Module 12: Use Quick Measures

  • Quick Measure – Year to Date
  • Quick Measure – Filter
  • Quick Measure – Rolling Average
  • Quick Measure – Percentage Difference

Module 13: Theme and Formatting Options

  • Introduction to Report Themes & types
  • Create Custom Theme Interface
  • Set the Visual Header Configuration
  • Add Image in Title, Latest Date
  • Create Multi-Row Card
  • Format Pages
  • Enable Always-Focus Mode
  • Recommended Practices

Module 14: Bookmarks

  • Quick Navigation Using Buttons
  • Toggle between Charts Using Buttons
  • Elements of a Bookmark
  • Configure Button States for User Experience
  • Set Button Effects
  • Find Anomalies in Data

Module 15: Data Visualization

  • Create KPI Score Card
  • Working With Uni Char Symbols
  • Slicer Synchronization across Multiple Pages
  • Working With Selection & Bookmarks Pane
  • Create Infographics

Module 16: Implement Conditional Formatting

  • 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 17: AI Enhanced Visualization

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

Module 18: Performance Analyzer

  • Why use the Performance Analyzer
  • Start Recording
  • Understand the Results
  • Drill Down into the Visual
  • Rename the Visual using Selection Pane
  • Analyze Results to Modify Slicer
  • Analyze Results to Refresh a Particular Visual

Module 19: Row Level Security

  • Create Roles
  • Write Table Filter Expressions for a Single & Multiple Fields
  • View as Roles
  • Create Dynamic Row Level Security
  • Assigning Members to Roles
  • URL Filtering
  • Dynamic URL Filtering

Module 20: Use Parameters & Functions

  • Create New Parameter
  • Import Web Query using Parameter
  • Create Functions
  • Invoke Functions
  • Define a List
  • Convert Lists to Tables
  • Add Column by Invoking Custom Functions

Select a time and we'll call you