Study guide — PL-300

Get data from data sources

• Connect to data sources, including databases, files, and online services
• Change data source settings, including data source credentials and privacy levels
• Select a storage mode, including Import, DirectQuery, and Composite
• Use Power Query Editor to work with query groups and query references

Profile the data

• Use Power Query column and value distribution/quality tools
• Identify data anomalies, including outliers and inconsistencies
• Inspect data structures and metadata

Clean, transform, and load data

• Resolve inconsistencies, unexpected values, and nulls
• Evaluate and transform column data types
• Apply user-friendly value replacements and format data
• Merge and append queries, and combine data from multiple sources
• Configure data loading, including query folding and incremental refresh settings