PL-300 Lesson 1: Prepare and Transform Data with Power Query

Topics Covered

• Power BI analytics workflow, business requirements, and data sources
• Power Query connections, profiling, cleaning, transformation, and loading
• Course scope, terminology, platform context, and role expectations
• Business and technical requirements, use cases, assumptions, and success criteria

Practical Activity

Analyze a representative use case, identify requirements, and create a platform or solution map.

• Document assumptions, selected features or services, and expected outcomes.
• Record validation evidence, risks, and any corrective actions.
• Summarize the decision in a reusable implementation or adoption note.

Lesson Outcome

Learners can explain and apply the lesson topics within a realistic PL-300 scenario.