Thank you Chris for the wonderful compliment. I am grateful, to be able to teach what I know and to learn from all of you guys. ⚡Power On!⚡ / Avi ★ Subscribe and Join me LIVE for Talk Power BI Fridays ruclips.net/user/PowerBIProlive ★
Thank you so much. This tutorial is awesome. The delivery, voice, content, props, pace are just perfect. I gave a try to other PowerBI tutorials, but couldn't watch them more than 10-15 min.
So nice of you. Thank you for your feedback. If you'd like to learn more about Power BI , here is a link about our structured course on this Webinar 👉 web.learnpowerbi.com/waitlist-invite/ ^RM
I have over 30 years of experience in writing reports, and this is my first time with Power BI. What a terrific introduction. I've learnt more in 30 minutes than I have in 3 hours of trying to figure it out myself. I'm a subscriber now!
Hi. I'm a super beginner. I was an IT for more than 8 years, and then I joined the Content team, making magazines, books etc. Then I got retrenched after a year during the first pandemic lockdown. I heard about the Power BI and I want to master it before my upcoming interview sometime in December. Having a Power BI is one of the requirements. Hope this video helps me a lot, going through it right now and downloading the files. Thanks Avi.
This is absolutely an hour well spent. It leaves you feeling confident that you can work with Power BI even if you only know it by name. Well done, sir
I've been trying to learn tableau. This tutorial has taught me more in 1 hour than my college course in tableau ever did. I'm making the switch to PowerBI.
Glad this tutorial video helped you, Alan. Thanks for the positive feedback. ⚡Power On!⚡ / Avi ★ Subscribe and Join me LIVE for Talk Power BI Fridays ruclips.net/user/PowerBIProlive ★
Hi Pranay Sharma, I'm so glad to hear about your positive feedback. Means a lot to me! ⚡Power On!⚡ / Avi ★ Get Your Questions Answered LIVE on TalkPowerBI Fridays www.learnpowerbi.com/talk ★
Hi David Githinji, Wow! Thanks for the wonderful feedback! So glad that my Power BI tutorial has helped you. ⚡Power On!⚡ / Avi ★ Get Your Questions Answered LIVE on TalkPowerBI Fridays www.learnpowerbi.com/talk ★
Dear Avi, a million thanks for this mind-blowing introduction. I wish all teachers could be that effective. 1hour. Perfect Language. Perfect Tone... Above all, with the perfect tricks to keep our model leanest! Hats off! 5* You are simply the best teacher Avi!
Phenominal guide thank you. Anyone that already works with data, qlikview / tableau, etc will have a decent understanding of what they want to get out of a dashboard. This guide is so easy to follow and brilliantly communicated. Probably one of the most valuable hours I've ever spent in my life. Thank you !!
Thank you. Am glad you found this useful. if you have any questions you can get them answered in our LIVE TalkPowerBI Q&A show. 👉 www.TalkPowerBI.com Or Join our LearnPowerBI Private Community 👉 web.learnpowerbi.com/waitlist-invite/ ^RM
Amazing and comprehensive tutorial! My first experience with Power BI saw me jump right into the reports and visuals phase and soon hit road blocks because of no modeling and DAX experience. The full view of the workflow and importance of modeling is something I missed or didn’t pay much attention to trying to learn Power BI on my own. Thanks for the great content!
Hi Anas Farah, Thanks for the wonderful feedback! It's always a pleasure to be able to share my knowledge around Power BI to you guys. ⚡Power On!⚡ / Avi ★ Get Your Questions Answered LIVE on TalkPowerBI Fridays www.learnpowerbi.com/talkpowerbi ★
19:00 Unpivoting... That was, what I was looking for and why I never got PowerBI to work for me properly. Did not think, it was so easy to do that! Thank you so much!
Very well done, so easy to grasp the terms with your teaching style. I took a BI Bootcamp 6 years ago with Pragmatic works but really never used PBI on the job, so I forgot everything. I tried watching some of their tutorials to relearn it and they were sleepers. I was actually able to sit through this entire hour taking notes and working along side with you pain free! Thanks!
Hi Marcus, Thank you. Am glad you found this useful. if you have any questions you can get them answered in our LIVE TalkPowerBI Q&A show. 👉 www.TalkPowerBI.com Or Join our LearnPowerBI Private Community 👉 web.learnpowerbi.com/waitlist-invite/ ^RM
Excellent tutorial Avi. Today was my first day with Power BI and I already feel that I can build what I am looking for. Thanks a million :) Keep up the good work.
Thank you so much for your kind words, Priyanka. I really appreciate you taking the time out to share you very first step in your Power BI journey! ⚡Power On!⚡ / Avi ★ Subscribe and Join me LIVE for Talk Power BI Fridays ruclips.net/user/PowerBIProlive ★
Top class. I am new to Power BI. I work on Business Central in Dubai as a Functional Consultant and wanted to learn PBI. Your tutorial is amazing and the explanation is to the point. I will try all the steps and shall approach you with questions, if any. I would like to join your Friday live session or any other session which you conduct on Power BI. Thank you... :)
Thank you. Am glad you found this useful. if you have any questions you can get them answered in our LIVE TalkPowerBI Q&A show. 👉 www.TalkPowerBI.com Or Join our LearnPowerBI Private Community 👉 web.learnpowerbi.com/waitlist-invite/ ^RM
I will be honest. I felt so anxious to learn how to use PowerBI due to my PTSD caused by learning to code in Matlab during college. After watching this video, you've taken away that anxiety away and fueled me into actually wanting to use the tool. Thank you so much!
Hey Christian, I am glad you feel comfortable watching and learning from this content. If you have any questions you can get them answered in our LIVE TalkPowerBI Q&A show. 👉 www.TalkPowerBI.com Or Join our LearnPowerBI Private Community 👉 web.learnpowerbi.com/waitlist-invite/ ^RM
@@PowerBIPro Hi, I'm unable to download the files using the link given in the description box. It seems that the Download button isn't working. Could you take a look please. And Thank you for the amazing video. Being a beginner in PowerBi, I really loved it. Thanks in advance.
This is a video from a year ago, before MPower BI updated its features. I'm following up with the lecture, and I may spend longer figuring out the Power BI updated features. It's fantastic, and thank you.
Hi Avi! Thank you so very much for the detailed explanation. I am an aspiring data analyst, currently sharpening my skills in Power BI. Your video has been very helpful so far. Thanks again!
Your ability to communicate and transfer knowledge is amazing. This was so much value in an hour. Now, I'm going back to take it step by step with the files as advised. You're a keeper!
So, I had no clue what to do in Power BI. We just got the module at work and it didn't make any sense to me. After watching this tutorial, I literally am able to put together data and make charts and I've only watched half so far. Fantastic job of making this training appropriate for beginners!
totally awesome :) One thing that would be nice for you to share is how to combine unlimited Excel files into the data model through Power Query. For example, a customer has an Excel file for each month and they store these files in a single folder. They want to bring in all current and future added Excel files into Power BI's data model without editing the Power Query each time. I have seen how you can combine the Excel files and all future added files together into Power Query in Excel, so I am going to try to do the same and hope it works in Power BI.
Wow! Thanks for the compliment Shane! If you have more questions about Power BI, do join me every Friday at 9AM PST for my #TalkPowerBI Live event. ⚡Power On!⚡ / Avi ★ Subscribe and Join me LIVE for Talk Power BI Fridays ruclips.net/user/PowerBIProlive ★
Welcome and Thank you for the compliment Erwin.⚡Power On!⚡ / Avi ★ Subscribe and Join me LIVE for Talk Power BI Fridays ruclips.net/user/PowerBIProlive ★
If there’s anyone in here that can send me the downloadable files so I can follow along, I would greatly appreciate it. I filled out the little form to receive the files and follow along in the video but I haven’t gotten them yet.
This is my first time to comment in watching an introduction video. It felt so valuable that I've spent 1 hour on this tutorial and I learned a lot. Thanks for this wonderful video. Looking forward to more.
Would you love to learn more about Power bi? Did you know you can get your Power Bi questions answered in our LIVE TalkPowerBI Q&A show? 👉 www.TalkPowerBI.com Or Join our LearnPowerBI Private Community 👉 web.learnpowerbi.com/waitlist-invite/ ^RM
Thanks man for this, really is Beginner to Pro... This is all the background that one needs to explore on their own (with a point of reference). Thanks again.
Avi, I wish I found you earlier. Your subject matter understanding, communication skills and ability to transfer knowledge is stellar. I am coming from a Qlik background and needed to get primed on Power BI quickly. Your 1 hour tutorial did exactly that. Great work!
Are you trying to download by going to web.learnpowerbi.com/download/ and it's not working? It's supposed to send the download link in email. Make sure to check your Other/Promotions/Junk/Spam folders.
Great tutorial - I’ve seen some clips of Avi’s tips before and have used PBI for awhile now, but there were several modeling basics covered in this video that I’ll use to tighten up my praxis. For example, this is the first clear explanation I’ve seen of what’s inside PBI service, how ‘dataset’ = data model, which I can use to create different kinds of reports for users, all based on the same model. Also, AVI’s explanation of “row vs filter context” was the first one I’ve heard that didn’t leave me frustrated and more confused. I got the feeling that with more review and practice building measures and calculated columns, I’ll get it down quicker now.
Thank you for leaving a positive feedback on this video tutorial, LME. I appreciate it a lot. ⚡Power On!⚡ / Avi ★ Subscribe and Join me LIVE for Talk Power BI Fridays ruclips.net/user/PowerBIProlive ★
I am having the same problem. I have tried what Seantron Eich suggested but neither of these button even exist (they are not just greyed out as suggested by Seantron Eich). According to Microsoft (powerbi.microsoft.com/en-us/blog/updated-ribbon-experience-for-power-bi-desktop/) : "In the new ribbon, you may have noticed that the “Modeling” tab has fewer buttons. Now, if you want to modify the structure, properties, or apply formatting to tables, columns, and measures, these options will appear as contextual tabs when you select a field in the fields list." . But I tried clicking on the column but I don't see any such buttons anywhere. If anyone does figure this out, please let us know. Thank you.
Problem solved. I clicked on the 'Month' field under the "Fields" pane (the vertical pane on the right edge if the window). Then a "Column tools" tab appears in the top ribbon which contains the Format (for currency) and Sort by column (for sorting by MonthNum)
This is one of the best tutorial I had experienced in youtube .....Very well explained!! ..I learnt few valuable points which institutes haven't discussed...
I think I ran into the same problem. The version of Power BI in the tutorial is slightly different than mine, so a couple things have been a little off. Here's what I did: 1) Select the data view on the left 2) Select "Budget" in "Fields" on the right 3) Select the "Month" column 4) Select "Column Tools" on the ribbon. Select "Date" for "Data Type". Select the "Format" that you like. I chose "2001-03 (yyyy-mm)" Once I did that and returned to Report, the date appeared properly in the BudgetAmount graph. I hope this helps.
An alternative is to get back to the query editor. For the "Month" column you see the data type as Text. Change this to date and you're back in business. The advantage of this one is that all transformations are still visible in one place.
@@RoysIdea Hi I tried your method, but get the error message saying that it can't automatically convert the column to Data type. Do you know any insight about this? Thanks
Wow! As a total newbie to Power BI I found that a little overwhelming but it certainly sold me on the value and functionality and proved to me that I can use it to achieve what I need. I'm now going to go for a walk to let it all sink in, have a coffee, and go through it again slowly. Thanks Avi
So nice of you. Thank you for your feedback. If you'd like to learn more about Power BI , here is a link about our structured course on this Webinar 👉 web.learnpowerbi.com/waitlist-invite/ ^RM
Stuck❓ Need Help❓ If you get stuck anywhere in the Tutorial or when applying these principles using your own data, there are many ways you can get help: 【1】 Join one of our Upcoming LIVE Events: www.TalkPowerBI.com 【2】 Join our LIVE Zoom Calls to answer your Power BI Technical Questions. Learn More at web.learnpowerbi.com/powerbi-live-question-and-answer 【3】 Join our LearnPowerBI Program with and get help inside our Exclusive Private Community www.learnpowerbi.com/training 【4】 You can also post a question here in the comment --or-- Email us at avi@avising.com Just make sure to ask "Good" Questions (provide screenshots, sample files if possible). Read article below for help. How to Ask Good Power BI Questions❓ & Get Them Answered✔️ www.linkedin.com/pulse/how-ask-good-power-bi-questions-get-them-answered-singh-powerbipro- 【5】 If you need Consulting Help please contact us at www.learnpowerbi.com/consulting ⚡Power On!⚡ Avi / PowerBIPro Don't Just Learn Power BI, Become a Pro www.learnpowerbi.com/pro
Dude you rock !!! Awesome tutorial, I gotta tell you you have streamlined the session from back end to front end reporting wisely sharing enough time for the back end transformation/ Edit. Although would like to see some scheduling and automation of reporting... may be you have it on a diff link, if so please do share. To me seems like a hybrid MS Access with a built in visualization far more advanced (leaps and bounce). Also please share power BI edit on SQL tables.... would like to see the data type parsing from DB to ETL layout. Thank you once again for the great work.
This comment is totally honest review about the video so i have been trying to learn powerbi from very loong time but was unable to find a video where i can start to learn , i have also watched some other yt'ers vidoe about powerbi but there they only show us how to create a dashboard and not the fundamentals of powerbi , this is the video which left me surprised as its so detailed will refer every video of yours in future Thank You sir for this video , you earned a loyal subscriber for your videos Thnk YOU
Hey Kawa, Thank you for your feedback. If you would love to know more about our PowerBi training program you can book a quick call here: learnpowerbi.as.me/?appointmentType=30727100
Wow, I love that unpivot function. I literally had to create a VBA function from scratch to transpose columns into rows for Excel and Access to accomplish this at work. Now just click a button...amazing!
Wow wow wow. Never used PBI, but wanted to learn as I work in a financial field and wants to be up to date with tools, this course was just WOW. I’ve never been that focused for the whole entire hour. Thank youuu!!
Thank you, this was OUTSTANDING! I was just given the task to learn BI and take over what we have along with creating new datasets. This tutorial was very helpful in getting me started and now I am off to view your several linked videos. I have gladly subscribed and have all alerts on. I am looking forward to more of your knowledge and expertise. Thank you, Sir.
Thank you. If you have any questions you can get them answered in our LIVE TalkPowerBI Q&A show. 👉 www.TalkPowerBI.com Or Join our LearnPowerBI Private Community 👉 web.learnpowerbi.com/waitlist-invite/ ^RM
One of the best video so far on power BI. Your explanation is great and amazing. I watched other videos on this topic but your video is really great to learn power BI.
Content 100%
Video 100%
Teaching skills 200%
You are the best .Thank you for the content.
I like the energy and passion
Hey do you know where can i download the practice files. The link provided in the description doesn't work anymore.
You have 2 strengths: enthusiasm and communication. Phenomenal teacher and a good lesson for beginners.
Thank you Chris for the wonderful compliment. I am grateful, to be able to teach what I know and to learn from all of you guys.
⚡Power On!⚡ / Avi
★ Subscribe and Join me LIVE for Talk Power BI Fridays ruclips.net/user/PowerBIProlive ★
I agree...I instantly subscribed and I'm learning soo much thanks @avi
Thank you so much. This tutorial is awesome. The delivery, voice, content, props, pace are just perfect. I gave a try to other PowerBI tutorials, but couldn't watch them more than 10-15 min.
So nice of you. Thank you for your feedback. If you'd like to learn more about Power BI , here is a link about our structured course on this Webinar
👉 web.learnpowerbi.com/waitlist-invite/
^RM
I have over 30 years of experience in writing reports, and this is my first time with Power BI. What a terrific introduction. I've learnt more in 30 minutes than I have in 3 hours of trying to figure it out myself. I'm a subscriber now!
Hi. I'm a super beginner. I was an IT for more than 8 years, and then I joined the Content team, making magazines, books etc. Then I got retrenched after a year during the first pandemic lockdown. I heard about the Power BI and I want to master it before my upcoming interview sometime in December. Having a Power BI is one of the requirements. Hope this video helps me a lot, going through it right now and downloading the files. Thanks Avi.
That is one of the enjoyable and simplest training ever. Thank you for making our journey easy
Thanks mate!
⚡Power On!⚡ / Avi
★ Subscribe and Join me LIVE for Talk Power BI Fridays ruclips.net/user/PowerBIProlive ★
Wow.....The best Power BI video I have seen by far. If your a beginner, this video is for you. I grade A+++++
Glad you enjoyed it!
This is absolutely an hour well spent. It leaves you feeling confident that you can work with Power BI even if you only know it by name. Well done, sir
Well said!
I've been trying to learn tableau. This tutorial has taught me more in 1 hour than my college course in tableau ever did. I'm making the switch to PowerBI.
Power on my friend.
And if you have any questions you can get them answered in our LIVE TalkPowerBI Q&A show.
👉 www.TalkPowerBI.com ^RM
I taught myself Excel reporting and MS Access. This is a game changer for me. Thank you very much!
This is exactly what I’ve been looking for. Clear, engaging and professional. Many thanks Avi!
Glad this tutorial video helped you, Alan. Thanks for the positive feedback.
⚡Power On!⚡ / Avi
★ Subscribe and Join me LIVE for Talk Power BI Fridays ruclips.net/user/PowerBIProlive ★
Ohhhh! You give great roadmap, understanding and strategy about Power BI. I'm so thankful to you for sharing the beautiful knowledge.
Thanks for the compliment, Leon!
⚡Power On!⚡ / Avi
★ Subscribe and Join me LIVE for Talk Power BI Fridays ruclips.net/user/PowerBIProlive ★
We need more Tutors like you!
Just outstanding learning experience ❤️
Hi Pranay Sharma,
I'm so glad to hear about your positive feedback. Means a lot to me!
⚡Power On!⚡ / Avi
★ Get Your Questions Answered LIVE on TalkPowerBI Fridays www.learnpowerbi.com/talk ★
Hello, I have tried all I could to download the files used in the video. Could you pls hep me?
Most informative and simplified Power BI tutorial on RUclips ! Simply the Greatest !
Hi David Githinji,
Wow! Thanks for the wonderful feedback! So glad that my Power BI tutorial has helped you.
⚡Power On!⚡ / Avi
★ Get Your Questions Answered LIVE on TalkPowerBI Fridays www.learnpowerbi.com/talk ★
Dear Avi, a million thanks for this mind-blowing introduction. I wish all teachers could be that effective. 1hour. Perfect Language. Perfect Tone... Above all, with the perfect tricks to keep our model leanest! Hats off! 5*
You are simply the best teacher Avi!
ruclips.net/user/shortske5tBxu6VR8?feature=share
Phenominal guide thank you.
Anyone that already works with data, qlikview / tableau, etc will have a decent understanding of what they want to get out of a dashboard. This guide is so easy to follow and brilliantly communicated.
Probably one of the most valuable hours I've ever spent in my life.
Thank you !!
Thank you. Am glad you found this useful. if you have any questions you can get them answered in our LIVE TalkPowerBI Q&A show.
👉 www.TalkPowerBI.com Or Join our LearnPowerBI Private Community
👉 web.learnpowerbi.com/waitlist-invite/
^RM
The best explanation ever. Thank you so much
HeyIsaiah,
I'm glad to help!
⚡Power On!⚡ / Avi
★ Subscribe and Join me LIVE for Talk Power BI Fridays ruclips.net/user/PowerBIProlive ★
Amazing and comprehensive tutorial! My first experience with Power BI saw me jump right into the reports and visuals phase and soon hit road blocks because of no modeling and DAX experience. The full view of the workflow and importance of modeling is something I missed or didn’t pay much attention to trying to learn Power BI on my own. Thanks for the great content!
Hi Anas Farah,
Thanks for the wonderful feedback! It's always a pleasure to be able to share my knowledge around Power BI to you guys.
⚡Power On!⚡ / Avi
★ Get Your Questions Answered LIVE on TalkPowerBI Fridays www.learnpowerbi.com/talkpowerbi ★
19:00 Unpivoting... That was, what I was looking for and why I never got PowerBI to work for me properly. Did not think, it was so easy to do that! Thank you so much!
Being a data analyst myself I must say its one of the easiest tutorial I came across. Good job Avi.
Very well done, so easy to grasp the terms with your teaching style. I took a BI Bootcamp 6 years ago with Pragmatic works but really never used PBI on the job, so I forgot everything. I tried watching some of their tutorials to relearn it and they were sleepers. I was actually able to sit through this entire hour taking notes and working along side with you pain free! Thanks!
ruclips.net/video/F2GY5U-uVhI/видео.html
ruclips.net/user/shortske5tBxu6VR8?feature=share
best crash course ever with the road map of all the future study.
Amazing. Beautiful style of teaching. Makes things so simple to understand and great examples. Thx
Thank you
⚡Power On!⚡ / Avi
★ Subscribe and Join me LIVE for Talk Power BI Fridays ruclips.net/user/PowerBIProlive ★
I'm just 16 minutes into the lecture and I paused to say you are a really awesome teacher!
The best Power Bi tutorial among thousand of out there! Finally i am able to build my dashboard.
Hi Marcus, Thank you. Am glad you found this useful. if you have any questions you can get them answered in our LIVE TalkPowerBI Q&A show.
👉 www.TalkPowerBI.com Or Join our LearnPowerBI Private Community
👉 web.learnpowerbi.com/waitlist-invite/
^RM
Hi, i was at 28:47. In my version of PBi couldnt find the icon to change the format into currency.
Thank you for your help, love the way you teach!
I wish I had such enthusiasm about something in my life too.
Hi Ulla Lauska,
You're welcome.
⚡Power On!⚡ / Avi
★ Get Your Questions Answered LIVE on TalkPowerBI Fridays www.learnpowerbi.com/talkpowerbi ★
Excellent tutorial Avi. Today was my first day with Power BI and I already feel that I can build what I am looking for. Thanks a million :) Keep up the good work.
Thank you so much for your kind words, Priyanka. I really appreciate you taking the time out to share you very first step in your Power BI journey!
⚡Power On!⚡ / Avi
★ Subscribe and Join me LIVE for Talk Power BI Fridays ruclips.net/user/PowerBIProlive ★
Top class. I am new to Power BI. I work on Business Central in Dubai as a Functional Consultant and wanted to learn PBI. Your tutorial is amazing and the explanation is to the point. I will try all the steps and shall approach you with questions, if any. I would like to join your Friday live session or any other session which you conduct on Power BI. Thank you... :)
Thank you. Am glad you found this useful. if you have any questions you can get them answered in our LIVE TalkPowerBI Q&A show.
👉 www.TalkPowerBI.com Or Join our LearnPowerBI Private Community
👉 web.learnpowerbi.com/waitlist-invite/
^RM
I will be honest. I felt so anxious to learn how to use PowerBI due to my PTSD caused by learning to code in Matlab during college. After watching this video, you've taken away that anxiety away and fueled me into actually wanting to use the tool. Thank you so much!
Hey Christian, I am glad you feel comfortable watching and learning from this content. If you have any questions you can get them answered in our LIVE TalkPowerBI Q&A show.
👉 www.TalkPowerBI.com Or Join our LearnPowerBI Private Community
👉 web.learnpowerbi.com/waitlist-invite/
^RM
"I called them 'Side Table Deductions' - I'll let you come up with an abbreviation for that."
This line right there killed it.
Ha! Yeah...I don't ever want to go back to that old world. That was just one of the pain points. There were many more.
@@PowerBIPro Hi, I'm unable to download the files using the link given in the description box. It seems that the Download button isn't working. Could you take a look please. And Thank you for the amazing video. Being a beginner in PowerBi, I really loved it. Thanks in advance.
wr
@@PowerBIPro may i know which version you used in this video? My version has some options missing
This is amazing. You are the great Teacher
Hey thanks Valerie.
⚡Power On!⚡ / Avi
★ Subscribe and Join me LIVE for Talk Power BI Fridays ruclips.net/user/PowerBIProlive ★
this is exactly what i needed, clear and concise. Thanks a lot! :)
Glad it helped!
been using Ms Excel for 16 yrs. saw first video on power bi and am amazed with its functionalities. your way of delivering is also exceptional.
This is a video from a year ago, before MPower BI updated its features. I'm following up with the lecture, and I may spend longer figuring out the Power BI updated features. It's fantastic, and thank you.
Hi Avi! Thank you so very much for the detailed explanation. I am an aspiring data analyst, currently sharpening my skills in Power BI. Your video has been very helpful so far. Thanks again!
ruclips.net/user/shortske5tBxu6VR8?feature=share
46:55 Side Table Deductions, "I'd let you come up with the acronym for that" had me cracking up lmao hahhaha LEGEND
Your ability to communicate and transfer knowledge is amazing. This was so much value in an hour. Now, I'm going back to take it step by step with the files as advised. You're a keeper!
True
ruclips.net/user/shortske5tBxu6VR8?feature=share
So, I had no clue what to do in Power BI. We just got the module at work and it didn't make any sense to me. After watching this tutorial, I literally am able to put together data and make charts and I've only watched half so far. Fantastic job of making this training appropriate for beginners!
From all videos a saw this one help me to understand what Power BI can do. Thanks, a lot.
can we have the Excel that you used for this training, so we can follow your steps to understand more.
totally awesome :)
One thing that would be nice for you to share is how to combine unlimited Excel files into the data model through Power Query. For example, a customer has an Excel file for each month and they store these files in a single folder. They want to bring in all current and future added Excel files into Power BI's data model without editing the Power Query each time. I have seen how you can combine the Excel files and all future added files together into Power Query in Excel, so I am going to try to do the same and hope it works in Power BI.
Use Denodo
Great video! Currently interviewing for a Business Analyst position, so this definitely helped.
Amazing! You are the only tutor whose video I spent 1 hour to watch, sometimes replay and want to watch more . It's really helpful! Thank you
Bạn ơi, bạn có tải đc file thực hành trong link ở phần description ko
Great overview, thank you Avi. I had done an introductory Power BI course before but this was a great refresher
Wow! Thanks for the compliment Shane! If you have more questions about Power BI, do join me every Friday at 9AM PST for my #TalkPowerBI Live event.
⚡Power On!⚡ / Avi
★ Subscribe and Join me LIVE for Talk Power BI Fridays ruclips.net/user/PowerBIProlive ★
Thank you Avi, this is helping me in my line of work. Great educator you are!
Welcome and Thank you for the compliment Erwin.⚡Power On!⚡ / Avi
★ Subscribe and Join me LIVE for Talk Power BI Fridays ruclips.net/user/PowerBIProlive ★
If there’s anyone in here that can send me the downloadable files so I can follow along, I would greatly appreciate it. I filled out the little form to receive the files and follow along in the video but I haven’t gotten them yet.
This is my first time to comment in watching an introduction video. It felt so valuable that I've spent 1 hour on this tutorial and I learned a lot. Thanks for this wonderful video. Looking forward to more.
Watched the whole video at once. Very useful. Thanks.
Would you love to learn more about Power bi? Did you know you can get your Power Bi questions answered in our LIVE TalkPowerBI Q&A show?
👉 www.TalkPowerBI.com Or Join our LearnPowerBI Private Community
👉 web.learnpowerbi.com/waitlist-invite/
^RM
46:55 - I call them Side Table Deductions; I'll let you come up with an acronym for that. Lol This guy.
Ha! Oh..these were painful. Had been burnt by these one times too many. Boy, was I glad to have found Power BI and be done with them :-)
I am sure you know, there are calculated fields and items option in excel
This is really well done and interesting, thank you! On a funny note: My non-native-talker ears keep hearing Power-Behind :-D
The automatic transcription keeps saying Barbie.
Figured it out. Wasn't using the product category and sub category. Thank you for this tutorial. I will be signing up for more classes
Thanks man for this, really is Beginner to Pro... This is all the background that one needs to explore on their own (with a point of reference). Thanks again.
Avi, I wish I found you earlier. Your subject matter understanding, communication skills and ability to transfer knowledge is stellar. I am coming from a Qlik background and needed to get primed on Power BI quickly. Your 1 hour tutorial did exactly that. Great work!
ruclips.net/user/shortske5tBxu6VR8?feature=share
Thank you! I am MS certified in Power BI and Advanced Excel with DAX, but I haven't used it for a bit. This is an EXCELLENT refresher. Thanks again!
I am loving this tutoria! I am having trouble downloading the power BI files to go along with the tutorial. Is anyone else having this issue?
Are you trying to download by going to web.learnpowerbi.com/download/ and it's not working? It's supposed to send the download link in email. Make sure to check your Other/Promotions/Junk/Spam folders.
Great tutorial - I’ve seen some clips of Avi’s tips before and have used PBI for awhile now, but there were several modeling basics covered in this video that I’ll use to tighten up my praxis. For example, this is the first clear explanation I’ve seen of what’s inside PBI service, how ‘dataset’ = data model, which I can use to create different kinds of reports for users, all based on the same model.
Also, AVI’s explanation of “row vs filter context” was the first one I’ve heard that didn’t leave me frustrated and more confused. I got the feeling that with more review and practice building measures and calculated columns, I’ll get it down quicker now.
Thank you for leaving a positive feedback on this video tutorial, LME. I appreciate it a lot.
⚡Power On!⚡ / Avi
★ Subscribe and Join me LIVE for Talk Power BI Fridays ruclips.net/user/PowerBIProlive ★
What a great teacher … no time waste … so well explained … simply perfect
I am stunned to see few people disliking this video :(.. you are amazing boss. your ability to communicate the concepts is supreme..
My mom says the jews are a holy nation, as A BI Analyst, I feel she's wrong. definitely Indians. be blessed!
What skills we need to learn to become a buisiness intelligence analyst?can you please replay 😊
Thanks you so much for amazing video and very valuable information. You are expert instructor.
This kind of tutorial is usually boring and cant concentrate for long ....
But my brother u made my day ☺️☺️☺️
Thank you so much for your feedback😀
I saw many videos of many people, but you are the one clear and
I am having issues selecting the “currency” and the “sort by column” functions. Does anyone know the solution to this?
I had problems with this too. Make sure you click your field in the right column first, then the currency button won't be grayed out.
@@seantron1 Thanks a lot
I am having the same problem. I have tried what Seantron Eich suggested but neither of these button even exist (they are not just greyed out as suggested by Seantron Eich). According to Microsoft (powerbi.microsoft.com/en-us/blog/updated-ribbon-experience-for-power-bi-desktop/) : "In the new ribbon, you may have noticed that the “Modeling” tab has fewer buttons. Now, if you want to modify the structure, properties, or apply formatting to tables, columns, and measures, these options will appear as contextual tabs when you select a field in the fields list." . But I tried clicking on the column but I don't see any such buttons anywhere. If anyone does figure this out, please let us know. Thank you.
Problem solved. I clicked on the 'Month' field under the "Fields" pane (the vertical pane on the right edge if the window). Then a "Column tools" tab appears in the top ribbon which contains the Format (for currency) and Sort by column (for sorting by MonthNum)
@@qasidahmad1196 Thank you! I was panicking for a while when I can't find them.
This is one of the best tutorial I had experienced in youtube .....Very well explained!! ..I learnt few valuable points which institutes haven't discussed...
Thank u so much, with your teaching style and interactive communication insist me to fall in love with power Bi, thank u so much, keep empowering us.
29:46 at this step there is something going wrong for me. When I drag budget amount in, the year 2016 goes away and every step after doesn't work
I think I ran into the same problem. The version of Power BI in the tutorial is slightly different than mine, so a couple things have been a little off. Here's what I did:
1) Select the data view on the left
2) Select "Budget" in "Fields" on the right
3) Select the "Month" column
4) Select "Column Tools" on the ribbon. Select "Date" for "Data Type". Select the "Format" that you like. I chose "2001-03 (yyyy-mm)"
Once I did that and returned to Report, the date appeared properly in the BudgetAmount graph. I hope this helps.
An alternative is to get back to the query editor. For the "Month" column you see the data type as Text. Change this to date and you're back in business. The advantage of this one is that all transformations are still visible in one place.
@@RoysIdea Hi I tried your method, but get the error message saying that it can't automatically convert the column to Data type. Do you know any insight about this? Thanks
@@andrewh7868 thanks a ton it worked
I think that you should check the Model, in my case i messed up the relation between budget and calendar
Wow! As a total newbie to Power BI I found that a little overwhelming but it certainly sold me on the value and functionality and proved to me that I can use it to achieve what I need. I'm now going to go for a walk to let it all sink in, have a coffee, and go through it again slowly.
Thanks Avi
So nice of you. Thank you for your feedback. If you'd like to learn more about Power BI , here is a link about our structured course on this Webinar
👉 web.learnpowerbi.com/waitlist-invite/
^RM
@@PowerBIPro The link doesn't seem to work, Avi
This tutorial helped me create my first ever PowerBI report with REALTIME data!! Thanks Avi!
Stuck❓ Need Help❓ If you get stuck anywhere in the Tutorial or when applying these principles using your own data, there are many ways you can get help:
【1】 Join one of our Upcoming LIVE Events: www.TalkPowerBI.com
【2】 Join our LIVE Zoom Calls to answer your Power BI Technical Questions. Learn More at web.learnpowerbi.com/powerbi-live-question-and-answer
【3】 Join our LearnPowerBI Program with and get help inside our Exclusive Private Community www.learnpowerbi.com/training
【4】 You can also post a question here in the comment --or-- Email us at avi@avising.com
Just make sure to ask "Good" Questions (provide screenshots, sample files if possible). Read article below for help.
How to Ask Good Power BI Questions❓ & Get Them Answered✔️
www.linkedin.com/pulse/how-ask-good-power-bi-questions-get-them-answered-singh-powerbipro-
【5】 If you need Consulting Help please contact us at www.learnpowerbi.com/consulting
⚡Power On!⚡
Avi / PowerBIPro
Don't Just Learn Power BI, Become a Pro www.learnpowerbi.com/pro
What time on Friday?
Every 9am PST
Where are the practice files please
You doing a great job .. thanks for such a great content .. so much to learn from you .. power BI guru
Dude you rock !!! Awesome tutorial, I gotta tell you you have streamlined the session from back end to front end reporting wisely sharing enough time for the back end transformation/ Edit. Although would like to see some scheduling and automation of reporting... may be you have it on a diff link, if so please do share. To me seems like a hybrid MS Access with a built in visualization far more advanced (leaps and bounce). Also please share power BI edit on SQL tables.... would like to see the data type parsing from DB to ETL layout. Thank you once again for the great work.
Wow this VDO is very easy to understand the fundamental of power bi. Thanks
You are most welcome ^RM
honestly I have spend so much money on courses but the way you taught us.. all doubts are cleared with interest!!!! lots of love!!!!
This is the best beginner tutorial for PBI and I wish it was on Udemy for business so I snag a cert for it!
I dont know if you believe it or not, he is really good at solving the hard loop holes in power BI, Love you man.... you nailed it
This comment is totally honest review about the video
so i have been trying to learn powerbi from very loong time but was unable to find a video where i can start to learn , i have also watched some other yt'ers vidoe about powerbi but there they only show us how to create a dashboard and not the fundamentals of powerbi , this is the video which left me surprised as its so detailed
will refer every video of yours in future
Thank You sir for this video , you earned a loyal subscriber for your videos
Thnk YOU
Hey Kawa, Thank you for your feedback. If you would love to know more about our PowerBi training program you can book a quick call here: learnpowerbi.as.me/?appointmentType=30727100
After completing this training tutorial i am willing to complete more tutorial with the same excitement. Great job!
Hey Abu, love your energy . Power on! ^ RM
Learning PowerBI for my next job! This video made it easy & understandable to a beginner like me. Thanks Avi Singh.
Best Power BI lecture in an hour.****4/5
Wow, I love that unpivot function. I literally had to create a VBA function from scratch to transpose columns into rows for Excel and Access to accomplish this at work. Now just click a button...amazing!
Wow wow wow. Never used PBI, but wanted to learn as I work in a financial field and wants to be up to date with tools, this course was just WOW. I’ve never been that focused for the whole entire hour. Thank youuu!!
This video is boosting my career!! Thanks!!
Happy to hear that!
Thank you so much for this rich tutorial. GOD bless you .
This is an amazing tutorial! Makes me very enthusiastic and passionate about Power BI. Well done, Avi!
Really well done. Have not seen many better technical tutorials.
Glad you like it. You can visit our site to learn more about our Training Program: www.learnpowerbi.com/training
PoerwrBi is a brilliant product...and it was brilliantly explained. Really makes you want to open a dataset right now and start creating reports.
If I could have got your channels few month back , it could be lots of time saving. Amazingly explained
Power BI made easy can also be the title. Your teaching is seamless. Thank you
The best Power BI video seen yet. The concept of modelling and how important it is for PowerBI visuals is well explained. Thanks for this video.
Thanks Avi ..simple ,crisp and clear
This is so entertaining to watch… I used to watch other tutorial videos but they sounds so boring, however yours captivate my attention. Thank you.
But I have a question though, I don’t have the currency button in my modeling menu. Do you know why?
Apparently I have to start dive in Power BI for my organisation and your tutorial really helps me! Thank you
Thanks Leo and the team for the lesson today.
You are a TALENTED tutor! Thank you- a great primer which is exactly what I needed to start exploring Power BI concepts further👏🏻👏🏻👏🏻
Glad it was helpful!
Amazing Power BI intro video! Very easy to follow and understand. Thank you! 🙂
Thank you, this was OUTSTANDING! I was just given the task to learn BI and take over what we have along with creating new datasets. This tutorial was very helpful in getting me started and now I am off to view your several linked videos. I have gladly subscribed and have all alerts on. I am looking forward to more of your knowledge and expertise. Thank you, Sir.
Glad it was helpful!
Easily the best Power BI tutorial I've seen. Looking forward to watching your other videos!
Thank you. If you have any questions you can get them answered in our LIVE TalkPowerBI Q&A show.
👉 www.TalkPowerBI.com Or Join our LearnPowerBI Private Community
👉 web.learnpowerbi.com/waitlist-invite/
^RM
good job, thanks.. i am starting with PowerBI and this is what all beginners need
Exellent ... The Introduction, the concept, the video editing, information and perfect details in all steps from scrach to final report .....
One of the best video so far on power BI. Your explanation is great and amazing. I watched other videos on this topic but your video is really great to learn power BI.
Thanks! All the essentials in 60 minutes.