Microsoft Power BI Advanced, Online Training Course

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

Course: PBIADV

Duration: 2 Days

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.

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.

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.

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