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
 

Number of participants


Starts

Ends


Dates are subject to availability and take place between 09:30 and 16:30.
Open Training Courses require 5+ participants.

Testimonials (10)

Related Courses

Big Data Business Intelligence for Govt. Agencies

  35 Hours

Related Categories