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

Accounting for Business Decision Making: Strategy Assessment and Control
University of Illinois at Urbana-Champaign via Coursera Operations Management
Udemy Operating Azure Stack Hub
Pluralsight Using Workflow Management to Optimize Resource Allocation
Pluralsight On Premises Capacity Upgrade and Monitoring with Google Cloud's Apigee API Platform
Pluralsight