Power BI Tutorial From Beginner to Pro ⚡ Desktop to Dashboard in 60 Minutes ⏰
Вставка
- Опубліковано 2 чер 2024
- This Complete Power BI Tutorial takes you Step-by-Step as you use Power BI Desktop to create a beautiful Power BI Dashboard. 👉 Download Power BI Files in Video at web.learnpowerbi.com/download...
✅ Subscribe to always get my latest videos: ua-cam.com/users/powerbipro?su...
🔴 Ask Questions LIVE on TalkPowerBI Fridays www.TalkPowerBI.com
👉 Join the Learn Power BI Family web.learnpowerbi.com/waitlist... (Paid Power BI Training Program)
▶️Topics Covered◀️ (click to jump to topic)
02:27 1. Get Data (Query Editor)
21:42 2. Relationships
33:41 3. DAX
48:15 4. Visuals
56:13 5. PowerBI.com
▶️Detailed Topics Covered◀️ (click to jump to topic)
00:00 How to Use this Tutorial
02:27 1A Meet the Power BI Duo!
03:06 1B Get Data - Connectors and Get Simple Data
08:45 1C Get Data - Query Editor Overview
12:40 1D Get Data - Clean up Messy Data
15:52 1E Get Data - Query Editor vs Macros
17:29 1F Get Data - Clean up Continued
21:42 2A Relationships - Key Concepts 🗝️
24:10 2B Relationships - Creating Relationships
26:59 2C Relationships - Explore Data Using Visuals
32:42 2D Relationships - Analyzing Multiple Data Tables Together 🗝️
33:41 3A DAX - Writing DAX Measure (Implicit vs. Explicit Measures) 🗝️
37:00 3B DAX - Calculated Column
39:03 3C DAX - Measure vs. Calculated Column (Key Concept 🗝️)
44:26 3D DAX - More Measures and Magic!
46:20 3E DAX - Before and After Power BI 🗝️
48:15 4A Visuals - 80/20 Rule 🗝️
49:19 4B Visuals - Text, Image, Cards, Shape
51:28 4C Visuals - Bar/Column Chart, Drill Down
52:51 4D Visuals - Conditional Formatting 🗝️
53:38 4E Visuals - Line Chart, Bar Chart
54:11 4F Visuals - Top 10 Products/Customers
56:13 5A Power BI.com - Publish
57:28 5B PowerBI.com - Features In-Depth 🗝️
59:27 5C PowerBI.com - Everything About Dashboards 🗝️
01:02:19 5D PowerBI.com - Sharing Dashboards with Others 🗝️
01:02:46 Your 3 Crucial Next Steps to Power On!
▶️Next Step In Your Journey◀️
👉 Join the Learn Power BI Family web.learnpowerbi.com/waitlist... (Paid Power BI Training Program)
▶️Slower Power BI Tutorial◀️
• Power BI Tutorial for ...
▶️Links to Other UA-cam Videos◀️
You can watch ALL the videos mentioned in this Tutorial as part of this playlist
👉 • Power BI Tutorial and ...
This playlist includes:
• How to Download & Install Power BI
• 🗝️Power BI Licensing (Paid Power BI Options)
• 🗝️Ultimate Calendar Table
• 🗝️Power BI Data Modeling
• 🗝️DAX: Row Context and Filter Context In-Depth
• Data vs. Lookup Tables In-Depth
• Power BI Relationships In-Depth
• Using a Fiscal Calendar (See Ultimate Calendar)
• DAX: Implicit vs Explicit Measures
• DAX: Create Row Context in Measures Using X Functions (Coming Soon. Will be added to Playlist)
• DAX: Measures vs Calculated Columns In-Depth
• DAX: When Is It Right to Create a Calculated Column? (Coming Soon. Will be added to Playlist)
• PowerBI.com: Creating Excel Reports Connected to Power BI (Analyze In Excel In-Depth)
(Coming Soon. Will be added to Playlist)
• PowerBI.com: Setting up Automated Refresh (Coming Soon. Will be added to Playlist)
• Power BI Custom Visuals (Coming Soon. Will be added to Playlist)
• PowerBI.com: Different Ways of Sharing Your Reports (Coming Soon. Will be added to Playlist)
• PowerBI.com: How to Create a PowerBI.com Account (Coming Soon. Will be added to Playlist)
========================================
This Tutorial would take you step-by-step through a LIVE Demo as we
✔️Build a Power BI Model
✔️Create a Beautiful Power BI Report
✔️Publish it and Use it on PowerBI.com
You can follow along using the Download Files (link above).
The Tutorial would introduce you to【 Power BI Desktop 】- the “Authoring Tool” of Power BI. And teach you how to use:
✔️Query Editor
✔️Relationships
✔️DAX Measures
✔️Creating Beautiful & Interactive Reports
✔️and more…
Then we would continue our journey to the 【 PowerBI.com Platform 】- where you would learn:
✔️Publish a Report
✔️Create New Reports
✔️Create a Single Source of Truth for All Your Reporting
✔️Creating a Dashboard
✔️Sharing a Dashboard
✔️and more…
You would also understand the Power BI Process
✔️Author
✔️Publish
✔️Consume
You would learn fundamental Power BI Concepts
✔️Difference Between Creating Models vs. Reports
✔️Implicit vs. Explicit Measures
✔️Measures vs. Calculated Columns
✔️80-20 Rule of Power BI Model Authoring
✔️and more…
⚡Power On!⚡
-Avi Singh
www.LearnPowerBI.com
#PowerBI #PowerBITutorial #PowerBIPro
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.
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 ★
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
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 ★
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 ★
I never write comments but need to highlight how useful this video is for beginners - very easy and understandable explained!
I really like how you put this video together! Short and concise, hitting the right concepts and reasoning behind.
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 ★
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 ★
OMG..... I was blown away by the unpivoting.... Going through self-study on PBI..... Love your training....
This is the most valuable use of my 1 hour...especially when I'm really in the mood to learn something new on UA-cam and those videos don't kill your interest in the first 10 mins itself.
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....
Brilliant. I love the turbo-paced introduction with links to more detailed tutorials for those that need it. Thanks!
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!
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
"This is where the magic happens!" :)
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
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!
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 ★
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 ★
I taught myself Excel reporting and MS Access. This is a game changer for me. Thank you very much!
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
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 ★
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 ★
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
Thanks Avi. Awesome all-around intro, still relevant in 2023, good pace, perfect level of detail, good examples. It's exactly what I was looking for to get a sense of what PowerBI is and what it can do. Merci beaucoup!
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 ★
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 ★
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.
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!
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
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
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!
I LOVE YOU AVI!!!! Thanks for being so detailed... I been through Tableau boot camp, felt that Power BI is much easier and clean to use. Probably because you made this seems so easy and fundamentally structured.
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
best crash course ever with the road map of all the future study.
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.
Excellent tutorial. Avi does an amazing job of making this fun and informative for all levels of users.
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
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 ★
This has thought me everything I need to get started with Power BI. So glad I found you!!!
I cannot imagine a better overview of this program in one hour, thank you very much.
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 ★
Amazing tutorial!! Cleared out a lot of questions in my mind.. Thank you and keep going please :)
Thank you Menekse! Join me for one of our Live sessions on Fridays if you can: ua-cam.com/users/PowerBIProlive
I love talking to people their and hearing their Power BI journeys.
Also reach out to me on LinkedIn if you like: www.linkedin.com/in/avichalsingh/
⚡Power On!⚡ / Avi
★ Subscribe and Join me LIVE for Talk Power BI Fridays ua-cam.com/users/PowerBIProlive ★
Impressive and breathtaking! Thanks a bunch for the thorough introduction to Power BI!
Being a data analyst myself I must say its one of the easiest tutorial I came across. Good job 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
Well said!
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?
This was extremely helpful! I have been trying to understand PowerBI for a while and you explained it fantastically. Thank you so much!
Your tutorial is amazing, best ever on UA-cam, Thank you so much!
46:55 Side Table Deductions, "I'd let you come up with the acronym for that" had me cracking up lmao hahhaha LEGEND
Omg Side Table Deduction is a great acronym.
Avi, I am so glad I saw your video. It is filled with awesome advice. I have looked in the past how to use Power BI. And most people want to "amaze" you with the visuals. But you spent a great amount of time, looking into query editor an DAX to prepare your data so that the visualization becomes so easy. Thank you. Subscribed.
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!
Sir,
Glad I found you channel, have been loving and using excel since a while now and was trying to figure out how to go beyond pivots and charts... Perfect place, using this channel alongside your book... Thank you....
Thank you for the compliment Ankit.
⚡Power On!⚡ / Avi
★ Subscribe and Join me LIVE for Talk Power BI Fridays ua-cam.com/users/PowerBIProlive ★
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
It was amazing for me as a beginner and you made me more interested to learn more about Power BI.
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.
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 ★
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
Apparently I have to start dive in Power BI for my organisation and your tutorial really helps me! Thank you
Awesome video! I love the section of 2A Relationship.. i always have a hard time trying to link the tables.
Thank you for making this so much easier!
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 exactly what i needed, clear and concise. Thanks a lot! :)
Glad it helped!
This is an amazing tutorial! Makes me very enthusiastic and passionate about Power BI. Well done, Avi!
Hi! This is a great introduction to Power BI, even though your program in the video isn't the latest version any more. I've run into a problem with cleaning up a datasheet where various data in one column should be in separate columns and I can't seem to figure out how to split it nicely. There's obviously a lot of other data in the same query. Do you have a video that could help with this or maybe your a reply on your own?
"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 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.
I'm just 16 minutes into the lecture and I paused to say you are a really awesome teacher!
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 ★
Hi, i was at 28:47. In my version of PBi couldnt find the icon to change the format into currency.
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.
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
Amazing Power BI intro video! Very easy to follow and understand. Thank you! 🙂
can we have the Excel that you used for this training, so we can follow your steps to understand more.
Hello, thanks for your tutorial.
What is the name of the recording software that u r using ?
THnaks again !
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
man! the pacing, the simple explanation and the delivery; i don't know where to begin. Love it Avi!
Much appreciated!
Kitchen of Power BI - Cool!! BBI... that was like a 100 year ago, right ; )
Hey Mike! BBI...uh not sure what that is. Did I say that in my video?
I'm disappointed no one commented on my Dr. Who Time Machine/TARDIS reference :-)
@@PowerBIPro O, sorry... : ( I meant: BPBI!!! Before Power BI : ) Well... I thought the Dr Who references was rad, rad, rad!!!!!
You're bought great masters, Mike is the pro in excel and Avi for the power bi. Mike thanks for your informative videos, I assume your dedication to excel is tremendous have learned loads of tips from your videos
Yup! Mike is super amazing. Now of course Excel and Power BI overlap to a great degree. In fact the two main engines of Power BI (Query Editor & DAX) are both found inside Excel (Power Query & Power Pivot)...and Mike has taken on teaching all of it! Check out his MSPTDA Course ua-cam.com/video/tmTJEdRtFlA/v-deo.html
Power On! / Avi
@@PowerBIPro Go Team!!!!!!!
this is a wonderful video, thanks a lot. it is really useful !
Hey Shaimaa, I'm glad that this video has helped you learn more about Power BI.
⚡Power On!⚡ / Avi
★ Subscribe and Join me LIVE for Talk Power BI Fridays ua-cam.com/users/PowerBIProlive ★
Hi Avi, Just got into PBI thankyou So Much for this Beautiful Lecture! I am a Tableau User (Tableau Certified) but seeing Data Modelling and Power Query Capabilities in PBI is Just Jaw-Dropping! Tableau has Tableau Prep but not so advanced as Power Query Though.
ua-cam.com/users/shortske5tBxu6VR8?feature=share
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!!
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
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.
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.
Clear, well detailed, many examples. Well done, Thank you!
Hey Avi, thank you for the video!
I can't download the Power BI Files.
I click on the "Download Now" button, but nothing happens.
Thanks!
Turn off your pop up blockers
@@edlee5443 Hey Ed, never is too late to say thank you! I tried it again, and it worked fine for me! Thank you so much.
I tried it using Internet Explorer, just to download it. It may help other users.
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.
Thank you, Avi. I am very impressed not only with the presentation by your style of presentation. Awesome job and thank you, Avi. Please keep them coming.
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.
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
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
Thanks Avi ..simple ,crisp and clear
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.
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 😊
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
Content 100%
Video 100%
Teaching skills 100%
Thank you for the content.
Very clear step by step instructions, subscribed, n I’m sure I can apply this to my day to day analytical work! Thank you.