Power BI Tutorial From Beginner to Pro ⚡ Desktop to Dashboard in 60 Minutes ⏰

Рет қаралды 5,396,128

Күн бұрын

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: kzfaq.info?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 KZfaq 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

Пікірлер: 2 400

@PowerBIPro 5 жыл бұрын

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

@vesnapopovic4956 4 жыл бұрын

What time on Friday?

@PowerBIPro 4 жыл бұрын

Every 9am PST

@lolaluf2751 4 жыл бұрын

Where are the practice files please

@Babayagaom 4 жыл бұрын

You doing a great job .. thanks for such a great content .. so much to learn from you .. power BI guru

@shriramrao5856 4 жыл бұрын

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.

@sandraetubiebi6184 3 жыл бұрын

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 Жыл бұрын

kzfaq.infoke5tBxu6VR8?feature=share

@slickperspective2745 3 жыл бұрын

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.

@guthasrikanth 2 жыл бұрын

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

@AnalyticsPro1 Жыл бұрын

kzfaq.info/get/bejne/a9l3rJZll7Schqc.html Free bi course step by step

@schoolofpowerbi1563 Жыл бұрын

kzfaq.infoke5tBxu6VR8?feature=share

@anasfrh 4 жыл бұрын

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!

@PowerBIPro 4 жыл бұрын

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 ★

@kerstinle1966 3 жыл бұрын

I never write comments but need to highlight how useful this video is for beginners - very easy and understandable explained!

@pgazelk_main Жыл бұрын

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!

@anshikasingh5822 3 жыл бұрын

This is the most valuable use of my 1 hour...especially when I'm really in the mood to learn something new on KZfaq and those videos don't kill your interest in the first 10 mins itself.

@chrisa8203 4 жыл бұрын

You have 2 strengths: enthusiasm and communication. Phenomenal teacher and a good lesson for beginners.

@PowerBIPro 4 жыл бұрын

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 kzfaq.infolive ★

@michaelrai3467 4 жыл бұрын

I agree...I instantly subscribed and I'm learning soo much thanks @avi

@angeleyes9171 3 жыл бұрын

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!

@ykmahi7025 Жыл бұрын

kzfaq.info/get/bejne/fJh3jJiGktu6mH0.html

@schoolofpowerbi1563 Жыл бұрын

kzfaq.infoke5tBxu6VR8?feature=share

@dsswooshy 2 жыл бұрын

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 !!

@PowerBIPro 2 жыл бұрын

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

@haridasmaulloo9087 3 жыл бұрын

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 Жыл бұрын

kzfaq.infoke5tBxu6VR8?feature=share

@leonwu9563 4 жыл бұрын

Ohhhh! You give great roadmap, understanding and strategy about Power BI. I'm so thankful to you for sharing the beautiful knowledge.

@PowerBIPro 4 жыл бұрын

Thanks for the compliment, Leon! ⚡Power On!⚡ / Avi ★ Subscribe and Join me LIVE for Talk Power BI Fridays kzfaq.infolive ★

@lindalederer6078 3 жыл бұрын

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!

@troublekick 2 жыл бұрын

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

@lindal8596 2 жыл бұрын

@@troublekick You are right....

@Waltrow 2 жыл бұрын

Brilliant. I love the turbo-paced introduction with links to more detailed tutorials for those that need it. Thanks!

@maggikuitems3998 3 жыл бұрын

I taught myself Excel reporting and MS Access. This is a game changer for me. Thank you very much!

@ameradam4605 4 жыл бұрын

That is one of the enjoyable and simplest training ever. Thank you for making our journey easy

@PowerBIPro 4 жыл бұрын

Thanks mate! ⚡Power On!⚡ / Avi ★ Subscribe and Join me LIVE for Talk Power BI Fridays kzfaq.infolive ★

@salvindsouza7053 3 жыл бұрын

Content 100% Video 100% Teaching skills 200% You are the best .Thank you for the content.

@rubinsanchez7499 3 жыл бұрын

I like the energy and passion

@pramod3643 3 жыл бұрын

Hey do you know where can i download the practice files. The link provided in the description doesn't work anymore.

@sumitghosh955 3 жыл бұрын

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.

@yunikomdotmai 2 жыл бұрын

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.

@PowerBIPro 2 жыл бұрын

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

@priyankamistry6138 5 жыл бұрын

Extremely insightful and so perfectly explained! I am so thankful to you Avi. Keep up the great work.

@PowerBIPro 5 жыл бұрын

Wow! Thanks Priyanka. Your kind words means a lot to me. ⚡Power On!⚡ / Avi ★ Subscribe and Join me LIVE for Talk Power BI Fridays kzfaq.infolive ★

@ngedwin6174 3 жыл бұрын

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.

@PowerBIPro 3 жыл бұрын

I am so glad I was able to help you. Stay in touch. Power On! / Team Avi

@schoolofpowerbi1563 Жыл бұрын

kzfaq.infoke5tBxu6VR8?feature=share

@profinancepartner5072 2 жыл бұрын

I really like how you put this video together! Short and concise, hitting the right concepts and reasoning behind.

@elvistsang832 2 жыл бұрын

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!

@isaiahmaragalla 5 жыл бұрын

The best explanation ever. Thank you so much

@PowerBIPro 5 жыл бұрын

HeyIsaiah, I'm glad to help! ⚡Power On!⚡ / Avi ★ Subscribe and Join me LIVE for Talk Power BI Fridays kzfaq.infolive ★

@Hiker1958 5 жыл бұрын

This is exactly what I’ve been looking for. Clear, engaging and professional. Many thanks Avi!

@PowerBIPro 4 жыл бұрын

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 kzfaq.infolive ★

@jayf1581 3 жыл бұрын

I cannot imagine a better overview of this program in one hour, thank you very much.

@holgerpopolger 3 жыл бұрын

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!

@medasbabu 4 жыл бұрын

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!

@PowerBIPro 4 жыл бұрын

You are welcome Suresh! ⚡Power On!⚡ / Avi ★ Subscribe and Join me LIVE for Talk Power BI Fridays kzfaq.infolive ★

@LipsitaArt Жыл бұрын

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 Жыл бұрын

kzfaq.infoke5tBxu6VR8?feature=share

@willtoler1 Жыл бұрын

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

@ailisobrien9595 3 жыл бұрын

This has thought me everything I need to get started with Power BI. So glad I found you!!!

@ullalauska5413 4 жыл бұрын

Thank you for your help, love the way you teach! I wish I had such enthusiasm about something in my life too.

@PowerBIPro 4 жыл бұрын

Hi Ulla Lauska, You're welcome. ⚡Power On!⚡ / Avi ★ Get Your Questions Answered LIVE on TalkPowerBI Fridays www.learnpowerbi.com/talkpowerbi ★

@wangarimaina5947 2 жыл бұрын

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

@PowerBIPro 2 жыл бұрын

Well said!

@ruthngmj 3 жыл бұрын

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!

@stephaniealdana5123 3 жыл бұрын

This was extremely helpful! I have been trying to understand PowerBI for a while and you explained it fantastically. Thank you so much!

@ErwinMeister8 4 жыл бұрын

Thank you Avi, this is helping me in my line of work. Great educator you are!

@PowerBIPro 4 жыл бұрын

Welcome and Thank you for the compliment Erwin.⚡Power On!⚡ / Avi ★ Subscribe and Join me LIVE for Talk Power BI Fridays kzfaq.infolive ★

@7295shane 4 жыл бұрын

Great overview, thank you Avi. I had done an introductory Power BI course before but this was a great refresher

@PowerBIPro 4 жыл бұрын

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 kzfaq.infolive ★

@Vis.Sharma 2 жыл бұрын

Being a data analyst myself I must say its one of the easiest tutorial I came across. Good job Avi.

@mahsyarsaid 3 жыл бұрын

Apparently I have to start dive in Power BI for my organisation and your tutorial really helps me! Thank you

@priyankainani6905 4 жыл бұрын

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.

@PowerBIPro 4 жыл бұрын

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 kzfaq.infolive ★

@deesterdee6650 4 жыл бұрын

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.

@pearldsouza7945 2 жыл бұрын

Use Denodo

@kyser9124 2 жыл бұрын

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.

@sherryasd 3 жыл бұрын

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.

@ankitkothari857 4 жыл бұрын

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....

@PowerBIPro 4 жыл бұрын

Thank you for the compliment Ankit. ⚡Power On!⚡ / Avi ★ Subscribe and Join me LIVE for Talk Power BI Fridays kzfaq.infolive ★

@fionacai9225 3 жыл бұрын

best crash course ever with the road map of all the future study.

@robinzierhut8389 3 жыл бұрын

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!

@micahtron5000 2 жыл бұрын

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.

@PowerBIPro 2 жыл бұрын

Power on my friend.

@PowerBIPro 2 жыл бұрын

And if you have any questions you can get them answered in our LIVE TalkPowerBI Q&A show. 👉 www.TalkPowerBI.com ^RM

@valeriejuinpou2500 4 жыл бұрын

This is amazing. You are the great Teacher

@PowerBIPro 4 жыл бұрын

Hey thanks Valerie. ⚡Power On!⚡ / Avi ★ Subscribe and Join me LIVE for Talk Power BI Fridays kzfaq.infolive ★

@SIrfan-qj9oq 4 жыл бұрын

Amazing. Beautiful style of teaching. Makes things so simple to understand and great examples. Thx

@PowerBIPro 4 жыл бұрын

Thank you ⚡Power On!⚡ / Avi ★ Subscribe and Join me LIVE for Talk Power BI Fridays kzfaq.infolive ★

@MrTheoreoguy Жыл бұрын

Great video! Currently interviewing for a Business Analyst position, so this definitely helped.

@esonamasiza8959 Жыл бұрын

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.

@nairobi203 Жыл бұрын

OMG..... I was blown away by the unpivoting.... Going through self-study on PBI..... Love your training....

@menekseustagroot919 5 жыл бұрын

Amazing tutorial!! Cleared out a lot of questions in my mind.. Thank you and keep going please :)

@PowerBIPro 5 жыл бұрын

Thank you Menekse! Join me for one of our Live sessions on Fridays if you can: kzfaq.infolive 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 kzfaq.infolive ★

@mahmoudabdelraouf7284 2 жыл бұрын

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.

@PowerBIPro 2 жыл бұрын

@dino.a2564 5 ай бұрын

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.

@shaunxenonkhan7511 3 жыл бұрын

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 Жыл бұрын

kzfaq.infoke5tBxu6VR8?feature=share

@doctrui 4 жыл бұрын

"This is where the magic happens!" :)

@anitaweng8456 Жыл бұрын

This video is absolutely awesome!!! Perfect for beginner! Give a full picture of how Power BI works!!! Much appreciated for it!!!

@Erufailos 3 жыл бұрын

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?

@pranaysharma324 3 жыл бұрын

We need more Tutors like you! Just outstanding learning experience ❤️

@PowerBIPro 3 жыл бұрын

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 ★

@nurudeenkolade9749 3 жыл бұрын

Hello, I have tried all I could to download the files used in the video. Could you pls hep me?

@thetongueshow 3 жыл бұрын

"I called them 'Side Table Deductions' - I'll let you come up with an abbreviation for that." This line right there killed it.

@PowerBIPro 3 жыл бұрын

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.

@zalparathod481 3 жыл бұрын

@@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.

@zes3813 3 жыл бұрын

@farihajannat7653 3 жыл бұрын

@@PowerBIPro may i know which version you used in this video? My version has some options missing

@malishariat9107 3 жыл бұрын

It was amazing for me as a beginner and you made me more interested to learn more about Power BI.

@AaronWesson 2 жыл бұрын

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.

@PowerBIPro 2 жыл бұрын

Glad it was helpful!

@shrimfuni843 Жыл бұрын

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 :)

@PowerBIPro Жыл бұрын

Thanks for watching. If you ever get stuck on a powerbi Item, Join our live Q&A on Zoom--> www.learnpowerbi.com/talk

@lisagalley 4 жыл бұрын

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.

@PowerBIPro 4 жыл бұрын

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 kzfaq.infolive ★

@leeman1765 3 жыл бұрын

Impressive and breathtaking! Thanks a bunch for the thorough introduction to Power BI!

@ngedwin6174 3 жыл бұрын

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.

@belmabroukamal4321 4 жыл бұрын

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

@PowerBIPro 4 жыл бұрын

Thanks, Belmabrouk! ⚡Power On!⚡ / Avi ★ Subscribe and Join me LIVE for Talk Power BI Fridays kzfaq.infolive ★

@rickvucina3807 2 жыл бұрын

Wow.....The best Power BI video I have seen by far. If your a beginner, this video is for you. I grade A+++++

@PowerBIPro 2 жыл бұрын

Glad you enjoyed it!

@abdulhaffizumar4564 2 жыл бұрын

I'm just 16 minutes into the lecture and I paused to say you are a really awesome teacher!

@lzyong306 3 жыл бұрын

Your tutorial is amazing, best ever on KZfaq, Thank you so much!

@shubhamsahakari9708 4 ай бұрын

46:55 Side Table Deductions, "I'd let you come up with the acronym for that" had me cracking up lmao hahhaha LEGEND

@karimb5777 4 жыл бұрын

can we have the Excel that you used for this training, so we can follow your steps to understand more.

@namthiky7091 3 жыл бұрын

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

@thanhhungtran1183 3 жыл бұрын

Bạn ơi, bạn có tải đc file thực hành trong link ở phần description ko

@BB-2383 8 ай бұрын

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!

@johnathanlu8834 4 жыл бұрын

Omg Side Table Deduction is a great acronym.

@jayayen3243 3 жыл бұрын

This is really well done and interesting, thank you! On a funny note: My non-native-talker ears keep hearing Power-Behind :-D

@cubicinfinity2 3 жыл бұрын

The automatic transcription keeps saying Barbie.

@jpvalois Жыл бұрын

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!

@AmitChristian 3 жыл бұрын

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.

@roshansrinivas8729 2 жыл бұрын

this is exactly what i needed, clear and concise. Thanks a lot! :)

@PowerBIPro 2 жыл бұрын

Glad it helped!

@TheKyo4848 4 жыл бұрын

Hello, thanks for your tutorial. What is the name of the recording software that u r using ? THnaks again !

@deeptichandu8455 Жыл бұрын

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...

@ashwinikumar2302 10 ай бұрын

Thanks for a wonderful video on Power BI... easily the best one I have seen after watching so many other videos on the same topic... every minute is gold...

@keithnurse 3 жыл бұрын

46:55 - I call them Side Table Deductions; I'll let you come up with an acronym for that. Lol This guy.

@PowerBIPro 3 жыл бұрын

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-yi3gl 3 жыл бұрын

I am sure you know, there are calculated fields and items option in excel

@mohammadarmanibinsafarazka685 Жыл бұрын

Hi, i was at 28:47. In my version of PBi couldnt find the icon to change the format into currency.

@Raul2467Ganhar 2 жыл бұрын

What a great teacher … no time waste … so well explained … simply perfect

@excelisfun 5 жыл бұрын

Kitchen of Power BI - Cool!! BBI... that was like a 100 year ago, right ; )

@PowerBIPro 5 жыл бұрын

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 :-)

@excelisfun 5 жыл бұрын

@@PowerBIPro O, sorry... : ( I meant: BPBI!!! Before Power BI : ) Well... I thought the Dr Who references was rad, rad, rad!!!!!

@stephenbrincat7124 5 жыл бұрын

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

@PowerBIPro 5 жыл бұрын

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 kzfaq.info/get/bejne/qtOEfaiVt9qqnHU.html Power On! / Avi

@excelisfun 5 жыл бұрын

@@PowerBIPro Go Team!!!!!!!

@dominiquenesbeth1185 3 жыл бұрын

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.

@GarethHowell 2 жыл бұрын

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

@PowerBIPro 2 жыл бұрын

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

@GarethHowell 2 жыл бұрын

@@PowerBIPro The link doesn't seem to work, Avi

@ZeyaLwinTun Жыл бұрын

This is an amazing tutorial! Makes me very enthusiastic and passionate about Power BI. Well done, Avi!

@maurociccolella4223 4 жыл бұрын

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

@Michaellc7 3 жыл бұрын

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!

@edlee5443 3 жыл бұрын

Turn off your pop up blockers

@Michaellc7 3 жыл бұрын

@@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.

@bigchungus2728 2 жыл бұрын

Bud, can’t thank you enough for this incredibly well done video that helped me learn enough to create my own report and presentation in a matter of a few hours. You saved my arse at work.

@PowerBIPro 2 жыл бұрын

@davidgithinji6491 3 жыл бұрын

Most informative and simplified Power BI tutorial on KZfaq ! Simply the Greatest !

@PowerBIPro 3 жыл бұрын

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 ★

@sorentan7567 4 жыл бұрын

I am having issues selecting the “currency” and the “sort by column” functions. Does anyone know the solution to this?

@seantron1 4 жыл бұрын

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.

@robertngenzi1234 4 жыл бұрын

@@seantron1 Thanks a lot

@qasidahmad1196 4 жыл бұрын

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.

@qasidahmad1196 4 жыл бұрын

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)

@angelchan7047 4 жыл бұрын

@@qasidahmad1196 Thank you! I was panicking for a while when I can't find them.

@shaimaaelsherif3368 4 жыл бұрын

this is a wonderful video, thanks a lot. it is really useful !

@PowerBIPro 4 жыл бұрын

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 kzfaq.infolive ★

@maneesh2u 2 жыл бұрын

Very informative! Thank you.

@Hope-vs8kw 2 жыл бұрын

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.

@jaspentv5770 4 жыл бұрын

I would highly appreciate if someone provide a sample data for this training. ^ _ ^

@PowerBIPro 3 жыл бұрын

Hey Jaspen, sorry could not respond earlier. Hopefully y ou were able to get a hold of the files. The link is included in description: Get the files from web.learnpowerbi.com/download Power On! /Avi

@thanhhungtran1183 3 жыл бұрын

@@PowerBIPro sorry but nothing happen when i click download button :(((