DP-500T00 Designing and Implementing Enterprise-Scale Analytics Using Azure and Power BI
5 Based on 213 reviews- 429,627 Learners
- 287 Courses
This course covers methods and practices for performing advanced data analytics at scale. Students will build on existing analytics experience and will learn to implement and manage a data analytics environment, query and transform data, implement and manage data models, and explore and visualize data. In this course, students will use Microsoft Purview, Azure Synapse Analytics, and Power BI to build analytics solutions.
Request More InfoWho should attend DP-500T00 Designing and Implementing Enterprise-Scale Analytics Using Azure and Power BI Course
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.
Prerequisites for DP-500T00 Designing and Implementing Enterprise-Scale Analytics Using Azure and Power BI Course
DP-500T00 Designing and Implementing Enterprise-Scale Analytics Using Azure and Power BI Course Outline
- Understand the Azure data ecosystem
- Explore modern analytics solution architecture
- Understand data analytics types
- Explore the data analytics process
- Understand types of data and data storage
- 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
- What is Microsoft Purview?
- How Microsoft Purview works
- When to use Microsoft Purview
- Search for assets
- Browse assets
- Use assets with Power BI
- Integrate with Azure Synapse Analytics
- Register and scan data
- Classify and label data
- Search the data catalog
- Register and scan a Power BI tenant
- Search and browse Power BI assets
- View Power BI metadata and lineage
- 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
- What is Azure Synapse Analytics
- How Azure Synapse Analytics works
- When to use Azure Synapse Analytics
- Understand Azure Synapse serverless SQL pool capabilities and use cases
- Query files using a serverless SQL pool
- Create external database objects
- Get to know Apache Spark
- Use Spark in Azure Synapse Analytics
- Analyze data with Spark
- Visualize data with Spark
- Design a data warehouse schema
- Create data warehouse tables
- Load data warehouse tables
- Query a data warehouse
- 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
- Describe the significance of scalable models
- Implement Power BI data modeling best practices
- Configure large datasets
- Define use cases for dataflows
- Create reusable assets
- Implement best practices
- Understand model relationships
- Set up relationships
- Use DAX relationship functions
- Understand relationship evaluation
- Use DAX time intelligence functions
- Additional time intelligence calculations
- Understand calculation groups
- Explore calculation groups features and usage
- Create calculation groups in a model
- Restrict access to Power BI model data
- Restrict access to Power BI model objects
- Apply good modeling practices
- Use Performance analyzer
- Troubleshoot DAX performance by using DAX Studio
- Optimize a data model by using Best Practice Analyzer
- 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
- Describe Power BI real-time analytics
- Set up automatic page refresh
- Create real-time dashboards
- Set-up auto-refresh paginated reports
- Get data
- Create a paginated report
- Work with charts on the report
- Publish the report
- Elements of data governance
- Configure tenant settings
- Deploy organizational visuals
- Manage embed codes
- Help and support settings
- Usage metrics for dashboards and reports
- Usage metrics for dashboards and reports - new version
- Audit logs
- Activity log
- 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
- Describe the Power BI and Synapse workspace integration
- Understand Power BI data sources
- Describe Power BI optimization options
- Visualize data with serverless SQL pools
- Define application lifecycle management
- Recommend a source control strategy
- Design a deployment strategy
- Understand the deployment process
- Create a deployment pipeline
- Assign a workspace
- Deploy content
- Work with deployment pipelines
- Create reusable Power BI assets
- Explore Power BI assets using lineage view
- Manage a Power BI dataset using XMLA endpoint
Resources
FAQs on DP-500T00 Designing and Implementing Enterprise-Scale Analytics Using Azure and Power BI
This course is designed for candidates with subject matter expertise in designing, creating, and deploying enterprise-scale data analytics solutions. Ideal attendees have advanced Power BI skills, including data repository management, Power Query, and DAX, plus experience with Azure Synapse Analytics, T-SQL, and data visualization.
Participants should have foundational knowledge of core data concepts and Azure data services (equivalent to Azure Data Fundamentals), along with experience designing scalable data models, transforming data, and enabling advanced analytics using Power BI (equivalent to Power BI Data Analyst certification).
The course covers Azure data services, data analytics concepts and processes, scaling analytics with Azure Synapse Analytics and Power BI, and using Microsoft Purview for data governance, including discovering, cataloging, and managing data artifacts.
The course aims to equip candidates with the skills needed to design and implement enterprise-scale analytics solutions using Azure and Power BI, enabling them to manage large-scale data platforms, ensure data governance, and deliver actionable business insights.
Microsoft Purview is introduced as a key tool for data governance, enabling learners to discover trusted data, catalog data artifacts, and integrate governance practices with Power BI and Azure Synapse Analytics for enterprise-scale analytics solutions.