課程大綱： Power BI培訓(xùn)
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
加入高級會員獲得助教答疑
