Power BI for Advanced User

Audience

• Power BI for Beginner

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

Module 1 :Getting data organised

Grouping tables

Append tables to a query

Module 2 : Advanced Power Query M language

When to use M and when to use DAX

Create a date table in Power Query Editor

Module 3 : Advanced data refreshing

Data refresh

Gateways

Installing a gateway

Adding data sources

Scheduled refresh using gateway

Module 4 : Time intelligence

SAMEPERIODLASTYEAR function

DATEADD function

PARALLELPERIOD function

TOTALYTD and TOTALMTD functions

Module 5 : DAX and filter contexts

FILTER function

ALL function

ALLSELECTED function

CROSSFILTER function

DIVIDE function

Variables in DAX

Ranking with RANKX

What-if parameters

LOOKUPVALUE function

Module 6 : Advanced report features

Creating a hierarchy for a non-date field

Drill-through

Report tooltips

Grouping and binning

Installing custom visuals

Module 7: Perform analytics in Power BI

You will learn how to use Power BI to perform data analytical functions, how to identify outliers in your data, how to group data together, and how to bin data for analysis. You will also learn how to perform time series analysis. Finally, you will work with advanced analytic features of Power BI, such as Quick Insights, AI Insights, and the Analyze feature.

Learning objectives

 In this module, you will:

 Explore statistical summary.

Identify outliers with Power BI visuals.

Group and bin data for analysis.

Apply clustering techniques.

Conduct time series analysis.

Use the Analyze feature.

Use advanced analytics custom visuals.

Review Quick insights.

Apply AI Insights.

Module 8: Implement row-level security

Row-level security (RLS) allows you to create a single or a set of reports that targets data for a specific user. In this module, you will learn how to implement RLS by using either a static or dynamic method and how Microsoft Power BI simplifies testing RLS in Power BI Desktop and Power BI service.

 Learning objectives

 In this module, you will:

 Configure row-level security by using a static method.

Configure row-level security by using a dynamic method.

Summary and Next Steps