Microsoft Power BI Advanced, 2-Day Training Course in Melbourne
Event description
Please Note: All of our in-person public courses are hosted at wheelchair-accessible venues. If you require any specific assistance, please contact learn@3grow.net to discuss this prior to booking and we will do our utmost to help.
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
Tickets for good, not greed Humanitix dedicates 100% of profits from booking fees to charity