Data clean up

The business users have informed you that all valid transactions have an Invoice No. You need to remove transactions with empty invoice values.

You have also been informed that different versions of the same US states in the Order State variable also need your attention.

We do not recommend doing so, but if you lost progress you can load the solution workbook of the previous exercise 1_1_data_source_solution.pbix from the Workbooks folder.