I have worked as an Incident handler and level 1 IT operations. Now retired. I had a brief look at Power BI in 2018 and started learning POWER BI. Then the retirement came and I ditched it. After seeing your tutorials and the way you explain and teach, you have rekindled the desire to learn for learning sake and for the pure pleasure of learning. I cannot thank you enough for your modest way of teaching and absolutely very potent and useful content. Thank you very much. Keep up the good work and may you reach your goal of helping others.
The more I learn the more I understand your videos....watching repeatedly....thanks for teaching power bi while I travel from Delhi to noida...home to office...great person!!!!! Love you....
Wow.. This is the best tutorial I have ever came across. Big thank you. Keep up the good work. Liked it... Subscribed it and will recommend to anyone who wants to learn PowerBI.
Greetings Mr.Chandoo. I am an awesome learner from your videos. Thank You So Much for your efforts to impart the subject impactful. Can you please let me know how you are able to get the 3 indicators (Valid, Error and Empty) under each column while you are transforming the Medals Data?
Hi sir.. just came across your channel on power bi today, it is so helpful for the people like us who wants to start a career in power bi. But, a small request could you please number the video's in the form of series like 1,2,3.. so that it would be helpful for a beginner to follow a series to understand the tool better .. Thank you.
Hi Anusha... thanks for your lovely comments. It is not possible to number videos like that. I do not make them in any order. If you want a structured learning path, please join my course - chandoo.org/wp/power-bi-course/
We can calculate Gold% in Power Query also before loading data to power pivot, then why we should use DAX to do it? What is the advantage of using DAX to do calculations over PQ? Please explain.
While Gold % is not the best example of what Power Pivot can do, the measure is flexible and optimal. We can see Gold % for a country, continent or any other grouping with the measure. Power Query column wouldn't let you do that.
Ultimately tutorial video on what is the POWER BI at all. Even I tried to fine tune data in Excel and then I bring it in PBI visual layer. I am comfortable with PQ but Power pivot something still out of my access so for calculations I depends upon excel.
Thanks Nirmal.. Power Pivot is tricky but not impossible to learn. Feel free to watch the live stream I did on Power Pivot - czcams.com/video/eCuPRqQNe6Y/video.html
Wow!!! Had to stop the video and make a comment about the presenter. Great job. Awesome job. Great explanation. Incredible! Just subscribed and smashed the like button. Hands down the best!!
I am a mos excel Associate certified. I am in dilemma whether i should go for mos excel expert or power BI now? Could you pls give your suggestions in this regard?
Hi Chandoo. I like your every videos and material. Recently I was looking to do survey analysis using Power BI. Mean I am looking a way to do analyse survey data in Power BI than R or SPSS etc. My main focus is looking for multiple type questions, questions using Likert Scale and Yes/No type questions combined in a Survey Design. I could not find suitable material which I was looking for. I also never did survey analysis in Power BI however I did in my MS using R but I now I am shifting to PBI as it save my time at work rather than shifting multiple analysis packages. Hope you could bring something to suggest me🙏🏻.
Failed to save modifications to the server. Error returned: 'The following system error occurred: Class not registered '. I found this problem after saving the name as Medals and clicking close and apply. plz help me
Really enjoy your videos and find them very accessible! I was wondering why on this example you would choose to fill down to get rid of the nulls, if this fills it with the information from the row above, than this gives an incorrect country name to that row and makes the data skew in favour of that country no? Or was this just used an example of something you *can* do?
Sir I was completed b.tech IT in the year 2011 but no any experience in software field and long career gap aspirants....could I learn powerBI course and choose my dream career in this platform.....???
Hello sir for learning power bi or good it's necessary the sql power pivot power query ? How muxh excel level required means what we need main formula and function please describe sir
Thanks Chris. For one, I wanted to demonstrate the features of Power Pivot too. But also, the measure is flexible and optimal. We can see Gold % for a country, continent or any other grouping with the measure. Power Query column wouldn't let you do that.
Hey sir already talk to u and asked for a lot. And thnk u that u always make time to reply. So i hv joined Google data analyst course 1 month back. I don't hv technical background so i stuck lots of time. Can u recommend some online excel course from core to advance with certification. I want to join ur course but sorry i don't hv that much money currentlymy financialsituationis tight. But got a lot of help from ur excel videos. So help if u hv any recommendations.
As suggested by others, there are many courses on CZcams for free. So go ahead and explore them. Please note that if you want to learn you must allocate time, practice and be willing to get extra resources (either paying for courses / books / or asking friends / colleagues to help you). All the best.
Sir can a 45 years old person also get a job after learning Power bi. No experience no IT Background jobless. Age barrier your teaching is interesting.please suggest thanks
I agree but (respectfully) disagree with some of the main points in this video. 1. DAX is part of the ETL portion (referred to as "Power Query" in this video). In fact, you can see the DAX expressions for each step at the top of the screen. 2. It might be confusing to some to refer to the aggregation and other calculations on the data after the ETL portion as "Power Pivot" as this tool in Excel is used to create pivot tables and not just new measures. (Even further "Power Pivot / Chart" in Excel allows users to create pivot tables and visualizations as part of the same process.) Perhaps a different way of looking at the Power BI segments is ETL > Data Model Tables > Visualization. Though, of course, they're not exclusive to Power BI. (I've even created similar dashboards on the Tokyo Olympics and Paralympics sourced from Wikipedia pages in Excel but could copy the DAX queries from Excel into PBI.)
Unfortunately, you are wrong on both. 1. The language in Power Query is M and not DAX. Please check Microsoft Power Query documentation here - docs.microsoft.com/en-us/power-query/ 2. There is no confusion. Aggregation is another word for calculation or measure. You can make such measures in Excel or Power BI too. No matter where you do it, they are handled and calculated by the Power Pivot engine. While I agree with your conclusion " a different way of looking at the Power BI segments is ETL > Data Model Tables > Visualization", the arguments are not correct.
@@chandoo_ Thank you for your response. I guess we can "[disagree] to [agree]". LOL I do appreciate that you at least acknowledge my suggestion of Power BI segments as "ETL > Data Model Tables > Visualization". And I acknowledge that at least *I'M* confused by the distinctions in exactly what's being referred to between M language, "Power Query", DAX language, and "Power Pivot [/ Chart]" particularly when discussing Power BI versus being able to do identical work in Excel.
I recommend reading more on Power Query language and DAX (Power Pivot) language for knowing the distinction. They can be confusing and the lines are blurry in many areas.
Best PowerBI teacher! Thank you for the great content!
Wow, thanks!
I have worked as an Incident handler and level 1 IT operations. Now retired. I had a brief look at Power BI in 2018 and started learning POWER BI. Then the retirement came and I ditched it. After seeing your tutorials and the way you explain and teach, you have rekindled the desire to learn for learning sake and for the pure pleasure of learning. I cannot thank you enough for your modest way of teaching and absolutely very potent and useful content. Thank you very much. Keep up the good work and may you reach your goal of helping others.
Discovering this channel, wrapped up the year for me on a positive notes. Thank you for your simplified teaching.
Best teacher\presenter ever! Thank you, Sir!
Wow, thanks!
Undoubtedly....❤❤
I would follow you on your website when it came to Excel and now I’ve discovered your CZcams! Excellent teacher!
Thank you Chandoo for a clear explanation of Power BI as a system! Appreciated! 😊👍
You are welcome Vijay...
@@chandoo_
Thank you Sir
I love this man, he's explaining in just the way I wanted, thanks man
The more I learn the more I understand your videos....watching repeatedly....thanks for teaching power bi while I travel from Delhi to noida...home to office...great person!!!!! Love you....
In a fairly short video you covered and explained the 3 components very well. Thank you for your succinct yet clear explanation :)
Grateful, I started learning PBI from you (the right way) This will make a lot of difference in my learning experience.
Thank you, Chandoo!!
clear explanation! i have been looking for this kind of video for a long time. no one give a clearer and easier to understand than you!
Thank you Sir for all the knowledge you share with us! You have great teaching skills.. not everyone explains this way.. very easy to understand.
I have been using Power BI for years, but this is the best systematic approach in explaining Power BI structure.
That means a lot Adis. Thank you :)
@@chandoo_ you are more than welcome. I subscribed to your channel.
As a newbie, best and clearest explanation i have heard so far.
Glad it was helpful!
You are really a great personality, being an Indian I am proud of you, great learning, thank a lot, let god bless you, regards
Thanks Srini for your lovely words and appreciation of my work :)
Thanks @chandoo I'm new to a power bi and I watch a lot of your videos but I wish all your videos were like this one
This should be the first video everyone watches before learning power bi.
Wow.. This is the best tutorial I have ever came across. Big thank you. Keep up the good work. Liked it... Subscribed it and will recommend to anyone who wants to learn PowerBI.
Greetings Mr.Chandoo. I am an awesome learner from your videos. Thank You So Much for your efforts to impart the subject impactful. Can you please let me know how you are able to get the 3 indicators (Valid, Error and Empty) under each column while you are transforming the Medals Data?
How to study power BI theoritically ? How to remember concepts?
Best explanation. i think a 2nd standard kid can understand it. Thanks a lot for so so easy explanation. Great job
hello Chandoo, hope you are well. Thanks for taking the time to share and explain simply the layers of Power BI
My pleasure!
Wow!
The way of explanation about the concept was really really great.
Thank you sir.
Hi sir.. just came across your channel on power bi today, it is so helpful for the people like us who wants to start a career in power bi. But, a small request could you please number the video's in the form of series like 1,2,3.. so that it would be helpful for a beginner to follow a series to understand the tool better .. Thank you.
Hi Anusha... thanks for your lovely comments. It is not possible to number videos like that. I do not make them in any order. If you want a structured learning path, please join my course - chandoo.org/wp/power-bi-course/
Awesome Chandoo!! Very clear and well explained. Thanks also for stepping through an example.. very helpful :)) Thumbs up!!
You are welcome Wayne...
Thank you very much. A great resource for a self learner like me ! Best luck .. keep it up!
@Chandoo sir loved the video, would request you to make more such videos on Power BI with end to end examples. Thank you
Thank you for short and clearly explanation about those things, power query..power pivot.. and power bi
Glad it was helpful!
i just started learning power bi and thank you.....
Sir, you are an awesome teacher...thanks for these quality content available for free..
We can calculate Gold% in Power Query also before loading data to power pivot, then why we should use DAX to do it? What is the advantage of using DAX to do calculations over PQ? Please explain.
While Gold % is not the best example of what Power Pivot can do, the measure is flexible and optimal. We can see Gold % for a country, continent or any other grouping with the measure. Power Query column wouldn't let you do that.
First time I watched a video without any distractions.
Wow.. thanks for the compliment :)
Chandoo the legend dropping free knowledge for us noobs. Thanks my brother.
Most insightful explanation. thanks Chandoo
My pleasure
Chandoo ... How much the course fee..? Plz let me know I will see you on your master class..
Just one word…THE BEST TEACHER 👏👏
Thank you Mounika... 😀
What is the minimum system requirement to install POWER BI. Currently I have laptop with i3 and 7th generation processor.
Ultimately tutorial video on what is the POWER BI at all. Even I tried to fine tune data in Excel and then I bring it in PBI visual layer. I am comfortable with PQ but Power pivot something still out of my access so for calculations I depends upon excel.
Thanks Nirmal.. Power Pivot is tricky but not impossible to learn. Feel free to watch the live stream I did on Power Pivot - czcams.com/video/eCuPRqQNe6Y/video.html
best teacher
india
Great job as usual! Well presented and easy to understand. Very useful
Wow!!! Had to stop the video and make a comment about the presenter. Great job. Awesome job. Great explanation. Incredible! Just subscribed and smashed the like button. Hands down the best!!
Thanks Tyson 😍
Very nicely explained and presented for understanding thank you sir
Hi sir,
I need help in Power BI .
Can you pls tell me how to create and show difference in graphs as per the table imported form web?
I am a mos excel Associate certified. I am in dilemma whether i should go for mos excel expert or power BI now? Could you pls give your suggestions in this regard?
Very clearly and in simple way explained . Thank you
I am very gratefull to find this video.thankyou so muchh
Hey chandoo, Why you and your excel and Power BI are so cool? God bless man.
Wish from Bangladesh :)
Thank you so much 😀
Thank you for the clear and simple explanation 😊
You’re welcome 😊
I APPLIED THE SUM POWER POVIT BUT IT IS SHOWING ERROR BECAUSE IT IS NOT RECOGNIZING THE MEDALS NAME
Hi Chandoo. I like your every videos and material.
Recently I was looking to do survey analysis using Power BI. Mean I am looking a way to do analyse survey data in Power BI than R or SPSS etc. My main focus is looking for multiple type questions, questions using Likert Scale and Yes/No type questions combined in a Survey Design.
I could not find suitable material which I was looking for.
I also never did survey analysis in Power BI however I did in my MS using R but I now I am shifting to PBI as it save my time at work rather than shifting multiple analysis packages.
Hope you could bring something to suggest me🙏🏻.
Please, where can I find your Pandas Python Library, that is showed on yours short cuts.
Thanks.😅
Well explained..in simple manner from start to end.. Really Appreciate 👍🏻👍🏻👍🏻
Failed to save modifications to the server. Error returned: 'The following system error occurred: Class not registered '.
I found this problem after saving the name as Medals and clicking close and apply. plz help me
Really enjoy your videos and find them very accessible!
I was wondering why on this example you would choose to fill down to get rid of the nulls, if this fills it with the information from the row above, than this gives an incorrect country name to that row and makes the data skew in favour of that country no?
Or was this just used an example of something you *can* do?
Hii sir can you suggest me how many hours we have to practice for power bi
Thanks for this wonderful video.....I'm very happy to see such a great video of power bi.
Most welcome
Informative video...Thank you from India
Glad it was helpful!
Best tutorial/explanation I have found
Wow, thanks!
You are the best teacher Chandoo, keep it up bro!!
Thanks Lamborghini...
Thank you Chandro. Why cant u run a webinar ?
Thank you for the great content. Best ever explaining.Thanks a lot
Sir I was completed b.tech IT in the year 2011 but no any experience in software field and long career gap aspirants....could I learn powerBI course and choose my dream career in this platform.....???
Great video!! Very clear and succinct. Thanks a lot.
Hello sir for learning power bi or good it's necessary the sql power pivot power query ? How muxh excel level required means what we need main formula and function please describe sir
Dax
It's a crystal clear presentation..
Chandoo you are PRO
Good learning Bro, Thanks for the video..
Thanks for very good teaching.
Another great one. Why would you not do the calculation in a column inside Power Query?
Thanks Chris. For one, I wanted to demonstrate the features of Power Pivot too. But also, the measure is flexible and optimal. We can see Gold % for a country, continent or any other grouping with the measure. Power Query column wouldn't let you do that.
Very Well explained chandoo,please keep posting videos,thank you so much
So nice of you. I am adding new videos every week. :)
Can you tell me if we can do Power BI Adhoc Analytics
Great explanation sir
Bro, Thanks for your valuable time and effort for us. Keep rocking it
Very nicely explanation sir
Pls upload more videos for Power BI Or upload an course on Udemy for this
Wow thanks for your explanation to let me know concept of Power BI
Hiii
Do you know any websites to practice DAX
Like Hacker rank for SQL
Another amazing class, thank you Chandoo
this is the exact thing which i want. TQ
Hi sir can you tell how to export huge data from power Bi on scheduling to SharePoint in excel format.
Thank you. This video was very helpful to me.
That was quick and fast very well explained with excellent visuals 👍
Glad you liked it!
Quite helpul video! Thank you for this!
Hey sir already talk to u and asked for a lot. And thnk u that u always make time to reply. So i hv joined Google data analyst course 1 month back. I don't hv technical background so i stuck lots of time. Can u recommend some online excel course from core to advance with certification. I want to join ur course but sorry i don't hv that much money currentlymy financialsituationis tight. But got a lot of help from ur excel videos. So help if u hv any recommendations.
Look through the playlists on the Excelisfun CZcams channel.
@@JVarghese81 thnk u 😊😇
Check udemy courses of Leila gharani.. she has great set of courses for excel.
As suggested by others, there are many courses on CZcams for free. So go ahead and explore them. Please note that if you want to learn you must allocate time, practice and be willing to get extra resources (either paying for courses / books / or asking friends / colleagues to help you). All the best.
Sir can a 45 years old person also get a job after learning Power bi. No experience no IT Background jobless. Age barrier your teaching is interesting.please suggest thanks
Thanks a lot ! Very Informative for beginners like me !
Glad it was helpful!
Thank U Chandoo ❤Muwahh ❤
I agree but (respectfully) disagree with some of the main points in this video.
1. DAX is part of the ETL portion (referred to as "Power Query" in this video). In fact, you can see the DAX expressions for each step at the top of the screen.
2. It might be confusing to some to refer to the aggregation and other calculations on the data after the ETL portion as "Power Pivot" as this tool in Excel is used to create pivot tables and not just new measures. (Even further "Power Pivot / Chart" in Excel allows users to create pivot tables and visualizations as part of the same process.)
Perhaps a different way of looking at the Power BI segments is ETL > Data Model Tables > Visualization. Though, of course, they're not exclusive to Power BI. (I've even created similar dashboards on the Tokyo Olympics and Paralympics sourced from Wikipedia pages in Excel but could copy the DAX queries from Excel into PBI.)
Unfortunately, you are wrong on both.
1. The language in Power Query is M and not DAX. Please check Microsoft Power Query documentation here - docs.microsoft.com/en-us/power-query/
2. There is no confusion. Aggregation is another word for calculation or measure. You can make such measures in Excel or Power BI too. No matter where you do it, they are handled and calculated by the Power Pivot engine.
While I agree with your conclusion " a different way of looking at the Power BI segments is ETL > Data Model Tables > Visualization", the arguments are not correct.
@@chandoo_ Thank you for your response. I guess we can "[disagree] to [agree]". LOL
I do appreciate that you at least acknowledge my suggestion of Power BI segments as "ETL > Data Model Tables > Visualization".
And I acknowledge that at least *I'M* confused by the distinctions in exactly what's being referred to between M language, "Power Query", DAX language, and "Power Pivot [/ Chart]" particularly when discussing Power BI versus being able to do identical work in Excel.
I recommend reading more on Power Query language and DAX (Power Pivot) language for knowing the distinction. They can be confusing and the lines are blurry in many areas.
So wonderfully broken down ,, love it 😍
Please will you need a programming skill as a power bi expert and is power bi the same with Tableau?
Thanku sir for this best video
i love u sir for your explanation❤
Thanks Chandoo
Power Query
Power pivot
Power visual
Data..... p.Query
Thank you so much for this video
Superb sir. Thank you very much
You are welcome Mohammed.
Thank you for this clear demo
Grt teaching bro. Very usefull
Thanks and welcome
Just subscribed today and I am already a fan.. great content 👍
Welcome aboard. :)
High level information and easy to understand ..
Thank you.
great teacher indeed!