Olá Luís, from a fellow countryman, congrats on your first job. I'm also looking for my first job. Can we get in touch? I'd love to get some tips from you.
I love that you didn't overprepare and explained your thinking process when dealing with problems that occurred. This is more valuable than having it all planned out in advance.
Exactly, this is another thing I love so much about this video. He made it look so real like I am doing it and thinking on what to do next. Thank you again Alex.
Hey Alex, I found your channel about a year now. I took most to the project with you. Created a profile for myself shared with with employers. I got a job with of one the biggest real estate firms in Nigeria as a Research Analyst. I am back for more 😊 Thank you, Alex.
Hi Alex, I am from India. When I decided to switch my career as a Data Analyst, I don't have any clue where to start. But once I started watching your videos I understood I am in a right place. Thank you very much for your efforts. I really enjoyed working with this real time data. I appreciate it.
36:30 You can go into visualisations, format visuals, under visual select detail labels, then select values. "Value decimal places" will change the decimals to however many you want to display. I usually set it to 2 ;)
Thank you for this Alex. I'm still in the process of finding and landing a job. Did my first data analyst interview last Saturday. Unfortunately did not pan out but I'm not giving up! I'm adding this to my portfolio and keep building and moving from there
Hey. At 15:37 , you can just go to Applied Steps and drag the Added Custom step below the Changed Type3 step and that will automatically fix the errors. Thanks for this awesome project!
I can't thank you enough Alex for what you are doing to help the Data community. You bring so much valuable insight and knowledge to so many people all across the world. Please continue to do what you do, you are extremely valuable to so many!! Your videos are a huge reason why I decided to make the career change to Data Analytics. Now, if I could just land my first role, that would be the icing on the cake!!
Alex, I'm learning SOOOOOO much from your Bootcamp series!! This is my 4th project and I was so much more confident. I had a breakthrough doing this project--had lots of fun. I'm very eager to watch more videos from you on in-depth cleaning, but I thought this was a fantastic tutorial! I so appreciate you and all the time you put into building this terrific series. As always, THANK YOU!
You save my day!! I've just simplified a bunch of excel work with this video, something that I think Power BI needs to improve a lot is the design tools... Imagine how powerful would be if we can design like we can in figma...
At 13:39 to remove the minus "--" and "k" it's simpler to just highlight Q3 Current Yearly Salary, Split Column by Delimeter, Custom is the minus"-", use each occurrence then ok. This will create only 2 columns. One with 106k the 1st half and the 2nd with 125k the 2nd half. Highlight the column and right click to find replace value. The value to find will be k, Replace with just leave blank and your done in fewer steps.
hands off to you. You are the best person available on RUclips breaking everything into a way that can be understood by us who are freshies to this field. Salute to you. Love you so much make more videos like this.
Hi, this is really useful for someone who isn't working in data analysis, but helping to understand it and make it more presentable and easier to digest for stakeholders.
Hello Alex, Thanks for making Power BI very easy like the way you made in Excel & SQL 😊 I created this project on my own and am looking forward to your project with DAX functions as you said about in one of the videos that will do something for 2hours. If you already did that add into the playlist or do it if you have some moment in your schedule 🤗 Thanks again for all the great lessons !
I look forward to landing a god data analyst role with your guided projects in my portfolio. These are the best tutorials for data analysis. Thank you.
Thank you so much for the walkthrough! As a future intern, this tools have fed me the fundamental foundations giving me a lot of energy learning more about the visualisation.
Hi Alex, I really enjoyed the whole playlist on Power BI. I finished watching all those in just a day because that is how interesting your teachings were and gained a lot of knowledge. I would love to learn more from your videos in the upcoming days. Thanks a lot.
@16:00 mark when Alex changes the formula to recreate that custom column after he changed the type for the previous two target columns you can actually just reorder the custom column in the applied steps to go after the 'Changed Type' and that will have the same result rather than recreating the formula
Hey Alex, I'm learning from Thailand. (just want you to know that you also have Thai follower lol) I've no other words than a huge thanks to you, i've just finished you SQL, Tableau, and this video it the latest one, it's help me a lot made me able to present my work difference way other than the excel table. Keep up good work and once again, thank you.
I love how you explained it thoroughly. Gonna practise with more projects. Thanks for your amazing power bi tutorial series. Gonna stick to this channel
Hey Alex, thank you soo much for teaching a beginner like me with no prior knowledge on how to use Power BI. Your bit sized videos along with the clarity were excellent to get familiar with the dynamics of Power BI. Thank you again, you have been a great teacher, looking forward to learn more tutorials from you, Cheers! 🙌❤
This whole series was beneficial. Can you also guide a thought process on how to look at the data before actually starting to make visualization/transforming it? Like what things to look out for.
Thank you so much for the great videos. I admire your composure and fluency in teaching. You are not just a teacher but a leader. See you at the top Alex! Have a pleasant day 🙏
Hi Alex! Thanks so much for this guided project. It was so insightful and every bit of the project opened my eyes to so many things that I didn't know before. You are a big blessing to us Don't stop being amazing.
Hi Alex, I have been following you and your videos from quite a long time,when you don't have these many followers and to be honest i got to know about this field from you only. I haven't got a job as of now as a data analyst/engineer but i am working in data migration from past 2 years and planning to switch soon but i really want to thank you for delivering this awesome content,i can't even describe how fun it is learning from you.THANKS A LOT.❤
Great Project - thanks Alex! I'm more of a Tableau User myself than Power BI, so I recreated a similar dashboard but in Tableau instead. Creating that Gauge Chart in Tableau was a LOT more challenging than I initially thought, since I had to do it from scratch. But worked out!
Hi Alex, To start, I want to thank you very much for your video series. It has been very helpful for my Power BI knowledge. This is the first video series I have fully completed. So once video series. Thank you very much. Great work. 👍
Thank you so much Alex. Your content has always been of great help and I love the fact that you always share your dataset to enable one to work along with you.
Hi Alex, Thank you for the content! I was just looking at the wrong things all the time. When I find your video, it was the most easiest and understandable. Thank you once again and I hope you make a lot of great content. Cheers!
Hi, Alex The Analyst, I wanted to thank you for your knowledgeable videos and the effort in creating such meaningful content for inspiring Data Analysts. To be honest, in today's world there is so much knowledge and education platform but I really love your videos and the way you put them across. Hats off to you.
Thank you so much for always providing such great easy to follow projects! I have been able to learn so much by making these useful projects along with you. You work so hard and I can not thank you enough for putting free content for us aspiring data analysts! Looking forward to the extensive Power B.I project! Always grateful to you.
Hi Alex, thanks for all you do. At 14:46 after you replaced values for the filtered rows containing'+' how did you get back to the normal number of rows? You clicked' select all' twice and yours went back to normal but mine remained at the two rows? In so confused
Hi ! Alex thank you so much for this short and precise session of power bi , being a beginner , i learn a lot and the final project at the end gaves me the insights how to design a dashboard, what graph needs to add. Again thank you so much. Keep posting things like that...
Hi Alex, thanks for your video. Could you please explain how you removed the filter after replacing the '+' in the duplicated salary column? I did what you showed in the video but could not get the entire values in the column back. I can't un-filter the column.
I love this playlist you created on Power BI. I really love the final project you used; using professional survey. However, you didn't show how to publish our dashboard. I'm new in the field.
Many thanks Alex for teaching us, As a beginner,It will be very helpful for us ,If you make a video about Data analysis presentation ,how to create the presentation etc.
Alex: "I don't know why I said tones like that." Also Alex: "That's kinda groovy man." lol, thanks for the tutorials, I learned a lot and you helped me see why Power BI is one of the most preferred tools for data visualization.
Thanks for the amazing guidance videos for Power BI, it will definitely help for my new job. hopefully u will make videos for the intermediate/Advanced levels.
Hats off to you Alex! Such a well explained video! Explanation was on point. Keep creating such end to end videos please. Your videos are great help for beginners like me. Thank you. New subscriber
bro did you get at 14:45 when I clicked select all (with the 225 part) and clicked ok, I only got 2 rows and could not get back/show the rest of the data. Can you let me know how can I fix it? I've redone the steps 3+ times already and same results. Thanks!
![PySpark Full Course [2024] | Learn PySpark | PySpark Tutorial | Edureka](http://i.ytimg.com/vi/sSkAuTqfBA8/mqdefault.jpg)
![PySpark Full Course [2024] | Learn PySpark | PySpark Tutorial | Edureka](/img/tr.png)
Hi, Alex! I just wanted to thank you. I got my first job as a Data Analyst and your content helped me a lot. Please keep doing this amazing videos.
Congratulations!! So awesome to hear!
Congrats man!
Great to hear ❤️
By the way by which company have you been hired?
@@maliksalman1907 A3 Data Consultoria, Its a Brazilian data consultant company, I am sure you don't know but it's a great company at my country.
Olá Luís, from a fellow countryman, congrats on your first job. I'm also looking for my first job. Can we get in touch? I'd love to get some tips from you.
I love that you didn't overprepare and explained your thinking process when dealing with problems that occurred. This is more valuable than having it all planned out in advance.
Really glad to hear that! I've always tried to include the issues I get along the way - we all run into them! :D
yes you are absolutely right
Agreed!
Exactly, this is another thing I love so much about this video. He made it look so real like I am doing it and thinking on what to do next. Thank you again Alex.
Hey Alex,
I found your channel about a year now. I took most to the project with you. Created a profile for myself shared with with employers. I got a job with of one the biggest real estate firms in Nigeria as a Research Analyst. I am back for more 😊
Thank you, Alex.
Congratulations Dachun, can u share your linkedIn id
Congratulations bro! Please can we connect?
Congratulations! I’m from Nigeria as well, can we connect?
Nice can we connect.
Hi Alex,
I am from India. When I decided to switch my career as a Data Analyst, I don't have any clue where to start. But once I started watching your videos I understood I am in a right place. Thank you very much for your efforts. I really enjoyed working with this real time data. I appreciate it.
I am from Russia. Do you working now in Data Analysis ?
36:30 You can go into visualisations, format visuals, under visual select detail labels, then select values. "Value decimal places" will change the decimals to however many you want to display. I usually set it to 2 ;)
Thank You for that
16:11 U can just select both columns and then go to "Add column" -> "Statistics" -> "Average". It will insert a new average column.
This "Statistics* -> "Average" where we should write in a new column name or custom column name @hieuPham-dh2qk
It's not working
Thank you for this Alex. I'm still in the process of finding and landing a job. Did my first data analyst interview last Saturday. Unfortunately did not pan out but I'm not giving up! I'm adding this to my portfolio and keep building and moving from there
I just mimiced all you said and made my first Dashboard. Thanks a million for your kind explanation.
I did my first project from this today something i started and completed for the first time, Thank you so much.
Hey. At 15:37 , you can just go to Applied Steps and drag the Added Custom step below the Changed Type3 step and that will automatically fix the errors. Thanks for this awesome project!
Took me longer than I would have thought ( I started at 10 and its now almost midnight) but man did this feel rewarding to learn.
I can't thank you enough Alex for what you are doing to help the Data community. You bring so much valuable insight and knowledge to so many people all across the world. Please continue to do what you do, you are extremely valuable to so many!! Your videos are a huge reason why I decided to make the career change to Data Analytics. Now, if I could just land my first role, that would be the icing on the cake!!
Alex, I'm learning SOOOOOO much from your Bootcamp series!! This is my 4th project and I was so much more confident. I had a breakthrough doing this project--had lots of fun. I'm very eager to watch more videos from you on in-depth cleaning, but I thought this was a fantastic tutorial! I so appreciate you and all the time you put into building this terrific series. As always, THANK YOU!
Thank you so much for this video Alex!, I followed the project from beginning to end and created my own dashboard
Hello Alex this is Fezi from India, Undertaking data analytics student, and this video helped me a lot to get hands-on with PowerBI Thank
You save my day!! I've just simplified a bunch of excel work with this video, something that I think Power BI needs to improve a lot is the design tools... Imagine how powerful would be if we can design like we can in figma...
I'm just getting started with MSFT BI; thank you so much - this clarified everything I needed to get started!
At 13:39 to remove the minus "--" and "k" it's simpler to just highlight Q3 Current Yearly Salary, Split Column by Delimeter, Custom is the minus"-", use each occurrence then ok. This will create only 2 columns. One with 106k the 1st half and the 2nd with 125k the 2nd half. Highlight the column and right click to find replace value. The value to find will be k, Replace with just leave blank and your done in fewer steps.
thats what i did to, don't know why he did it in a round about way
hands off to you. You are the best person available on RUclips breaking everything into a way that can be understood by us who are freshies to this field. Salute to you. Love you so much make more videos like this.
Hi Alex, did my first project from this and it was fun and satisfying, might not be perfect. You make learning interesting and I am stuck with you ❤
Thanks man, somehow when I follow the tutorial somethings wrong in the new column. Your method shows the correct answer I want.
Hey thanks, Alex, I jetted on to look for projects for Power BI and came across your video. I must say I enjoyed my first video with you
Hi, this is really useful for someone who isn't working in data analysis, but helping to understand it and make it more presentable and easier to digest for stakeholders.
Hello Alex, Thanks for making Power BI very easy like the way you made in Excel & SQL 😊 I created this project on my own and am looking forward to your project with DAX functions as you said about in one of the videos that will do something for 2hours. If you already did that add into the playlist or do it if you have some moment in your schedule 🤗 Thanks again for all the great lessons !
I created my first dashboard from this, Learned alot from this. Thank you
Eagerly waiting for new project.
Awesome!
Thank you very much. Have followed the whole series and now have a working understanding of Power BI. Bless you Alex.
I look forward to landing a god data analyst role with your guided projects in my portfolio. These are the best tutorials for data analysis. Thank you.
Thank you so much for the walkthrough! As a future intern, this tools have fed me the fundamental foundations giving me a lot of energy learning more about the visualisation.
Hi Alex, I really enjoyed the whole playlist on Power BI. I finished watching all those in just a day because that is how interesting your teachings were and gained a lot of knowledge. I would love to learn more from your videos in the upcoming days. Thanks a lot.
im watching your videos daily and m learning a lot for you so huge thanks I SHALL NOT SULLY YOUR NAME I PROMISE
@16:00 mark when Alex changes the formula to recreate that custom column after he changed the type for the previous two target columns you can actually just reorder the custom column in the applied steps to go after the 'Changed Type' and that will have the same result rather than recreating the formula
Thanks your answer helped me a lot
Hey Alex, I'm learning from Thailand. (just want you to know that you also have Thai follower lol)
I've no other words than a huge thanks to you, i've just finished you SQL, Tableau, and this video it the latest one, it's help me a lot made me able to present my work difference way other than the excel table. Keep up good work and once again, thank you.
Have you bought Tableau?
@@_drakesdeception Nah, still use it for free. I'm more comfortable with BI tho.
@@fenrirr7208 The Student license?
@@_drakesdeception If you meant to BI, it's my company account, not sure which one they bought
Thank you so much for your effort into this video! Your videos make data analysis much more accessible to people who do not have formal training!
Thoroughly enjoyed building this! So excited to do more with Power BI. Thanks Alex!
Thank you so much! This is my first project and I happy that is was easy even for those who never worked in Power BI before
Hello, I can't seem to find the average of the two columns
Wow! This really gives a soft landing into Power BI. Thanks, Alex.
Thanks so much, Alex! Just finish the course and I'm glad! God bless you bro!
I love how you explained it thoroughly. Gonna practise with more projects. Thanks for your amazing power bi tutorial series. Gonna stick to this channel
Hey Alex, thank you soo much for teaching a beginner like me with no prior knowledge on how to use Power BI. Your bit sized videos along with the clarity were excellent to get familiar with the dynamics of Power BI. Thank you again, you have been a great teacher, looking forward to learn more tutorials from you, Cheers! 🙌❤
This whole series was beneficial. Can you also guide a thought process on how to look at the data before actually starting to make visualization/transforming it? Like what things to look out for.
Thank you so much for the great videos. I admire your composure and fluency in teaching. You are not just a teacher but a leader. See you at the top Alex! Have a pleasant day 🙏
Just finished the final project, thank you Alex. You are a great instructor. Your lessons are really easy to understand and follow step by step
please how did you download the sample data? I couldn't find it
Thanks Alex. I'm trying to learn data visualisation to complement my job skills and this really helps 👊
Great intro to Power BI! Helps me a lot, as I'm just being thrown into making reports and analyzing data in my job, without any experience
Your tutorials help me a lot to start with power bi, Thank You so much Alex
Just Finished the course ... AWSOM WORK
alex, thank you so much for this videos, they were so useful for starting to use power bi, I hold you in the highest regard.
Thanks Alex. This was very easy to follow for a beginner. All steps are still relevant even a year later on.
Thanks a lot Alex, I enjoyed the moment doing my first power BI dashboard and I think that it presents much more visualisation options than Excel.
Hi Alex! Thanks so much for this guided project. It was so insightful and every bit of the project opened my eyes to so many things that I didn't know before. You are a big blessing to us
Don't stop being amazing.
Thank for showing us an example of a project, this is super useful in order to enrich our portfolio with real projects!
the best coaching video on utube!!!
Thank you so much for this one Alex! Can't wait to start this one on a weekend. Let's go! 🔥
Hi Alex,
I have been following you and your videos from quite a long time,when you don't have these many followers and to be honest i got to know about this field from you only.
I haven't got a job as of now as a data analyst/engineer but i am working in data migration from past 2 years and planning to switch soon but i really want to thank you for delivering this awesome content,i can't even describe how fun it is learning from you.THANKS A LOT.❤
I love it!
You are a great teacher! I understood the topic and followed along with ease. :D
May the sweet Jesus bless You and your loved ones!
Great Project - thanks Alex!
I'm more of a Tableau User myself than Power BI, so I recreated a similar dashboard but in Tableau instead. Creating that Gauge Chart in Tableau was a LOT more challenging than I initially thought, since I had to do it from scratch. But worked out!
Hi Alex, To start, I want to thank you very much for your video series. It has been very helpful for my Power BI knowledge. This is the first video series I have fully completed. So once video series. Thank you very much. Great work. 👍
Thank you so much Alex. Your content has always been of great help and I love the fact that you always share your dataset to enable one to work along with you.
Glad to hear it! I think the datasets make it easier to follow along and learn :)
@@AlexTheAnalyst Yes the dataset makes it way much easier to learn along with and the way you explains it, makes it look very simple to comprehend. 🥰
Great work Alex the Guru. Now I feel like an expert. Be blessed abundantly.
Hi Alex, Thank you for the content! I was just looking at the wrong things all the time. When I find your video, it was the most easiest and understandable. Thank you once again and I hope you make a lot of great content.
Cheers!
Hi, Alex The Analyst, I wanted to thank you for your knowledgeable videos and the effort in creating such meaningful content for inspiring Data Analysts. To be honest, in today's world there is so much knowledge and education platform but I really love your videos and the way you put them across. Hats off to you.
So glad to hear it!
Hi Ajay, Did u got a job?
@@manojjagdale6517 Searching for new challenge.
Really thank you for your help and guidance. Kindly do not forget about the advanced version of the project. Super excited for it🙏
Thank you so much for always providing such great easy to follow projects! I have been able to learn so much by making these useful projects along with you. You work so hard and I can not thank you enough for putting free content for us aspiring data analysts! Looking forward to the extensive Power B.I project! Always grateful to you.
Thank you so much for all your tutorials Alex. I hope to meet you in person one day and show u how much u really inspire me
Thank you Alex, I got to build my first dashboard!
Thank you Alex! With your help, I can now proudly say I just added a new tool to my toolkit 😎. Again, thank you!
Hi Alex, I just completed the POWER BI tutorial series. They are very well delivered and helpful. Big Big thanks!! ❤
Hi, Alex! Your PowerBI series was super useful. I made my first dashboard and it turned out to be amazing. Thanks alot.
Thank You Alex. You're one of the finest E-Mentor at all.
Hi Alex, thanks for all you do.
At 14:46 after you replaced values for the filtered rows containing'+'
how did you get back to the normal number of rows? You clicked' select all' twice and yours went back to normal but mine remained at the two rows? In so confused
*I'm
Same
Hey I'm facing the same issues
Hi I met the same problem. Did you solve it?
Same problem for me also
Thank you for this fantastic tutorial, Alex! It is so helpful and easy to follow through.
Love your videos!!!! We need the intermediate and advance power bi courses!!!
Survey Takers = Participants :)
Thanks for the video!
i just complete these lectures .thanks Alex.
Great series. Thank you
Thank you for this. It was easy to follow and understand. I have hopes of getting into the field of Data Analytics in the near future.
Hi ! Alex thank you so much for this short and precise session of power bi , being a beginner , i learn a lot and the final project at the end gaves me the insights how to design a dashboard, what graph needs to add.
Again thank you so much.
Keep posting things like that...
Hi Alex, thanks for your video. Could you please explain how you removed the filter after replacing the '+' in the duplicated salary column? I did what you showed in the video but could not get the entire values in the column back. I can't un-filter the column.
Justice for this comment please
@@stephensafarowic5544 yes, im stuck here also
facing same problem..help please
Wow, learning from you was so much fun...You are an awesome teacher
I love this playlist you created on Power BI. I really love the final project you used; using professional survey. However, you didn't show how to publish our dashboard. I'm new in the field.
Thanks Alex. Your Power BI videos are very informative and helpful for beginnners.
Thanks sooooooooo much for this tutorial series and this project especially.
I have learnt a TON.
Many thanks Alex for teaching us, As a beginner,It will be very helpful for us ,If you make a video about Data analysis presentation ,how to create the presentation etc.
Nice n easy. I've really learned powerbi with you. I'm gonna learn SQL n other data analytics skills as well. Keep doing good job
Great series Alex, thanks for all you do ♥
Thanks for this Alex, great explanation and easy to follow.
Too easy with Alex. Big thanks.
Next stop - > python.
Thank You @alex the analyst . It was a nice learning on Power BI from your tutorial. Good Luck !
AAAAA I LOVE THIS THANK YOU ALEX YOU'RE THE BEST
Alex: "I don't know why I said tones like that."
Also Alex: "That's kinda groovy man."
lol, thanks for the tutorials, I learned a lot and you helped me see why Power BI is one of the most preferred tools for data visualization.
Thank you for this culminating video after the series. Keep up the great work.
Alex You have done it again, Thank you man!!
Thanks Alex!It was great to practice this basic Project :)
Thankyou for this tutorial, From Philippines. 🙏🤗😚
Thanks for the amazing guidance videos for Power BI, it will definitely help for my new job. hopefully u will make videos for the intermediate/Advanced levels.
Wonderful stuff! Looking forward to the advanced Power BI guided project too.
The cleanest Viz I have seen thus far👌
Good job Alex.so clear and easy. Thank you so much.
Thank you again Alex for this video, always clear and incredible👌
At 14:45 how do I unfilter. When I try to do it, it does not return to the previous version. It only contains the 225
I'm having the same issue as well
yes same thing with me also
Just go to the history tab and delete that action. For some unknown reason, the recent power query has that bug
bless u
Hats off to you Alex! Such a well explained video! Explanation was on point. Keep creating such end to end videos please. Your videos are great help for beginners like me. Thank you.
New subscriber
bro did you get at 14:45 when I clicked select all (with the 225 part) and clicked ok, I only got 2 rows and could not get back/show the rest of the data. Can you let me know how can I fix it? I've redone the steps 3+ times already and same results. Thanks!
@@abhishekpatil3524 replace + sign with 225. And after that use add custom column
@@santoshwaghmare4081 Can you explain in little more detail plz, if you dont mind
Same issue 😞