Forum Discussion
Data cleansing
Hi,
Request your guidance to overcome this issue;
In our sales dashboard were are uploading DATA on a daily basis in excel format, we are getting the DATA from our parent company and have to do the DATA cleansing daily, this is consuming a lot of time. Is there a way that when we get the DATA same cleansing works can be done easily using PQ
kindly advice
regards,
dsmitha
Hi,
This was the top result when i Google:
https://learn.microsoft.com/en-us/training/modules/automate-data-cleaning-power-query/
I have not used it by my self, but it looks What youre after 🙂
Br
Marius
4 Replies
Hi,
PQ have a lot of data cleansing functionalities, but its hard to do ut automaticly if the issues are diffrent from month to month. If the cleansing you are doing in excel is the same all the time it should be possible to implement this in PQ so it does it automaticly. But if its diffrent every time its harder. All depends on the data and What is the problem time to time.
Br
Marius
Hi,
This was the top result when i Google:
https://learn.microsoft.com/en-us/training/modules/automate-data-cleaning-power-query/
I have not used it by my self, but it looks What youre after 🙂
Br
Marius