Full Power BI Guided Project | Microsoft Power BI for Beginners

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

[@luiseduardocosta9878]

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.

[@AlexTheAnalyst]

Congratulations!! So awesome to hear!

[@prasannakarkhanis9431]

Congrats man!

[@maliksalman1907]

Great to hear ❤️ By the way by which company have you been hired?

[@luiseduardocosta9878]

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

[@davidg9469]

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.

[@tianag4627]

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.

[@AlexTheAnalyst]

Really glad to hear that! I've always tried to include the issues I get along the way - we all run into them! :D

[@29ibrahimsayed95]

yes you are absolutely right

[@bakedpotatouwu]

Agreed!

[@goodnessmichael8934]

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.

[@dachun9485]

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.

[@manojjagdale6517]

Congratulations Dachun, can u share your linkedIn id

[@emmanuelchigozie9889]

Congratulations bro! Please can we connect?

[@champagne_mami]

Congratulations! I’m from Nigeria as well, can we connect?

[@dorayoung5149]

Nice can we connect.

[@aravindhsankar9017]

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.

[@naderbazyari2]

I just mimiced all you said and made my first Dashboard. Thanks a million for your kind explanation.

[@alianahaze]

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

[@BruceNJeffAreMyFlies]

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 ;)

[@HieuPham-dh2qk]

16:11 U can just select both columns and then go to "Add column" -> "Statistics" -> "Average". It will insert a new average column.

[@mahwishwasi478]

This "Statistics* -> "Average" where we should write in a new column name or custom column name @hieuPham-dh2qk

[@ldybgrl1]

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

[@NuelAbramD.DeGuzman]

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.

[@FawazPashaShroff]

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

[@sj1795]

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!

[@funmilayogbokoyi7363]

Thank you so much for this video Alex!, I followed the project from beginning to end and created my own dashboard

[@TheDavesterist]

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!

[@PurpleFan87]

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.

[@harriatchrista]

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.

[@olodiobuma2738]

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 ❤

[@caesar6986]

Thanks man, somehow when I follow the tutorial somethings wrong in the new column. Your method shows the correct answer I want.

[@mosengen]

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

[@adamkirchhoff2286]

I'm just getting started with MSFT BI; thank you so much - this clarified everything I needed to get started!

[@jeremyv12]

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.

[@kammogotsi325]

Thanks Alex. This was very easy to follow for a beginner. All steps are still relevant even a year later on.

[@jeisonkunene6376]

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

[@marecare987]

Thank for showing us an example of a project, this is super useful in order to enrich our portfolio with real projects!

[@19995700]

Thanks Alex. I'm trying to learn data visualisation to complement my job skills and this really helps 👊

[@ganeshanalyst]

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 !

[@MadeForD]

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

[@rayyanzaidi3323]

hands off to you. You are the best person available on KZbin 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.

[@miyanonkululeko]

Thoroughly enjoyed building this! So excited to do more with Power BI. Thanks Alex!

[@ShinEKMG]

Thank you very much. Have followed the whole series and now have a working understanding of Power BI. Bless you Alex.

[@mouryasaiunnam697]

I did my first project from this today something i started and completed for the first time, Thank you so much.

[@mezianeouchebbouk1779]

Your tutorials help me a lot to start with power bi, Thank You so much Alex

[@jmora7101]

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

[@WesTsidE231]

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 🙏

[@ZINALOUDJANI-uk9ft]

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.

[@vieiradan]

Thanks so much, Alex! Just finish the course and I'm glad! God bless you bro!

[@sandracarruthers7127]

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

[@sifonetuk5207]

please how did you download the sample data? I couldn't find it

[@mynameismylink]

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!

[@sunnygawande5283]

I created my first dashboard from this, Learned alot from this. Thank you Eagerly waiting for new project.

[@AlexTheAnalyst]

Awesome!

[@paulokeowo7687]

Wow! This really gives a soft landing into Power BI. Thanks, Alex.

[@pratyushshetty08]

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! 🙌❤

[@josephcruz4736]

Thank you so much for this one Alex! Can't wait to start this one on a weekend. Let's go! 🔥

[@magdalenekimani8549]

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.

[@chantellechiu2988]

Thank you Alex, I got to build my first dashboard!

[@in5125]

the best coaching video on utube!!!

[@tarifkhantuber]

Great video and also love the explaination which go along Thanks Alex

[@eilafkhalil4635]

Really thank you for your help and guidance. Kindly do not forget about the advanced version of the project. Super excited for it🙏

[@monisolaoyeyemi6019]

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.

[@literosy]

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.

[@AlexTheAnalyst]

Glad to hear it! I think the datasets make it easier to follow along and learn :)

[@literosy]

@@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. 🥰

[@SantiagoOldanoVazquez]

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.

[@chukwuebukanwodo9642]

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

[@mirabelsika7442]

Thank you for this fantastic tutorial, Alex! It is so helpful and easy to follow through.

[@aderojuabolaji9721]

Thank you Alex! With your help, I can now proudly say I just added a new tool to my toolkit 😎. Again, thank you!

[@zik92]

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!

[@nestormartire5305]

Love your videos!!!! We need the intermediate and advance power bi courses!!!

[@AdityaSharma-f3x]

amazing tutorial, learnt a lot, thanks a lot!!

[@nelisadludla2563]

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.

[@RosasYo]

Survey Takers = Participants :) Thanks for the video!

[@gauravpathak2126]

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

[@kazinahian3593]

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.

[@vaibhavitatekar4700]

Hi, Alex! Your PowerBI series was super useful. I made my first dashboard and it turned out to be amazing. Thanks alot.

[@Sawabeq]

Just Finished the course ... AWSOM WORK

[@umairtaj8653]

i just complete these lectures .thanks Alex.

[@willymwangi3865]

Great work Alex the Guru. Now I feel like an expert. Be blessed abundantly.

[@ezhankhan1035]

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!

[@ebubeawachie]

Thanks sooooooooo much for this tutorial series and this project especially. I have learnt a TON.

[@SadhanaYadav-kk1xp]

Hi Alex, I just completed the POWER BI tutorial series. They are very well delivered and helpful. Big Big thanks!! ❤

[@bhagyamalithwasalatantri5761]

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

[@domingosnhamussua3070]

Thanks for helping me build my first dashboard

[@shahporanhimel9207]

Thank You @alex the analyst . It was a nice learning on Power BI from your tutorial. Good Luck !

[@swastiktripathy8412]

Thanks Alex. Your Power BI videos are very informative and helpful for beginnners.

[@amazingbroadcast4384]

AAAAA I LOVE THIS THANK YOU ALEX YOU'RE THE BEST

[@fenrirr7208]

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.

[@_drakesdeception]

Have you bought Tableau?

[@fenrirr7208]

@@_drakesdeception Nah, still use it for free. I'm more comfortable with BI tho.

[@_drakesdeception]

@@fenrirr7208 The Student license?

[@fenrirr7208]

@@_drakesdeception If you meant to BI, it's my company account, not sure which one they bought

[@huzaifaarqam9368]

Thank You Alex. You're one of the finest E-Mentor at all.

[@AjaySingh-800]

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.

[@AlexTheAnalyst]

So glad to hear it!

[@manojjagdale6517]

Hi Ajay, Did u got a job?

[@AjaySingh-800]

@@manojjagdale6517 Searching for new challenge.

[@takudzwakarombo5204]

Alex You have done it again, Thank you man!!

[@wajidmahmood9482]

Wow, learning from you was so much fun...You are an awesome teacher

[@itzboyon6983]

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

[@ayokunnumicaleb2002]

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.

[@tushararora6665]

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

[@mendezapoccalypto7534]

Good job Alex.so clear and easy. Thank you so much.

[@DPEART6475]

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.

[@NightWingRequiem]

thats what i did to, don't know why he did it in a round about way

[@samfordata]

Great series Alex, thanks for all you do ♥

[@yurobert3007]

Wonderful stuff! Looking forward to the advanced Power BI guided project too.

[@jomarieolaran1255]

Thankyou for this tutorial, From Philippines. 🙏🤗😚

[@goodnessmichael8934]

Thank You so much Alex. This was really helpful. I appreciate you a lot.

[@gj1135]

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.

[@Grumpy-J]

Great series, thank you! (FWIW, Subbed and thumbs up to all the vids in this series)

[@alainrav2005]

Thank you again Alex for this video, always clear and incredible👌

[@faismeen]

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

[@patrickmeehan6856]

Thank you for this culminating video after the series. Keep up the great work.

[@marychideme2878]

Thanks Alex this is very helpful❤❤

[@Simran__Manuja]

Alex, you are a lifesaver

[@vinil248]

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.

[@AbrarMuhtasim]

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.

[@truthgaming2296]

thanks alex, its help me a lot :)

[@ChanceMinus]

Excellent series. Thank you.

[@mariamintova5752]

Thank you Alex! Great job!

[@sauliuhas]

Hi Alex, It would be interesting to see API tutorial. Your explanation and teaching are phenomenal

[@Muyiwa-p3e]

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.

[@stephensafarowic5544]

Justice for this comment please

[@thewhistleblower577]

thank you so much...all the way from Nigeria