We are happy to advise you!
+49 40 253346-10     Contact

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.

Note: This text was automatically translated and may contain errors.

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
Online Training

Duration 2 days

Price (excl. tax)
  • 890.— €

Courseware language: German

Classroom Training

Duration 2 days

Price (excl. tax)
  • Germany: 890.— €
incl. catering

Courseware language: German

 

Schedule

Instructor-led Online Training:   Course conducted online in a virtual classroom.
English
Time zone: Central European Time (CET)   ±1 hour
Online Training Time zone: Central European Time (CET)
Online Training Time zone: Central European Summer Time (CEST)
Online Training Time zone: Central European Summer Time (CEST)
Online Training Time zone: Central European Summer Time (CEST)
Online Training Time zone: Central European Summer Time (CEST)
Online Training Time zone: Central European Time (CET)