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!
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!
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'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!!
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?
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.
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
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! 😊
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 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, 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.
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.
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!
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
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.
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!
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.
@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
Hello, I am having a problem. I cannot do the Count Disctinct value for DATA TYPE "TEXT" inside the Transformation Data model. The option for statistics is not accessible for TEXT type data. Available only for Whole number, currency and number. Any solution? Because of the tutorial Im watching, they are not telling me about the solution. Themks!
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?
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 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!
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!
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'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 😊
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 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!!
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?
I used to work with Tableau as BI Analyst but kinda curious about how Power BI differents with Tableau, makes me excited!
Tip for everyone. You can remove a column by right-clicking the column and selecting remove column.
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.
very good quality content, thank you
Thank you so much alex.. You are a gem ✌️
The reason you are Alex the Analyst. Thank you
Great tool!!! Thank you very much!!! An easy and simple way to start learning about this amazing tool.
Another great video, Alex!! THANKS!!!
Learning big time. Thanks Alex
Been waiting for this ✨ Thank you
Than you Alex! It is really helpful and I am looking forward to see you in next video !
Really though Power Bi was complex but its not. Great vids!
Good tutorial.
It would be nice to have higher resolution.
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
Love the video, waiting for the rest! thank you
Thank you so much for sharing this powerful information.
Amazing as usual.👌👏
Great tutorial, cheers buddy 👌
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
Thanks for sharing your knowledge and effort.
Waiting for this... Thank you so much Alex
You are very good! Thank you, a great refresher video!. Learning big time. Thanks Alex.
very helpful thank you
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?
You’re really good! Thanks a lot!
Great video! Thanks Alex!
Great video. Thanks
Thanks again Alex 😊💯
Алекс видео супер. Учусь по ним.
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
Thank You Alex! May God Bless you in Jesus Name!
You are very good! Thank you, a great refresher video!
Hey Alex, do you think you can make a video doing a project with Power Bi? Thanks!
Amazing!
The other columns are not in the downloaded excel
Alex, thank you so much for the video. But what did you do about the error in the attribute column?
thank you so much
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,
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.
Excellent.
Quality content
Thanks for this.
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.
Great!
Thank you !!
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!
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
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,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.
Hello Alex, I have one question. How did you get Purchase Overview table? Tnx!
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
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?
Can you explain why using fixed decimal number instead of decimal in your video. I don't understand the difference between them. Thank you.
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?
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!
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.
@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
I am unable to see the various sheets in the file shown in this video not sure why
Hello, I am having a problem. I cannot do the Count Disctinct value for DATA TYPE "TEXT" inside the Transformation Data model. The option for statistics is not accessible for TEXT type data. Available only for Whole number, currency and number. Any solution? Because of the tutorial Im watching, they are not telling me about the solution. Themks!
I can't fine this new file that you use it in this video. could you please help me?
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?
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.
Can we get access to the data you are using ?
It's in the description
Where’s the document to download
alex please there are 4 videos are hidden in this playlist
the file doesn't contain 3 sheets, only one !! :(
i am not able to download the file . Please Advice
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.
Done
Is apocalypse really all you can think of? Seriously?