* 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