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

Подписаться 14 тыс.

Просмотров 56 тыс.

50% 1

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

Опубликовано:

8 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 56

@myChannel40629 11 месяцев назад

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 ru-vid.com/group/PLvkYWwzsiISE7z76MedgwIkrno079fvm0 ru-vid.com/group/PLvkYWwzsiISGp7_MbKbWNFfJT-ArSh3fC ru-vid.com/group/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! 🙂

@shreeshree4270 10 месяцев назад

Thank You For Your Concern & Suggestion. I Shall Try & If Not Request Your Guidance. Regards.

@pivotalstats 10 месяцев назад

👍

@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 Месяц назад

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!

@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 8 месяцев назад

Great content indeed!

@pivotalstats 8 месяцев назад

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!

@sevgisjourney8922 5 месяцев назад

bravooo👏👏👏👏👏

@pivotalstats 5 месяцев назад

Cheers!

@crazyasad1010 Год назад

Great Communication for Interactive Skills

@pivotalstats Год назад

👍

@kishenjit Год назад

Nice presentation!

@pivotalstats Год назад

Thank you! Cheers!

@jeissondavidsuesca 4 месяца назад

hi from bogota

@pivotalstats 4 месяца назад

Hello, thanks for watching! :)

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

@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 6 месяцев назад

Good evening bro, I cannot change my data type of text to date can you please help me with that

@pivotalstats 6 месяцев назад

Hi, You can check out below video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-quEN7orGuSA.html

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

@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

@Cricstory0108 4 месяца назад

Sir column merge nahi ho rahe ha

@pivotalstats 4 месяца назад

Kuch error aa raha hai kya?

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

@lakkudawargave 3 месяца назад

Data ki file kaha hai

@pivotalstats 3 месяца назад

Link description mai hai. You can download from there.

@cyrilshabu6540 11 месяцев назад

Malayali ano ?

@pivotalstats 11 месяцев назад

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!