Cost Model Magician → 04) Data Transformation

Introduction to Power Query (0370.1)


Description
(Approx 1 hour)

▪ What is Power Query & How to Access it
▪ Key Functions including: Change Data Type, Reorder Columns, Choose Columns
▪ Key Functions including: Replace Values, Merge Columns, Merge, Unpivot, Append
▪ Key Functions including: Conditional Column, Filter, Split Column, Group By
▪ Tips & Tricks for Clean Data
Content
  • COURSE CONTENT
  • Introduction to Power Query
  • FEEDBACK
  • Let us know how we are doing
Completion rules
  • All units must be completed