Microsoft Power BI Desktop

For all users who need to quickly and efficiently create interactive corporate reports.

Any experiences with databases are great advantage for this training.

Application description

Data connection

• Live connection
• Imprts
• Import from PowerPivot data model
• Update options

Background queries (PowerQuery)

Data sources

• Non-relational
• Relational
• Active vs. non-active relations
• Cardinality of relations
• Direction of cross-filter

Unexpected change of data source

Building of data model

Building & using calendar

Data categorization

Hierarchy

• Single tabular
• Multitabular
• P\C hierarchies

Column DAX functions

Tabular DAX functions

Measures

KPI

Vizualization

• Built-in
  • Tables + conditional formatting
  • Charts
  • R script visual
• Custom
• Customization of visual (demo)
• Modification of tooltip help

Interaction

Data Drilling

Filers

• Visual level
• Page level
• Report level

Roles

Publication

• Power BI Services (Office 365)
  • Content packages
  • E-mail
  • Iframe
  • QR codes
• Pyramid Analytics (paid)

Previous courses

Microsoft Excel – Advanced Methods and Functions [MSEX3]

Microsoft Excel – In Practice [MSEX2]

Next courses

DAX in Power Pivot Add-in [DAXPP]

Microsoft Power BI Desktop - Advanced Techniques [PBID2]

Related courses

Microsoft Access 2016/2013 – Basic Course [MSAC1]

Microsoft Copilot - AI in the Office [MSCOP1]

Alernative courses

Beyond Excel I. [MSEXNL]

Beyond Excel II. [MSEXNL2]