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 ua-cam.com/users/PowerBIProlive ★
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.
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!
I don't remember the last time I completed the training with the same excitement that I began with. This one is simply superb Avi !!! Really a zero to dashboard training
Perfect guide for PowerBI, anyone that needs to get a full idea of power bi and start using it after only 60 mins, this is video is highly recommended.
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'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.
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
Rewatched this after 3 weeks for refresh, still find this the best fundamental after so many other PowerBI introduction. Avi defines the "table relationship" and the "kitchen" that none other has ever talk about. I had used MS Access, so this is super familiar and easy to grab for me, but without Avi's explanation, most beginner will be scratching head on what the heck are those lines about.
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!
Hey Man, as someone whose had some experience in Power BI.. after watching this, I've come to realize that there are still some beginner stuff I can learn. Great tutorial! Looking to come back to this channel and lear some more, you've earned a subscriber :)
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 ua-cam.com/users/PowerBIProlive ★
I haven't been able to get through even one darn video yet cause I'm always getting interrupted at my work but I love your style and think it's engaging and hope to learn a lot!
Just my 2 cents, if we are planning to learn something to accelerate our careers during work time it’s never going to happen! Believe me ! Moreover it’s the the time we dedicate to what we are supposed to do even though it means spending time on sharpening our skills to do the same job better. Unless we can’t find to dedicate and learn outside our work/college hours imho , i Dont think we will ever learn but keep procrastinating with excuses on why we couldn’t learn. So my friend schedule 30 mins each day after work, strictly, just to enhance your knowledge, every single day… I’m sure you will wonder why we didn’t start and plan this appropriately earlier
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
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 ★
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
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 ★
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!
Wow! Thanks Priyanka. Your kind words means a lot to me. ⚡Power On!⚡ / Avi ★ Subscribe and Join me LIVE for Talk Power BI Fridays ua-cam.com/users/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
Wow, Today was a very productive day, I was always focusing on Visualisation aspect of Power BI, thanks for this tutorial, I understood other aspects of Power BI, Thank You Avi!
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 ★
@@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.
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.
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 ua-cam.com/users/PowerBIProlive ★
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
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!
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!
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
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!
Unfortunately, Power BI changes every month. The current version has changed quite a bit from the version in this video. The basics are fine, but a lot of the formatting and sorting has changed
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!
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...
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.
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 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.
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 ua-cam.com/users/PowerBIProlive ★
Welcome and Thank you for the compliment Erwin.⚡Power On!⚡ / Avi ★ Subscribe and Join me LIVE for Talk Power BI Fridays ua-cam.com/users/PowerBIProlive ★
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.
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 ua-cam.com/users/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 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
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
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!!
Glad it was helpful! and 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 watched many learning Videos on UA-cam and other platforms. This video is amazing. I have never saw a learning video this much interacting and his voice is just amazing. Great work done by Avi Singh. Thank you so much!!
I swear to God you’re the best, I’ve whatched many videos and subscribed in a cource but never find easier and better than this video, and the best thing is your english, it’s clear and understandable, please keep it up, I wish if you have Patreon so that we can donate
Thank you Mahr. 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
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!
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.
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
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.
I never write comments but need to highlight how useful this video is for beginners - very easy and understandable explained!
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 ua-cam.com/users/PowerBIProlive ★
I agree...I instantly subscribed and I'm learning soo much thanks @avi
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.
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
ua-cam.com/users/shortske5tBxu6VR8?feature=share
I don't remember the last time I completed the training with the same excitement that I began with. This one is simply superb Avi !!! Really a zero to dashboard training
ua-cam.com/video/5sGy342N8Vs/v-deo.html
Free bi course step by step
ua-cam.com/users/shortske5tBxu6VR8?feature=share
OMG..... I was blown away by the unpivoting.... Going through self-study on PBI..... Love your training....
Perfect guide for PowerBI, anyone that needs to get a full idea of power bi and start using it after only 60 mins, this is video is highly recommended.
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'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
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!
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 ua-cam.com/users/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
Rewatched this after 3 weeks for refresh, still find this the best fundamental after so many other PowerBI introduction. Avi defines the "table relationship" and the "kitchen" that none other has ever talk about. I had used MS Access, so this is super familiar and easy to grab for me, but without Avi's explanation, most beginner will be scratching head on what the heck are those lines about.
I am so glad I was able to help you. Stay in touch. Power On! / Team Avi
ua-cam.com/users/shortske5tBxu6VR8?feature=share
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!
ua-cam.com/users/shortske5tBxu6VR8?feature=share
Hey Man, as someone whose had some experience in Power BI.. after watching this, I've come to realize that there are still some beginner stuff I can learn. Great tutorial! Looking to come back to this channel and lear some more, you've earned a subscriber :)
Thanks for watching. If you ever get stuck on a powerbi Item, Join our live Q&A on Zoom--> www.learnpowerbi.com/talk
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 ua-cam.com/users/PowerBIProlive ★
I haven't been able to get through even one darn video yet cause I'm always getting interrupted at my work but I love your style and think it's engaging and hope to learn a lot!
Just my 2 cents, if we are planning to learn something to accelerate our careers during work time it’s never going to happen! Believe me ! Moreover it’s the the time we dedicate to what we are supposed to do even though it means spending time on sharpening our skills to do the same job better. Unless we can’t find to dedicate and learn outside our work/college hours imho , i Dont think we will ever learn but keep procrastinating with excuses on why we couldn’t learn. So my friend schedule 30 mins each day after work, strictly, just to enhance your knowledge, every single day… I’m sure you will wonder why we didn’t start and plan this appropriately earlier
@@troublekick You are right....
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 taught myself Excel reporting and MS Access. This is a game changer for me. Thank you very much!
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 ★
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
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 ua-cam.com/users/PowerBIProlive ★
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.
Most informative and simplified Power BI tutorial on UA-cam ! 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 ★
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!
ua-cam.com/video/F2GY5U-uVhI/v-deo.html
ua-cam.com/users/shortske5tBxu6VR8?feature=share
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 ua-cam.com/users/PowerBIProlive ★
Extremely insightful and so perfectly explained! I am so thankful to you Avi. Keep up the great work.
Wow! Thanks Priyanka. Your kind words means a lot to me.
⚡Power On!⚡ / Avi
★ Subscribe and Join me LIVE for Talk Power BI Fridays ua-cam.com/users/PowerBIProlive ★
Finally a concise power BI tutorial that's easy to the ears. The way you speak and explain things is a pleasure to listen. Thanks so much for this!
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
Wow, Today was a very productive day, I was always focusing on Visualisation aspect of Power BI, thanks for this tutorial, I understood other aspects of Power BI, Thank You Avi!
You are welcome Suresh!
⚡Power On!⚡ / Avi
★ Subscribe and Join me LIVE for Talk Power BI Fridays ua-cam.com/users/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?
"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
I'm just 16 minutes into the lecture and I paused to say you are a really awesome teacher!
Being a data analyst myself I must say its one of the easiest tutorial I came across. Good job 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.
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 ua-cam.com/users/PowerBIProlive ★
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 ua-cam.com/users/PowerBIProlive ★
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
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!
This is amazing. You are the great Teacher
Hey thanks Valerie.
⚡Power On!⚡ / Avi
★ Subscribe and Join me LIVE for Talk Power BI Fridays ua-cam.com/users/PowerBIProlive ★
Brilliant. I love the turbo-paced introduction with links to more detailed tutorials for those that need it. Thanks!
best crash course ever with the road map of all the future study.
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.
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!
ua-cam.com/users/shortske5tBxu6VR8?feature=share
"This is where the magic happens!" :)
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 ★
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
honestly I have spend so much money on courses but the way you taught us.. all doubts are cleared with interest!!!! lots of love!!!!
can we have the Excel that you used for this training, so we can follow your steps to understand more.
Hi, i was at 28:47. In my version of PBi couldnt find the icon to change the format into currency.
Go to visualizations pane, click on General, click on Data format, change format to currency and change the other ones as explained in the video
46:55 Side Table Deductions, "I'd let you come up with the acronym for that" had me cracking up lmao hahhaha LEGEND
What a great teacher … no time waste … so well explained … simply perfect
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!
Unfortunately, Power BI changes every month. The current version has changed quite a bit from the version in this video. The basics are fine, but a lot of the formatting and sorting has changed
Thank you for your feedback, We will keep on updating.
@@PowerBIPro Can you make a new video on new changes.. :( I am struggling
@@PowerBIPro Sir not getting some features on Sorting and many more. Kindly assist how could we find that.
Thanks for the update
I don’t find formatting in modeling 😢 where do I search it
this is exactly what i needed, clear and concise. Thanks a lot! :)
Glad it helped!
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!
ua-cam.com/users/shortske5tBxu6VR8?feature=share
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...
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
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
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.
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 😊
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.
This tutorial helped me create my first ever PowerBI report with REALTIME data!! Thanks Avi!
That's what i've been looking for, the explaination is perfectly clear, thank s for this video, it's really useful and helped me a lot
Thanks, Belmabrouk!
⚡Power On!⚡ / Avi
★ Subscribe and Join me LIVE for Talk Power BI Fridays ua-cam.com/users/PowerBIProlive ★
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 ua-cam.com/users/PowerBIProlive ★
Omg Side Table Deduction is a great acronym.
Great video! Currently interviewing for a Business Analyst position, so this definitely helped.
This video is absolutely awesome!!! Perfect for beginner! Give a full picture of how Power BI works!!! Much appreciated for it!!!
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 ua-cam.com/users/PowerBIProlive ★
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.
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.
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 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 ua-cam.com/users/PowerBIProlive ★
Hey Avi, what software do you use to record your screen.. Especially the arrow marks.. They look so cool :)
you can use power point 2016, it is available to record the screen
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 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
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
Hi Avi,
Can you make a model that include "Who Are The Lost Customers" New Customers, etc.
That would be very hepfull
Thank you very much in advance
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
Apparently I have to start dive in Power BI for my organisation and your tutorial really helps me! Thank you
I am stunned to see few people disliking this video :(.. you are amazing boss. your ability to communicate the concepts is supreme..
I just found your channel. I really hope I master this POWER BI.
You can do it!
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.
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!!
awesome tutorial - thank you! i found answers for almost all my knowledge gaps in PBI.
Glad it was helpful! and 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
Learning PowerBI for my next job! This video made it easy & understandable to a beginner like me. Thanks Avi Singh.
I have watched many learning Videos on UA-cam and other platforms. This video is amazing. I have never saw a learning video this much interacting and his voice is just amazing. Great work done by Avi Singh. Thank you so much!!
Glad it was helpful!
I swear to God you’re the best, I’ve whatched many videos and subscribed in a cource but never find easier and better than this video, and the best thing is your english, it’s clear and understandable, please keep it up, I wish if you have Patreon so that we can donate
Thank you Mahr. 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
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
This is the best beginner tutorial for PBI and I wish it was on Udemy for business so I snag a cert for it!
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!
Best Power BI lecture in an hour.****4/5
Question: if I already have a table filter via Power Query, can I use Power BI to create Power Bi Charts? 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!
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
Content 100%
Video 100%
Teaching skills 100%
Thank you for the content.
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