From the course: Power BI Data Methods (2019)

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Making initial field transformations

Making initial field transformations

From the course: Power BI Data Methods (2019)

Start my 1-month free trial

Making initial field transformations

“

- [Instructor] We have already extracted data and in looking into the metadata as well as changing the data types, we started the transformation step of the ETL process. To make a useful data table, we can undertake helpful initial transformation steps for columns such as promoting the first row as headers for the column names, renaming columns, removing unneeded columns, moving columns around or duplicating them. In the US Census Power BI file we set up connections to earlier, we see in the query for the Population by Zip Code where we selected the source, then promoted the headers and changed the data types. If we click on the Source step, we see where the headers are in row one instead of the header row. We then see that the headers are promoted in the second step. We can easily move the columns around in the Power BI data table. Let's say we want to put the CPOP which represents the population for the entire…

Contents