Course Outline

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

 

 

  14 Hours
 

Testimonials (10)

Related Courses

Related Categories