Microsoft Certified: Power BI Data Analyst Associate (PL-300)
Demonstrate methods and best practices that align with business and technical requirements for modelling, visualising, and analysing data with Microsoft Power BI.
Study the core features and capabilities of Power BI to help you prepare for the PL-300 exam and obtain the official certification.
Training Overview
As a candidate for this certification, 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 visualisations.
Enable others to perform self-service analytics.
As a Power BI data analyst, you work closely with business stakeholders to identify business requirements. You collaborate with analytics engineers and data engineers to identify and acquire data.
You use Power BI to:
Prepare the data
Model the data
Visualise and analyse data
Manage and secure Power BI
You should be proficient at using Power Query and Data Analysis Expressions (DAX).
Course Agenda
Get or connect to data
Identify and connect to data sources or a shared semantic model
Change data source settings, including credentials and privacy levels
Choose between DirectLake, DirectQuery, and Import
Create and modify parameters
Profile and clean the data
Evaluate data, including data statistics and column properties
Resolve inconsistencies, unexpected or null values, and data quality issues
Resolve data import errors
Transform and load the data
Select appropriate column data types
Create and transform columns
Group and aggregate rows
Pivot, unpivot, and transpose data
Convert semi-structured data to a table
Create fact tables and dimension tables
Identify when to use reference or duplicate queries and the resulting impact
Merge and append queries
Identify and create appropriate keys for relationships
Configure data loading for queries