And importantly, the process probably took about a minute to complete. With a few simple steps, Power Query allows the user to transform the data into the below format. There are unneeded rows at the top of the file, columns of blank values, values to fill down, and dates to unpivot. This type of data will be very familiar to Excel users, who know just how much work is involved in re-formatting data to fit their analysis needs. The problem is that the data in their text file looks like this (below). This means modifying the layout, removing errors, and generally making the data more usable for analysis.Ĭommon data transformations performed in Power Query include:Įxample: In this example, a user wants to calculate the monthly performance of each store. ![]() The core purpose of Power Query is to transform data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |