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.

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

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

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

[@Акоп-т2х]

I am from Russia. Do you working now in Data Analysis ?

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

[@mosaabalmasry5980]

Thank You for that

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

[@Ascend65]

It's not working

[@naderbazyari2]

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

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

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

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

[@mouryasaiunnam697]

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

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

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

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

[@adamkirchhoff2286]

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

[@NuelAbramDeGuzman]

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.

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

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

[@funmilayogbokoyi7363]

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

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

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

[@ShinEKMG]

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

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

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

[@sunnygawande5283]

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

[@AlexTheAnalyst]

Awesome!

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

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

[@19995700]

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

[@kammogotsi325]

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

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

[@Ascend65]

Hello, I can't seem to find the average of the two columns

[@marecare987]

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

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

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

[@miyanonkululeko]

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

[@Sawabeq]

Just Finished the course ... AWSOM WORK

[@mezianeouchebbouk1779]

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

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

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

[@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 🙏

[@khadarimohammed6340]

im watching your videos daily and m learning a lot for you so huge thanks I SHALL NOT SULLY YOUR NAME I PROMISE

[@vieiradan]

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

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

[@paulokeowo7687]

Wow! This really gives a soft landing into Power BI. 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🙏

[@chantellechiu2988]

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

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

[@josephcruz4736]

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

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

[@SadhanaYadav-kk1xp]

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

[@umairtaj8653]

i just complete these lectures .thanks Alex.

[@aderojuabolaji9721]

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

[@Nick-pd2yo]

@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

[@AlinSelinayOzmen]

Thanks your answer helped me a lot

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

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

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

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

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

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

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

[@sarthakmajhi6586]

Hoping to crack a data analyst job role soon. *Fingers crossed*

[@vaibhavitatekar4700]

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

[@willymwangi3865]

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

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

[@domingosnhamussua3070]

Thanks for helping me build my first dashboard

[@nestormartire5305]

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

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

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

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

[@ajex010]

completed the series, now I am doing this project and then I'll start searching for more

[@AlexTheAnalyst]

That's great! Good work!

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

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

[@warigonganga5604]

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

[@thiscyn]

more detail thanks. not understand

[@in5125]

the best coaching video on utube!!!

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

[@sauliuhas]

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

[@mirabelsika7442]

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

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

[@baileyboy3687]

@@stephensafarowic5544 yes, im stuck here also

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

[@omerdurkut1053]

Thanks Alex!It was great to practice this basic Project :)

[@shahporanhimel9207]

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

[@ebubeawachie]

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

[@adrianb6193]

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!

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

[@TshilidziMagada]

Thanks for this Alex, great explanation and easy to follow.

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

[@huzaifaarqam9368]

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

[@Joe-Bourbon]

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.

[@swastiktripathy8412]

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

[@RosasYo]

Survey Takers = Participants :) Thanks for the video!

[@yurobert3007]

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

[@StarkTsorian]

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!

[@sergiomenacho7]

Great video! It'd be great if you changed the average age so that it doesn't show in decimal numbers.

[@Kratikajain511]

I have no words for this person 😭

[@Itsmizzymizzy]

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?

[@wajidmahmood9482]

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

[@tshepisomokoena5075]

Great series. Thank you

[@sushi_senpai_og]

00:01 Preparing for the final project with real data and survey insights 01:49 Transforming data in Power BI from Excel 05:59 Data transformation in Power Query Editor 07:59 Splitting columns to simplify visualization options 11:56 Calculating average and data cleaning process 14:05 Creating an average salary column in Power BI using Dax expressions 18:22 Setting up data and basic visualization in Power BI 20:15 Analyzing Survey Data 23:57 Formatting visual and renaming elements for a clearer dashboard view. 25:58 Visualizing voter count and favorite programming languages 29:32 Analyzing work-life balance and salary satisfaction 31:20 Visualizing gender pay gap using Power BI 35:10 Making adjustments to the visual presentation of the data. 37:00 Organizing and ordering data for better understanding 41:01 Customize and utilize the data for creating impactful dashboards

[@bolajiawofuwa8116]

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

[@tarifkhantuber]

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