{"id":12006,"date":"2022-05-10T14:42:37","date_gmt":"2022-05-10T14:42:37","guid":{"rendered":"https:\/\/blog.cloudthat.com\/?p=12006"},"modified":"2024-06-25T11:00:58","modified_gmt":"2024-06-25T11:00:58","slug":"exam-dp-500-study-guide","status":"publish","type":"blog","link":"https:\/\/www.cloudthat.com\/resources\/blog\/exam-dp-500-designing-and-implementing-enterprise-scale-analytics-solutions-using-microsoft-azure-and-microsoft-power-bi-beta","title":{"rendered":"Exam DP-500: Designing and Implementing Enterprise Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI (Beta)"},"content":{"rendered":"<p><span data-contrast=\"auto\">In recent days voluminous data generated at the enterprise level with rapid digital transformation has created room for the proliferation of data silos. Analyzing, interpreting, and acting upon data silos is a hurricane task for analysts. <\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">The Microsoft DP-500 Azure Enterprise Data Analyst Associate certification helps data analysts to extract data from heterogeneous sources and then model and analyze the same to arrive at beneficial business decisions. This examination can work as a panacea for Data Analysts to effectively overcome data silos generated at enterprises. Currently, this certification is available in the beta version. This blog post focuses on the prerequisites to take this examination and the critical skills measured by this examination in a detailed way.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p>&nbsp;<\/p>\n<table border=\"3\">\n<tbody>\n<tr>\n<td><span style=\"color: #000080;\"><strong>TABLE OF CONTENT<\/strong><\/span><\/td>\n<\/tr>\n<tr>\n<td><a href=\"#Is\"> Is DP-500: Azure Enterprise Data Analyst Associate Exam Designed for you?<\/a><\/td>\n<\/tr>\n<\/tbody>\n<tbody>\n<tr>\n<td><span style=\"color: #000080;\"><strong>Skills Measured:<\/strong><\/span><\/td>\n<\/tr>\n<tr>\n<td><a href=\"#Implement and manage a data analytics environment (25\u201330%)\">a. Implement and Manage a Data Analytics Environment (25\u201330%)<\/a><\/td>\n<\/tr>\n<tr>\n<td><a href=\"#Implement and manage data models (25\u201330%)\">b. Implement and Manage Data Models (25\u201330%)<\/a><\/td>\n<\/tr>\n<tr>\n<td><a href=\"#Explore and visualize data (20\u201325%)\">c. Explore and Visualize Data (20\u201325%)<\/a><\/td>\n<\/tr>\n<tr>\n<td><a href=\"#About CloudThat\">About CloudThat<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<h2 id=\"Is\">Is DP-500: Azure Enterprise Data Analyst Associate Exam Designed for you?<\/h2>\n<h2><\/h2>\n<p><span data-contrast=\"none\">in this Microsoft DP-500\u00a0Exam training guide we are sharing essential prerequisites for aspirants keen to take up this beta examination:\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<ul>\n<li data-leveltext=\"%1.\" data-font=\"Calibri\" data-listid=\"1\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"none\">Prior experience designing, creating, and deploying enterprise-scale data analytics solutions are preferable.\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"%1.\" data-font=\"Calibri\" data-listid=\"1\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"none\">Experience in cleaning and transforming data, building enterprise data models, handling advanced analytics capabilities, integrating IT infrastructure, and the ability to apply development lifecycle practices is desirable.\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"%1.\" data-font=\"Calibri\" data-listid=\"1\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"none\">Aspirants should possess advanced Power BI skills that include managing data repositories and data processing in the cloud and on-premises environments.\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"%1.\" data-font=\"Calibri\" data-listid=\"1\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"none\">Develop competency in working with Power Query and Data Analysis Expressions (DAX).\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"%1.\" data-font=\"Calibri\" data-listid=\"1\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"none\">Skills to consume data from Azure Synapse Analytics.\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"%1.\" data-font=\"Calibri\" data-listid=\"1\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"none\">Ability to carry out queries on relational databases, analyze data through Transact-SQL (T-SQL), and visualize data.\u00a0<\/span><\/li>\n<\/ul>\n<p><span class=\"TextRun SCXW224813782 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW224813782 BCX0\">Aspirants keen to earn this certification should pass <\/span><\/span><a class=\"Hyperlink SCXW224813782 BCX0\" href=\"https:\/\/www.cloudthat.com\/training\/azure\/dp-500-designing-and-implementing-enterprise-scale-analytics-solutions-using-microsoft-azure-and-microsoft-power-bi\/\" target=\"_blank\" rel=\"noreferrer noopener\"><span class=\"TextRun Underlined SCXW224813782 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW224813782 BCX0\" data-ccp-charstyle=\"Hyperlink\">Exam DP-500 Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI<\/span><\/span><\/a><span class=\"TextRun SCXW224813782 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW224813782 BCX0\"> which is currently available as a new Beta course. The DP-500 exam preparation demands rigorous training and dedication. This study guide also throws light on different skills that get assessed through this beta course.\u00a0 \u00a0 \u00a0\u00a0<\/span><\/span><span class=\"EOP SCXW224813782 BCX0\" data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<h2>Skills Measured<\/h2>\n<h3><\/h3>\n<p>This Exam DP-500 study guide provides a detailed view of various skills measured by this beta certification course.<\/p>\n<h3 id=\"Implement and manage a data analytics environment (25\u201330%)\">Implement and Manage a Data Analytics Environment (25\u201330%)<\/h3>\n<p>&nbsp;<\/p>\n<p><strong>Governing and administering a data analytics environment<\/strong><\/p>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"2\" aria-setsize=\"-1\" data-aria-posinset=\"2\" data-aria-level=\"1\"><span data-contrast=\"auto\">Power BI assets management using Azure Purview.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"2\" aria-setsize=\"-1\" data-aria-posinset=\"3\" data-aria-level=\"1\"><span data-contrast=\"auto\">Employing Azure Purview for identifying data sources in Azure<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<\/ul>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"2\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"auto\">Skills to recommend Power BI admin portal settings.\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"2\" aria-setsize=\"-1\" data-aria-posinset=\"2\" data-aria-level=\"1\"><span data-contrast=\"auto\">Ability to recommend monitoring and auditing solutions for data analytics environment, that comprises of Power BI REST API and PowerShell cmdlets.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<\/ul>\n<p><strong><span class=\"TextRun SCXW206979229 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW206979229 BCX0\" data-ccp-charstyle=\"Heading 2 Char\">Integrate an analytics platform into an existing <\/span><span class=\"NormalTextRun SCXW206979229 BCX0\" data-ccp-charstyle=\"Heading 2 Char\">IT<\/span><span class=\"NormalTextRun SCXW206979229 BCX0\" data-ccp-charstyle=\"Heading 2 Char\"> infrastructure<\/span><\/span><\/strong><\/p>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"3\" aria-setsize=\"-1\" data-aria-posinset=\"3\" data-aria-level=\"1\"><span data-contrast=\"auto\">Ability to identify solutions, including features, performance, and licensing strategy requirements.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"3\" aria-setsize=\"-1\" data-aria-posinset=\"4\" data-aria-level=\"1\"><span data-contrast=\"auto\">Hone skills in configuring and managing Power BI capacity.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<\/ul>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"3\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"auto\">Develop competency in recommending and configuring on-premises gateways in Power BI.\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"3\" aria-setsize=\"-1\" data-aria-posinset=\"2\" data-aria-level=\"1\"><span data-contrast=\"auto\">Expertise\u00a0to recommend and configure a Power BI tenant or workspace and integrate with Azure Data Lake Storage Gen2.\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"3\" aria-setsize=\"-1\" data-aria-posinset=\"3\" data-aria-level=\"1\"><span data-contrast=\"auto\">Competency in integrating an existing Power BI workspace with Azure Synapse Analytics.<\/span><\/li>\n<\/ul>\n<p><strong><span class=\"TextRun SCXW257879242 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW257879242 BCX0\" data-ccp-charstyle=\"Heading 2 Char\">Manage the analytics development lifecycle<\/span><\/span><\/strong><\/p>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"4\" aria-setsize=\"-1\" data-aria-posinset=\"4\" data-aria-level=\"1\"><span data-contrast=\"auto\">Skills to work with\u00a0code and artifacts on a source control repository in Azure Synapse Analytics.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<\/ul>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"4\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"auto\">Ability to suggest Power BI asset deployment strategy.\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"4\" aria-setsize=\"-1\" data-aria-posinset=\"2\" data-aria-level=\"1\"><span data-contrast=\"auto\">Provide\u00a0a source control strategy for Power BI assets.\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"4\" aria-setsize=\"-1\" data-aria-posinset=\"3\" data-aria-level=\"1\"><span data-contrast=\"auto\">Capability to implement and manage deployment pipelines in Power BI.\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"4\" aria-setsize=\"-1\" data-aria-posinset=\"4\" data-aria-level=\"1\"><span data-contrast=\"auto\">Expertise in performing impact analysis of downstream dependencies from dataflows and datasets.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"4\" aria-setsize=\"-1\" data-aria-posinset=\"5\" data-aria-level=\"1\"><span data-contrast=\"auto\">The caliber of recommending automation solutions for different\u00a0analytics development lifecycles, including Power BI REST API and PowerShell cmdlets.\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<\/ul>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"4\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"auto\">Prowess in deploying and managing datasets by using the XMLA endpoint.\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"4\" aria-setsize=\"-1\" data-aria-posinset=\"2\" data-aria-level=\"1\"><span data-contrast=\"auto\">Competency in creating reusable assets, including Power BI templates, Power BI data source (.pbids) files, and shared datasets.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"4\" aria-setsize=\"-1\" data-aria-posinset=\"3\" data-aria-level=\"1\"><span data-contrast=\"auto\">Generate queries for advanced data sources, including JSON, Parquet, APIs, and Azure Machine Learning models.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<\/ul>\n<h4><span class=\"TextRun SCXW257879242 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW257879242 BCX0\">\u00a0<\/span><\/span><span class=\"EOP SCXW257879242 BCX0\" data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/h4>\n<h3 id=\"Implement and manage data models (25\u201330%)\">Implement and Manage Data Models (25\u201330%)<\/h3>\n<p>&nbsp;<\/p>\n<p><strong><span class=\"TextRun SCXW1266897 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW1266897 BCX0\" data-ccp-charstyle=\"Heading 2 Char\">Design and build tabular models<\/span><\/span><\/strong><\/p>\n<ul style=\"font-weight: 400;\">\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"5\" aria-setsize=\"-1\" data-aria-posinset=\"4\" data-aria-level=\"1\"><span data-contrast=\"auto\">Ability to select the DirectQuery for Power BI datasets. <\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"5\" aria-setsize=\"-1\" data-aria-posinset=\"5\" data-aria-level=\"1\"><span data-contrast=\"auto\">Display skills of appropriate usage of external tools like\u00a0DAX Studio and Tabular Editor 2, create calculation groups. <\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"5\" aria-setsize=\"-1\" data-aria-posinset=\"6\" data-aria-level=\"1\"><span data-contrast=\"auto\">Ability to write calculations comprising of DAX variables and functions such as handling blanks or errors, creating virtual relationships, and working with iterators.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"5\" aria-setsize=\"-1\" data-aria-posinset=\"7\" data-aria-level=\"1\"><span data-contrast=\"auto\">Expertise in designing and building large-format datasets. <\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"5\" aria-setsize=\"-1\" data-aria-posinset=\"8\" data-aria-level=\"1\"><span data-contrast=\"auto\">Prowess in designing and building composite models that comprise aggregations. <\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"5\" aria-setsize=\"-1\" data-aria-posinset=\"9\" data-aria-level=\"1\"><span data-contrast=\"auto\">Skills in designing and implementing enterprise-scale row-level security and object-level security.<\/span><\/li>\n<\/ul>\n<p><strong><span class=\"TextRun SCXW246140751 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW246140751 BCX0\" data-ccp-charstyle=\"Heading 2 Char\">Optimizing enterprise-scale data models<\/span><\/span><\/strong><\/p>\n<ul style=\"font-weight: 400;\">\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"5\" aria-setsize=\"-1\" data-aria-posinset=\"10\" data-aria-level=\"1\"><span data-contrast=\"auto\">Display caliber of identifying and implementing performance improvements in queries and report visuals. <\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"5\" aria-setsize=\"-1\" data-aria-posinset=\"11\" data-aria-level=\"1\"><span data-contrast=\"auto\">Ability to troubleshoot DAX performance through DAX Studio <\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"5\" aria-setsize=\"-1\" data-aria-posinset=\"12\" data-aria-level=\"1\"><span data-contrast=\"auto\">Competency in optimizing\u00a0 data models through\u00a0Tabular Editor 2 <\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"5\" aria-setsize=\"-1\" data-aria-posinset=\"13\" data-aria-level=\"1\"><span data-contrast=\"auto\">Skill to analyze data model efficiency by employing vertipaq Analyzer <\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"5\" aria-setsize=\"-1\" data-aria-posinset=\"14\" data-aria-level=\"1\"><span data-contrast=\"auto\">The talent for implementing incremental refresh. <\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"5\" aria-setsize=\"-1\" data-aria-posinset=\"15\" data-aria-level=\"1\"><span data-contrast=\"auto\">Showcase skills to optimize data models by employing denormalization.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<\/ul>\n<h3 id=\"Explore and visualize data (20\u201325%)\">Explore and Visualize Data (20\u201325%)<\/h3>\n<h4><\/h4>\n<p><strong><span class=\"TextRun SCXW125300004 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW125300004 BCX0\" data-ccp-parastyle=\"heading 2\">Explore data by using Azure Synapse Analytics<\/span><\/span><\/strong><\/p>\n<ul style=\"font-weight: 400;\">\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"6\" aria-setsize=\"-1\" data-aria-posinset=\"16\" data-aria-level=\"1\"><span data-contrast=\"auto\">The capability of exploring data by using native visuals in Spark notebooks. <\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"6\" aria-setsize=\"-1\" data-aria-posinset=\"17\" data-aria-level=\"1\"><span data-contrast=\"auto\">The prowess of exploring and visualizing data by using the Azure Synapse SQL results pane.<\/span><\/li>\n<\/ul>\n<p><strong><span class=\"TextRun SCXW91863061 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW91863061 BCX0\" data-ccp-charstyle=\"Heading 2 Char\">Visualize data by using Power BI<\/span><\/span><\/strong><\/p>\n<ul style=\"font-weight: 400;\">\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"6\" aria-setsize=\"-1\" data-aria-posinset=\"18\" data-aria-level=\"1\"><span data-contrast=\"auto\">The ability to create and import a custom report theme. <\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"6\" aria-setsize=\"-1\" data-aria-posinset=\"19\" data-aria-level=\"1\"><span data-contrast=\"auto\">Demonstrate skills in creating R or Python visuals in Power BI. <\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"6\" aria-setsize=\"-1\" data-aria-posinset=\"20\" data-aria-level=\"1\"><span data-contrast=\"auto\">Display skills in connecting and querying datasets through the XMLA endpoint. <\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"6\" aria-setsize=\"-1\" data-aria-posinset=\"21\" data-aria-level=\"1\"><span data-contrast=\"auto\">Design, develop and configure accessibility reports on Power BI.\u00a0 <\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"6\" aria-setsize=\"-1\" data-aria-posinset=\"22\" data-aria-level=\"1\"><span data-contrast=\"auto\">Competency in enabling personalized visuals through reports. <\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"6\" aria-setsize=\"-1\" data-aria-posinset=\"23\" data-aria-level=\"1\"><span data-contrast=\"auto\">Ability to configure automatic page refresh. <\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"6\" aria-setsize=\"-1\" data-aria-posinset=\"24\" data-aria-level=\"1\"><span data-contrast=\"auto\">Demonstrate skills to create and distribute paginated reports in Power BI Report Builder.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<\/ul>\n<h2 id=\"About CloudThat\">About CloudThat<\/h2>\n<p><span data-contrast=\"auto\">CloudThat leads the cloud training and consulting deck in India since 2012. We are a <a href=\"https:\/\/www.cloudthat.com\/about-us\/\">cloud-agnostic organization<\/a> offering training in cloud and other niche technologies like DevOps, and AI\/ML. IoT, etc. We have the rare distinction of being an Authorized Training Partner for Microsoft, AWS, Google, and VMware. As a Microsoft Gold Partner, Advanced AWS Consulting Partner, Authorized AWS Training Partner, Authorized Google Cloud Partner, and Authorized VMware Training Reseller we have helped 500k+ professionals to carve a niche in the cloud computing stream. <\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">Moreover, our courses are aligned with the official curriculum of industry stalwarts like Microsoft, AWS, Google, and VMware and are delivered through industry-certified trainers. The training is curated with an emphasis on hands-on lab sessions, rigorous training, and practice sessions via the Exam Preparation portal. Moreover, with this Exam DP-500 blog post we have put an effort to bring out the details on how to approach the\u00a0latest DP-500 examination? and how to prepare for this DP-500 exam.\u00a0 \u00a0<\/span><\/p>\n<p>&nbsp;<\/p>\n<h2>References<\/h2>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/certifications\/exams\/dp-500\">https:\/\/docs.microsoft.com\/en-us\/learn\/certifications\/exams\/dp-500<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"author":257,"featured_media":12013,"parent":0,"comment_status":"open","ping_status":"open","template":"","blog_category":[3608,3607,6533],"user_email":"ravichandra@cloudthat.com","published_by":"324","primary-authors":"","secondary-authors":"","acf":[],"_links":{"self":[{"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/blog\/12006"}],"collection":[{"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/blog"}],"about":[{"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/types\/blog"}],"author":[{"embeddable":true,"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/users\/257"}],"replies":[{"embeddable":true,"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/comments?post=12006"}],"version-history":[{"count":1,"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/blog\/12006\/revisions"}],"predecessor-version":[{"id":45735,"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/blog\/12006\/revisions\/45735"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/media?parent=12006"}],"wp:term":[{"taxonomy":"blog_category","embeddable":true,"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/blog_category?post=12006"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}