Power BI - Beyond the Basics Training Course

DAX

Commonly Used DAX Functions
Sum, Average, Count, DistinctCount
Create a measure table
Copying and Moving Measures
Use Variables in calculation
Different granularity: calculate allocated weight
Filter context
Evaluation Contexts and Relationships
Understand the use of CALCULATE
Table Functions: ALL, ALLEXCEPT, FILTER
Table Functions: DISTINCT, VALUES
Advanced Evaluation Context DAX  
Context transition
Iterator -> nested row context
Row context and Totals
Row context and cumulative total
 
Time Intelligence prerequisites
Time intelligence functions MTD, QTD, YTD, SamePeriodLastYear
YTD, MTD with CALCULATE
Rolling totals for different periods
IF, HasOneValue
Using a Safe Divide Function
Using the Blank() Function
Build an Example Time Intelligence Report
Creating Dynamic titles
Using parameter table
What is scenarios
DAX STUDIO:
Dax as a query language
Capturing and debugging queries with Dax Studio
Power BI referencing

Advanced visualization

Moving away from 1 Dimensional Story-telling
Adding navigation with Buttons and Bookmarks
Create a presentation using bookmarks
Using Focus Mode
Selection Pane
Creating Drill-Through Reports
Use of Custom Visuals
Custom Themes
Building Reports using Q&A
Optimizing Report Slicers
Filtering Reports by Relative Dates
Multiple pages slicers
Types of Slicers and Filters
Filter Pane
Customizing Report Visual Interactivity
Cross Highlighting or Cross Filtering
Choosing Visuals Based on Context
Using Custom Visuals
Creating amazing reports with Layouts
Conditional Colour formatting
Adding & Optimizing Tool Tips
Using the Format Painter
Visual Alignment Tips
Custom Page Sizing
 Tooltip page
Using Logos & Custom Icons
Making Enhancements with Shapes and Lines
Formatting Tips & Tricks
Best Practice Guidelines and Development Tips
Removing or Hiding Data Model Redundancies
Optimizing Waterfall Charts
Getting Value from Scatter, Ribbon & Bullet Charts
Use R and Python in Power BI visuals

Advanced MODELLING

Many-to-Many relationship
Cross filtering
Cross Filtering with CALCULATE
Cross Filtering and Time intelligence
Role Playing Dimensions
Creating  a ordered vs shipped date table
UseRelationship function

AdvanceD Power Query

Merge and Append queries
Create a blank Query
Create a custom table
Enter data manually
Create a table using M coding
Conditional column
Multi-condition column
Columns from example

M

The M Syntax
M language reference table
M Query Basics
Variables and Parameters
Parametrize data source
Create M Query Functions
Invoke functions
Automate import using M function
Create date table using M

Power BI Administration

Data Refresh When, Who, What
Gateway : overview, installation, when needed
Which connection require a Gateway and which do not
Scheduling Data Refresh
Data refresh and licencing
Gateway: personal mode and Enterprise mode
Gateway: prerequisites
Gateway installation
Gateway Configuration
Gateway and direct query
What Gateway do
Security
Data at rest
Data in Use
Data in Transit
Security Users access
Implementing Row Level Security
Implementing Dynamic Security

Administration portal
Usage metrics
Users administration
Tenant settings
Embedded code
Manage custom visuals
Global administrator
Manage user licence
Manage Group and workspaces
Audit logs