Designing And Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure And Microsoft Power BI DP500 - Canada

Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI DP500 Course Outline

Module 1: Explore Azure Data Services for Modern Analytics

• Introduction
• Understand the Azure Data Ecosystem
• Explore Modern Analytics Solution Architecture

Module 2: Understand Concepts of Data Analytics

• Introduction
• Understand Data Analytics Types
• Explore the Data Analytics Process
• Understand Types of Data and Data Storage

Module 3: Explore Data Analytics at Scale

• Introduction
• Explore Data Team Roles and Responsibilities
• Review Tasks and Tools for Data Analysts
• Scale Analytics with Azure Synapse Analytics and Power BI
• Strategies to Scale Analytics

Module 4: Introduction to Microsoft Purview

• Introduction
• What Is Microsoft Purview?
• How Microsoft Purview Works
• When to Use Microsoft Purview

Module 5: Discover Trusted Data Using Microsoft Purview

• Introduction
• Search for Assets
• Browse Assets
• Use Assets with Power BI
• Integrate with Azure Synapse Analytics

Module 6: Catalog Data Artifacts by Using Microsoft Purview

• Introduction
• Register and Scan Data
• Classify and Label Data
• Search the Data Catalog

Module 7: Manage Power BI Assets by Using Microsoft Purview

• Introduction
• Register and Scan a Power BI Tenant
• Search and Browse Power BI Assets
• View Power BI Metadata and Lineage

Module 8: Integrate Microsoft Purview and Azure Synapse Analytics

• Introduction
• Catalog Azure Synapse Analytics Data Assets in Microsoft Purview
• Connect Microsoft Purview to an Azure Synapse Analytics Workspace
• Search a Purview Catalog in Synapse Studio
• Track Data Lineage in Pipelines
• Exercise - Integrate Azure Synapse Analytics and Microsoft Purview

Module 9: Introduction to Azure Synapse Analytics

• Introduction
• What is Azure Synapse Analytics
• How Azure Synapse Analytics Works
• When to Use Azure Synapse Analytics
• Exercise - Explore Azure Synapse Analytics

Module 10: Use Azure Synapse Serverless SQL Pool to Query Files in a Data Lake

• Introduction
• Understand Azure Synapse Serverless SQL Pool Capabilities and Use Cases
• Query Files Using a Serverless SQL Pool
• Create External Database Objects
• Exercise - Query Files Using a Serverless SQL Pool

Module 11: Analyze Data with Apache Spark in Azure Synapse Analytics

• Introduction
• Get to Know Apache Spark
• Use Spark in Azure Synapse Analytics
• Analyse Data with Spark
• Visualize Data with Spark
• Exercise - Analyse Data with Spark

Module 12: Analyse Data in a Relational Data Warehouse

• Introduction
• Design a Data Warehouse Schema
• Create Data Warehouse Tables
• Load Data Warehouse Tables
• Query a Data Warehouse
• Exercise - Explore a Data Warehouse

Module 13: Choose a Power BI Model Framework

• Introduction
• Describe Power BI Model Fundamentals
• Determine When to Develop an Import Model
• Determine When to Develop a DirectQuery Model
• Determine When to Develop a Composite Model
• Choose a Model Framework

Module 14: 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

Module 15: Create and Manage Scalable Power BI Dataflows

• Introduction
• Define Use Cases for Dataflows
• Create Reusable Assets
• Implement Best Practices
• Exercise: Create a Dataflow

Module 16: Create Power BI Model Relationships

• Introduction
• Understand Model Relationships
• Set Up Relationships
• Use DAX Relationship Functions
• Understand Relationship Evaluation
• Exercise: Work with Model Relationships

Module 17: 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

Module 18: Create Calculation Groups

• Introduction
• Understand Calculation Groups
• Explore Calculation Groups Features and Usage
• Create Calculation Groups in a Model
• Exercise: Create Calculation Groups

Module 19: 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

Module 20: 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

Module 21: Understand Advanced Data Visualization Concepts

• Introduction
• Create and Import a Custom Report Theme
• Enable Personalized Visuals in a Report
• Design and Configure Power BI Reports for Accessibility
• Create Custom Visuals with R or Python
• Review Report Performance Using Performance Analyzer

Module 22: Monitor Data in Real-Time with Power BI

• Introduction
• Describe Power BI Real-Time Analytics
• Set Up Automatic Page Refresh
• Create Real-Time Dashboards
• Set Up Auto-Refresh Paginated Reports
• Exercise: Monitor Data in Real-Time with Power BI

Module 23: Create Paginated Reports

• Introduction to Paginated Reports
• Get Data
• Create a Paginated Report
• Work with Charts on the Report
• Publish the Report

Module 24: 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

Module 25: 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

Module 26: Monitor and Audit Usage

• Introduction
• Usage Metrics for Dashboards and Reports
• Usage Metrics for Dashboards and Reports - New Version
• Audit Logs
• Activity Log

Module 27: Provision Premium Capacity in Power BI

• Introduction
• Premium Resource Management
• Supporting Multi Geographies
• Bring Your Own Key (BYOK)
• Featured External Tools

Module 28: 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

Module 29: 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

Module 30: 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

Module 31: 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

Module 32: Design a Power BI Application Lifecycle Management Strategy

• Introduction
• Define Application Lifecycle Management
• Recommend a Source Control Strategy
• Design a Deployment Strategy

Module 33: Create and Manage a Power BI Deployment Pipeline

• Introduction
• Understand the Deployment Process
• Create a Deployment Pipeline
• Assign a Workspace
• Deploy Content
• Work with Deployment Pipelines

Module 34: Create and Manage Power BI Assets

• Introduction
• Create Reusable Power BI Assets
• Explore Power BI Assets Using Lineage View
• Manage a Power BI Dataset Using XMLA Endpoint
• Exercise: Create Reusable Power BI Assets