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
• introducing DAX calculation groups to enhance measures flexibility and re-usability

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

Advanced visual (Cont...)

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 Language

• 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