Certificate Authentication

Power BI Architecture

Data sources

• On-premises and online data sources
• Data transformations + M language
• Direct connections to selected sources (SQL Server, OLAP)

Modeling

Relationship between tables (single and multidirectional data filtering)

• DAX - templates and best practices
• Introduction to DAX
  • Most commonly used functions and context of calculations
  • Working with the time dimension (including fiscal periods, comparing periods, YTD)
  • Hierarchie parent-child
  • Filtering data relative to hierarchy
  • Popular DAX templates

Visualizations

• Interactive data analysis
• Select the appropriate visualization
• Filters, grouping, exclusions
• Visualization on maps
• Visualizations using the R language
• Visualization enhancements (so-called custom visuals)

Data Access Management - Row-Level Security

Team work and mobile with Power BI

• Dashboards and reports
• Q & A mechanism
• Workspaces Mobile applications