Not all data is perfect. You may need to make a few tweaks or even spend hours reworking the entire dataset to make the original source data usable in your dashboards. Generically, this is known as data transformation. Transforming data is one area where Power Query excels, and this chapter will introduce you to a range of techniques that you may one day need to apply to adjust (or pummel) your data sources so that they form a solid basis for analytics.
So what does data transformation entail? The term covers a range of approaches ...
