Free Udemy Course: PL-300: Microsoft Power BI Data Analyst - Apr 2025

Skills at a glancePrepare the data (25–30%)Model the data (25–30%)Visualize and analyze the data (25–30%)Manage and secure Power BI (15–20%)Prepare the data (25–30%)Get or connect to dataIdentify and connect to data sources or a shared semantic modelChange data source settings, including credentials and privacy levelsChoose between DirectQuery and ImportCreate and modify parametersProfile and clean 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 columnsGroup and aggregate rowsPivot, unpivot, and transpose dataConvert semi-structured data to a tableCreate fact tables and dimension tablesIdentify 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 tableIdentify use cases for calculated columns and calculated tablesCreate model calculations by using DAXCreate single aggregation measuresUse the CALCULATE functionImplement time intelligence measuresUse basic statistical functionsCreate semi-additive measuresCreate a measure by using quick measuresCreate calculated tables or columnsCreate calculation groupsOptimize model performanceImprove performance by identifying and removing unnecessary rows and columnsIdentify poorly performing measures, relationships, and visuals by using Performance Analyzer and DAX query viewImprove performance by reducing granularityVisualize and analyze the data (25–30%)Create reportsSelect an appropriate visualFormat and configure visualsApply and customize a themeApply conditional formattingApply slicing and filteringConfigure the report pageChoose when to use a paginated reportCreate visual calculations by using DAXEnhance reports for usability and storytellingConfigure bookmarksCreate custom tooltipsEdit and configure interactions between visualsConfigure navigation for a reportApply sorting to visualsConfigure sync slicersGroup and layer visuals by using the Selection paneConfigure drill through navigationConfigure export settingsDesign reports for mobile devicesEnable personalized visuals in a reportDesign and configure Power BI reports for accessibilityConfigure automatic page refreshIdentify patterns and trendsUse the Analyze feature in Power BIUse grouping, binning, and clusteringUse AI visualsUse reference lines, error bars, and forecastingDetect outliers and anomaliesManage and secure Power BI (15–20%)Create and manage workspaces and assetsCreate and configure a workspaceConfigure and update a workspace appPublish, import, or update items in a workspaceCreate dashboardsChoose a distribution methodConfigure subscriptions and data alertsPromote or certify Power BI contentIdentify when a gateway is requiredConfigure a semantic model scheduled refreshSecure and govern Power BI itemsAssign workspace rolesConfigure item-level accessConfigure access to semantic modelsImplement row-level security rolesConfigure row-level security group membershipApply sensitivity labels