Course Code: powerbii
Duration: 21 hours
Course Outline:

Duration of training：

3 days, 21 hours in total. (1 hour break included per day)

Data Visualization Overview

Excel & Power BI

Power BI Overview

  • Power BI Desktop Introduction
  • Connect to Data
  • Load data into Power BI

Power Query

  • Merge/Append
  • Pivot/Unpivot
  • Transformation

Data Modeling

Data Visualization

  • Chart Creation
  • Mobile View
  • AI Function
  • Performance Analysis

Report Publish and Share

  • Power BI Service Overview
  • Publish and Share
  • Dashboard

Row Level Security Setting

  • Simple Security
  • Dynamic Security
  • Page Level Security
  • Report Service Security Setting

DAX Function

  • Aggregation functions
  • Filter/Logic Functions
  • Calculate Enginee
  • Datetime Function
  • Variable