Design and build tabular models

Aperçu

Title:

Design and Build Tabular Models

Description:

This comprehensive course provided by Microsoft Learn covers various aspects of creating and managing tabular models in Power BI. The structured curriculum is divided into several modules:

• Module 1:

  Foundationally, you'll delve into Power BI model relationships.

  Learn to define, set up, and manipulate these relationships, and delve into Dynamic Analysis Expressions (DAX) relationship functions, alongside understanding how relationships are evaluated.

• Module 2:

  The focus shifts to time intelligence, a critical aspect of dynamic business reporting. You will explore and implement DAX calculations such as Year-To-Date (YTD) and Year-Over-Year (YoY) growth within your model.

• Module 3:

  Emphasis is placed on creating and managing calculation groups.

  Discover their functionality, maintenance, and application in Power BI reports.

• Module 4:

  You'll tackle model security using row-level security (RLS) and object-level security (OLS), learning to restrict access to model data and objects effectively.

• Module 5:

  Wrap up with performance optimization. Tools such as Performance Analyzer, DAX Studio, and Tabular Editor help you enhance query and data model performance.

University:

Provider:

Microsoft Learn

Categories:

Data Analysis Courses

Matières