* Please note that this is an online course, delivered remotely by a live instructor through Zoom *

Course: PBIADV

Duration: 2 Days

Overview

This intensive two-day course explores the newest capabilities and enhancements in Microsoft Power BI, with a strong focus on addressing the real-world analytical challenges encountered by business professionals. Participants will develop advanced skills in data transformation and preparation, learn proven data modelling techniques and industry best practices, explore AI-powered analytics and visualisation features, and implement effective security and governance controls to support enterprise-scale reporting solutions.

Audience

The Power BI Advanced course is designed for business professionals who want to leverage business intelligence technologies to create meaningful reports and interactive dashboards. It is also well suited to SQL Server Reporting Services (SSRS) developers and report authors seeking modern and more engaging approaches to data analysis and presentation.

Prerequisites

This course is intended for individuals who have previously completed a Power BI Essentials course or possess equivalent practical experience with Power BI. To gain the greatest value from the training, participants should be comfortable working with Microsoft Excel, including features such as VLOOKUP and PivotTables, and should have a solid understanding of the Power BI interface, navigation, and core reporting concepts.

Module List

Module 1: Introduction
Module 2: Power Query - Advanced Data Transformation
Module 3: Power Query - Creating Columns
Module 4: Fuzzy Match
Module 5: Data Profiling
Module 6: Converting Flat File into a Data Model
Module 7: Data Modelling - Fundamental Concepts
Module 8: Data Modelling - Common Issues and Solutions
Module 9: Latest Features in Data Modelling
Module 10: DAX Introduction and Core Concepts
Module 11: Common DAX Functions
Module 12: Quick Measures
Module 13: Data Visualization
Module 14: Conditional Formatting in Power BI
Module 15: AI Enhanced Visualization
Module 16: Performance Analyzer
Module 17: Working with Row Level Security
Module 18: Work Space App
Module 19: Working with Parameters and Functions

Click here for the full 'Power BI Advanced' course outline

Microsoft Power BI Advanced, 2-Day Online Training Course

Choose your tickets

Microsoft Power BI Advanced, Online ticket