Overview

In order to set realistic expectations, please note: These questions are NOT official questions that you will find on the official exam. These questions DO cover all the material outlined in the knowledge sections below. Many of the questions are based on fictitious scenarios which have questions posed within them.The official knowledge requirements for the exam are reviewed routinely to ensure that the content has the latest requirements incorporated in the practice questions. Updates to content are often made without prior notification and are subject to change at any time.Each question has a detailed explanation and links to reference materials to support the answers which ensures accuracy of the problem solutions.The questions will be shuffled each time you repeat the tests so you will need to know why an answer is correct, not just that the correct answer was item "B" last time you went through the test.NOTE: This course should not be your only study material to prepare for the official exam. These practice tests are meant to supplement topic study material.Should you encounter content which needs attention, please send a message with a screenshot of the content that needs attention and I will be reviewed promptly. Providing the test and question number do not identify questions as the questions rotate each time they are run. The question numbers are different for everyone.As a candidate for this exam, you should deliver actionable insights by working with available data and applying domain expertise. You should:Provide meaningful business value through easy-to-comprehend data visualizations.Enable others to perform self-service analytics.Deploy and configure solutions for consumption.As a Power BI data analyst, you work closely with business stakeholders to identify business requirements. You collaborate with enterprise data analysts and data engineers to identify and acquire data. You use Power BI to:Transform the data.Create data models.Visualize data.Share assets.You should be proficient at using Power Query and writing expressions by using Data Analysis Expressions (DAX). You know how to assess data quality. Plus, you understand data security, including row-level security and data sensitivity.Skills at a glancePrepare the data (25-30%)Model the data (25-30%)Visualize and analyze the data (25-30%)Deploy and maintain items (15-20%)Prepare the data (25-30%)Get data from data sourcesIdentify and connect to a data sourceChange data source settings, including credentials, privacy levels, and data source locationsSelect a shared semantic model, or create a local data modelChoose between DirectQuery, Import, and Dual modeChange the value in a parameterClean the dataEvaluate data, including data statistics and column propertiesResolve inconsistencies, unexpected or null values, and data quality issuesResolve data import errorsTransform and load the dataSelect appropriate column data typesCreate and transform columnsTransform a queryDesign a star schema that contains facts and dimensionsIdentify when to use reference or duplicate queries and the resulting impactMerge and append queriesIdentify and create appropriate keys for relationshipsConfigure data loading for queriesModel the data (25-30%)Design and implement a data modelConfigure table and column propertiesImplement role-playing dimensionsDefine a relationship's cardinality and cross-filter directionCreate a common date tableImplement row-level security rolesCreate model calculations by using DAXCreate single aggregation measuresUse CALCULATE to manipulate filtersImplement time intelligence measuresIdentify implicit measures and replace with explicit measuresUse basic statistical functionsCreate semi-additive measuresCreate a measure by using quick measuresCreate calculated tablesOptimize model performanceImprove performance by identifying and removing unnecessary rows and columnsIdentify poorly performing measures, relationships, and visuals by using Performance AnalyzerImprove performance by choosing optimal data typesImprove performance by summarizing dataVisualize and analyze the data (25-30%)Create reportsIdentify and implement appropriate visualizationsFormat and configure visualizationsUse a custom visualApply and customize a themeConfigure conditional formattingApply slicing and filteringConfigure the report pageUse the Analyze in Excel featureChoose when to use a paginated reportEnhance reports for usability and storytellingConfigure bookmarksCreate custom tooltipsEdit and configure interactions between visualsConfigure navigation for a reportApply sortingConfigure sync slicersGroup and layer visuals by using the Selection paneDrill down into data using interactive visualsConfigure export of report content, and perform an exportDesign reports for mobile devicesEnable personalized visuals in a reportDesign and configure Power BI reports for accessibilityIdentify patterns and trendsUse the Analyze feature in Power BIUse grouping, binning, and clusteringIncorporate the Q & A feature in a reportUse AI visualsUse reference lines, error bars, and forecastingDetect outliers and anomaliesCreate and share scorecards and metricsDeploy and maintain items (15-20%)Create and manage workspaces and itemsCreate and configure a workspaceAssign workspace rolesConfigure and update a workspace appPublish, import, or update items in a workspaceCreate dashboardsChoose a distribution methodApply sensitivity labels to workspace contentConfigure subscriptions and data alertsPromote or certify Power BI contentManage global options for filesManage semantic modelsIdentify when a gateway is requiredConfigure a semantic model scheduled refreshConfigure row-level security group membershipProvide access to semantic modelsConfigure automatic page refresh

Skills

Reviews