I never write comments but need to highlight how useful this video is for beginners - very easy and understandable explained!
@salvindsouza70534 жыл бұрын
Content 100% Video 100% Teaching skills 200% You are the best .Thank you for the content.
@rubinsanchez74993 жыл бұрын
I like the energy and passion
@pramod36433 жыл бұрын
Hey do you know where can i download the practice files. The link provided in the description doesn't work anymore.
@chrisa82034 жыл бұрын
You have 2 strengths: enthusiasm and communication. Phenomenal teacher and a good lesson for beginners.
@PowerBIPro4 жыл бұрын
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 kzbin.infolive ★
@michaelrai34674 жыл бұрын
I agree...I instantly subscribed and I'm learning soo much thanks @avi
@sandraetubiebi61843 жыл бұрын
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!
@classychannel2020 Жыл бұрын
True
@schoolofpowerbi1563 Жыл бұрын
kzbin.infoke5tBxu6VR8?feature=share
@slickperspective27453 жыл бұрын
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.
@guthasrikanth2 жыл бұрын
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
@AnalyticsPro12 жыл бұрын
kzbin.info/www/bejne/a6SqqmZqZ7NrjNU Free bi course step by step
@schoolofpowerbi1563 Жыл бұрын
kzbin.infoke5tBxu6VR8?feature=share
@nairobi203 Жыл бұрын
OMG..... I was blown away by the unpivoting.... Going through self-study on PBI..... Love your training....
@mohammadarmanibinsafarazka685 Жыл бұрын
Hi, i was at 28:47. In my version of PBi couldnt find the icon to change the format into currency.
@Itsraouff2 жыл бұрын
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.
@PowerBIPro2 жыл бұрын
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
@yunikomdotmai2 жыл бұрын
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.
@PowerBIPro2 жыл бұрын
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
@rickvucina38072 жыл бұрын
Wow.....The best Power BI video I have seen by far. If your a beginner, this video is for you. I grade A+++++
@PowerBIPro2 жыл бұрын
Glad you enjoyed it!
@ameradam46054 жыл бұрын
That is one of the enjoyable and simplest training ever. Thank you for making our journey easy
@PowerBIPro4 жыл бұрын
Thanks mate! ⚡Power On!⚡ / Avi ★ Subscribe and Join me LIVE for Talk Power BI Fridays kzbin.infolive ★
@shrimfuni8432 жыл бұрын
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 :)
@PowerBIPro2 жыл бұрын
Thanks for watching. If you ever get stuck on a powerbi Item, Join our live Q&A on Zoom--> www.learnpowerbi.com/talk
@micahtron50002 жыл бұрын
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.
@PowerBIPro2 жыл бұрын
Power on my friend.
@PowerBIPro2 жыл бұрын
And if you have any questions you can get them answered in our LIVE TalkPowerBI Q&A show. 👉 www.TalkPowerBI.com ^RM
@sherryasd3 жыл бұрын
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.
@ngedwin61743 жыл бұрын
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.
@PowerBIPro3 жыл бұрын
I am so glad I was able to help you. Stay in touch. Power On! / Team Avi
@schoolofpowerbi1563 Жыл бұрын
kzbin.infoke5tBxu6VR8?feature=share
@wangarimaina59472 жыл бұрын
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
@PowerBIPro2 жыл бұрын
Well said!
@maggikuitems39983 жыл бұрын
I taught myself Excel reporting and MS Access. This is a game changer for me. Thank you very much!
@isidoroleon9305 Жыл бұрын
From all videos a saw this one help me to understand what Power BI can do. Thanks, a lot.
@elvistsang8322 жыл бұрын
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!
@haridasmaulloo90873 жыл бұрын
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!
@schoolofpowerbi1563 Жыл бұрын
kzbin.infoke5tBxu6VR8?feature=share
@Hiker19585 жыл бұрын
This is exactly what I’ve been looking for. Clear, engaging and professional. Many thanks Avi!
@PowerBIPro5 жыл бұрын
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 kzbin.infolive ★
@dsswooshy2 жыл бұрын
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 !!
@PowerBIPro2 жыл бұрын
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
@davidgithinji64913 жыл бұрын
Most informative and simplified Power BI tutorial on KZbin ! Simply the Greatest !
@PowerBIPro3 жыл бұрын
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 ★
@Vis.Sharma2 жыл бұрын
Being a data analyst myself I must say its one of the easiest tutorial I came across. Good job Avi.
@leonwu95634 жыл бұрын
Ohhhh! You give great roadmap, understanding and strategy about Power BI. I'm so thankful to you for sharing the beautiful knowledge.
@PowerBIPro4 жыл бұрын
Thanks for the compliment, Leon! ⚡Power On!⚡ / Avi ★ Subscribe and Join me LIVE for Talk Power BI Fridays kzbin.infolive ★
@anasfrh4 жыл бұрын
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!
@PowerBIPro4 жыл бұрын
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 ★
@angeleyes91714 жыл бұрын
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!
@ykmahi70252 жыл бұрын
kzbin.info/www/bejne/fGOqimiLYtqJnqs
@schoolofpowerbi1563 Жыл бұрын
kzbin.infoke5tBxu6VR8?feature=share
@manjunathd77702 жыл бұрын
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... :)
@PowerBIPro2 жыл бұрын
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
@christianlaya38602 жыл бұрын
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!
@PowerBIPro2 жыл бұрын
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
@lindalederer60784 жыл бұрын
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!
@troublekick3 жыл бұрын
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
@lindal85963 жыл бұрын
@@troublekick You are right....
@thetongueshow4 жыл бұрын
"I called them 'Side Table Deductions' - I'll let you come up with an abbreviation for that." This line right there killed it.
@PowerBIPro4 жыл бұрын
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.
@zalparathod4813 жыл бұрын
@@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.
@zes38133 жыл бұрын
wr
@farihajannat76533 жыл бұрын
@@PowerBIPro may i know which version you used in this video? My version has some options missing
@priyankamistry61385 жыл бұрын
Extremely insightful and so perfectly explained! I am so thankful to you Avi. Keep up the great work.
@PowerBIPro5 жыл бұрын
Wow! Thanks Priyanka. Your kind words means a lot to me. ⚡Power On!⚡ / Avi ★ Subscribe and Join me LIVE for Talk Power BI Fridays kzbin.infolive ★
@dino.a25649 ай бұрын
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.
@holgerpopolger3 жыл бұрын
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!
@medasbabu4 жыл бұрын
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!
@PowerBIPro4 жыл бұрын
You are welcome Suresh! ⚡Power On!⚡ / Avi ★ Subscribe and Join me LIVE for Talk Power BI Fridays kzbin.infolive ★
@pranaysharma3244 жыл бұрын
We need more Tutors like you! Just outstanding learning experience ❤️
@PowerBIPro4 жыл бұрын
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 ★
@nurudeenkolade97494 жыл бұрын
Hello, I have tried all I could to download the files used in the video. Could you pls hep me?
@shubhamsahakari97087 ай бұрын
46:55 Side Table Deductions, "I'd let you come up with the acronym for that" had me cracking up lmao hahhaha LEGEND
@waldoaraya30586 ай бұрын
20:40 If anyone has problems applying changes because ProductKey field in Budget table is unique, the solution is changing the model, the relation between Product table and Budget table from: one to one (1:1) >>> One to many (1:*), after that you can apply changes.
@powerplatformdeutsch2 жыл бұрын
The best Power Bi tutorial among thousand of out there! Finally i am able to build my dashboard.
@PowerBIPro2 жыл бұрын
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
@SIrfan-qj9oq5 жыл бұрын
Amazing. Beautiful style of teaching. Makes things so simple to understand and great examples. Thx
@PowerBIPro5 жыл бұрын
Thank you ⚡Power On!⚡ / Avi ★ Subscribe and Join me LIVE for Talk Power BI Fridays kzbin.infolive ★
@isaiahmaragalla5 жыл бұрын
The best explanation ever. Thank you so much
@PowerBIPro5 жыл бұрын
HeyIsaiah, I'm glad to help! ⚡Power On!⚡ / Avi ★ Subscribe and Join me LIVE for Talk Power BI Fridays kzbin.infolive ★
@ullalauska54134 жыл бұрын
Thank you for your help, love the way you teach! I wish I had such enthusiasm about something in my life too.
@PowerBIPro4 жыл бұрын
Hi Ulla Lauska, You're welcome. ⚡Power On!⚡ / Avi ★ Get Your Questions Answered LIVE on TalkPowerBI Fridays www.learnpowerbi.com/talkpowerbi ★
@abdulhaffizumar45642 жыл бұрын
I'm just 16 minutes into the lecture and I paused to say you are a really awesome teacher!
@robinzierhut83893 жыл бұрын
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!
@karimb57774 жыл бұрын
can we have the Excel that you used for this training, so we can follow your steps to understand more.
@priyankainani69055 жыл бұрын
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.
@PowerBIPro4 жыл бұрын
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 kzbin.infolive ★
@fionacai92254 жыл бұрын
best crash course ever with the road map of all the future study.
@Hope-vs8kw2 жыл бұрын
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.
@shoaibahmed56164 ай бұрын
Thanks you so much for amazing video and very valuable information. You are expert instructor.
@dominiquenesbeth11853 жыл бұрын
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.
@Waltrow2 жыл бұрын
Brilliant. I love the turbo-paced introduction with links to more detailed tutorials for those that need it. Thanks!
@LipsitaArt2 жыл бұрын
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!
@schoolofpowerbi1563 Жыл бұрын
kzbin.infoke5tBxu6VR8?feature=share
@pgazelk_main2 жыл бұрын
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!
@MrTheoreoguy Жыл бұрын
Great video! Currently interviewing for a Business Analyst position, so this definitely helped.
@roshansrinivas87292 жыл бұрын
this is exactly what i needed, clear and concise. Thanks a lot! :)
@PowerBIPro2 жыл бұрын
Glad it helped!
@keithnurse4 жыл бұрын
46:55 - I call them Side Table Deductions; I'll let you come up with an acronym for that. Lol This guy.
@PowerBIPro3 жыл бұрын
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 :-)
@HarisKhan-yi3gl3 жыл бұрын
I am sure you know, there are calculated fields and items option in excel
@valeriejuinpou25005 жыл бұрын
This is amazing. You are the great Teacher
@PowerBIPro5 жыл бұрын
Hey thanks Valerie. ⚡Power On!⚡ / Avi ★ Subscribe and Join me LIVE for Talk Power BI Fridays kzbin.infolive ★
@tushargaikwad20443 жыл бұрын
honestly I have spend so much money on courses but the way you taught us.. all doubts are cleared with interest!!!! lots of love!!!!
@dassprakash9132 Жыл бұрын
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
@deesterdee66504 жыл бұрын
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.
@pearldsouza79453 жыл бұрын
Use Denodo
@7295shane5 жыл бұрын
Great overview, thank you Avi. I had done an introductory Power BI course before but this was a great refresher
@PowerBIPro5 жыл бұрын
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 kzbin.infolive ★
@belmabroukamal43215 жыл бұрын
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
@PowerBIPro5 жыл бұрын
Thanks, Belmabrouk! ⚡Power On!⚡ / Avi ★ Subscribe and Join me LIVE for Talk Power BI Fridays kzbin.infolive ★
@Raul2467Ganhar3 жыл бұрын
What a great teacher … no time waste … so well explained … simply perfect
@anitaweng8456 Жыл бұрын
This video is absolutely awesome!!! Perfect for beginner! Give a full picture of how Power BI works!!! Much appreciated for it!!!
@gianwinters5 жыл бұрын
Thank you Avi, this is helping me in my line of work. Great educator you are!
@PowerBIPro5 жыл бұрын
Welcome and Thank you for the compliment Erwin.⚡Power On!⚡ / Avi ★ Subscribe and Join me LIVE for Talk Power BI Fridays kzbin.infolive ★
@doctrui4 жыл бұрын
"This is where the magic happens!" :)
@lisagalley4 жыл бұрын
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.
@PowerBIPro4 жыл бұрын
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 kzbin.infolive ★
@bilalkirmani73113 жыл бұрын
Hi. I'm a beginner in this. Can someone please guide me about how much should I learn more after this tutorial to start a job or a freelancing career? And if i start freelancing with power Bi skills learnt in this tutorial as a side job, are there good chances that I'd make good amount of money in it?
@BB-2383 Жыл бұрын
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!
@shaunxenonkhan75113 жыл бұрын
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!
@schoolofpowerbi1563 Жыл бұрын
kzbin.infoke5tBxu6VR8?feature=share
@johnathanlu88344 жыл бұрын
Omg Side Table Deduction is a great acronym.
@jayayen32433 жыл бұрын
This is really well done and interesting, thank you! On a funny note: My non-native-talker ears keep hearing Power-Behind :-D
@cubicinfinity23 жыл бұрын
The automatic transcription keeps saying Barbie.
@deeptichandu84552 жыл бұрын
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...
@rajud732 жыл бұрын
Best presentation prepared by Avi Singh, i appreciate your effort to teach us Thank you
@fjfurhgkaig2 жыл бұрын
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
@PowerBIPro2 жыл бұрын
Thank you for your feedback, We will keep on updating.
@bhaktisura88252 жыл бұрын
@@PowerBIPro Can you make a new video on new changes.. :( I am struggling
@subhankarbanik93062 жыл бұрын
@@PowerBIPro Sir not getting some features on Sorting and many more. Kindly assist how could we find that.
@vedantsharma6596 Жыл бұрын
Thanks for the update
@abhinavpanwar946 Жыл бұрын
I don’t find formatting in modeling 😢 where do I search it
@sorentan75674 жыл бұрын
I am having issues selecting the “currency” and the “sort by column” functions. Does anyone know the solution to this?
@seantron14 жыл бұрын
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.
@robertngenzi12344 жыл бұрын
@@seantron1 Thanks a lot
@qasidahmad11964 жыл бұрын
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.
@qasidahmad11964 жыл бұрын
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)
@Lanzengying4 жыл бұрын
@@qasidahmad1196 Thank you! I was panicking for a while when I can't find them.
@simurugemurug28225 жыл бұрын
Hey Avi, what software do you use to record your screen.. Especially the arrow marks.. They look so cool :)
@shakiraasfoor75995 жыл бұрын
you can use power point 2016, it is available to record the screen
@kyser91242 жыл бұрын
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.
@maurociccolella42234 жыл бұрын
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
@jaipatel75484 жыл бұрын
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
@andrewh78684 жыл бұрын
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.
@RoysIdea4 жыл бұрын
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.
@10_yilin_s3 жыл бұрын
@@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
@saisaranyaananthapadmanaba98613 жыл бұрын
@@andrewh7868 thanks a ton it worked
@ronaldokomen41703 жыл бұрын
I think that you should check the Model, in my case i messed up the relation between budget and calendar
@devilliersduplessis79044 жыл бұрын
My mom says the jews are a holy nation, as A BI Analyst, I feel she's wrong. definitely Indians. be blessed!
@nadiyatharakkal5214 жыл бұрын
What skills we need to learn to become a buisiness intelligence analyst?can you please replay 😊
@mahrmahr98712 жыл бұрын
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
@PowerBIPro2 жыл бұрын
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
@IndraKurukuntla Жыл бұрын
I have watched many learning Videos on KZbin 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!!
@PowerBIPro Жыл бұрын
Glad it was helpful!
@PowerBIPro5 жыл бұрын
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
@vesnapopovic49565 жыл бұрын
What time on Friday?
@PowerBIPro5 жыл бұрын
Every 9am PST
@lolaluf27514 жыл бұрын
Where are the practice files please
@Babayagaom4 жыл бұрын
You doing a great job .. thanks for such a great content .. so much to learn from you .. power BI guru
@shriramrao58564 жыл бұрын
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.
@warrenanderson4123 жыл бұрын
Question: if I already have a table filter via Power Query, can I use Power BI to create Power Bi Charts? Thank you!
@deepak93nair3 жыл бұрын
Learning PowerBI for my next job! This video made it easy & understandable to a beginner like me. Thanks Avi Singh.
@pearldsouza79453 жыл бұрын
This tutorial helped me create my first ever PowerBI report with REALTIME data!! Thanks Avi!
@Noelito402 жыл бұрын
PoerwrBi is a brilliant product...and it was brilliantly explained. Really makes you want to open a dataset right now and start creating reports.
@abuhasanal-nahiyan60942 жыл бұрын
After completing this training tutorial i am willing to complete more tutorial with the same excitement. Great job!
@PowerBIPro2 жыл бұрын
Hey Abu, love your energy . Power on! ^ RM
@binoysingha85293 жыл бұрын
I am stunned to see few people disliking this video :(.. you are amazing boss. your ability to communicate the concepts is supreme..
@willtoler12 жыл бұрын
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
@tc75842 жыл бұрын
I work in HR and looking to use Power BI after a friend blew me away with a report from it. I'd venture to say that Power Bi is the future and the way you can drill down on the data and what happened to get the numbers you're looking at is amazing .
@1rasha3 жыл бұрын
you can also make these kind of side calculation in simple pivot, no need to make two pivots and then side calculations as mentioned by you. you can simply put everything in one pivot and make calculated fields of what you need. (47:10)
@esonamasiza89592 жыл бұрын
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.
@jigarkawa242 Жыл бұрын
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
@PowerBIPro Жыл бұрын
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
@jibbsautomations Жыл бұрын
This is the best beginner tutorial for PBI and I wish it was on Udemy for business so I snag a cert for it!
@mamamalet10 ай бұрын
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!!
@VarunKumar-xt4jq3 жыл бұрын
I saw many videos of many people, but you are the one clear and
@tacosmargs58 Жыл бұрын
glad I found this.. I was watching another tutorial and the speaker was so boring, I just couldn't stay engaged. This one looks great.