PL-300: Microsoft Power BI Data Analyst

Get data from different data sources

• identify and connect to a data source
• change data source settings
• select a shared dataset or create a local dataset
• select a storage mode
• use Microsoft Dataverse
• change the value in a parameter
• connect to a data flow

Clean, transform, and load the data

• profile the data
• resolve inconsistencies, unexpected or null values, and data quality issues
• identify and create appropriate keys for joins
• evaluate and transform column data types
• shape and transform tables
• combine queries
• apply user-friendly naming conventions to columns and queries
• configure data loading
• resolve data import errors

Design a data model

• define the tables
• configure table and column properties
• design and implement role-playing dimensions
• define a relationship's cardinality and cross-filter direction
• design a data model that uses a star schema
• create a common date table

Develop a data model

• create calculated tables
• create hierarchies
• create calculated columns
• implement row-level security roles
• use the Q&A feature

Create model calculations by using DAX

• create basic measures by using DAX
• use CALCULATE to manipulate filters
• implement Time Intelligence using DAX
• replace implicit measures with explicit measures
• use basic statistical functions
• create semi-additive measures
• use quick measures

Optimize model performance

• remove unnecessary rows and columns
• identify poorly performing measures, relationships, and visuals
• reduce cardinality levels to improve performance

Create reports

•  add visualization items to reports
• choose an appropriate visualization type
• format and configure visualizations
• use a custom visual
• apply and customize a theme
• configure conditional formatting
• apply slicing and filtering
• configure the report page
• use the Analyze in Excel feature
• choose when to use a paginated report

Create dashboards

• manage tiles on a dashboard
• configure mobile view
• use the Q&A feature
• add a Quick Insights result to a dashboard
• apply a dashboard theme
• pin a live report page to a dashboard

Enhance reports for usability and storytelling

• configure bookmarks
• create custom tooltips
• edit and configure interactions between visuals
• configure navigation for a report
• apply sorting
• configure Sync Slicers
• group and layer visuals by using the selection pane
• drilldown into data using interactive visuals
• export report data
• design reports for mobile devices

Identify patterns and trends

• use the Analyze feature in Power BI
• identify outliers
• choose between continuous and categorical axes
• use groupings, binnings, and clustering
• use AI visuals
• use the Forecast feature
• create reference lines by using the Analytics pane

3 Days