Design and build tabular models

Overview

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

Syllabus

Taught by

Tags

united states