Power BI Datenmodellierung - Schulung in Hannover

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 Audience< /p>

Advanced Power BI users

Duration

1 day

< strong>Content in detail

Introduction to tabular data models

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

Detailed analysis of the data import< /strong>

• 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 linking (DAX)
• Calculated tables
• Structure and intended use
• Calculated columns vs. measures

ATVISIO consulting practice: “Best practice” and avoidable errors

New: Book online training now

You will be contacted on the mutually agreed training day Your trainer and first mirrors 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 day-to-day business.

For further information, call us.< /p>

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