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!
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!!
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!
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.
I like your approach, you take a messy table an show us step by step how to deal with it! Thanks a lot! I did Power BI course a few months ago but haven't been using it at all, so this was a great refresher for me.
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!
For anyone who is confused why the end result is better and how to know that: your end goal should always be to have one column per variable (product, supermarket, date, price) and one row per observation. This is a good practice in Power BI, Python, R etc. Why? Because normally any data can be stored like this, it's universal and simple.
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 😊
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!!
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 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
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?
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.
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?
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.
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
Nice video. Can these data transformation steps be reproduced as you might with a record a macro in excel, or do you need to do them manually each time?
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
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!
Only for me Power BI seems so tedious compared to Tableau? Alex could you do the material explaining exactly what are the scenarios in real life that would make you use one over the other?
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!
Good Job sir. Sir, the data set you used in this video is not among the data set. Please how am i going to get this data set you used in this video Thank You
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.
@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
why my powerbi does not recognize the row and columns as it should be ? mine says COLUMN1 instead of sum of rice. how can i fix it so it can be imported correctly?
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.
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.
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.
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!!
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!
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.
I like your approach, you take a messy table an show us step by step how to deal with it! Thanks a lot! I did Power BI course a few months ago but haven't been using it at all, so this was a great refresher for me.
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!
For anyone who is confused why the end result is better and how to know that: your end goal should always be to have one column per variable (product, supermarket, date, price) and one row per observation. This is a good practice in Power BI, Python, R etc. Why? Because normally any data can be stored like this, it's universal and simple.
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 😊
Tip for everyone. You can remove a column by right-clicking the column and selecting remove column.
Thank you Alex for starting Power BI series. Eagerly waiting for your videos. Tableau series was very helpful, keep up the good work.
i just started the bootcamp and i'm enjoying every bit of it thank you so much alex
Thank you for your great teaching . the way you teach is really understandable. you are a perfect teacher.
I used to work with Tableau as BI Analyst but kinda curious about how Power BI differents with Tableau, makes me excited!
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!!
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
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
Great tool!!! Thank you very much!!! An easy and simple way to start learning about this amazing tool.
The reason you are Alex the Analyst. Thank you
Than you Alex! It is really helpful and I am looking forward to see you in next video !
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?
Another great video, Alex!! THANKS!!!
Thank You Alex! May God Bless you in Jesus Name!
You are very good! Thank you, a great refresher video!. Learning big time. Thanks Alex.
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.
Been waiting for this ✨ Thank you
Really though Power Bi was complex but its not. Great vids!
Love the video, waiting for the rest! thank you
Learning big time. Thanks Alex
Good tutorial.
It would be nice to have higher resolution.
Thank you so much for sharing this powerful information.
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?.
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?
Waiting for this... Thank you so much Alex
Thanks for sharing your knowledge and effort.
Great tutorial, cheers buddy 👌
Hey Alex, do you think you can make a video doing a project with Power Bi? Thanks!
Alex, thank you so much for the video. But what did you do about the error in the attribute column?
You’re really good! Thanks a lot!
You are very good! Thank you, a great refresher video!
Great video! Thanks Alex!
Amazing as usual.👌👏
Алекс видео супер. Учусь по ним.
very helpful thank you
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.
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
Nice video. Can these data transformation steps be reproduced as you might with a record a macro in excel, or do you need to do them manually each time?
Great video. Thanks
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
Thanks again Alex 😊💯
The other columns are not in the downloaded excel
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.
Hello Alex, I have one question. How did you get Purchase Overview table? Tnx!
Amazing!
Excellent.
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!
thank you so much
Thanks for this.
Only for me Power BI seems so tedious compared to Tableau? Alex could you do the material explaining exactly what are the scenarios in real life that would make you use one over the other?
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!
Good Job sir. Sir, the data set you used in this video is not among the data set. Please how am i going to get this data set you used in this video
Thank You
Thank you !!
Quality content
Can you explain why using fixed decimal number instead of decimal in your video. I don't understand the difference between them. Thank you.
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.
Great!
@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
How to add a column to data (Excel) and refesh data on Power BI but no change in visual or non-error
Can I get link to download this Data, so that I can practice it to arrange it.
why my powerbi does not recognize the row and columns as it should be ? mine says COLUMN1 instead of sum of rice. how can i fix it so it can be imported correctly?
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?
On the second video, how did you come up with the pivot table, it was not there from the Excel sheet, the excel was just row data.
Its okay, I found it, Thank Alex.
@@shedrachkambai5787 how did u find it, having the same issue!
@harzenly if you download the datasets, Alex already separated it already, check the datasets we are to download
Where’s the document to download
I can't fine this new file that you use it in this video. could you please help me?
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.
I am unable to see the various sheets in the file shown in this video not sure why
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.
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
i am not able to download the file . Please Advice
Done
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.