YoVDO

Implement and manage an analytics environment

Offered By: Microsoft via Microsoft Learn

Tags

Business Intelligence Courses Data Governance Courses Azure Synapse Analytics Courses Auditing Courses Capacity Management Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
  • Module 1: Learn the fundamental rules, regulations, and policies of a BI governance approach.

    In this module, you will:

    • Define the key components of an effective BI governance model
    • Describe the key elements associated with data governance
    • Configure, deploy, and manage elements of a BI governance strategy
    • Set up BI help and support settings
  • Module 2: Learn how to collaborate and share dashboards and reports with coworkers.

    In this module, you will:

    • Understand the differences between My workspace, workspaces, and apps
    • Describe new workspace capabilities and how they improve the user experience
    • Anticipate migration impact to Power BI users
    • Share, publish to the web, embed links and secure Power BI reports, dashboards, and content
  • Module 3: Learn how to use activity logs and auditing with Power BI to monitor and inspect user activity in a Power BI environment.

    In this module, you will:

    • Discover what usage metrics are available through the Power BI admin portal
    • Optimize use of usage metrics for dashboards and reports
    • Distinguish between audit logs and the activity logs
  • Module 4: Learn about the differences between Power BI Pro and Power BI Premium, and how Power BI Premium manages capacity resources.

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

    • Describe the difference between Power BI Pro and Power BI Premium
    • Define dataset eviction
    • Explain how Power BI manages memory resources
    • List three external tools you can use with Power BI Premium.
  • Module 5: Learn how to establish a data access infrastructure for accessing all your data within Power BI.

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

    • Understand the difference between gateways, the various connectivity modes, and data refresh methods.
    • Describe the gateway network requirements, where to place the gateway in your network, and how to use clustering to ensure high availability.
    • Scale, monitor, and manage gateway performance and users.
  • Module 6: Learn the various ways to share Power BI reports beyond your Power BI tenant.

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

    • Describe the various embedding scenarios that allow you to broaden the reach of Power BI
    • Understand the options for developers to customize Power BI solutions
    • Learn to provision and optimize Power BI embedded capacity and create and deploy dataflows
    • Build custom Power BI solutions template apps
  • Module 7: Common manual tasks can be automated with Microsoft Power BI Cmdlets for Windows PowerShell and PowerShell core.

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

    • Use REST APIs to automate common Power BI admin tasks
    • Apply Power BI Cmdlets for Windows PowerShell and PowerShell core
    • Use Power BI Cmdlets
    • Automate common Power BI admin tasks with scripting
  • Module 8: Build reports using Power BI within Azure Synapse Analytics

    In this module, you'll:

    • Describe the Power BI and Synapse workspace integration
    • Understand Power BI data sources
    • Describe optimization options
    • Visualize data with serverless SQL pools

Syllabus

  • Module 1: Module 1: Provide governance in a Power BI environment
    • Introduction
    • Elements of data governance
    • Configure tenant settings
    • Deploy organizational visuals
    • Manage embed codes
    • Help and support settings
    • Check your knowledge
    • Summary
  • Module 2: Module 2: Facilitate collaboration and sharing in Power BI
    • Introduction
    • Workspaces evolved
    • Impact to Power BI users
    • Permissions in workspaces v2
    • Apps in Power BI
    • Share
    • Publish to web
    • Embed and link in portals
    • Data sensitivity labels
    • Data privacy
    • Check your knowledge
    • Summary
  • Module 3: Module 3: Monitor and audit usage
    • Introduction
    • Usage metrics for dashboards and reports
    • Usage metrics for dashboards and reports - new version
    • Audit logs
    • Activity log
    • Check your knowledge
    • Summary
  • Module 4: Module 4: Provision Premium capacity in Power BI
    • Introduction
    • Premium resource management
    • Supporting multi geographies
    • Bring your own key (BYOK)
    • Featured external tools
    • Check your knowledge
    • Summary
  • Module 5: Module 5: Establish a data access infrastructure in Power BI
    • Introduction
    • Personal gateways versus enterprise gateways
    • How data is refreshed
    • Gateway network requirements
    • Where to install gateway?
    • Establish high availability gateways
    • Establish load balancing of gateways
    • Gateway performance monitoring documentation
    • Multiple data sources per gateway
    • Manage gateway users
    • Active Directory user mapping with custom property lookup
    • Check your knowledge
    • Summary
  • Module 6: Module 6: Broaden the reach of Power BI
    • Introduction
    • REST API custom development
    • Provision a Power BI embedded capacity
    • Dataflow introduction
    • Dataflow explained
    • Create a Dataflow
    • Dataflow capabilities on Power BI Premium
    • Template apps - install packages
    • Template apps - installed entities
    • Template app governance
    • Check your knowledge
    • Summary
  • Module 7: Module 7: Automate Power BI administration
    • Introduction
    • REST API - Power BI service
    • Microsoft Power BI cmdlets for Windows PowerShell and PowerShell core
    • Install and use the Power BI cmdlet
    • Test REST API calls
    • Script typical administrator tasks
    • Lab
    • Check your knowledge
    • Summary
  • Module 8: Module 8: Build reports using Power BI within Azure Synapse Analytics
    • Introduction
    • Describe the Power BI and Synapse workspace integration
    • Exercise - Connect to Power BI from Synapse
    • Understand Power BI data sources
    • Exercise - Create a new data source to use in Power BI
    • Exercise - Create a new Power BI report in Synapse Studio
    • Describe Power BI optimization options
    • Exercise - Improve performance with materialized views and result-set caching
    • Visualize data with serverless SQL pools
    • Knowledge check
    • Summary

Tags

Related Courses

Relational Database Support for Data Warehouses
University of Colorado System via Coursera Compliance in Office 365: Data Governance
Microsoft via edX Introduction to Data Analytics for Business
University of Colorado Boulder via Coursera Compliance in Office 365: Data Governance
Microsoft via edX Microsoft Azure Security Services
Microsoft via edX