In this video we learn how we can automate data collection/ data transformation process by making use of power query and we will look at the following sources of data:
- Excel table :You will learn how you can grab data from a particular excel table and add some transformation steps to clean the data and use it for reporting.
- Excel worksheet: You will learn how you can grab data from a particular sheet and add some transformation steps to clean the data and use it for reporting.
- Folder: You will learn how to combine multiple excel files into one single file by just dropping the different files into a particular folder.