📌 Topics Covered:

  • Introduction to the Power Query Editor interface.
  • The “Transform Data” workflow.
  • Basic cleaning: Removing rows and columns.
  • Data type correction (Text, Whole Number, Date).
  • Using the “Use First Row as Headers” feature.

📝 Class Summary: An introductory session on data preparation that teaches how to use Power Query to clean and structure raw data before it is loaded into the data model for visualization.

✅ What You Will Learn:

  • How to access the Power Query environment from the Power BI Ribbon.
  • Techniques for promoting headers to ensure data fields are correctly identified.
  • Methods to fix common data type errors that prevent accurate calculations.
  • How to track and undo changes using the “Applied Steps” pane.

 

Watch the Video

Download the Practice File

Click “Mark as Complete” button.

 

Thanks and Good Luck

PreviousNext