Introduction to Power BI — Lesson 2: Data Preparation and Modeling

Topics Covered

• Power Query transformations
• relationships
• data types
• model design basics

Practical Activity

• Document the scenario, assumptions, stakeholders, and expected business or technical outcome.
• Complete a guided configuration, analysis, or design exercise aligned to the lesson topics.
• Record validation evidence, risks, dependencies, and corrective actions.
• Summarize the result in a reusable implementation or operating note.

Validation Checklist

• Requirements and assumptions are clearly documented.
• The selected Microsoft features or services match the scenario.
• Security, governance, and operational impacts are considered.
• The final result includes evidence and actionable next steps.

Lesson Outcome

Learners can explain and apply data preparation and modeling within a realistic business intelligence and reporting with Power BI scenario.