Thank you so much! Check out the playlists for more Power BI related videos th-cam.com/play/PLvkYWwzsiISE7z76MedgwIkrno079fvm0.html th-cam.com/play/PLvkYWwzsiISGp7_MbKbWNFfJT-ArSh3fC.html th-cam.com/play/PLvkYWwzsiISF_4qKF6n4wcgQh7ow0PzSk.html
Hey you are doing great... content is very good, you explain in a very simple and very clear cut manner and your presentation skill is superb...Please make videos with data analytics projects also.
this is awesome plszalso do upload some advance cleaning method with a practical dataset with their usecases explanation also .....and secondly your voice is really awesome....u got a new subscriber😉
Hi, unfortunately I don't get enough time to attend to 1-1 queries because of my day job and other commitments. However you can post in your queries here on youtube and I will try my best to answer them. Thanks!
@@pivotalstats I saw that you connect on insta texts? If that's true I won't bother you much but will ask the most important questions 1 at a time or an e-mail address can help me. Thank you for your prompt response.
use choose column instead. it will be more handy as you choose the coloumn you wnat to keep in the table, other coloumns will be removed themselves. Just try it once yourself on the same data.
In that case, once you have applied your replacement with 0, go to advanced editor and replace 0 with below formula: List.Average(Table.Column(#"Changed Type1", "intended_balcon_amount")) **Please note #"Change Type1" is the previous steps name, so if your previous step is something else then change it accordingly.**
Sir , what to do with null values .. whose data type is date format.. like shipped date , delivery date...if dis is null somewhere ... From what we can change ? If uh could help plz
If you know the exact dates which needs to replaced with NULL values, then inside Power Query Editor, go to TRANSFORM >> REPLACE VALUES. And then "Value to Find = null" and "Replace With = your new date". However if you are not sure of the dates which needs to be entered, then I would personally leave it alone and then filter them out from my visualization or data if not needed. Hope this helps!
jus now i subscribed but please upload the real time projects end to end please boss and keep it sample data for all the real time projects thanking you and all the best .
When you say multi Column Headers, do you mean Main header for Subject then sub header for Term and so on.? If yes then we will have to first convert that data into a single column header data, otherwise visualization and analysis will not work properly. I will try to create something on this. Thanks!
Hi, due to lack of time, I'm not picking up any freelance projects for now. However you can post ur query here and I'll try to help out as much as possible. Thanks!
@Pivotalstats see like in one column of a sales data Few datas be like ( 30lacs , 50 lacs ) Few datas be like ( 2crs) There are many spelling errors also not everydata in one format , where i cant use delimeter.. Brother i need an urgent help ..i have a submission.. i have texted you over instagram.. pls dm
Unfortunately Power BI only gives us the option to remove rows in terms of "Top, Bottom, Alternate, Duplicate, Blank & Errors". I believe there is no option to directly select couple of rows and delete them. However you always have the option to remove rows using the FILTER method that I showed in this video. Hope this helps. Thanks for watching !
what if you have multiple columns which has a null value, since it is exhausting to the the step of removing null values for each columns, is there a much faster way of removing null values in each column? maybe jsut like in the method of removing duplicates. thanks.
Hi, The process remains the same, you just have to select multiple columns at once by pressing "ctrl", or else press "ctrl + A" to select all. After this you can follow the same process as shown in this video. Hope this helps!
You are just point to point and perfect. Please make more videos. Thanks very much for your work.
Thank you so much!
Check out the playlists for more Power BI related videos
th-cam.com/play/PLvkYWwzsiISE7z76MedgwIkrno079fvm0.html
th-cam.com/play/PLvkYWwzsiISGp7_MbKbWNFfJT-ArSh3fC.html
th-cam.com/play/PLvkYWwzsiISF_4qKF6n4wcgQh7ow0PzSk.html
@@pivotalstats No playlists. Super content, Thanks.
Hey you are doing great... content is very good, you explain in a very simple and very clear cut manner and your presentation skill is superb...Please make videos with data analytics projects also.
Thank you so much 🙂
Awesome your explanation is so simple and short to comprehend
Glad you liked it
this is awesome plszalso do upload some advance cleaning method with a practical dataset with their usecases explanation also .....and secondly your voice is really awesome....u got a new subscriber😉
Sure ill definitely plan that for a future video. Thank you so much! 🙂
Hi, your content is outstanding, please make a video excel tutorial for data analytics.
Thanks, yes its in progress. Will upload soon!
@Pivotalstats, where are you most available to pick 1-1 queries?
Hi, unfortunately I don't get enough time to attend to 1-1 queries because of my day job and other commitments. However you can post in your queries here on youtube and I will try my best to answer them. Thanks!
@@pivotalstats I saw that you connect on insta texts? If that's true I won't bother you much but will ask the most important questions 1 at a time or an e-mail address can help me.
Thank you for your prompt response.
Great content indeed!
Thanks!
Nice presentation!
Thank you! Cheers!
Thank You For Your Concern & Suggestion.
I Shall Try & If Not Request Your Guidance.
Regards.
👍
Great Communication for Interactive Skills
👍
Good video, If I have to replace some values in the whole table, do you know how I can select all of them at one time?
Hi, you can select the 1st column and then Ctrl A. This will select all columns. Then you can apply the Replace Values step. Hope this helps!
use choose column instead. it will be more handy as you choose the coloumn you wnat to keep in the table, other coloumns will be removed themselves. Just try it once yourself on the same data.
Yes that's a great suggestion. Thanks !
How to replace nulls with mean, median or average?
In that case, once you have applied your replacement with 0, go to advanced editor and replace 0 with below formula:
List.Average(Table.Column(#"Changed Type1", "intended_balcon_amount"))
**Please note #"Change Type1" is the previous steps name, so if your previous step is something else then change it accordingly.**
Sir , what to do with null values .. whose data type is date format.. like shipped date , delivery date...if dis is null somewhere ... From what we can change ? If uh could help plz
If you know the exact dates which needs to replaced with NULL values, then inside Power Query Editor, go to TRANSFORM >> REPLACE VALUES. And then "Value to Find = null" and "Replace With = your new date".
However if you are not sure of the dates which needs to be entered, then I would personally leave it alone and then filter them out from my visualization or data if not needed. Hope this helps!
Yes thank you... I left it as blank only..... It is my projct not able to make star schema as it is a snowflake schema.... All messd up 😭😭😭🥺 ....
jus now i subscribed but please upload the real time projects end to end please boss and keep it sample data for all the real time projects
thanking you and all the best
.
Noted, will do. Thanks for subscribing!
Good evening bro, I cannot change my data type of text to date can you please help me with that
Hi,
You can check out below video:
th-cam.com/video/quEN7orGuSA/w-d-xo.html
Nice
Thanks
hi from bogota
Hello, thanks for watching! :)
bravooo👏👏👏👏👏
Cheers!
Could You Please Put A Video For Cleaning Multi Column Header Excell Like For School Results Ie Subject, Term 1&2, Unit Test 1,2 , 3,4
When you say multi Column Headers, do you mean Main header for Subject then sub header for Term and so on.? If yes then we will have to first convert that data into a single column header data, otherwise visualization and analysis will not work properly.
I will try to create something on this. Thanks!
Hello.. i have a complex data .. can i share to you?
Hi, due to lack of time, I'm not picking up any freelance projects for now. However you can post ur query here and I'll try to help out as much as possible. Thanks!
@Pivotalstats see like in one column of a sales data
Few datas be like ( 30lacs , 50 lacs )
Few datas be like ( 2crs)
There are many spelling errors also not everydata in one format , where i cant use delimeter.. Brother i need an urgent help ..i have a submission.. i have texted you over instagram.. pls dm
Sure, can you share the data with me using google drive and ping me the link over instagram. I'll check it out when I get some time. Thanks!
Brother can you please help me with your mail id.. i can send over there??
Hello
How to handle empty rows
Hi, you can filter out the empty rows in the cleaning step itself. Check the video at 10:55. Hope it helps!
@@pivotalstats At 10:55 it just shows how to filter data and not how to handle empty rows, could you please help?
Sir column merge nahi ho rahe ha
Kuch error aa raha hai kya?
Remove row
Unfortunately Power BI only gives us the option to remove rows in terms of "Top, Bottom, Alternate, Duplicate, Blank & Errors". I believe there is no option to directly select couple of rows and delete them. However you always have the option to remove rows using the FILTER method that I showed in this video. Hope this helps.
Thanks for watching !
Data ki file kaha hai
Link description mai hai. You can download from there.
Malayali ano ?
Yeah bro
please remove music
Thanks for the feedback. Yes I have improved my editing skills now :)
what if you have multiple columns which has a null value, since it is exhausting to the the step of removing null values for each columns, is there a much faster way of removing null values in each column? maybe jsut like in the method of removing duplicates. thanks.
Hi,
The process remains the same, you just have to select multiple columns at once by pressing "ctrl", or else press "ctrl + A" to select all. After this you can follow the same process as shown in this video. Hope this helps!