Microsoft Power BI Advanced, 2-Day Online Training Course
Description
* 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
Tickets for good, not greed Humanitix dedicates 100% of profits from booking fees to charity















