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

DP-500T00 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.

Duration: 4.0 days

Enquire Now

Schedule

Virtual ILT | 11 Jun 2024 - 14 Jun 2024 Sri Lanka
Virtual ILT | 11 Jun 2024 - 14 Jun 2024 United Arab Emirates
Virtual ILT | 17 Jun 2024 - 17 Jun 2024 India
Singapore | 18 Jun 2024 - 21 Jun 2024 Singapore
Virtual ILT | 18 Jun 2024 - 21 Jun 2024 Singapore
Kuala Lumpur | 23 Jul 2024 - 26 Jul 2024 Malaysia
Virtual ILT | 23 Jul 2024 - 26 Jul 2024 Malaysia

Start learning today!

Click Hereto customize your Training

Objectives

  • Describe the Azure data ecosystem for analytics
  • Describe types of data analytics
  • Understand the data analytics process
  • Explore data job roles in analytics
  • Understand tools for scaling analytics solutions
  • Evaluate whether Microsoft Purview is appropriate for data discovery and governance needs.
  • Describe how the features of Microsoft Purview work to provide data discovery and governance.
  • Browse, search, and manage data catalog assets.
  • Use data catalog assets with Power BI.
  • Use Microsoft Purview in Azure Synapse Studio.
  • Describe asset classification in Microsoft Purview.
  • Register and scan a Power BI tenant.
  • Use the search and browse functions to find data assets.
  • Describe the schema details and data lineage tracing of Power BI data assets.
  • Catalog Azure Synapse Analytics database assets in Microsoft Purview.
  • Configure Microsoft Purview integration in Azure Synapse Analytics.
  • Search the Microsoft Purview catalog from Synapse Studio.
  • Track data lineage in Azure Synapse Analytics pipelines activities.
  • Identify the business problems that Azure Synapse Analytics addresses.
  • Describe core capabilities of Azure Synapse Analytics.
  • Determine when to use Azure Synapse Analytics.
  • Identify capabilities and use cases for serverless SQL pools in Azure Synapse Analytics
  • Query CSV, JSON, and Parquet files using a serverless SQL pool
  • Create external database objects in a serverless SQL pool
  • Identify core features and capabilities of Apache Spark.
  • Configure a Spark pool in Azure Synapse Analytics.
  • Run code to load, analyze, and visualize data in a Spark notebook.
  • Design a schema for a relational data warehouse.
  • Create fact, dimension, and staging tables.
  • Use SQL to load data into data warehouse tables.
  • Use SQL to query relational data warehouse tables.
  • 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 an appropriate Power BI model framework.
  • Describe the importance of building scalable data models
  • Implement Power BI data modeling best practices
  • Use the Power BI large dataset storage format
  • Describe Power BI dataflows and use cases.
  • Describe best practices for implementing Power BI dataflows.
  • Create and consume Power BI dataflows.
  • Understand how model relationship work.
  • Set up relationships.
  • Use DAX relationship functions.
  • Understand relationship evaluation.
  • Define time intelligence.
  • Use common DAX time intelligence functions.
  • Create useful intelligence calculations.
  • Explore how calculation groups work.
  • Maintain calculation groups in a model.
  • Use calculation groups in a Power BI report.
  • Restrict access to Power BI model data with RLS.
  • Restrict access to Power BI model objects with OLS.
  • Apply good development practices to enforce Power BI model security.
  • Optimize queries using performance analyzer.
  • Troubleshoot DAX performance using DAX Studio.
  • Optimize a data model using Tabular Editor.
  • Create and import a custom report theme.
  • Create custom visuals with R or Python.
  • Enable personalized visuals in a report.
  • Review report performance using Performance Analyzer.
  • Design and configure Power BI reports for accessibility.
  • 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 and tables on the report.
  • Publish the report.
  • 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
  • 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
  • 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
  • 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.
  • 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.
  • 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
  • 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
  • Describe the Power BI and Synapse workspace integration
  • Understand Power BI data sources
  • Describe optimization options
  • Visualize data with serverless SQL pools
  • Outline the application lifecycle process.
  • Choose a source control strategy.
  • Design a deployment strategy.
  • Articulate the benefits of deployment pipelines
  • Create a deployment pipeline using Premium workspaces
  • Assign and deploy content to pipeline stages
  • Describe the purpose of deployment rules
  • Deploy content from one pipeline stage to another
  • Create specialized datasets.
  • Create live and DirectQuery connections.
  • Use Power BI service lineage view.
  • Use XMLA endpoint to connect datasets.

Content

1. Explore Azure data services for modern analytics

Understand analytics solutions in the Azure data ecosystem. Explore the architecture of a scalable analytics solution to meet business needs.

Click here to know more

2. Understand concepts of data analytics

Explore key concepts of data analytics, including types of analytics, data, and storage. Explore the analytics process and tools used to discover insights.

Click here to know more

3. Explore data analytics at scale

Describe data analytics at scale and understand the roles of a data team. Learn about the responsibilities of an enterprise data analyst and what tools are available to build scalable solutions.

Click here to know more

4. Introduction to Microsoft Purview

In this module, you'll evaluate whether Microsoft Purview is the right choice for your data discovery and governance needs.

Click here to know more

5. Discover trusted data using Microsoft Purview

Use Microsoft Purview Studio to discover trusted organizational assets for reporting.

Click here to know more

6. Catalog data artifacts by using Microsoft Purview

Register, scan, catalog, and view data assets and their relevant details in Microsoft Purview.

Click here to know more

7. Manage Power BI assets by using Microsoft Purview

Improve data governance and asset discovery using Power BI and Microsoft Purview integration.

Click here to know more

8. Integrate Microsoft Purview and Azure Synapse Analytics

Learn how to integrate Microsoft Purview with Azure Synapse Analytics to improve data discoverability and lineage tracking.

Click here to know more

9. Introduction to Azure Synapse Analytics

Learn about the features and capabilities of Azure Synapse Analytics - a cloud-based platform for big data processing and analysis.

Click here to know more

10. Use Azure Synapse serverless SQL pool to query files in a data lake

With Azure Synapse serverless SQL pool, you can leverage your SQL skills to explore and analyze data in files, without the need to load the data into a relational database.

Click here to know more

11. Analyze data with Apache Spark in Azure Synapse Analytics

Apache Spark is a core technology for large-scale data analytics. Learn how to use Spark in Azure Synapse Analytics to analyze and visualize data in a data lake.

Click here to know more

12. Analyze data in a relational data warehouse

Relational data warehouses are a core element of most enterprise Business Intelligence (BI) solutions, and are used as the basis for data models, reports, and analysis.

Click here to know more

13. Choose a Power BI model framework

Describe model frameworks, their benefits and limitations, and features to help optimize your Power BI data models.

Click here to know more

14. Understand scalability in Power BI

Scalable data models enable enterprise-scale analytics in Power BI. Implement data modeling best practices, use large dataset storage format, and practice building a star schema to design analytics solutions that can scale.

Click here to know more

15. Create and manage scalable Power BI dataflows

Create Power BI transformation logic for reuse across your organization with Power BI dataflows. Learn how to combine Power BI dataflows with Power BI Premium for scalable ETL, and practice creating and consuming dataflows.

Click here to know more

16. Create Power BI model relationships

Power BI model relationships form the basis of a tabular model. Define Power BI model relationships, set up relationships, recognize DAX relationship functions, and describe relationship evaluation.

Click here to know more

17. Use DAX time intelligence functions in Power BI Desktop models

By the end of this module, you'll learn the meaning of time intelligence and how to add time intelligence DAX calculations to your model.

Click here to know more

18. Create calculation groups

In this module you’ll learn what calculation groups are, explore key features and usage scenarios, and learn to create calculation groups.

Click here to know more

19. Enforce Power BI model security

Enforce model security in Power BI using row-level security and object-level security.

Click here to know more

20. Use tools to optimize Power BI performance

Use tools to develop, manage, and optimize Power BI data model and DAX query performance.

Click here to know more

21. Understand advanced data visualization concepts

Create cohesive, inclusive, and efficient Power BI reports to effectively communicate results.

Click here to know more

22. Monitor data in real-time with Power BI

Describe real-time analytics in Power BI using automatic page refresh, real-time dashboards, and auto-refresh in paginated reports.

Click here to know more

23. Create paginated reports 

Paginated reports allow report developers to create Power BI artifacts that have tightly controlled rendering requirements. Paginated reports are ideal for creating sales invoices, receipts, purchase orders, and tabular data. This module will teach you how to create reports, add parameters, and work with tables and charts in paginated reports.

Click here to know more

24. Provide governance in a Power BI environment

Power BI governance is a set of rules, regulations, and policies that define and ensure the effective, controlled, and valuable operation of a BI environment. In this module, you'll learn the fundamental components and practices necessary to govern a Power BI tenant.

Click here to know more

25. Facilitate collaboration and sharing in Power BI

You've created dashboards and reports. Perhaps you want to collaborate on them with your coworkers. Or maybe you're ready to distribute them more widely. What's the best way to collaborate and share them? In this module, we compare your options.

Click here to know more

26. Monitor and audit usage

Usage metrics help you understand the impact of your dashboards and reports. When you run either dashboard usage metrics or report usage metrics, you discover how those dashboards and reports are being used throughout your organization, who's using them, and for what purpose. Knowing who is taking what action on which item in your Power BI tenant can be critical in helping your organization fulfill its requirements, like meeting regulatory compliance and records management. This module outlines what is available in usage metrics reports and audit logs.

Click here to know more

27. Provision Premium capacity in Power BI

Power BI Premium is a dedicated, capacity-based offering. Learn about the differences between Power BI Pro and Power BI Premium, and how Power BI Premium manages capacity resources. Featured tools you can use with Power BI premium are also covered.

Click here to know more

28. Establish a data access infrastructure in Power BI

Working with on-premises data sources requires configuring a gateway between Power BI and the on-premises data source. This module examines how to work with gateways and SQL Server Analysis Services (SSAS) data sources that are used either for scheduled refresh or for live connections.

Click here to know more

29. Broaden the reach of Power BI

You can broaden the reach of Power BI by sharing your reports beyond your Power BI environment. You can publish reports to the public internet, embed reports in Microsoft Teams or in PowerApps, and place BI reports in a SharePoint online web part. There's also a special version of Power BI service called Microsoft Power BI Embedded (PBIE) which allows application developers to embed fully interactive reports into their applications without having to build their own data visualizations and controls from scratch.

Click here to know more

30. Automate Power BI administration

Cmdlets are functions written in PowerShell script language that execute commands in the Windows PowerShell environment. Running these cmdlets will allow you to interact with your Power BI Platform without having to go through the admin portal in a web browser. Combine these cmdlets with other PowerShell functions to write complex scripts that can optimize your workflow.

Click here to know more

31. Build reports using Power BI within Azure Synapse Analytics

In this module, you will learn how you can build Power BI reports from within Azure Synapse Analytics.

Click here to know more

32. Design a Power BI application lifecycle management strategy

The use of OneDrive, Git repositories, and Power BI deployment pipelines allows us to follow application lifecycle management techniques. This reduces administrative overhead and provides continuity in the development process.

Click here to know more

33. Create and manage a Power BI deployment pipeline

Deployment pipelines enable creators to develop and test Power BI content in the Power BI service before the content is made available for consumption by users. It offers creators improved productivity, faster delivery of content updates, and reduced manual work and errors. The tool is designed as a pipeline with three stages: development, test, and production.

Click here to know more

34. Create and manage Power BI assets

Creating shared data assets for your analytics environment provides structure and consistency. Maintaining those assets is as important, and XMLA endpoint provides additional administrative capabilities.

Click here to know more

Audience

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

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.

Certification

product-certification

Skills Measured

  • Implement and manage a data analytics environment (25–30%)
  • Query and transform data (20–25%)
  • Implement and manage data models (25–30%)
  • Explore and visualize data (20–25%)

Course Benefits

product-benefits
  • Career growth
  • Broad Career opportunities
  • Worldwide recognition from leaders
  • Up-to Date technical skills
  • Popular Certification Badges

Microsoft Popular Courses

ms-700t00

The Managing Microsoft Teams course is designed for those aspiring to be Microsoft 365 Teams Administrators to deploy, configure and manage Office 365 workloads

az-900t00

This course is a high-level overview of Azure. The course will provide foundational level knowledge of cloud services and how those services are provided with M

sc-900t00

This course provides foundational level knowledge on security, compliance, and identity concepts and related cloud-based Microsoft solutions.

mb-335t00

MB-335T00 is a course code that refers to a specific training program or course offered by Microsoft. Unfortunately, as of my knowledge cutoff in September 2021
Enquire Now
 
 
 
 
wMD7ES
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy