What you’ll learn
- Learn the finer points of Power BI
- Extend your knowledge of Power Query
- Quickly customize Power BI reports for different audiences
- Integrate Power BI with other Microsoft products
- Intermediate data modelling and DAX techniques
The Power BI Intermediate course by G Com Solutions is designed for users who are already familiar with Power BI and are looking to broaden their horizons when it comes to creating reports and dashboards.
The course will extend your knowledge of the Query Editor by showing your how to use query parameters and templates to add power and flexibility to your report creation. You will learn how to use query parameters to control data sources and to filter data as it’s loaded into the data model.
The course also discusses row-level security (RLS), the creation of roles and the implementation of RLS in the Power BI service. And we’ll also see how to leverage the DAX USERNAME function to create roles which are based on the user’s login.
We then move on to the integration of Power BI with other Microsoft products. We look at the incorporation of Excel solutions into Power BI workspaces and how to use the Analyze in Excel feature to build Excel reports driven by Power BI datasets. We also discuss the pinning of Excel content to Power BI dashboards and how to leverage Power BI’s dashboard subscription feature to distribute Excel content to a much wider audience than is normally possible.
We look at connecting to SharePoint folders and sub-folders, connecting to SharePoint lists and the security implications involved when embedding Power BI reports within SharePoint pages.
We also discuss PowerPoint integration: the tenant settings which control the ability to export reports to PowerPoint, the mechanism for exporting reports; and how to get the most out of this feature by optimizing your reports specifically for PowerPoint export.
The course then moves on to the configuration and implementation of drill-through pages and this includes a discussion of cross-report drill-through and how to overcome some of the limitations of this feature. And, we end this section with a look at a feature often used in conjunction with drill-through; customized tooltip pages.
Next, we talk about DAX what-if parameters and, after discussing the use of Power BI’s built-in feature, which can only be used with numeric parameters, the course shows you how to extend this feature by creating your own custom parameter tables.
And we use the parameters feature as a launchpad to the creation of a sophisticated currency conversion dashboard which gives us a chance to practice other useful techniques, such as the inclusion of custom visuals in your reports, the use of DAX variables to make your formulas clearer and easier to maintain, and how to provide useful interactive feedback to your users by creating dynamic titles driven by complex DAX formulas.
So, if you’ve already mastered the basics of Power BI and are looking to build on that knowledge, the Power BI Intermediate course by G Com Solutions could be exactly what you need.