Power Bi Advanced: Take Your Power Bi Skills To A New Level

Hone your Power BI Expertise by Learning Advanced Power BI Skills and Techniques

What you'll learn

Advanced features of Microsoft Power BI

Extend your knowledge of Power Query

Advanced insights into Power Query and the M language

Advanced data modelling and visualization techniques

Requirements

Knowledge of the basics of Power BI Desktop and the Power BI service

Description

The G Com Solutions Power BI Advanced course is designed to give experienced Power BI users the opportunity to hone their expertise in Power BI by tackling a series of challenging and useful Power BI techniques.This course assumes that you are already familiar with Power Query and so we dive straight into advanced topics like the optimizing Data Types, column Profiling and writing M language code, as well as discussing advanced data connection techniques used when working with JSON, XML and SharePoint libraries and folders.The course also provides further practice on data modelling, discussing such topics as role-playing dimensions and use of inactive relationships to cater for multiple significant dates within a main fact table. And, naturally, you will get plenty of additional practice in all aspects of DAX: calculated columns, calculated tables, DAX measures and time-intelligence functions.As an advanced Power BI report developer, it is also important that you build and utilize datasets in the most efficient manner. In this course, you will learn how to implement data centralization by using PBIDS Files, disabling the export of static data from your reports, creating dataflows and shared Datasets and how to promote and certifying your centralized datasets.The course also provides advanced visualization practice, and you will be given the opportunity to create a sophisticated sales pipeline dashboard, starting from scratch and using such techniques as dynamic chart titles and colors and Dynamically Showing a Chart.Then, back in the Power BI service, we discuss the finer points of dashboard tiles: Creating Hyperlinks in a Text Box, working with Image Tiles, Web content tiles, Video Tiles, and Streaming Real-time data by integrating Power Automate functionality.We then turn our attention to visualizing our data, we look at using the form of visual as well as displaying a hierarchy of images in slices, which enable the user to track the performance of sales managers, as well as individual salespeople. We also look at a useful technique for creating a chart which only becomes visible when a slicer selection is made by the user.In short, this course will offer Power BI users who are familiar with all of the fundamentals a challenging hands-on workshop, which will expand their familiarity with Power BI best practices, data modelling, visualization and report creation.

Overview

Section 1: 01-Advanced Data Connections

Lecture 1 0100a-Welcome

Lecture 2 0100b-Download the Course Files

Lecture 3 0101-Navigating Data Structures

Lecture 4 0102-Connecting to JSON Files

Lecture 5 0103-Connecting to XML Files

Lecture 6 0104-Connecting to Files in a SharePoint Library

Lecture 7 0105-Connecting to SharePoint Folders

Lecture 8 0106-Accessing SharePoint Sub-Folders

Lecture 9 0107-Understanding Storage Modes

Lecture 10 0108-Using PBIDS Files

Section 2: 02-Advanced Power Query

Lecture 11 0201-Optimizing Data Types

Lecture 12 0202-Grouping Data

Lecture 13 0203-Column Profiling

Lecture 14 0204-Column Profile Statistics

Section 3: 03-Examining M Language Code

Lecture 15 0301-TableCombine

Lecture 16 0302-TableNestedJoin

Lecture 17 0303-TableRemoveColumns vs TableSelectColumns

Lecture 18 0304-TableUnpivotOtherColumns

Lecture 19 0305-TableReplaceValues

Lecture 20 0306-TableTransformColumnTypes

Lecture 21 0307-TableRenameColumns

Lecture 22 0308-Writing an M Function

Section 4: 04-Data Centralisation

Lecture 23 0401-Disabling Data Export

Lecture 24 0402-Creating a Dataflow

Lecture 25 0403-Creating a Shared Dataset

Lecture 26 0404-Promoting and Certifying Datasets

Lecture 27 0405-Granting Access to Datasets

Lecture 28 0406-Using Microsoft Dataverse

Section 5: 05-Advanced Data Modelling

Lecture 29 0501-Many-to-Many Relationships

Lecture 30 0502-Cross-Filter Direction

Lecture 31 0503-Setting Table Properties

Lecture 32 0504-Setting Field Properties

Section 6: 06-Advanced DAX

Lecture 33 0601-RELATED and RELATEDTABLE

Lecture 34 0602-Using ADDCOLUMNS

Lecture 35 0603-Using SUMMARIZE

Lecture 36 0604-Semi-Additive Measures

Lecture 37 0605-DAX Path Functions

Section 7: 07-DAX Time Intelligence

Lecture 38 0701-DATESYTD and DATESMTD

Lecture 39 0702-SAMEPERIODLASTYEAR

Lecture 40 0703-DATEADD

Lecture 41 0704-PARALLELPERIOD

Lecture 42 0705-Running Total

Lecture 43 0706-DATESINPERIOD

Section 8: 08-Role Playing Dimensions

Lecture 44 0801-Connecting to the data

Lecture 45 0802-Performing Basic Transformations

Lecture 46 0803-Connecting to an External Date Table

Lecture 47 0804-Overview of Relationships

Lecture 48 0805-Engineering a One-to-Many Relationship

Lecture 49 0806-Handling multiple significant dates

Lecture 50 0807-Active and Inactive Relationships

Lecture 51 0808-Using the Default Relationship

Lecture 52 0809-The USERELATIONSHIP Function

Lecture 53 0810-Calculating Key Metrics

Section 9: 09-Advanced Visualization Practice

Lecture 54 0901-Visualizing our Data

Lecture 55 0902-Displaying Top 5 Customers

Lecture 56 0903-Sources of Business

Lecture 57 0904-Displaying the Sales Funnel

Lecture 58 0905-Converted and Lost Business

Lecture 59 0906-Displaying Target vs Actual

Lecture 60 0907-Sales Opportunities by Month

Lecture 61 0908-Displaying Sales Managers

Lecture 62 0909-Displaying Sales People

Lecture 63 0910-Dynamically Showing a Chart

Lecture 64 0911-Optimizing Visual Interactions

Section 10: 10-Advanced Dashboard Tiles

Lecture 65 1001-Creating Hyperlinks in a Text Box

Lecture 66 1002-Creating Image Tiles

Lecture 67 1003-Creating Web-Content Tiles

Lecture 68 1004-Creating Video Tiles

Lecture 69 1005-Streaming Real-Time Data Tiles

Section 11: 11-Power BI AI Capabilities

Lecture 70 1101-The Key Influencers Visual

Lecture 71 1102-The Decomposition Tree Visual

Lecture 72 1103-The Q&A Visual

Lecture 73 1104-Quick Insights

Lecture 74 1105-AI Insights

Existing users of Power BI looking to extend their knowledge