Practice Tests: PL-300 Power BI Data Analyst Associate Cert

About this course

These are the exam domains covered in the PL-300 practice test: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 dataset, or create a local datasetChoose between DirectQuery, Import, and Dual modeChange the value in a parameterTransform 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 queriesClean the dataEvaluate data, including data statistics and column propertiesResolve inconsistencies, unexpected or null values, and data quality issuesResolve data import errorsModel 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 statist