Azure Enterprise Data Analyst Associate (DP-500)
This content is part of the LDI Data Analyst Role Path and is organised around the syllabus of the Microsoft DP-500 Exam which allows you to become a Certified Azure Enterprise Data Analyst Associate. The syllabus covers the creation, deployment and management of Enterprise-scale data analytics solutions using Azure and Power BI Premium. It considers how to govern the Power BI estate through controls such as Tenant Settings and using tools such as Azure Purview, as well as utilising an Enterprise BI architecture using dataflows and shared datasets. It also looks at using Azure Synapse Analytics as a core back-end architecture and managing performance of Power BI datasets through the XMLA endpoint using external tools such as DAX Studio and Tabular Editor.
-
Implement and manage a data analytics environment
-
Query and transform data
-
Implement and manage data models
-
Explore and visualize data
Quizzes
DP 500 - 8 Question Sample
This quiz is for those with advanced Power BI skills, including managing data repositories and data processing in the cloud and on-premises, along with using Power Query and DAX, and who are interested in potentially taking the Microsoft DP-500 Exam
This quiz contains a sample of 8 Questions (2 from each of the four topic areas).
0 Tokens
DP 500 Module 1- 10 Questions
This quiz is for those with advanced Power BI skills, including managing data repositories and data processing in the cloud and on-premises, along with using Power Query and DAX, and who are interested in potentially taking the Microsoft DP-500 Exam
This quiz focuses on the "Implement and manage a data analytics environment" which comprises 25-30% of the overall exam.
There are 150 questions in this question bank - 10 questions are selected at random weighted across the number of questions in each sub-topic (Govern and administer a data analytics environment, Integrate an analytics platform into an existing IT infrastructure, Manage the analytics development lifecycle)
20 Tokens
DP 500 Module 1 - 5 Questions
This quiz is for those with advanced Power BI skills, including managing data repositories and data processing in the cloud and on-premises, along with using Power Query and DAX, and who are interested in potentially taking the Microsoft DP-500 Exam
This quiz focuses on the "Implement and manage a data analytics environment" which comprises 25-30% of the overall exam.
There are 150 questions in this question bank - 5 questions are selected at random weighted across the number of questions in each sub-topic (Govern and administer a data analytics environment, Integrate an analytics platform into an existing IT infrastructure, Manage the analytics development lifecycle)
10 Tokens
Courses
No courses to display.
E-Books
No E-Books to display.
Resources
No resources to display.
What are Pipelines?
This article covers the use of pipelines in Power BI
Dataset Impact Analysis
When you make changes to a dataset, or are considering making changes, it is important to be able to assess the impact those changes will have on downstream reports and dashboards that depend on that dataset. Dataset impact analysis provides you with information that can help you make this assessment.
Introduction to deployment pipelines
The deployment pipelines tool enables BI creators to manage the lifecycle of organizational content. It's an efficient and reusable tool for creators in an enterprise with Premium capacity. Deployment pipelines enable creators to develop and test Power BI content in the Power BI service, before the content is consumed by users. The content types include reports, paginated reports, dashboards, datasets and dataflows.
Deployment Pipelines Best Practices
This article provides guidance for BI creators who are managing their content throughout its lifecycle. It focuses on leveraging deployment pipelines as a BI content lifecycle management tool.
Recommending a Development Life Cycle Strategy
The development process is iterative; it typically requires building an initial solution, testing the solution in a different environment, returning to make necessary revisions, and eventually releasing a final product. This process is known as a development life cycle. This process can take place in several different ways and in different environments.
Source control in Synapse Studio
This article will outline how to configure and work in a Synapse workspace with git repository enabled. And we also highlight some best practices and a troubleshooting guide.
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.
Linking a Power BI workspace to a Synapse workspace
In this article, you will learn how to connect a Power BI workspace to an Azure Synapse Analytics workspace to create new Power BI reports and datasets from Synapse Studio.
Configuring dataflow storage to use Azure Data Lake Gen 2
Data used with Power BI is stored in internal storage provided by Power BI by default. With the integration of dataflows and Azure Data Lake Storage Gen 2 (ADLS Gen2), you can store your dataflows in your organization's Azure Data Lake Storage Gen2 account. This essentially allows you to "bring your own storage" to Power BI dataflows, and establish a connection at the tenant or workspace level.
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.
On-premises Data Gateway Sizing
This article targets Power BI administrators who need to install and manage the on-premises data gateway.
The gateway is required whenever Power BI must access data that isn't accessible directly over the Internet. It can be installed on a server on-premises, or VM-hosted Infrastructure-as-a-Service (IaaS).
What is an on-premises data gateway?
The on-premises data gateway acts as a bridge to provide quick and secure data transfer between on-premises data (data that isn't in the cloud) and several Microsoft cloud services. These cloud services include Power BI, PowerApps, Power Automate, Azure Analysis Services, and Azure Logic Apps. By using a gateway, organizations can keep databases and other data sources on their on-premises networks, yet securely use that on-premises data in cloud services.
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.
Manage Capacity Settings
Capacity is a dedicated set of resources reserved for exclusive use. Premium and Embedded capacities offer a dependable and consistent performance for your content.
Optimisation Guide for Power BI
This article provides guidance that enables developers and administrators to produce and maintain optimized Power BI solutions. You can optimize your solution at different architectural layers.
Licensing the Power BI service for users in your organization
This article focuses on purchasing services and per-user licensing from an administrator perspective. For more information about how users can get their own license.
Monitor and Audit Usage
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.
Tracking Users Activities in Power BI
Knowing who is taking what action on which item in Power BI can be critical in helping your organization fulfill its requirements, like meeting regulatory compliance and records management. This article discusses two options to track user activity: The Power BI activity log and the unified audit log.
Administer Power BI - Premium, Power BI embedded and Automation
This course will demonstrate how Power BI Premium manages capacity resources. You’ll learn how to establish a data access infrastructure and how to share Power BI reports beyond your Power BI tenant. Finally, you’ll learn how to automate common tasks with Microsoft Power BI Cmdlets for Windows PowerShell and PowerShell core.
Administer Power BI - Tenants, Governance and Collaboration
This learning path covers typical tasks and tools, such as the Power BI admin portal and Office 365 admin center. You will learn how to establish and provide governance for a Power BI environment and provision Power BI Premium capacity.
Tenant Settings
This article targets Power BI administrators who are responsible for setting up and configuring the Power BI environment in their organization.
Manage Multiple Azure Sources in Microsoft Purview
This article outlines how to register multiple Azure sources and how to authenticate and interact with them in Microsoft Purview.
Introduction to Microsoft Purview
Microsoft Purview is a unified data governance service that helps you manage and govern your on-premises, multi-cloud, and software-as-a-service (SaaS) data. Easily create a holistic, up-to-date map of your data landscape with automated data discovery, sensitive data classification, and end-to-end data lineage.
In this module, you will evaluate whether Microsoft Purview is the right choice for your data discovery and governance needs.
Manage a Power BI Tenant in Microsoft Purview
This article outlines how to register a Power BI tenant in a same-tenant scenario, and how to authenticate and interact with the tenant in Microsoft Purview.
This article will provide you with knowledge on how to govern and administer a data analytics environment.
No resources to display.
MS Docs: Connect to and manage a Power BI tenant in Microsoft Purview (Same Tenant)
This article outlines how to register a Power BI tenant in a same-tenant scenario, and how to authenticate and interact with the tenant in Microsoft Purview
No resources to display.
No resources to display.
No resources to display.
No resources to display.
Quizzes
DP 500 Module 2 - 10 Questions
This quiz is for those with advanced Power BI skills, including managing data repositories and data processing in the cloud and on-premises, along with using Power Query and DAX, and who are interested in potentially taking the Microsoft DP-500 Exam
This quiz focuses on the "Query and Transform Data" topic which comprises 20-25% of the overall exam.
There are 100 questions in this question bank - 10 questions are selected at random weighted across the number of questions in each sub-topic (Query data by using Azure Synapse Analytics, Ingest and transform data by using Power BI)
20 Tokens
DP 500 Module 2 - 5 Questions
This quiz is for those with advanced Power BI skills, including managing data repositories and data processing in the cloud and on-premises, along with using Power Query and DAX, and who are interested in potentially taking the Microsoft DP-500 Exam
This quiz focuses on the "Query and Transform Data" topic which comprises 20-25% of the overall exam.
There are 100 questions in this question bank - 5 questions are selected at random weighted across the number of questions in each sub-topic (Query data by using Azure Synapse Analytics, Ingest and transform data by using Power BI)
10 Tokens
Courses
No courses to display.
E-Books
No E-Books to display.
Resources
No resources to display.
An Overview of Query in Power BI Desktop
This articles covers Power BI Desktop Query functionality
Privacy Levels for Cloud Data Sources
This blog covers the Cloud Data Sources and its Privacy features.
Power BI Desktop Privacy Levels
In Power BI Desktop, privacy levels specify an isolation level that defines the degree that one data source will be isolated from other data sources. Although a restrictive isolation level blocks information from being exchanged between data sources, it may reduce functionality and impact performance.
Monitor Report Performance in Power BI
Monitor report performance in Power BI Desktop using the Performance Analyzer. Monitoring will help you learn where the bottlenecks are, and how you can improve report performance.
core Machine Learning Models with PREDICT
Dedicated SQL pool provides you the capability to score machine learning models using the familiar T-SQL language. With T-SQL PREDICT, you can bring your existing machine learning models trained with historical data and score them within the secure boundaries of your data warehouse.
Using a Machine Learning PREDICT function in a Query
This article introduces the Machine Learning Function PREDICT in a Query.
How to Analyse Data with a Serverless SQL Pool
In this tutorial, you'll learn how to analyze data with serverless SQL pool.
How to Analyse Data with Dedicated SQL Pools
In this tutorial, you'll use the NYC Taxi data to explore a dedicated SQL pool's capabilities.
Using Azure Synapses Serverless SQL Pools 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.
What is Azure Synapse SQL Architecture?
Synapse SQL leverages a scale out architecture to distribute computational processing of data across multiple nodes. Compute is separate from storage, which enables you to scale compute independently of the data in your
system.
This article describes the architecture components of Synapse SQL.
What is Azure Synapse Analytics
This article covers the basics of Azure Synapse as a tool used as an enterprise analytics service primarily across data warehouses and big data systems.
Query Diagnosts in Power Query
With Query Diagnostics, you can achieve a better understanding of what Power Query is doing at authoring and at refresh time in Power BI Desktop
Understanding folding with Query Diagnostics
One of the most common reasons to use Query Diagnostics is to have a better understanding of what operations were 'pushed down' by Power Query to be performed by the back-end data source, which is also known as 'folding'
No resources to display.
No resources to display.
No resources to display.
No resources to display.
No resources to display.
No resources to display.
Quizzes
No quizzes to display.
Courses
No courses to display.
E-Books
No E-Books to display.
Resources
No resources to display.
Understanding Star Schema and its Importance in Power BI
This article targets Power BI Desktop data modelers. It describes star schema design and its relevance to developing Power BI data models optimized for performance and usability.
How to Configure Incremental Refresh and Real-Time Data
This article describes how to configure incremental refresh and real-time data for datasets.
Using Large Datasets in Power BI Premium
Power BI datasets can store data in a highly compressed in-memory cache for optimized query performance, enabling fast user interactivity. With Premium capacities, large datasets beyond the default limit can be enabled with the Large dataset storage format setting. When enabled, dataset size is limited by the Premium capacity size or the maximum size set by the administrator.
Introducing Calculation Groups
Calculation groups can significantly reduce the number of redundant measures by grouping common measure expressions as calculation items.
Using External Tools in Power BI Desktop
The External Tools ribbon provides easy access to external tools that have been installed locally and registered with Power BI Desktop. When launched from the External Tools ribbon, Power BI Desktop passes the name and port number of its internal data model engine instance to the tool, and the current model name. The tool then automatically connects, providing a seamless connection experience.
What is DirectQuery Model Guidance in Power BI Desktop?
This article targets data modelers developing Power BI DirectQuery models, developed by using either Power BI Desktop or the Power BI service. It describes DirectQuery use cases, limitations, and guidance. Specifically, the guidance is designed to help you determine whether DirectQuery is the appropriate mode for your model, and to improve the performance of your reports based on DirectQuery models. This article applies to DirectQuery models hosted in the Power BI service or Power BI Report Server.
No resources to display.
No resources to display.
No resources to display.
No resources to display.
No resources to display.
No resources to display.
Quizzes
No quizzes to display.
Courses
No courses to display.
E-Books
No E-Books to display.
Resources
No resources to display.
Power BI Report Builder
This Article introduces the Report Builder in Power BI and its functionality.
Power BI Report Builder is a tool for authoring paginated reports that you can publish to the Power BI service.
Automatic Page Refresh in Power BI
Automatic page refresh in Power BI enables your active report page to query for new data, at a predefined cadence, for DirectQuery sources.
Personalising Visuals in a Report
This article covers methods of making your visuals more elaborate and personalised to fit your audience.
Designing Power BI Reports for Accessibility
You can design and create compelling reports while also designing for accessibility. Whenever building a report, no matter who your audience is, you should create your reports to be usable by as many people as possible, without the need to be adapted for a sort of special design.
Dataset Connectivity with the XMLA Endpoint
Power BI Premium, Premium Per User, and Power BI Embedded workspaces support open-platform connectivity from Microsoft and third-party client applications and tools by using an XMLA endpoint.
This article introduces what XMLA Endpoint is used for with particular emphasis on dataset connectivity.
Using Report Themes in Power BI Desktop
With Power BI Desktop report themes, you can apply design changes to your entire report, such as using corporate colors, changing icon sets, or applying new default visual formatting.
Visualising Data in Apache Spark
When using Apache Spark in Azure Synapse Analytics, there are various built-in options to help you visualize your data, including Synapse notebook chart options, access to popular open-source libraries, and integration with Synapse SQL and Power BI.
Analysing Data with Apache Spark
In this tutorial, you'll learn how to perform exploratory data analysis by using Azure Open Datasets and Apache Spark. You can then visualize the results in a Synapse Studio notebook in Azure Synapse Analytics.
Learn about the graph visualization capabilities in SQL editor with Microsoft Azure Synapse Analytics.
No resources to display.
No resources to display.
No resources to display.
No resources to display.
No resources to display.
