You’re explaining this better than my data analysis professor. Thank you!
@pivotalstats
11 ай бұрын
Thanks! Really glad it was helpful 😀
@kuldeepdraksharam7293
Жыл бұрын
You are just point to point and perfect. Please make more videos. Thanks very much for your work.
@pivotalstats
Жыл бұрын
Thank you so much! Check out the playlists for more Power BI related videos kzitem.info/door/PLvkYWwzsiISE7z76MedgwIkrno079fvm0 kzitem.info/door/PLvkYWwzsiISGp7_MbKbWNFfJT-ArSh3fC kzitem.info/door/PLvkYWwzsiISF_4qKF6n4wcgQh7ow0PzSk
@KeerthiAbe
9 ай бұрын
@@pivotalstats No playlists. Super content, Thanks.
@traptigupta4894
Жыл бұрын
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.
@pivotalstats
Жыл бұрын
Thank you so much 🙂
@digitalatit7324
Жыл бұрын
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😉
@pivotalstats
Жыл бұрын
Sure ill definitely plan that for a future video. Thank you so much! 🙂
@TDNoteBook
Жыл бұрын
Thank you very much for ETL Power Bi video.
@pivotalstats
Жыл бұрын
Welcome! 🙂
@alejandrorodriguezvasquez2557
Ай бұрын
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?
@pivotalstats
28 күн бұрын
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!
@shreeshree4270
10 ай бұрын
Thank You For Your Concern & Suggestion. I Shall Try & If Not Request Your Guidance. Regards.
@pivotalstats
10 ай бұрын
👍
@prabhatjoshi-hg2te
5 ай бұрын
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.
@pivotalstats
5 ай бұрын
Yes that's a great suggestion. Thanks !
@kishenjit
Жыл бұрын
Nice presentation!
@pivotalstats
Жыл бұрын
Thank you! Cheers!
@crazyasad1010
Жыл бұрын
Great Communication for Interactive Skills
@pivotalstats
Жыл бұрын
👍
@madgulamahesh
5 ай бұрын
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 .
@pivotalstats
5 ай бұрын
Noted, will do. Thanks for subscribing!
@shubhisingh8937
8 ай бұрын
Great content indeed!
@pivotalstats
8 ай бұрын
Thanks!
@vishalmane3139
5 ай бұрын
How to replace nulls with mean, median or average?
@pivotalstats
5 ай бұрын
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.**
@Sarkarijobwala123
5 ай бұрын
Good evening bro, I cannot change my data type of text to date can you please help me with that
@pivotalstats
5 ай бұрын
Hi, You can check out below video: kzitem.info/news/bejne/0qt7tGulq3mmhnY
@waheguru0803
9 ай бұрын
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
@pivotalstats
9 ай бұрын
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!
@waheguru0803
9 ай бұрын
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 😭😭😭🥺 ....
@jeissondavidsuesca
4 ай бұрын
hi from bogota
@pivotalstats
4 ай бұрын
Hello, thanks for watching! :)
@shreeshree4270
10 ай бұрын
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
@pivotalstats
10 ай бұрын
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!
@Kusumamanju
7 ай бұрын
How to handle empty rows
@pivotalstats
7 ай бұрын
Hi, you can filter out the empty rows in the cleaning step itself. Check the video at 10:55. Hope it helps!
@sevgisjourney8922
5 ай бұрын
bravooo👏👏👏👏👏
@pivotalstats
5 ай бұрын
Cheers!
@Cricstory0108
4 ай бұрын
Sir column merge nahi ho rahe ha
@pivotalstats
4 ай бұрын
Kuch error aa raha hai kya?
@chota_chef_
Жыл бұрын
Hello.. i have a complex data .. can i share to you?
@pivotalstats
Жыл бұрын
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!
@chota_chef_
Жыл бұрын
@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
@pivotalstats
Жыл бұрын
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!
@chota_chef_
Жыл бұрын
Brother can you please help me with your mail id.. i can send over there??
@chota_chef_
Жыл бұрын
Hello
@lakkudawargave
3 ай бұрын
Data ki file kaha hai
@pivotalstats
3 ай бұрын
Link description mai hai. You can download from there.
@arunranga3646
Жыл бұрын
Remove row
@pivotalstats
Жыл бұрын
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 !
@marvelstark3797
Жыл бұрын
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.
@pivotalstats
Жыл бұрын
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!
Пікірлер: 56