Full Power BI Guided Project | Microsoft Power BI for Beginners
Vložit
- čas přidán 8. 09. 2024
- In this video we will be walking through a full project in Power BI!
Download Microsoft Power BI: powerbi.micros...
Download Project Dataset: github.com/Ale...
Favorite Power BI Courses:
Power BI for Business Intelligence - bit.ly/3Nfi59i
Power BI A-Z - bit.ly/3MkpYKw
____________________________________________
SUBSCRIBE!
Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
____________________________________________
RESOURCES:
Coursera Courses:
📖Google Data Analyst Certification: coursera.pxf.i...
📖Data Analysis with Python - coursera.pxf.i...
📖IBM Data Analysis Specialization - coursera.pxf.i...
📖Tableau Data Visualization - coursera.pxf.i...
Udemy Courses:
📖Python for Data Analysis and Visualization- bit.ly/3hhX4LX
📖Statistics for Data Science - bit.ly/37jqDbq
📖SQL for Data Analysts (SSMS) - bit.ly/3fkqEij
📖Tableau A-Z - bit.ly/385lYvN
Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!
____________________________________________
SUPPORT MY CHANNEL - PATREON/MERCH
🙌Patreon Page - / alextheanalyst
💻Alex The Analyst Shop - teespring.com/...
____________________________________________
Websites:
💻Website: AlexTheAnalyst.com
💾GitHub: github.com/Ale...
📱Instagram: @Alex_The_Analyst
____________________________________________
All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for
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.
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 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.
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 ;)
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
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!
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 ❤
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!!
I just mimiced all you said and made my first Dashboard. Thanks a million for your kind explanation.
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
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.
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!
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 !
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
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.
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 did my first project from this today something i started and completed for the first time, Thank you so much.
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.
I created my first dashboard from this, Learned alot from this. Thank you
Eagerly waiting for new project.
Awesome!
I'm just getting started with MSFT BI; thank you so much - this clarified everything I needed to get started!
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
Thank you so much for this video Alex!, I followed the project from beginning to end and created my own dashboard
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...
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
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
hands off to you. You are the best person available on CZcams 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.
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 🙏
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! 🙌❤
Thanks Alex. This was very easy to follow for a beginner. All steps are still relevant even a year later on.
Thank for showing us an example of a project, this is super useful in order to enrich our portfolio with real projects!
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.
Thank you very much. Have followed the whole series and now have a working understanding of Power BI. Bless you Alex.
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.
Really thank you for your help and guidance. Kindly do not forget about the advanced version of the project. Super excited for it🙏
Thoroughly enjoyed building this! So excited to do more with Power BI. Thanks Alex!
Wow! This really gives a soft landing into Power BI. Thanks, Alex.
Your tutorials help me a lot to start with power bi, Thank You so much 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.
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
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.
Thanks so much, Alex! Just finish the course and I'm glad! God bless you bro!
Thank you Alex! With your help, I can now proudly say I just added a new tool to my toolkit 😎. Again, thank you!
Thank you Alex, I got to build my first dashboard!
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
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!
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. 🥰
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!
Thank you so much for this one Alex! Can't wait to start this one on a weekend. Let's go! 🔥
Hi Alex, I just completed the POWER BI tutorial series. They are very well delivered and helpful. Big Big thanks!! ❤
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!
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,
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.❤
Hi, ALex. I have few questions?
1. How to show my tableau, powerbi, excel project? I meant How do I show recruiter my powerbi and tableau project.
2. Do my project need to be an end-to-end project where I should be using a single dataset showing data manipulation using SQL and then export it to tableau or powerbi for creating dashboard. Is it okay to have SQL project, tableau and powerbi project different from one another.
3. I have difficulties while solving complex SQL queries. I need lot of time to solve complex queries. In beginner level role, how much complex queries I need to prepare for interview. Do interviewers ask complex queries to solve in live interview or give complex queries as task or assignment to solve?
4. how do I know I am ready to sit for powerbi and tableau interview? I meant how much do I need to know about powerbi and tableau to sit for an interview.
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 for this. It was easy to follow and understand. I have hopes of getting into the field of Data Analytics in the near future.
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
Hi, Alex! Your PowerBI series was super useful. I made my first dashboard and it turned out to be amazing. Thanks alot.
Just Finished the course ... AWSOM WORK
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.
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
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.
Hi Alex, It would be interesting to see API tutorial. Your explanation and teaching are phenomenal
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...
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!!!
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.
@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
Great work Alex the Guru. Now I feel like an expert. Be blessed abundantly.
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.
Hoping to crack a data analyst job role soon. *Fingers crossed*
completed the series, now I am doing this project and then I'll start searching for more
That's great! Good work!
i just complete these lectures .thanks Alex.
Hi Alex, thank you for making this video. It was really helpful. Can you please help me find the detailed project (a much more in-depth data-cleaning version of it) that you said you were going to do using this dataset? After watching this, I am very interested in learning what else can be done with this dataset and how can we clean it even more. Can I have the link to that project video if you made it coz I can't find it?
Have you gotten the link to the video ?
@@adesoyetomiwa3892 nope
HI Alex, just wanted to say Thank You for your videos
You mentioned doing another more elaborate project with this same data set
wanted to know if you came around to doing it
Hi Alex, thank you for the good content. :)
Can I ask why did you use count (distinct) for the tree map instead of count ?
Hope to learn more from you.
AAAAA I LOVE THIS THANK YOU ALEX YOU'RE THE BEST
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
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 😞
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
Thanks Alex. Your Power BI videos are very informative and helpful for beginnners.
Thanks for helping me build my first dashboard
the best coaching video on utube!!!
Wow, learning from you was so much fun...You are an awesome teacher
Thanks sooooooooo much for this tutorial series and this project especially.
I have learnt a TON.
Just posting here incase anyone else runs into this error. Another error that you may run into when combining the data in the “Current Yearly Salary” columns into the “Average Salary” column is Expression.Error: We cannot apply operator / to types List and Number.
To get around this error, you will need to calculate the”Average Salary” value in a two step process.
Step 1: Create a custom column to hold the values from adding Column A + Column B Table.AddColumn(#"Filtered Rows1", "Custom.1", each [#"Q3 - Current Yearly Salary (in USD) - Copy.1"]+[#"Q3 - Current Yearly Salary (in USD) - Copy.2"])
Step 2: Create a custom column to hold the final Average Salary value which is the total of Column A + Column B/2
= Table.AddColumn(#"Added Custom7", "Custom.2", each [Custom.1]/2)
Hope this helps
more detail thanks. not understand
Hey Alex! I see you took my comment down. Understandable. I still wanted to at least leave you the same sentiment without the link then to my survey. Thank you for these videos and all of the other free resources you've done. Really looking forward to diving into the SQL and Python videos. Again thank you for your hard work on all of this!
Am getting error in the date column, i believe changing the date format to dd/mm/yyyy would make it work.. but could pls tell how to change the date format
I was getting that error too, I didnt found how to fix it, but I ignored it because we don't need to use it on this project
@@VitorAbreu1001 Thank you I've been having the same issue and spent a while trying to fix it using Chat GPT. I was raging at my pc until I saw your comment that we don't even need the column and that we can ignore it. I stupidly didn't think to skip ahead through the video to check if we did need the column.
@@89rm I know how stressful that must have been! Im glad i helped you! Good luck on the rest of your work brother, you can do it!
@@VitorAbreu1001 oof thank you so so much i had the same issue
When the table loads into Power Query, the software attempts to change data types to what it considers appropriate. The error is because of the different date formats. Go to the applied steps section on the right and delete the change type step.
Thankyou for this tutorial, From Philippines. 🙏🤗😚
Thank You @alex the analyst . It was a nice learning on Power BI from your tutorial. Good Luck !
Hey Alex! Thank you for the informative and promising video session on Power BI. Could I ask when are you planning on releasing the in depth 2-hour Power BI video as mentioned in this video?
Thanks for this series Alex! You've mentioned on this last video of the series that you're going to revisit this on a higher level. I tried looking for it but couldn't find it. Any chance I missed it?
Haven't done it yet - been busy with other kinds of videos, but will circle back around probably this upcoming year :)
@@AlexTheAnalyst Amazing content! Did you revisit this on a higher level ? if yes please can you please share the video
HI Guys, I'm learning basics through the alex's videos and trying to do the project. Please give me suggestions to get a job in the India? what kind of preparation i need to get a job in data analytics field?
Survey Takers = Participants :)
Thanks for the video!
Wonderful stuff! Looking forward to the advanced Power BI guided project too.
hello sir, hope you are doing well. your course is very very good I gotten interview call but he just ask about DirectQuery Mode and importMode and I did not give answer and I am reject base on this, so sir please add this concept in the video may be its help other to get a job.
Thank You Alex. You're one of the finest E-Mentor at all.
Great tutorial! Thanks! Is there a way to publish from Power BI without a license like you can with Tableau Public? Curious how people display their projects in their portfolios.
An error I encountered while importing this data was Power bi was trying to parse in the dates in my locale format (DMY), but the CSV had them in MDY format. By converting them through the 'text to columns' feature under 'Data' tab in excel, I could fix the issue and successfully import (you'll get a parsing error otherwise). Hopefully this saves some people some confusion.