Transform before load

Raw data usually doesn't arrive in the perfect form when you account for human errors, bugs, and file conversion. Power BI accounts for this with the Power Query Editor, which allows you to transform data before loading it. In this exercise, you will load another dimension called DimCustomer, except unlike the others, this file will need to be edited prior to loading.

If you lost progress, close any open reports and load 2_1_transform_load.pbix from the Exercises folder on the desktop.