Data cleansing

[Anonymous]

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

[mariussve1]

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

[Anonymous]

Hi mariussve1,

thanks a lot, this one is perfect

regards,

dsmitha

[Anonymous]

Hi mariussve1,

Thank you , we are doing the same type of DATA cleansing in excel on a daliy basis. Based on you advise i understand we can make it happen automatically  by using PQ.  kindly request  to share any tutorial link for the same , thanks in advance

regards,

dsmitha

[mariussve1 · Accepted solution]

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