How to use Power Query in Power BI | Microsoft Power BI for Beginners
ฝัง
- เผยแพร่เมื่อ 19 พ.ค. 2024
- In this series we will be walking through the basics of Microsoft Power BI. In this video we will be walking through how to use the Power Query Editor in Power BI.
Download Microsoft Power BI: powerbi.microsoft.com/en-us/d...
Download Apocalypse Dataset: github.com/AlexTheAnalyst/Pow...
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.io/5bBd62
📖Data Analysis with Python - coursera.pxf.io/BXY3Wy
📖IBM Data Analysis Specialization - coursera.pxf.io/AoYOdR
📖Tableau Data Visualization - coursera.pxf.io/MXYqaN
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/stores/alex-the...
____________________________________________
Websites:
💻Website: AlexTheAnalyst.com
💾GitHub: github.com/AlexTheAnalyst
📱Instagram: @Alex_The_Analyst
____________________________________________
0:00 Intro
0:29 Looking at the Data
1:45 Load data into Power Query
2:32 Power Query UI
5:26 Removing Rows
6:17 Changing the Headers
6:49 Changing Data Types
8:00 Removing Rows with "x" Value
8:58 Removing Columns
9:25 Pivoting/Unpivoting
12:15 Saving Transformation
12:44 Outro
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
Great video, thanks. You did misspell apocalypse but it's not the end of the world.
I see what you did there 😅
Underrated comment
😂😂
😄
Bravo, sir.
Power Query is such a game changer for Power Bi (and Excel)... once you realize the "power" in bringing in data with this tool you'll never look back (For reference, I used to copy and paste excel files into a single excel file... 🤦🏼♂ lolz)
Thanks for sharing this, Alex!
Any chance for the two of you doing a colab? Alex and Luke.
Aaah, this brings back memories of the good old days when I discovered the power of Power BI and Power Query. Even though I've been using them for the past 2 years, I found this content thoroughly enjoyable. Thanks Alex!
I took a Power BI certification course a few months ago. It was super dry and brain numbing. But now that I'm following along your Power BI series I can really see the value and fun in using this tool. As always, THANK YOU ALEX!!
I've been learning the basics of power query and power BI. It was great to follow this along and understand it to the level I'm at, imbedding my learning 😊
Hi Alex,
Could you please make a video explaining real-life projects that you perform at work? I would like to have rough idea what projects are carried out in the healthcare industry.
This is one of the things Power BI Desktop beats Tableau Desktop at, the embedded ETL tool Power Query. Sure there is Tableau Prep for data cleaning, but I believe it is a separate tool. Nice video Alex!
Thank you Alex for starting Power BI series. Eagerly waiting for your videos. Tableau series was very helpful, keep up the good work.
I love this, these tools especially Tableau and Power bi, are reminding me of using Excel, though advanced of course but its awesome because it takes alot of fear out of learning something new for me lol Thank you Alex!!
You should create a video specifically about portfolio projects. What type of projects you should do how to find data for them.
Feel like you talk about portfolio projects a ton within other videos but should make 1 just dedicated to that
I used to work with Tableau as BI Analyst but kinda curious about how Power BI differents with Tableau, makes me excited!
Thank you for your great teaching . the way you teach is really understandable. you are a perfect teacher.
You are very good! Thank you, a great refresher video!. Learning big time. Thanks Alex.
Great video! Good examples, it is very clear explanation
Love the video, waiting for the rest! thank you
Than you Alex! It is really helpful and I am looking forward to see you in next video !
Another great video, Alex!! THANKS!!!
Tip for everyone. You can remove a column by right-clicking the column and selecting remove column.
Waiting for this... Thank you so much Alex
Learning big time. Thanks Alex
Thanks for sharing your knowledge and effort.
Been waiting for this ✨ Thank you
Thank you so much for sharing this powerful information.
You are very good! Thank you, a great refresher video!
Great video! Thanks Alex!
Great tutorial, cheers buddy 👌
Hi Alex,
You create great helpful content!
I need your suggestion on the following situation.
I maintain an excel of my client's campaign performance on google ads. I wanted to make a dashboard and automate it so that the dashboard keeps updating on a daily basis.
Can you please suggest how to go about it?
Want to use Tableau.
You’re really good! Thanks a lot!
Alex, thank you so much for the video. But what did you do about the error in the attribute column?
thank you so much
Thanks Alex but how do we treat the null values in the product_cost column? Are we going to remove it or just leave it there?.
Thanks again Alex 😊💯
Amazing as usual.👌👏
Hello Alex. Sorry to ask questions outside the video content.
I have two questions regarding Google Data Analytics:
1. The capstone course requires external data to use, or they provide data to work on it? I am asking this since I cannot access company data and its highly confidential too.
2. The public version of tablue is suffient to use it for the course?
Thanks in advance!
Thanks for this.
Hey Alex! Big fan of your work, you've helped me tremendously in my career the past 6 months. Wanted to help you out and mention that you mispelled "Apocalypse" btw. There's an 'A' in the middle and not an 'O'.
Thanks for what you do man! 😊
You're probably 100% correct - I am not good at spelling and this has been shown time and time again on my channel lmao I will never learn
The video is great like all others that you make. There are store-wise totals in the table in the final product. How would we manage those if it was a real-world scenario?
Hey, I appreciate you and the work you contribute freely to the world.
Also your audio sounds a little funky, like it's compressed or a noise reduction thing is mucking it up just a bit. Not huge, just thought I'd point it out.
Hey Alex, do you think you can make a video doing a project with Power Bi? Thanks!
Thank you !!
Hi Alex, thank you so much for the video, just got one question, if I have like 9 different excel table sheets, how can I generate a power query then and to export into the power BI?
The other columns are not in the downloaded excel
Алекс видео супер. Учусь по ним.
Hi Thanks, I'm just entering the BI world (after many years of excel/vba) what happens if you get that data every month, you have to do this every month? or the query editor will apply steps when you change the data source? and will it error if something becomes not compatible e.g. someone moves a column or changes datatype in the excel template
Hi Alex, thank u for the very useful tutorial. but i have a question. in this video, the first dataset doesn't have "month" on the first sheet, how does it appear on pivot table? is there a way to do it? thank u
Amazing!
Quality content
Thank You Alex! May God Bless you in Jesus Name!
Viewers will find your steps EASIER if you CHANGE the SIZE and COLOR of your CURSOR.
YELLOW is very easy to see on the screen. A little LARGER would also be great.
I struggling with Power BI. I think Excel is so ingrained in me. Also, I am old and way past my prime.
Can you explain why using fixed decimal number instead of decimal in your video. I don't understand the difference between them. Thank you.
Hello Alex! I have a question when it comes to having "null" in the date column, How can I replace it to be blank? Looking forward to your comment.
Super helpful video.
But.... I find the mouse pointer you use hard to find when I'm trying to follow along -- small, white on white with gray outline is hard to see. Maybe you could change the settings -- enlarge it, invert colors, or use yellow highlighted pointer. Just an idea. Thanks!
@alex the analyst when I import the excel data to PowerBI, the comma changes to dot and vice versa, i.e. to my regional settings(Germany) any help here
Thanks Alex, one question; I have a dataset and created a dashboard from that dataset, but there was a need to add some columns and rename a few columns in the excel sheet (dataset), when i press the refresh button; the message says there is an error because of adding columns and not matching the names! is there anyone to guide me through how to deal with this issue? thanks.
Add the columns in the excel sheet itself.
Can I get link to download this Data, so that I can practice it to arrange it.
Done
How to add a column to data (Excel) and refesh data on Power BI but no change in visual or non-error
i am not able to download the file . Please Advice
How was the table created in the “purchase overview” tab in the excel worksheet?
It was like that from the get go, check the link to the file in the description.
I have the same question like how was it made?
I can't fine this new file that you use it in this video. could you please help me?
Hello,where can I find the excel file that you are working on it in the video?
Under the video it says when the video was uploaded you will see more click on that and there is a link to download the excel file...hope this works for you.
I am unable to see the various sheets in the file shown in this video not sure why
Can we get access to the data you are using ?
It's in the description
alex please there are 4 videos are hidden in this playlist
the file doesn't contain 3 sheets, only one !! :(
7 unavailable videos , Please check it Alex
Those are queued up to be released in future weeks
@@AlexTheAnalyst Please I can't wait. #1 fan. any time range.