Curso: Power BI

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 - Understanding the syntax 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)
  • Functions for naturalizing a parent-child hierarchy
  • Filter functions
  • DAX templates

Visualizations

• Interactive data analysis
• Select the appropriate visualization
• Filters, grouping, exclusions
• Visualization on maps
• 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