Power BI Datenmodellierung - Schulung in Berlin

After the training, you will be able to build complex data models in Power BI and effectively use the possibilities of Power BI.

Description

If you want to create a good data model for Power BI, you first need to organize your data and simplify it using, for example, a star schema. This requires a solid knowledge of the possibilities of data modeling. In this training you will also learn why selecting the appropriate data granularity is important for the performance and usability of your Power BI reports.

Target group

Advanced Power BI users

Duration

1 day

Content in detail

Introduction to tabular data models

• Demarcation of tabular and multidimensional databases
• Attributes, dimensions, facts
• The star schema

Detailed analysis of the data import

• Import mode
• Direct query
• Dual mode

Best practices for the most important modeling points

• Setting up hierarchies
• Time table
• Creation and structure
• Time table via DAX and import
• Time viewing logics
• DAX functions (Date & Time, Time Intelligence)
• Linking tables
• Cardinalities (1:n, n:m)
• Filter direction
• Indirect link (DAX)
• Calculated tables
• Structure and purpose
• Calculated columns vs. measures

ATVISIO consulting practice: “Best practice” and avoidable errors

New: Now as online training book

On the mutually agreed training day, your trainer will contact you and first mirror his screen onto your computer - and vice versa if necessary. Ideally, you should have a second PC or laptop ready for your own exercises. Then the training can begin.

With online training you save time and travel costs and can use the hours gained productively for your daily business.

For further information, call us.

Further information

For companies, this training can also be carried out as in-house training. Please contact Rebecca Schlesser about this - by email schlesser@atvisio.de or by phone 0631/4140140