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

Social Network Analysis
University of Michigan via Coursera Intro to Algorithms
Udacity Data Analysis
Johns Hopkins University via Coursera Computing for Data Analysis
Johns Hopkins University via Coursera Health in Numbers: Quantitative Methods in Clinical & Public Health Research
Harvard University via edX