Loading a CSV

Datasets rarely come to you exactly as you need them for data analysis. As a result, it is important to understand how to transform data using Power Query before you can start creating reports and dashboards.

In this exercise, you will load a dataset, remove a row, promote a row to become the headers, and change the data type of a column.