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

The G Com Solutions Power BI Advanced course is designed to allow experienced Power BI users to hone their expertise by tackling a series of challenging and practical Power BI techniques.

This course assumes that you are already familiar with Power Query. So we dive straight into advanced topics like optimizing Data Types, column Profiling, and writing M language code, and discussing advanced data connection techniques used when working with JSON, XML, and SharePoint libraries and folders.

The course also provides further practice on data modeling, discussing such topics as role-playing dimensions and the 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, tables, DAX measures, and time-intelligence functions.

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

As an advanced Power BI report developer, it is also essential that you build and utilize datasets most efficiently. 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 certify your centralized datasets.

The course also provides advanced visualization practice. You will be allowed 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, and 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 visuals as well as displaying a hierarchy of images in slices, which enable the user to track the performance of sales managers and individual salespeople. We also look at a valuable technique for creating a chart that only becomes visible when the user selects a slicer.

In short, this course will offer Power BI users familiar with all of the fundamentals a challenging hands-on workshop, which will expand their familiarity with Power BI best practices, data modeling, visualization, and report creation.