G Com Solutions
About the instructor
All G Com Solutions trainers (both online and in person) are highly experienced IT professionals and qualified to deliver a wide range of Microsoft training courses.
They have a vast experience of delivering public and on-site IT training content at different skill levels, to groups of varying sizes and have all obtained the MCSA BI Reporting certification.
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.
- 1. Overview of Parameters and Templates FREE PREVIEW
- 2. The solution which we will create FREE PREVIEW
- 3. Creating dynamic titles
- 4. Parameterizing a filepath
- 5. Creating static list parameters
- 6. Creating dynamic list query parameters
- 7. Using parameters to filter data
- 8. Using Merge Queries for filtering
- 9. Exporting and using a Power BI template
- 10. Modifying parameters in the Power BI service
- 1. Importing Excel Tables
- 2. Uploading Excel Workbooks
- 3. Exporting data
- 4. Analyze in Excel FREE PREVIEW
- 5. Installing Power BI Publisher for Excel
- 6. Pinning Content to Power BI Dashboards
- 7. Using the Pin Manager
- 8. Workspace compatibility
- 9. Connecting to Power BI Datasets
- 10. Subscribing to Excel Dashboards
- 1. The solution we will be creating
- 2. Connecting to the data
- 3. Creating a date table
- 4. Creating a measures table
- 5. Creating a reference to a query
- 6. The Chiclet Slicer custom visual
- 7. The Timeline Slicer custom visual
- 8. Creating parameter slicers
- 9. Calculating the offset price
- 10. Ceating a dynamic title