Power BI Desktop Training (PBID)

 

Course Overview

With the Power BI Online Portal, Microsoft offers an almost unlimited number of analysis tools for evaluating complex data models. Any type of data source can be integrated and used in the portal. No matter whether these originate from the company's own enterprise resource planning systems or are even provided from Google Analytics data. Via the client software Power BI Desktop, Microsoft extends the possibilities even further and facilitates access to complex data models.

This text was automatically translated. Please click here to read the original German version.

Who should attend

Advanced users in the field of Excel, Access data analysis

Prerequisites

Basic knowledge of Windows and good Excel or Access skills are required

Course Content

Power BI - Data Sources
  • Retrieval from external data sources
  • Import of CSV / text files
  • Importing Excel workbooks
  • Establish database connections
  • Connect to SQL Server
  • Access to multiple sources in parallel
Query Editor
  • Merge multiple queries
  • Select and name fields of a query
  • Create user-defined fields
  • Remove superfluous columns from the query
  • Show / hide tables in field lists
  • Deactivating the loading of tables
  • Add additional sorts
  • Enter your own data as a new table
  • Merge tables
  • Set up sorting according to additional table
  • Apply Sort by Feature to Existing Fields
  • Duplicate existing tables
  • Removing empty records
  • Grouping of data records
  • Create calculated columns
Structure of a data model
Link data sources
  • Add multiple tables simultaneously as a data source
  • Automatic Relationships from Power BI Desktop
  • Create and modify relationships between tables
Introduction of measures
  • Introduction to DAX (Data Analysis Expressions) Programming
  • Editing interactions via Format Ribbon
  • Add custom columns for formatting/calculation
  • Configuration of combined diagrams
Introduction to calculated tables
  • DAX programming for own tables
  • Linking of calculated tables
  • Relationship types between calculated tables
  • Filtering problems in data models
Complex query methods
  • Combination of calculated tables, columns and measures
  • DAX code for query extension
Individual visualizations
  • Selection of standard visualizations
  • Creation of own visualization types
  • Specific use cases for custom diagrams
  • High density dashboard views
DAX in data models
  • Examples for DAX programming in data models

Prices & Delivery methods

Online Training

Duration
2 days

Price (excl. tax)
  • 990.— €

Courseware language: German

Classroom Training

Duration
2 days

Price (excl. tax)
  • Germany: 990.— €
  • Switzerland: CHF 1,160.—

Courseware language: German

Schedule

Guaranteed date:   The course is guaranteed to run regardless of the number of participants. This excludes unforeseeable events (e.g. accident, illness of the trainer) which make it impossible to carry out the course.
Instructor-led Online Training:   Course conducted online in a virtual classroom.
FLEX Classroom Training (hybrid course):   Course participation either on-site in the classroom or online from the workplace or from home.

German

Time zone: Central European Time (CET)   ±1 hour

Online Training Time zone: Central European Time (CET) Course language: German Guaranteed date!
Online Training Time zone: Central European Time (CET) Course language: German
Online Training Time zone: Central European Summer Time (CEST) Course language: German
Online Training Time zone: Central European Summer Time (CEST) Course language: German
Online Training Time zone: Central European Summer Time (CEST) Course language: German
Online Training Time zone: Central European Summer Time (CEST) Course language: German
FLEX Classroom Training (hybrid course):   Course participation either on-site in the classroom or online from the workplace or from home.

Germany

Hamburg Course language: German
Berlin Course language: German
Frankfurt Course language: German
Munich Course language: German

If you can't find a suitable date, don't forget to check our world-wide FLEX training schedule.