I appreciate you being available to make educative videos like this. Unfortunately, as a beginner in power query, I strugged to keep up with you and had to pause every single minute because you were flying too fast for me.
I agree it’s kinda fast if you’re following step by step. Kinda more suited for someone with advanced excel skills. It’s easier to watch one round for understanding first before attempting to follow I think. Appreciate Mo’s efforts too!
More on the way for sure! Don't forget to check out my other videos. I have at least another 20 videos like this where I can do applicable, practical technical stuff!
I was building a portfolio project on Excel and this video was very beneficial. Thankyou Mo! Plus whenever I need some motivation I watch your video and it works.
I found this video very helpful. Thank you very much for taking the time to share your knowledge in a way that is accessible. I hope you find it rewarding and fulfilling.
Great video and very approachable to people that are familiar with excel. I love that power query is in PowerBI and excel so it’s an easy transition into visualization once you get comfortable with data cleaning
Amazing video as always ! But it would be certainly be great if you can make a full guide of power query like how do we can make the most out of power query for data cleaning
Hi Mo Chen, it’s very good video and I found it while searching the beginner skills for power query. I’m an accountant and somehow it’s become necessity to learn power query. I like your videos but unfortunately you have made only one video on power query. I wish you can make a full 1 hr long course on power query and specially focusing on matching data and append and merging queries. I also like you should include how big data set can be connect and work along with meaningful reports especially for an audit purposes. Thank you brother !!
That's a great shortcut! I actually tend to use windows + shift + S to snip a certain area quickly. And yes, I like using point and click (with the mouse) in the videos because it's easier for the audience to follow.
This has become my go-to video for data cleaning. Thank you so much I have a survey excel sheet that contains multiple survey questions ie Q1 - Q6 and these questions all have diff answers. I’ve been struggling with how to visualize my data. I’d appreciate your help with this. Also could I send you the excel file? I’m a newbie so pls bear with me Thank you very much
7:52 I tried replicating the exact 'If' syntax in the custom column and it is throwing "Error" in the new column. Can't seem to figure out the error. Help!
You've probably worked this out by now, but it may help someone else. I had this at first, then realised I had the IF in capitals. When I put if in lower case it solved the problem. I hope you are well!
It depends haha. Sometimes Excel, sometimes Power Query, sometimes Python, sometimes Tableau... It just depends on the use case and what's most efficient.
The data in the example is very simple, there's no real cleaning required. Some of the data I work with is a total nightmare, plenty of spaces and numbers not aligning. This is almost like a perfectly clean data set. Some of the data I work with numbers and information are all over the place. What would I do to speed this up? I am almost manually sorting through the data which increase the chance of human error.
I have a question please... When I open power query and load my data the green bars above column name not appear I tried to show them but I found two options in data view tab whitespace and monospaced how I show the other options ... I use excel 2019 All the best for you😊
I am working on cleaning the data on power query, but I got an error on a column where most of the data is numeric but at the end of the column some of the data is alphanumeric like: NME67897 the rest of the values are numeric like 18657898 how can I fix this error...?
Bro you are cold at data cleaning! You literally cleaned mounds of data in 25 mins. I’m trying to learn this in my accounting space. You mentioned data camp, is that the only place you learned this?
No, definitely not. I've been working with data ever since the beginning of my career (so 6+ years now). DataCamp is a great place to learn though. I actually created my own Ultimate Excel Projects that includes data cleaning. If you're interested, you can check it out on my website :)
your videos are helping me more than course with high fees, thank you for making me understand data concepts
I’m glad my free videos beat the courses you paid for!
I appreciate you being available to make educative videos like this. Unfortunately, as a beginner in power query, I strugged to keep up with you and had to pause every single minute because you were flying too fast for me.
I agree it’s kinda fast if you’re following step by step. Kinda more suited for someone with advanced excel skills. It’s easier to watch one round for understanding first before attempting to follow I think. Appreciate Mo’s efforts too!
More videos like these please! ( explaining what a data analyst actually does for each kind of work )
More on the way for sure! Don't forget to check out my other videos. I have at least another 20 videos like this where I can do applicable, practical technical stuff!
Not even done with the video and I've learned a lot, this video is fantastic, gonna utilize so much from this video in my day to day!
Glad it was helpful!
I was building a portfolio project on Excel and this video was very beneficial. Thankyou Mo! Plus whenever I need some motivation I watch your video and it works.
I'm so glad you find the content educational and inspirational! Thanks for watching!
I am lucky to find this video. Thank you Mo Chen. You are really one of the best my Excel Sifu
I try my best! I’m glad you found the video helpful 😃
Love it. No fluff. Thanks a lot. You speak my language!
No fluff indeed! I’m glad you found it useful!
I enjoy real examples like this.
Thanks!
Glad you enjoyed it!
Fantastic content 陈先生. As a fellow data geek, I'm compelled to give kudos for excellent explanations of data cleaning in PQ.
I'm glad you liked the video!
Excellent Vid. Thanks so much Mo! You're heaven sent.
Thanks a lot, Mo! I've been enjoying watching your data analytics tutorial videos now. All the best!
I’m glad you like the videos! Thanks for watching!
I found this video very helpful. Thank you very much for taking the time to share your knowledge in a way that is accessible. I hope you find it rewarding and fulfilling.
Great video and very approachable to people that are familiar with excel. I love that power query is in PowerBI and excel so it’s an easy transition into visualization once you get comfortable with data cleaning
I’m glad you liked it!
i very struggle learn power query but this video make me easy to learn, i want try tomorrow , thanks for the video and sharing knowledge
Really, really love it. Thanks Mo
Huge brother. Thanks for opening the door to power query!
Any time!
Amazing video as always ! But it would be certainly be great if you can make a full guide of power query like how do we can make the most out of power query for data cleaning
Great idea! Let's see if I'll have the time.
Absolutely Amazing Bor, thank you
Glad you liked it!
Great video. Thank you so much for sharing. I really like that you show the steps where you identified errors and how you fixed them.
Glad it was helpful!
Thanks Mo, this was very helpful and informative
Glad it was helpful!
Can I just comment when I clicked on your website, how easy and insightful from the titles itself? Great job!
Of course you can haha. I’m glad you like the website too!
Love your content looking forward for more
Should we go this far in data cleaning for Power BI use case ? Thanks
Thanks for mo, the best power query exercise ❤🎉🎉,pretty useful one
Glad you liked it!!
Awasome detailed explanations. Thank you for making this video.
Glad you enjoyed it!
Amazing workflow, I can see I have a lot of work left to get there
Educative content, it just rejuvenate my knowledge of Power Query, it been a long while i used Power Query to Clean data, thanks.
Glad it was helpful!
Thank you mo. This video helps mef greatly. I am from Bangladesh.
You indeed a great Techer
Loving the content, would love to see a video that discusses automating tasks using Power Query
Great video idea! I noted it.
Loved it ! Stay blessed.
Really Loved This Approach Thank You For This
Hi Mo, loving these vids well explained and easy to follow along. Hope you do one on PowerBI next :)
I will for sure!
that was excellent information
Thanks MO! my man!
I’m glad you liked it!
Hi Mo Chen, it’s very good video and I found it while searching the beginner skills for power query. I’m an accountant and somehow it’s become necessity to learn power query. I like your videos but unfortunately you have made only one video on power query. I wish you can make a full 1 hr long course on power query and specially focusing on matching data and append and merging queries. I also like you should include how big data set can be connect and work along with meaningful reports especially for an audit purposes. Thank you brother !!
Thanks for the suggestions!
Thanks for the content
Any time
This was amazing. Thanks
I’m glad you found it useful!
Do you have Power Query lesson which relates to how to update new data to modified table data ? your lessons very much & thank you .
Not yet! But please check out my portfolio project playlist for other super useful, end to end data analysis videos.
thanks, I will. I need to change my job in 1 year, so your course are very important to me. ❤
Thanks Mo this was helpful 😊
I'm glad you liked it!
super easy to follow! Is there a reason you are not using Win + Ctrl + T for the snipping tool window? (I guess it's visually less confusing?)
That's a great shortcut! I actually tend to use windows + shift + S to snip a certain area quickly. And yes, I like using point and click (with the mouse) in the videos because it's easier for the audience to follow.
This has become my go-to video for data cleaning. Thank you so much
I have a survey excel sheet that contains multiple survey questions ie Q1 - Q6 and these questions all have diff answers. I’ve been struggling with how to visualize my data. I’d appreciate your help with this.
Also could I send you the excel file? I’m a newbie so pls bear with me
Thank you very much
@00:09 ahhh 😮 I need that “useless” dashboard, … my boss wants that one. Quick! Where can I get the how-to?
7:52 I tried replicating the exact 'If' syntax in the custom column and it is throwing "Error" in the new column. Can't seem to figure out the error. Help!
You've probably worked this out by now, but it may help someone else. I had this at first, then realised I had the IF in capitals. When I put if in lower case it solved the problem. I hope you are well!
Thank you Mo for this.
I’m glad you liked it!
What kind of portfolio would you recommend for someone who wants to work as a data analyst in the financial services sector?
why dont you use power query editor in power bi? like what are limitations?
Thanks
Hi Mo, need some advance level tutorial also.
Check out my portfolio projecy playlist. There are plenty advanced projects in there.
have you used DAX here? or python?
I am unable to download the project files, can you help me out?
Do you typically clean data with power query or do you use other means? Thank you for the video!
It depends haha. Sometimes Excel, sometimes Power Query, sometimes Python, sometimes Tableau... It just depends on the use case and what's most efficient.
great video, thank you
What PC are you using?
Wouldn't the " min sal " column actually be 75k?
The data in the example is very simple, there's no real cleaning required. Some of the data I work with is a total nightmare, plenty of spaces and numbers not aligning.
This is almost like a perfectly clean data set. Some of the data I work with numbers and information are all over the place. What would I do to speed this up? I am almost manually sorting through the data which increase the chance of human error.
Pls I need the Un cleaned data
Hi Mo, I always wait for your videos. Thanks for your useful videos, I appriciate it. You've reached 100k followers, did you get silver button?
Thanks for watching! I have not received it yet, but it’s on the way. Thanks for asking :)
Hi Mo Chen. Thank you so much for this video 🫶🏼🥹 i still learning about power query and i love to improve my skills
Did you use Excel on VM on your Mac or in a Windows PC?
I use Excel on my PC
I have a question please... When I open power query and load my data the green bars above column name not appear I tried to show them but I found two options in data view tab whitespace and monospaced how I show the other options ... I use excel 2019
All the best for you😊
That might be a version issue then. I'm using the latest Microsoft apps for everything.
I am working on cleaning the data on power query, but I got an error on a column where most of the data is numeric but at the end of the column some of the data is alphanumeric like: NME67897 the rest of the values are numeric like 18657898 how can I fix this error...?
I already tried changing the data type from numeric to text but did not work....I appreciate if you can help me...
Bro you are cold at data cleaning! You literally cleaned mounds of data in 25 mins. I’m trying to learn this in my accounting space. You mentioned data camp, is that the only place you learned this?
No, definitely not. I've been working with data ever since the beginning of my career (so 6+ years now). DataCamp is a great place to learn though. I actually created my own Ultimate Excel Projects that includes data cleaning. If you're interested, you can check it out on my website :)
gold
You can actually change type simultaneously by pressing ctr while choosing the column. BTW thanks for this video
14:00
Can you play guitar? You should be a rock star!
🤣
Too fast for beginners
He is fast but this is a goldmine. I can recommend watching Alex the analyst first as that's what I did and I think it was very easy to follow.
@@ruxcooking thanks
I watched with 0.5x playback speed and that's helpful. He's too fast for me too, but gotta pick his brain! 😁