YoVDO

Work with semantic models in Microsoft Fabric

Offered By: Microsoft via Microsoft Learn

Tags

Data Modeling Courses Scalability Courses Row-Level Security Courses Star Schema Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
  • Module 1: Scalable data models enable enterprise-scale analytics in Power BI. Implement data modeling best practices, use large dataset storage format, and practice building a star schema to design analytics solutions that can scale.

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

    • Describe the importance of building scalable data models
    • Implement Power BI data modeling best practices
    • Use the Power BI large dataset storage format
  • Module 2: 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 3: 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.
  • 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.

Syllabus

  • Module 1: Module 1: Understand scalability in Power BI
    • Introduction
    • Describe the significance of scalable models
    • Implement Power BI data modeling best practices
    • Configure large datasets
    • Exercise: Create a star schema model
    • Knowledge check
    • Summary
  • Module 2: Module 2: 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 3: Module 3: 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
  • 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

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