Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI (DP-500)

Candidates for this course should have subject matter expertise in designing, creating, and deploying enterprise-scale data analytics solutions. Specifically, candidates should have advanced Power BI skills, including managing data repositories and data processing in the cloud and on-premises, along with using Power Query and Data Analysis Expressions (DAX). They should also be proficient in consuming data from Azure Synapse Analytics and should have experience querying relational databases, analyzing data by using Transact-SQL (T-SQL), and visualizing data.

MODULE Explore Azure data services for modern analytics
MODULE Understand concepts of data analytics
MODULE Explore data analytics at scale
MODULE Introduction to Microsoft Purview
MODULE Discover trusted data using Microsoft Purview
MODULE Catalog data artifacts by using Microsoft Purview
MODULE Manage Power BI assets by using Microsoft Purview
MODULE Integrate Microsoft Purview and Azure Synapse Analytics
MODULE Introduction to Azure Synapse Analytics
MODULE Use Azure Synapse serverless SQL pool to query files in a data lake
MODULE Analyze data with Apache Spark in Azure Synapse Analytics
MODULE Analyze data in a relational data warehouse
MODULE Choose a Power BI model framework
MODULE Understand scalability in Power BI
MODULE Create and manage scalable Power BI dataflows
MODULE Create Power BI model relationships
MODULE Use DAX time intelligence functions in Power BI Desktop models
MODULE Create calculation groups
MODULE Enforce Power BI model security
MODULE Use tools to optimize Power BI performance
MODULE Understand advanced data visualization concepts
MODULE Monitor data in real-time with Power BI
MODULE Create paginated reports
MODULE Provide governance in a Power BI environment
MODULE Facilitate collaboration and sharing in Power BI
MODULE Monitor and audit usage
MODULE Provision Premium capacity in Power BI
MODULE Establish a data access infrastructure in Power BI
MODULE Broaden the reach of Power BI
MODULE Automate Power BI administration
MODULE Build reports using Power BI within Azure Synapse Analytics
MODULE Design a Power BI application lifecycle management strategy
MODULE Create and manage a Power BI deployment pipeline
MODULE Create and manage Power BI assets

Before attending this course, it is recommended that students have:

• A foundational knowledge of core data concepts and how they’re implemented using Azure data services. For more information see Azure Data Fundamentals.
• Experience designing and building scalable data models, cleaning and transforming data, and enabling advanced analytic capabilities that provide meaningful business value using Microsoft Power BI. For more information see Power BI Data Analyst.

MICROSOFT DP-500