Course Code: powerbi2
Duration: 14 hours
Prerequisites:

There are no specific requirements needed to attend this course.

Course Outline:

Introduction

  • Power BI - a unified, real-time business analytics dashboards

Power BI Architecture

  • Web Front End (WFE) cluster, Back End cluster, and Azure

Data sources

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

Modeling

  • Introduction to Power Pivot
  • Data modeling and data relationships

Relationship between tables (single and multidirectional data filtering)

  • Introduction to the DAX language
    • 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
    • Working with DAX templates
  • Creating DAX queries for calculate column, tables and measures
  • Custom business calculations in DAX/Power Pivot
  • DAX best practices
  • DAX advanced features

Visualizations

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

Data Access Management - Row-Level Security

Team work and mobile with Power BI

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