Beskrivning

Background

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.

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.

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 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, this course could be exactly what you need. These lessons will take you from an intermediate to an advanced user of Power BI.

Prerequisites

At least 3 to 6 months of experience working in Power BI is considered an asset. More realistically, the prerequisites for this course are a fun attitude and a desire to learn!

Audience

Business analyst, data analyst, financial analyst, marketing analyst, manager, executive… Power BI’s versatility allows it to serve many users. If you need to analyze data to derive key information, you are concerned.

Course Topics

• Creating a custom date table
• Query Parameters & Templates
• Incorporating Excel
• Create Dashboards
• KPIs
• Drill-through
• Report-page tooltips
• Bookmarks
• What-if Parameters
• Buttons, Shapes & Images
• Data alerts
• Live connections to Power BI datasets
• Power BI Themes
• And many, many more!

Kursen levereras i samarbete med

Kontakta oss om denna kurs