YoVDO

Design and build tabular models

Offered By: Microsoft via Microsoft Learn

Tags

Data Analysis Courses Row-Level Security Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
  • Module 1: Power BI model relationships form the basis of a tabular model. Define Power BI model relationships, set up relationships, recognize DAX relationship functions, and describe relationship evaluation.

    By the end of this module, you’ll be able to:

    • Understand how model relationship work.
    • Set up relationships.
    • Use DAX relationship functions.
    • Understand relationship evaluation.
  • Module 2: By the end of this module, you'll learn the meaning of time intelligence and how to add time intelligence DAX calculations to your model. These calculations will include year-to-date (YTD), year-over-year (YoY) growth, and others.

    By the end of this module, you'll be able to:

    • Define time intelligence.
    • Use common DAX time intelligence functions.
    • Create useful intelligence calculations.
  • Module 3: Create calculation groups

    After completing this module, you will be able to:

    • Explore how calculation groups work.
    • Maintain calculation groups in a model.
    • Use calculation groups in a Power BI report.
  • Module 4: Enforce model security in Power BI using row-level security and object-level security.

    By the end of this module, you’ll be able to:

    • Restrict access to Power BI model data with RLS.
    • Restrict access to Power BI model objects with OLS.
    • Apply good development practices to enforce Power BI model security.
  • Module 5: Use tools to optimize Power BI performance

    After completing this module, you'll be able to:

    • Optimize queries using performance analyzer.
    • Troubleshoot DAX performance using DAX Studio.
    • Optimize a data model using Tabular Editor.

Syllabus

  • Module 1: Module 1: Create Power BI model relationships
    • Introduction
    • Understand model relationships
    • Set up relationships
    • Use DAX relationship functions
    • Understand relationship evaluation
    • Exercise: Work with model relationships
    • Knowledge check
    • Summary
  • Module 2: Module 2: Use DAX time intelligence functions in Power BI Desktop models
    • Introduction
    • Use DAX time intelligence functions
    • Additional time intelligence calculations
    • Exercise - Create Advanced DAX Calculations in Power BI Desktop
    • Check your knowledge
    • Summary
  • Module 3: Module 3: Create calculation groups
    • Introduction
    • Understand calculation groups
    • Explore calculation groups features and usage
    • Create calculation groups in a model
    • Exercise: Create calculation groups
    • Knowledge check
    • Summary
  • Module 4: Module 4: Enforce Power BI model security
    • Introduction
    • Restrict access to Power BI model data
    • Restrict access to Power BI model objects
    • Apply good modeling practices
    • Exercise: Enforce model security
    • Knowledge check
    • Summary
  • Module 5: Module 5: Use tools to optimize Power BI performance
    • Introduction
    • Use Performance analyzer
    • Troubleshoot DAX performance by using DAX Studio
    • Optimize a data model by using Best Practice Analyzer
    • Exercise: Use tools to optimize Power BI performance
    • Knowledge check
    • Summary

Tags

Related Courses

New Features in SQL Server 2016 for Developers
LinkedIn Learning SQL Server: Security, Encryption, and Masking
LinkedIn Learning Curso Completo de Power BI Service
Coursera Project Network via Coursera Implement Security on Azure Synapse
Pluralsight Building Applications with Power BI
Pluralsight