Power BI Advanced: Take your Power BI Skills to a New Level

Power BI Advanced: Take your Power BI Skills to a New Level, available at $69.99, has an average rating of 4.27, with 74 lectures, based on 101 reviews, and has 804 subscribers.

You will learn about 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 This course is ideal for individuals who are Existing users of Power BI looking to extend their knowledge It is particularly useful for Existing users of Power BI looking to extend their knowledge.

Enroll now: Power BI Advanced: Take your Power BI Skills to a New Level

Summary

Title: Power BI Advanced: Take your Power BI Skills to a New Level

Price: $69.99

Average Rating: 4.27

Number of Lectures: 74

Number of Published Lectures: 74

Number of Curriculum Items: 74

Number of Published Curriculum Objects: 74

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

Existing users of Power BI looking to extend their knowledge

Target Audiences

Existing users of Power BI looking to extend their knowledge

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.

Course Curriculum

Chapter 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

Chapter 2: 02-Advanced Power Query

Lecture 1: 0201-Optimizing Data Types

Lecture 2: 0202-Grouping Data

Lecture 3: 0203-Column Profiling

Lecture 4: 0204-Column Profile Statistics

Chapter 3: 03-Examining M Language Code

Lecture 1: 0301-TableCombine

Lecture 2: 0302-TableNestedJoin

Lecture 3: 0303-TableRemoveColumns vs TableSelectColumns

Lecture 4: 0304-TableUnpivotOtherColumns

Lecture 5: 0305-TableReplaceValues

Lecture 6: 0306-TableTransformColumnTypes

Lecture 7: 0307-TableRenameColumns

Lecture 8: 0308-Writing an M Function

Chapter 4: 04-Data Centralisation

Lecture 1: 0401-Disabling Data Export

Lecture 2: 0402-Creating a Dataflow

Lecture 3: 0403-Creating a Shared Dataset

Lecture 4: 0404-Promoting and Certifying Datasets

Lecture 5: 0405-Granting Access to Datasets

Lecture 6: 0406-Using Microsoft Dataverse

Chapter 5: 05-Advanced Data Modelling

Lecture 1: 0501-Many-to-Many Relationships

Lecture 2: 0502-Cross-Filter Direction

Lecture 3: 0503-Setting Table Properties

Lecture 4: 0504-Setting Field Properties

Chapter 6: 06-Advanced DAX

Lecture 1: 0601-RELATED and RELATEDTABLE

Lecture 2: 0602-Using ADDCOLUMNS

Lecture 3: 0603-Using SUMMARIZE

Lecture 4: 0604-Semi-Additive Measures

Lecture 5: 0605-DAX Path Functions

Chapter 7: 07-DAX Time Intelligence

Lecture 1: 0701-DATESYTD and DATESMTD

Lecture 2: 0702-SAMEPERIODLASTYEAR

Lecture 3: 0703-DATEADD

Lecture 4: 0704-PARALLELPERIOD

Lecture 5: 0705-Running Total

Lecture 6: 0706-DATESINPERIOD

Chapter 8: 08-Role Playing Dimensions

Lecture 1: 0801-Connecting to the data

Lecture 2: 0802-Performing Basic Transformations

Lecture 3: 0803-Connecting to an External Date Table

Lecture 4: 0804-Overview of Relationships

Lecture 5: 0805-Engineering a One-to-Many Relationship

Lecture 6: 0806-Handling multiple significant dates

Lecture 7: 0807-Active and Inactive Relationships

Lecture 8: 0808-Using the Default Relationship

Lecture 9: 0809-The USERELATIONSHIP Function

Lecture 10: 0810-Calculating Key Metrics

Chapter 9: 09-Advanced Visualization Practice

Lecture 1: 0901-Visualizing our Data

Lecture 2: 0902-Displaying Top 5 Customers

Lecture 3: 0903-Sources of Business

Lecture 4: 0904-Displaying the Sales Funnel

Lecture 5: 0905-Converted and Lost Business

Lecture 6: 0906-Displaying Target vs Actual

Lecture 7: 0907-Sales Opportunities by Month

Lecture 8: 0908-Displaying Sales Managers

Lecture 9: 0909-Displaying Sales People

Lecture 10: 0910-Dynamically Showing a Chart

Lecture 11: 0911-Optimizing Visual Interactions

Chapter 10: 10-Advanced Dashboard Tiles

Lecture 1: 1001-Creating Hyperlinks in a Text Box

Lecture 2: 1002-Creating Image Tiles

Lecture 3: 1003-Creating Web-Content Tiles

Lecture 4: 1004-Creating Video Tiles

Lecture 5: 1005-Streaming Real-Time Data Tiles

Chapter 11: 11-Power BI AI Capabilities

Lecture 1: 1101-The Key Influencers Visual

Lecture 2: 1102-The Decomposition Tree Visual

Lecture 3: 1103-The Q&A Visual

Lecture 4: 1104-Quick Insights

Lecture 5: 1105-AI Insights

Instructors

Grant Gamble
Developer, trainer and author

Rating Distribution

1 stars: 0 votes
2 stars: 2 votes
3 stars: 9 votes
4 stars: 32 votes
5 stars: 58 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu