In this video, we will discuss how to clean and format a sales table using Power Query.
Bad data is a big pain for everyone. Data analysts spend most of their time cleaning data, as it rarely comes in the format they need.
Power Query comes as a perfect solution to this problem. In the video below, we look at a sales table and learn how to clean and format it with Power Query.
Steps in the video
None of these functions require a special knowledge of coding. They are quite simple and can be performed with the right-click of a mouse in the Power Query editor. When you understand concepts behind the transformations, you would be able to shape your data into the format you need in 10 minutes.
When building tables in Power Query, the rule of thumb is to go for less columns and more rows. This gives users the ability to perform a variety of operations, such as filtering out values, calculating differences, counting, averaging and other calculations at which the columnar database structure is far better than the spreadsheet format.