Top 10 Most Important Data Cleaning Methods in Power BI

No video

Top 10 Most Important Data Cleaning Methods in Power BI | Power BI

Рет қаралды 54,229

Күн бұрын

Mastering Power BI (affiliate):
amzn.to/43rQgm3
Let us see what are the most important Data Cleaning methods which you would need in conducting your data analysis
1. Removing Unwanted Columns
2. Renaming Columns
3. Removing Duplicates
4. Merging Columns
5. Splitting Columns
6. Replacing Null Values
7. Changing Data Types
8. Sorting Data
9. Filter Data
10. Pivot & Unpivot (will be covered in future videos)
Data used
www.pivotalsta...
Previous Video Link
• Understanding Power BI...
Visit my blog for more content :
www.pivotalsta...
Affiliate Links --
Best Web Hosting Service :
bluehost.sjv.i...
Cool tech that I use for these videos :
1. Blue Yeti Microphone - amzn.to/3CeMv7C
2. LG Ultrawide Curved Monitor - amzn.to/3EaHY8v
#Microsoft
#powerquery
#powerpivot
#dataanalytics
#dataanalysis
#powerbi
power bi,power bi desktop,power bi tutorial,power bi dashboard,power bi training,power bi tutorial for beginners,power bi for beginners,microsoft power bi,what is power bi,power bi desktop tutorial,power bi excel,learn power bi,how to power bi,powerbi,power bi course,power bi reports,power bi demo,power bi dashboard design,ms power bi,dax power bi,power bi pro,power bi basics,power bi report,power bi design,power bi service,power bi visuals

Пікірлер: 56

@myChannel40629 11 ай бұрын

You’re explaining this better than my data analysis professor. Thank you!

@pivotalstats 11 ай бұрын

Thanks! Really glad it was helpful 😀

@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 🙂

@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 kzfaq.info/sun/PLvkYWwzsiISE7z76MedgwIkrno079fvm0 kzfaq.info/sun/PLvkYWwzsiISGp7_MbKbWNFfJT-ArSh3fC kzfaq.info/sun/PLvkYWwzsiISF_4qKF6n4wcgQh7ow0PzSk

@KeerthiAbe 9 ай бұрын

@@pivotalstats No playlists. Super content, Thanks.

@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! 🙂

@alejandrorodriguezvasquez2557 21 күн бұрын

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 19 күн бұрын

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!

@TDNoteBook Жыл бұрын

Thank you very much for ETL Power Bi video.

@pivotalstats Жыл бұрын

Welcome! 🙂

@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 !

@shubhisingh8937 7 ай бұрын

Great content indeed!

@pivotalstats 7 ай бұрын

Thanks!

@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!

@kishenjit Жыл бұрын

Nice presentation!

@pivotalstats Жыл бұрын

Thank you! Cheers!

@vishalmane3139 4 ай бұрын

How to replace nulls with mean, median or average?

@pivotalstats 4 ай бұрын

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.**

@crazyasad1010 Жыл бұрын

Great Communication for Interactive Skills

@pivotalstats Жыл бұрын

👍

@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: kzfaq.info/get/bejne/p9t1gZqg163Zg3U.html

@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 😭😭😭🥺 ....

@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!

@jeissondavidsuesca 4 ай бұрын

hi from bogota

@pivotalstats 4 ай бұрын

Hello, thanks for watching! :)

@Kusumamanju 6 ай бұрын

How to handle empty rows

@pivotalstats 6 ай бұрын

Hi, you can filter out the empty rows in the cleaning step itself. Check the video at 10:55. Hope it helps!

@sevgisjourney8922 4 ай бұрын

bravooo👏👏👏👏👏

@pivotalstats 4 ай бұрын

Cheers!

@Cricstory0108 3 ай бұрын

Sir column merge nahi ho rahe ha

@pivotalstats 3 ай бұрын

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 !

@cyrilshabu6540 10 ай бұрын

Malayali ano ?

@pivotalstats 10 ай бұрын

Yeah bro

@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!