Full Power BI Guided Project | Microsoft Power BI for Beginners

Поділитися
Вставка
  • Опубліковано 2 жов 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

КОМЕНТАРІ • 446

  • @luiseduardocosta9878
    @luiseduardocosta9878 2 роки тому +360

    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
      @AlexTheAnalyst  2 роки тому +15

      Congratulations!! So awesome to hear!

    • @prasannakarkhanis9431
      @prasannakarkhanis9431 2 роки тому +2

      Congrats man!

    • @maliksalman1907
      @maliksalman1907 2 роки тому +1

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

    • @luiseduardocosta9878
      @luiseduardocosta9878 2 роки тому +16

      @@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
      @davidg9469 2 роки тому +5

      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
    @dachun9485 Рік тому +64

    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.

  • @tianag4627
    @tianag4627 Рік тому +94

    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
      @AlexTheAnalyst  Рік тому +17

      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
      @29ibrahimsayed95 Рік тому

      yes you are absolutely right

    • @bakedpotatouwu
      @bakedpotatouwu Рік тому

      Agreed!

    • @goodnessmichael8934
      @goodnessmichael8934 10 місяців тому

      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.

  • @hafsashireen7329
    @hafsashireen7329 Рік тому +5

    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

    • @VitorAbreu1001
      @VitorAbreu1001 Рік тому +1

      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

    • @89rm
      @89rm Рік тому +1

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

    • @VitorAbreu1001
      @VitorAbreu1001 Рік тому

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

    • @amazingbroadcast4384
      @amazingbroadcast4384 2 місяці тому +1

      @@VitorAbreu1001 oof thank you so so much i had the same issue

    • @kyriacosstavrinides893
      @kyriacosstavrinides893 Місяць тому +1

      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.

  • @aravindhsankar9017
    @aravindhsankar9017 Рік тому +23

    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.

  • @matthewcastillo8775
    @matthewcastillo8775 Рік тому +8

    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

    • @GaniyuTheGreat
      @GaniyuTheGreat 7 місяців тому

      I'm having the same issue as well

    • @sanjanashivakumar2370
      @sanjanashivakumar2370 7 місяців тому

      yes same thing with me also

    • @samuelagber3507
      @samuelagber3507 4 місяці тому +2

      Just go to the history tab and delete that action. For some unknown reason, the recent power query has that bug

    • @DanDan-qn6on
      @DanDan-qn6on Місяць тому

      bless u

  • @Muyiwa-p3e
    @Muyiwa-p3e Рік тому +7

    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.

  • @HieuPham-dh2qk
    @HieuPham-dh2qk 4 місяці тому +5

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

    • @mahwishwasi478
      @mahwishwasi478 2 місяці тому

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

  • @ldybgrl1
    @ldybgrl1 Рік тому +16

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

  • @debojitdutta4072
    @debojitdutta4072 2 місяці тому +1

    Hi Alex, In the 15th minute of your video, where you replace the value of x with 225 and then bring back the entire column back to its original form, I'm not able to do that as in my case it stays at 225 and does not display the other values, need some help

  • @BruceNJeffAreMyFlies
    @BruceNJeffAreMyFlies 8 місяців тому +4

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

  • @olodiobuma2738
    @olodiobuma2738 Рік тому +12

    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
      @caesar6986 День тому

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

  • @albertliu7103
    @albertliu7103 Рік тому +5

    Hi Alex, I really appreciate you uploading thisPower BI guided project video, very helpful! However, 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
      @abhishekpatil3524 Рік тому

      Same issue !! @Alex

    • @tawandathomas6838
      @tawandathomas6838 Рік тому

      Same issue here, did you get any assistance?

    • @mohansingh4120
      @mohansingh4120 Рік тому

      Same issue here

    • @warigonganga5604
      @warigonganga5604 Рік тому +7

      @albertliu7103 I got the same error. The way around this is do not filter by the + only . Instead1. Select the entire data set for "Current Yearly Salary" column 2. Right click and select "Replace Values" and put Value to Find = + Replace with value = 225 and then hit Ok. You should be able to see a total of 15 records/rows come up with the "225" value when you filter which includes the 2 rows that had +. Hope this helps.

    • @warigonganga5604
      @warigonganga5604 Рік тому +3

      @@mohansingh4120 I got the same error. The way around this is do not filter by the + only . Instead1. Select the entire data set for "Current Yearly Salary" column 2. Right click and select "Replace Values" and put Value to Find = + Replace with value = 225 and then hit Ok. You should be able to see a total of 15 records/rows come up with the "225" value when you filter which includes the 2 rows that had +. Hope this helps.

  • @ipsitbehera6979
    @ipsitbehera6979 Рік тому +2

    After I replaced + with 225 now I’m unable to get the main column. How do I remove the filter ?

  • @TheDavesterist
    @TheDavesterist Рік тому +5

    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!

  • @kritikagupta9894
    @kritikagupta9894 Рік тому +4

    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?

  • @naderbazyari2
    @naderbazyari2 Рік тому +3

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

  • @lindad1418
    @lindad1418 Рік тому +2

    At about 14:44 when you click back on select all for some reason the reason of my rows do not appear. I have redone this twice. not sure what I am doing wrong

    • @GaniyuTheGreat
      @GaniyuTheGreat 7 місяців тому

      Having the same issues as well today, how'd you fix it?

  • @ganeshanalyst
    @ganeshanalyst Рік тому +6

    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 !

  • @osmanuamadu2084
    @osmanuamadu2084 Рік тому +3

    Hello Alex, thank tous very much for a well explained context.
    But I have been following this project tutorial. I got stock after filtering the plus(+) sign. When I unfilter just like you, I could not get the data back like it has displaying for you. When I go back to unfilter, I have only value 225 showing.
    Again, I noticed that in ur steps after replacing value 2, your steps include "Removed column4", " Add Column1", "Removed Column5". Would appreciate some level of assistance at that level. Thank you..

    • @jacksun8129
      @jacksun8129 Рік тому

      I'm stuck on that too

    • @albertliu7103
      @albertliu7103 Рік тому

      Same here, redid the steps 3+ times and still can't see original data...

    • @furkaneren6381
      @furkaneren6381 Рік тому

      @@albertliu7103 same here

    • @kushagraagrawal3740
      @kushagraagrawal3740 Рік тому

      There is definitely something shady going on there. As you can see on the right hand side applied steps pane, as soon as he clicks on the select all, 3 additional steps appear instead of 1. Some steps have been edited out. I found a workaround as I was also stuck here. Basically, you just create another applied step and in the formula tab paste this: = Table.ReplaceValue(#"Replaced Value1","+","225",Replacer.ReplaceText,{"Q3 - Current Yearly Salary (in USD) - Copy.2"}) Make sure you replace the Replace Value 1 with the name of the last step in the action pane if it is different. This formula will replace the + with 225 and keep all other values intact.

  • @VishRP
    @VishRP Рік тому +1

    Hi Alex, how can I show the Power Bi project on my personal project website?

  • @rishabhballkooram9626
    @rishabhballkooram9626 Рік тому +1

    Hello Alex, can you please do a tutorial on how to publish the PowerBI dashboard on web for free. Thank you!

  • @pearlokon9065
    @pearlokon9065 Рік тому +1

    at 18:28 you didn't tell us how to go back to the power query editor when we need to change anything, like for example to split the country column

    • @pearlokon9065
      @pearlokon9065 Рік тому

      you didn't show* us how

    • @emmanuelmartins7273
      @emmanuelmartins7273 17 днів тому

      Please can you send me the file used? Tried downloading it vai the link but isn't going.

  • @WesTsidE231
    @WesTsidE231 Рік тому +4

    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 🙏

  • @funmilayogbokoyi7363
    @funmilayogbokoyi7363 8 місяців тому +2

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

  • @nnamdiLdavid
    @nnamdiLdavid Рік тому +3

    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

  • @laurabranham8458
    @laurabranham8458 Рік тому +1

    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.

  • @girdhar3224
    @girdhar3224 Рік тому +1

    28:46 HOW DOES TREE MAP IS CHANGING VALUES OF EVERY OTHER DATA

  • @warigonganga5604
    @warigonganga5604 Рік тому +5

    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
      @thiscyn Рік тому

      more detail thanks. not understand

  • @AbrarMuhtasim
    @AbrarMuhtasim Рік тому +1

    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.

  • @mf_faqih
    @mf_faqih 11 місяців тому +1

    Did anyone get an error in the Date Taken column? seems the downloaded data is a little bit different than in the video.

    • @kramachandran4292
      @kramachandran4292 11 місяців тому +1

      yeah i am facing the same issue looks it should be 10/6/2022 instead of 6/10/2022. BTW were you able to solve this issue?

  • @jeisonkunene6376
    @jeisonkunene6376 Рік тому +2

    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

  • @ritviksourab889
    @ritviksourab889 Рік тому +1

    what happend after 14.40 ?once after you selected all in that column 3 of yearly salary,not able to folllw on after it

  • @ayokunnumicaleb2002
    @ayokunnumicaleb2002 2 роки тому +2

    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.

  • @19995700
    @19995700 Рік тому +1

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

  • @nelisadludla2563
    @nelisadludla2563 Рік тому +1

    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.

  • @AjaySingh-800
    @AjaySingh-800 Рік тому +6

    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.

  • @anjalitherkar7439
    @anjalitherkar7439 10 місяців тому

    there is an error in date taken column.. ....how to remove that or solve that

  • @DPEART6475
    @DPEART6475 4 місяці тому +1

    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
      @NightWingRequiem 4 місяці тому

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

  • @josephcruz4736
    @josephcruz4736 2 роки тому +2

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

  • @kazinahian3593
    @kazinahian3593 Рік тому +4

    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.

  • @abdeljalilsekal6366
    @abdeljalilsekal6366 Рік тому +1

    when i replace + by 225 , did not succeed to return to the entire list

    • @sumairaasif2448
      @sumairaasif2448 Рік тому

      same here. You can replace the values without filtering.

  • @jeremyv12
    @jeremyv12 Рік тому +1

    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.

  • @sushi_senpai_og
    @sushi_senpai_og 17 днів тому

    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

  • @mirabelsika7442
    @mirabelsika7442 11 місяців тому +1

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

  • @santoshwaghmare4081
    @santoshwaghmare4081 2 роки тому +4

    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

    • @abhishekpatil3524
      @abhishekpatil3524 Рік тому

      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!

    • @santoshwaghmare4081
      @santoshwaghmare4081 Рік тому

      @@abhishekpatil3524 replace + sign with 225. And after that use add custom column

    • @abhishekpatil3524
      @abhishekpatil3524 Рік тому

      @@santoshwaghmare4081 Can you explain in little more detail plz, if you dont mind

    • @Loedairy
      @Loedairy Рік тому

      Same issue 😞

  • @darwinrojas2208
    @darwinrojas2208 20 днів тому

    Hello Alex! First of all, thank you for the videos, I learn a lot. I wanted to ask where I can find that project you mentioned that will take you like two hours, I've searched your channel but there's nothing. Waiting for your prompt response. Thank you in advance for your time.

  • @monisolaoyeyemi6019
    @monisolaoyeyemi6019 Рік тому +2

    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.

  • @abhishekpatil3524
    @abhishekpatil3524 Рік тому +2

    Hi Alex, I really appreciate you uploading thisPower BI guided project video, very helpful! However, 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!

    • @Loedairy
      @Loedairy Рік тому

      Hey watsup
      I got the same issues
      How did you get it fixed??

    • @furkaneren6381
      @furkaneren6381 Рік тому +1

      @@Loedairy Alex filtered the copy2 column. I filtered copy1 column intstead of cop2 column and then I replaced the + values on copy2 column and ıt worked .I recommend you to try it.

    • @nnamdiLdavid
      @nnamdiLdavid Рік тому

      @furkaneren but it affects all rows both copy and original, so how do you then get back to the original number of rows. Not sure I understand

  • @riomouris4767
    @riomouris4767 3 місяці тому

    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.

  • @leahrath2823
    @leahrath2823 5 місяців тому

    hi everyone! I know this video is from a year ago, but if there happens to be a person who actively is watching this, I could use some help! At the 14:45 mark, there is a cut where it goes from having "Replaced Value2" in the Applied Steps, then goes to having "Added Custom", "Removed Columns4", "Added Custom 1" and "Removed Columns5" in the Applied Steps. If anyone could explain (in beginner terms lol) how he got from one step to another, I would be super appreciative!

  • @baruchsigal4467
    @baruchsigal4467 10 місяців тому +1

    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?

    • @AlexTheAnalyst
      @AlexTheAnalyst  9 місяців тому +1

      Haven't done it yet - been busy with other kinds of videos, but will circle back around probably this upcoming year :)

    • @rabihyounes747
      @rabihyounes747 27 днів тому

      @@AlexTheAnalyst Amazing content! Did you revisit this on a higher level ? if yes please can you please share the video

  • @Pishgul
    @Pishgul 3 місяці тому

    Hello. Between replaced values2 and removed column some steps were neglected. At least from what I see, when you filter Q3 copy 2 (last column) for + values and replace it with 225. Only two rows remained. I dont know how after you deselect and select the column appeared again.

  • @ogunleyeoluwaseun2163
    @ogunleyeoluwaseun2163 6 місяців тому

    Hello Mr. Alex, thank you very much for the amazing video.
    I need your help! I am unable to download the sample files for all the videos on your Github. Is there any alternative way of getting the datasets?
    Thank you, sir.

  • @Stoner_FF_Yt
    @Stoner_FF_Yt 26 днів тому

    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.

  • @erdooabanyi5166
    @erdooabanyi5166 3 місяці тому

    Thank you very much for your well versed video on power bi. But at 13 mins if the video wher we are to replace values. I have done just as it was directed in the video but some of the k's were jot eliminated. But whn I replace d value of (-) all d minus signs were removed. Please I need help

  • @chinsinang8887
    @chinsinang8887 Місяць тому

    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.

  • @arslandurmuhammad7126
    @arslandurmuhammad7126 Рік тому +28

    After replacing '+' with '225', I am just getting only two rows of data. Kindly tell me, how would I be able to see all row?. Answer please dear Alex Analyst 🙏

    • @pranaykolhe8342
      @pranaykolhe8342 Рік тому +2

      i have also same doubt

    • @albertliu7103
      @albertliu7103 Рік тому +2

      Same here, redid the steps 3+ times and still can't see original data...

    • @saiymeenfatima_MVEE
      @saiymeenfatima_MVEE Рік тому

      Hey I'm facing the same issue

    • @millenniumkitten4107
      @millenniumkitten4107 Рік тому +13

      Im not sure why, but you have to unfilter it before you use Replace Values. It works correctly if it's not filtered

    • @sangeetasangwan17
      @sangeetasangwan17 Рік тому +4

      Just go on the applied steps and delete the filtered row step from there. You will see all the values then.

  • @braydenmiller8295
    @braydenmiller8295 2 роки тому +2

    Alex whats your thoughts on performing the PQ ETL in excel vs PBI? I tend to always do the ETL in the excel file if thats the data source.

    • @alexmartin2517
      @alexmartin2517 Рік тому

      I'm with you on this. Excel has its benefits in some instances. I guess it depends how many rows you are working with, especially if the data is pulled from a data warehouse originally

  • @faizanahmed3760
    @faizanahmed3760 Місяць тому

    I am unable to close and apply the power query editor as in the date column I have got a set of rows labelled "Error". Any suggestions?

  • @sj1795
    @sj1795 9 місяців тому +2

    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!

  • @janbazahmedkhan8023
    @janbazahmedkhan8023 4 місяці тому

    Hey #Alex_The_Analyst where is the 'really in-depth project' that you did on this particular dataset.. Could you provide the link for it please
    Thanks..

  • @alianahaze
    @alianahaze 10 днів тому

    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

  • @paulokeowo7687
    @paulokeowo7687 Рік тому +1

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

  • @syedsibtebukhari
    @syedsibtebukhari 6 місяців тому

    It will be so grateful if we can get a Certificate for this bootcamp, as you know, at job it's necessary to show some proof. Please I need one certificate for this bootcamp

  • @chantellechiu2988
    @chantellechiu2988 Рік тому +1

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

  • @victorokata5414
    @victorokata5414 5 місяців тому

    Hi Alex, I'm unable to download the dataset used for the project. Can you or anyone who has the data help me with this issue

  • @jonathanonyebuchi9253
    @jonathanonyebuchi9253 4 місяці тому

    hello Alex, i noticed that in the qualification column there were so many blank rows, why didn't you delete it?

  • @ruheenift
    @ruheenift 16 днів тому

    Hey Alex - Did you do a 2 hour detailed project with this data like you mentioned in the video ?

  • @parham6676
    @parham6676 Рік тому +1

    what happens at 14:45?
    why is there 4 more lines in APPLIED STEPS? what happened?

    • @parham6676
      @parham6676 Рік тому +1

      I'm stuck at the filtered view! how do i get back to the full view?

    • @parham6676
      @parham6676 Рік тому +1

      I don't mean to discourage you, I still love this.

  • @sarthakmajhi6586
    @sarthakmajhi6586 2 роки тому +1

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

  • @jendargue470
    @jendargue470 Місяць тому

    Great series! Thanks Alex! As a UK student, I had date format errors when I closed and applied cleaned data in PowerBI (my machine is trying to read 06/13/2022 as a UK date). I couldn't figure out how to reformat the date in Power BI and had to restart in Excel to fix date ( MDY to DMY changing 06/13/2022 etc. into 13/06/2022...). Is there a method I could have used in Power BI?

  • @vieiradan
    @vieiradan Рік тому +1

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

  • @kartikgupta370
    @kartikgupta370 10 місяців тому

    why my database developer showing that they are making less money than student/looking ??

  • @Udiama
    @Udiama 10 днів тому

    Please how was the ‘null’ entries treated and the blanks in ‘highest level of education’

  • @aderojuabolaji9721
    @aderojuabolaji9721 Рік тому +1

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

  • @ZakirBhai-y2d
    @ZakirBhai-y2d 11 місяців тому

    can anyone share bullet points to add in resume if this helps me a lot.
    as a fresher I have not proper details to how to add this in resume.

  • @kunalbolar2488
    @kunalbolar2488 Місяць тому

    DataFormat.Error: We couldn't parse the input provided as a Date value.
    Details:
    6/13/2022
    i am getting an error in power bi at column 505 and so on
    i solved the error by changing the regional settings in power bi to United states

    • @kunalbolar2488
      @kunalbolar2488 Місяць тому

      this resolved my error - ua-cam.com/video/quEN7orGuSA/v-deo.html

  • @nishipishi
    @nishipishi 7 місяців тому

    how to share from desktop to my portfolio since I don't have a work email?
    it seems to be impossible to create a work email for free with Microsoft and use powerbi service.

  • @SarahEllis-zz9ib
    @SarahEllis-zz9ib 4 місяці тому

    Hi can someone please help me ! I get to the 14:30 time stamp and every time i try and replace the + signs with 225 it works but then i try to reselect all and EVERYTHING ELSE is gone. I've restarted and tried playing around with it but everything else is just gone. can someone explain whats happening ?

    • @muhammadabdihakim3472
      @muhammadabdihakim3472 4 місяці тому +1

      just do the replacement without only selecting the +. In other words just find the + sign and replace it with 225 with all selections.

  • @literosy
    @literosy 2 роки тому +3

    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
      @AlexTheAnalyst  2 роки тому +1

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

    • @literosy
      @literosy 2 роки тому +1

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

  • @zik92
    @zik92 Рік тому +1

    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!

  • @tarifkhantuber
    @tarifkhantuber 16 днів тому

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

  • @gauravpathak2126
    @gauravpathak2126 8 місяців тому

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

  • @nkhofi
    @nkhofi 21 день тому

    Hi, Alex! Is the videos and insights enough to secure a job?

  • @adamkirchhoff2286
    @adamkirchhoff2286 11 місяців тому +1

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

  • @sauliuhas
    @sauliuhas Рік тому +1

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

  • @wajidmahmood9482
    @wajidmahmood9482 Рік тому +1

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

  • @StarkTsorian
    @StarkTsorian 4 місяці тому

    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!

  • @Itsmizzymizzy
    @Itsmizzymizzy 4 місяці тому

    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?

  • @joes.8351
    @joes.8351 4 місяці тому

    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.

  • @kwakuboateng7525
    @kwakuboateng7525 10 місяців тому

    Thanks Alex. A question here: For the very 1st visual, if we do An Average on The Average Salary Column for the stacked/clustered bar chart.... is it again computing Average over that same column? Because I thought a SUM on the Average Salary Column would be ideal since the averages have already been computed.. Please throw more light on this, thanks :). I enjoy your videos!.

  • @ZINALOUDJANI-uk9ft
    @ZINALOUDJANI-uk9ft 21 день тому

    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.

  • @lakshmilalitha2709
    @lakshmilalitha2709 6 місяців тому

    I want a full video on data cleaning , if he already made please help me with the link

  • @Brucesharklee
    @Brucesharklee Рік тому

    Hey Alex! I have a question where I can't find the answer to anywhere...
    I have a CSV file and I can't figure out why the decimal numbers in my CSV file show up with multiple decimal points. (eg: 6.34829851043932 showing as 634.829.851.043.932)
    PowerBI will import the same format and then when I want to change the data type to a decimal number it'll give an error. Is there a solution to this?

  • @NuelAbramD.DeGuzman
    @NuelAbramD.DeGuzman 13 днів тому

    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.

  • @mosengen
    @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

  • @truthgaming2296
    @truthgaming2296 3 місяці тому +1

    thanks alex, its help me a lot :)

  • @bhagyamalithwasalatantri5761
    @bhagyamalithwasalatantri5761 11 місяців тому

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

  • @nilashishalder7629
    @nilashishalder7629 Рік тому

    Hi Alex, its a old video so you might not see this but if you do, could you suggest some alternative name for 'Favourite Programming Language' as I want SQL to be there so I'll standardize it but that logic of SQL is not a programing language cannot be denied.
    How does 'Favourite Data Exploration Language' sound? Or if anyone else has any better sounding one, I'd be happy to get some idea