How to use Microsoft Power BI - Tutorial for Beginners
ฝัง
- เผยแพร่เมื่อ 9 พ.ค. 2024
- In this step-by-step tutorial video, learn how to get started using Microsoft Power BI. Power BI allows you to get insight from your business data. This is an introductory overview of Power BI to get you started.
📚 RESOURCES
- Download Power BI here: powerbi.microsoft.com/en-us/d...
- Kevin Cookie Company Financial Spreadsheet: 1drv.ms/x/s!AmxrofZZlZ-whJlAi...
- Wikipedia link: en.wikipedia.org/wiki/List_of...
- How to use Microsoft Power Automate: • Power Automate Tutoria...
⌚ TIMESTAMPS
00:00 Introduction
01:01 Download and install
03:00 Welcome screen
04:20 Sample data overview
06:00 Get data spreadsheet
07:40 Transform data from spreadsheet using Power Query Editor
10:10 Get data from web
11:25 Transform data from web using Power Query Editor
13:10 Join tables by merging queries
14:27 Overview of Power BI layout, including fields and visualizations
16:40 Insert title
17:20 Insert variety of visualizations
22:10 Insert slicer
23:30 Apply theme and change style
25:00 Save and Publish report
26:30 Share with others
27:05 Wrap up
📺 RELATED VIDEOS
- Playlist with all my videos on Power BI: • Power BI
📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter/
🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: amzn.to/3kCP2yz (Purchasing through this link gives me a small commission to support videos on this channel -- the price to you is the same)
🔽 CONNECT WITH ME
- Official web site: www.kevinstratvert.com
- LinkedIn: / kevinstratvert
- Discord: / discord
- Twitter: / kevstrat
- Facebook: / kevin-stratvert-101912...
- TikTok: / kevinstratvert
- Instagram: / kevinstratvert
🎒 MY COURSES
- Excel for Beginners in under 2 hours: kevinstratvert.thinkific.com/
🙏 REQUEST VIDEOS
forms.gle/BDrTNUoxheEoMLGt5
🔔 SUBSCRIBE ON TH-cam
th-cam.com/users/kevlers?...
#stratvert - วิทยาศาสตร์และเทคโนโลยี
🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
⏭ Watch next: How to use DAX Formulas in Power BI: th-cam.com/video/waG_JhBgUpM/w-d-xo.html
📩 Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter/
Hi Kevin.. thanks for this overview session.. i have a question.. if we have data for list of transactions (Open, Closed, cancelled). Can we create different visualizations as per transaction type from same data source?
🙏 Thanks Sir God Bless You 🙏💕🙏❤️
Hey Kevin, do u do training on power bi? 🙏
Hi Kevin, I'm your new subscriber here.
Power bi is not available in mac ☹😥
The video is really great! Thank you for sharing
Watching this makes me want to create reports on every single type of my work. Even my daily budgets and groceries and I will show a report presentation to my Hubby on where our moneys are going. Worth to subscribe and share peeps!!!
It’ll make a good portfolio!
Your husband would be so frustrated then... imagine working your back for 12 hours in data, dashboards and systems and then turn to your wife only to see charts and diagrams AGAIN!
@@galariajaved 😂😂😂
😆😆😆😆
I'm going to use this to track my pokemon investments, love love love Power BI ever since I started working with it last week.
I literally learned more watching this 27 min video than I have going through multiple hours of the learning paths/modules on the Microsoft website. Excellent presentation and content!
same for me
same here, the boring 8-min read on the Microsoft website... this video is pure gold. helping the algorithm here
Exactly, I have an interview in a couple days and even though I have a basic understanding of power BI and it’s use, this has helped tremendously in being able to talk about it and explain it as if I know what I’m doing 😂 hopefully all goes well with the interview.
I see this video is 3 years old but it's still super useful. I went through everything that Kevin explained several times so I am getting more adept at using PowerBI. The one thing that slipped by that he did NOT explain was that on the Country Slicer, to select more than 1 country, just hold down the Ctl key and then select multiple countries. Thanks for an amazing getting started video Kevin!!!
Kevin, you do an amazing job providing resources for practice and making instruction very clear. I frequently recommend your online training to educators.
This is awesome! No one makes things as lucid as tour tutorials! Please include more advanced features like calculated fields, dependant multi-layer slicers, transforming data using excel formulae, etc.
Best intro to PBI yet! Straight forward, simple and clear. Example company great way to demonstrate what is achievable. Thanks. Take it to the next level Kevin.
Hi Kevin, a friend ask me to look into Power Bi and i didn't understand where to begin. Although, i am a beginner and watching your video now gives me the confidence and moral boost. The step by step is very well detailed and informative. Today, 1st of Jan and watching your video is a sign that i am in the right direction. Definitely subscribing to your channel. THANK YOU KEVIN.
I really appreciated this overview generalized understanding of Power BI. Basically you have data to import. Clean up the data to show what you need. Import whatever else data needed from a website and what is imported to showcase if needed. Then make pretty visually the data based on the criteria to showcase. Then save and publish. Thanks for this good summary understanding to help me grasp Power BI which isn't bad whatsoever!!
Okay, Kevin. I’m going to need you to stop reading my mind. This is perfect - exactly what I was looking for!!! More Power BI videos, please! I started to teach myself Power BI and got discouraged, but now it just makes sense.
Also, I really appreciate how you have the video broken and named into sections on the timeline! Keep up the brilliant work.
I didn’t think one session would be more than enough to learn an application.. Just brilliant and thanks.. 👍🏼
Thank you so much for teaching in such a simplified concise and engaging way! As a first timer seeing Power BI I felt like it was really easy and doable! Thanks a lot for your contents ❤️
I had zero knowledge about PowerBI but after watching your video, I have used Power BI for my thesis. Thanks so much for these videos.
The way you segmented the different sections of this video is very helpful. More youtubers should do that.
Hi Kevin! Thanks for sharing your videos. You always made it easier for us to understand complex applications in a short videos. The rest can be on self-explorations.
I'm doing a course on Business Intelligence. This 28-minute video was more helpful than all the material I am going through. Awesome tutorial. Thank you for sharing.
You made everything pretty clear in less than half an hour of video. Amazing! Thank you so much for your help
Come on Kevin, you know we would like a Power BI pt 2!! Thanks for this one!
Kevin, you're an amazing tutor.
I wonder if you could do a video on Excel vs Power BI, which one is appropriate for which task, where they overlap, how you can combine them etc.
Cheers.
That was a great Power BI tutorial. Everything was crystal clear and easy to understand. Thanks Kevin! 🖤
Excellent introduction and first steps at setting up a report. Thanks, Kevin. 10/10 👍
Such an amazing tutorial. Easy to follow-through, concise and overall very informative. This has helped me a lot with my current project. Thanks a lot and keep up the great work! :)
Amazing how you managed to fit such extensive knowledge of Power BI, Power Query and ETL in such a small tutorial. Great work and thank you!!
Thanks Kevin l went through twice your video. First as l was driving listening. Second when l got to work being hands on. I had a lecture for the whole day on PowerBi. I nailed it as a pro. I went through with them your example as l was getting confident n then l made them to bring two examples of sample data of their choice.
I ve never been satisfied. I was lecturing to people who are already working. And everyone went home happy.
The lecture happened in South Africa n deligates where from all over Africa including as far as Gambia.
Thanks man thanks
Hi Kevin.. your way of teaching is awesome. Simple and Easy to understand. Learning lot from you. I have been working on large data. Feel frustrated till now. After watching your video, I feel that everything is easy, just needed a Good Mentor. And I Got it. Keep sharing your excellent knowledge. Lots of Love n Thanks u.
Wow Kevin you make the complex easy to understand. I would like to see a lot more of BI features please.
Same here
That really true. He defines the horrible look things in a very simplified way and his sequence of telling this are also awsome, help us quickly memorised.
Thanks Kevin. Will you be able to share a video on sales comparison's for last 3 years month wise?
Please does anyone know where to find data to practice and use Power BI features?
This is one of the best TH-cam presentations I have seen. Thanks, Kevin. Amazing job!
I completely agree with you...Starting from the sound all the way to the explanation..Great job, Kevin. Thanks.
Agreed
Thanks Kevin,You have added me a skill that will change my life.Good Job
After months of watching many tutorials, I can say this is that first tutorial video that I have practically gained some insights from. Thanks
This was extremely helpful! I can't thank you enough! You explained it in a manner that was WAY easier to understand than the training I went through with my company. :)
Please does anyone know where to find data to practice and use Power BI features?
This is definitely a good and clear cut video for beginner! Nice work and effort, Kevin!
Straightforward and crisp. Really easy for a beginner to understand on what power bi is about. You just earned a subscriber here.
Hi Kevin, thanks for sharing this knowledge with all of us! You explain very well and you are a good teacher. Would be glad to see more Power BI videos and Power Query as I am new to it and would be happy to see more advanced videos on it :))))
Thanks Kevin for this excellent material. I definitely want to know more about Power BI. I would appreciate if you go deeper on it
We've just launched our Power BI integration, and can't get over how great an intro to BI this is Kevin!
You are a great tutor! More of this so that I can appreciate data analysis without spending too much. Thank you!
Dear Kevin, thank you so much for this video. I have learned the basics from you. As you have provided tutorial for beginners, I request you to provide tutorial videos for intermediate and expert learners. Furthermore, this Power BI is highly used by the Big4 companies. If you know which specific keys in Power BI are most used by those companies please provide us by highlighting them.
Your tutorial was super easy to follow, I'd definitely love to see you cover inserting calculations since that is something I can apply to the work I do daily at my job. It would also be cool to see advance slicer options and other ways to give the report viewer control of what they see, like with buttons and bookmarks. Any additional Power Bi topics you cover will be much appreciated!
Please does anyone know where to find data to practice and use Power BI features?
@@d56273 Did you find somewhere yet?
@@gareth4106 not yet
@@d56273 You can find sample dataset in Power BI tool it self. Under Help > Examples.
This is by far the best Power BI Tutorial I've ever come across, well done Kevin.
Thanks, Kevin, for the detailed and easy-to-understand content. As a first-time user, this tutorial made it much easier for me to follow along.
This is awesome Kevin. I definitely need to explore this tool some more now. Thanks for the tutorial :)
our teacher recommended us this video so I greet all students from VŠE in Prague
This was so great I watched from start to finish without leaving my desk. Thank you Kevin, you just got a new subscriber.
I love your Power BI tutorials. I thought that using BI on daily basis gonna be complicated at first but these videos have completely changed my mind and encouraged me to use for every report that I make :) Thank you Kevin Cookie
Hi Kevin, Thanks a lot for putting this content. I have watched it in a single stretch because your presentation was making me curious in each steps waiting to see what could be next. Yes I would like to know more indepth about Power BI if you could please post another detailed video later. Now I can try to do it by myself as the program is staying installed in my PC since a few months back. ;-) Cheers.
love this highlevel overview. can't wait for more
Loving your Power BI tutorials, Kevin. Are you planning to do one about when and how to use M instead of DAX in Power BI? Although I understand broadly how the languages are different, I find it very difficult to know when to use one rather than the other when doing Power BI analysis, creating dashboards, etc.
Yes we want more Power BI videos. A lot of jobs are asking you to be a data analyst as well as your other duties.
Hi Kevin! Thank you for your efforts and the video, I really would love to see more video! I watched your first video about OBS that was awesome.
Awesome video Kevin. You explain it very clearly. I'd love to see you do DAX calculations and explain the row and filter context too🙏
Here's an intro to DAX: th-cam.com/video/waG_JhBgUpM/w-d-xo.html
Man!!! you're a tutorial god. I cannot believe I've learned so many things in less than 30 mins. Now I can go to those 3 hour tutorials knowing wtf I'm using
I built my first PowerBI Report and it was pretty easy and fun😊😊. Thank you, Kevin, you are an amazing teacher.
Thank you for your efforts and the video, Kevin! Would love to see more about Power BI!
This is a great primer for Power BI Kevin, also love the polish in this video!
Thank you so much for the quick and neat presentation of basics of power bi. Loved the way you interact with your audience. Your way of presentation keeps one glued to the content.
Thank you so much for this intro! Your're an amazing tutor! Truly helps me as a beginner who have never used this before.
Thanks for a very helpful, high-level introduction to Power BI
Your videos are really helpful, do more about Power BI, I really want to learn and I do it easily with your videos, good job!
Preparing for an interview, this video helped me understanding the basics
Thanks a bunch
Power BI in a nutshell. Thank you for the simplest yet detailed explanatory video ❤
Excellent introduction to Power Bi with clear explanations. Would love to see you go deeper into customisations, calculated columns and also whether it is possible to display a Power Bi report in a Powerpoint slide and have it be interactive e.g. using the slicers etc.
This is What I was looking for a long time. Thanks Dear💕. Looking for more
Thank you for this video. This is the MOST HELPFUL beginner tutorial for PBI I've ever encountered. One of the most useful features for me was the big blue circle surrounding the cursor.
The map feature and the slicer feature also surprised me that they existed and also how easily they transform the data.
Observation: Kevin Cookie Co reported sales from 2018 and 2019, but you used the population data from 2020. I know this is a tutorial, so data accuracy isn't essential, but maybe you should remark to the viewer the importance of accurate and precise data. When cookie sales got destroyed due to supply chain shut-downs, etc. in 2020 because of Covid, the sales figures per person would have been wildly different from the trends seen in the previous two years.
I am actually new to Power BI and now confident with the services. Great video. Thanks
Thank you so much. I am getting addicted to your tutorials.
Thank you so much .. i’ve been waiting this so long !!
Good job Kevin, you made it look so simple. Would love to see more videos from you as I’m a beginner at this. Definitely subscribing to your channel
Thanks Kevin... I'm a Cognos BI super user and this is the 1st time I have explored Power BI.. With your straightforward tutorial, I am now interested to explore further and possibly move from Cognos to power BI... Thanks for the 101 intro 🙂
Muito bom! Mais Power BI no canal, por favor!
Funny how 20 mins ago i didn't knew a thing about power BI
+1
this tutorial was so concise and so effective. thank you for such an effective introduction, with this foundation I feel like I can learn anything in BI now
Wow. Great demonstration. I don't know if it was because I took a Tableau class, but this seems really straight forward and easy. And being able to publish for free is amazing
Absolutely amazing, Thanks for this Kevin❤. I always thought this was a complicated tool to use but the way you simplified it by following your report step-by-step just clicked for me. What's also cool is that I watched this today, Dec 4th, 2022 but you posted this 2 years ago. So still very relevant. You get a like & subscribe from me 👍🔔
Hi Ayo Ayo, the same for me...watched this only today on 25 January 2023 and still a relevant video even after all this time. Thanks Kevin
That is a good intro! Thanks for sharing!
I built my first Power BI Report and I felt nice abt it. Thanks to Kevin ..........💗
That was an amazing video. Everything is clear to understand. I didn't think one session would be more than enough to learn an application. Thanks, tutor!
I agree
Great snapshot, always easy to follow your training Kevin.
Can you please create another more advanced PowerBI with more features.
Any chance you could show a PowerBI report and how you are bringing in the data fields from the Common Data Service for D365 business applications?
Like always absolutely great content, Thanks Kevin !
Hey @Kevin ...just wanted to say thanks for your efforts to make the tutorial very easy for the beginners like me. It gave me the confidence that I can learn this tool. thank you so much. God bless you!
Thank you for making a detailed yet very straightforward video. Glad that I learned so much here.
Please do some more videos on PowerBI. Make a playlist on this. Go deeper.
That’s what she said
@@joshc7865 Perfect! I wish there was a way to put emoji's rather than just a thumbs up. (although it DID take you 5 months to come up with the response LOL)
Omg finally been waiting for this
Yor are a legend. I saw few videos but nothing can be compared with yours. You describe it in a very beautiful way and it makes me feel so good. I can start working on my own now. thanks
Hello there!
I've just applied for a job where I supposed to work with powerBI and I was afraid of how I would use it without any experience but after this video I'm confident that I'll be able to do it. Great video!Thanks for this tutorial.
Thanks for your video. I would be interested to know how to integrate Python modeling or visualization in Power BI, also allows auto refreshing data :)
Hey Kevin this was very helpful! Could you please make a video on Power BI Pro and how it is different from the free version.
Will add to my list. Thanks for the suggestion, Vanshdeep!
I just started using PBi at work and this video has helped me to understand it with your step by step tutorial. Thanks so much for delivering such excellent content. I am so excited to learn more and become very good at understanding and using PBi
Great tutorial - not too fast, and not too slow. Thank you!
That was awesome!
Twas great, I follow you as well. You are also great
@@Sakhilemtimande You are also great.
26:30 You need Pro/premium to utilize sharing within organization. Free licence allow you only to publish to web (anyone can see) or my workspace. End users also need pro licences to read. So free is only good for personal testing or public data.
Good point. If it is free then what is the logic ?
This video was amazing!!! I am in absolute beginner and showing everything step by step was super helpful. This video gave me a lot of confidence.
The lecture is very clear and much useful of the beginners to kick start their PowerBI knowledge.
Unfortunately it seems like share is only available when you have a corporate account...
Yup, I get to try this out as my corporate account is on MS. Cant use private dot hotmail or live account.
Great Demo. This video is really helpful. Within half an hour, I could lean the entire details about power BI. Thank you so much
As always, Kevin, I find your tutorial to be very clear and extremely helpful. I suspect I ought to watch this Power BI tutorial about five times and by then I'll get it! I'm curious about one possibility. Given the power of these programs, is there a way to ask Power BI how it might analyze the data in a table so I can learn of ways to look at the data that I might not have thought of. Thanks as always. Anne K
I thought power bi is toughest and I can't learn without couching centres.... But today I feel confident I can learn whatever I want from internet.... Thanks man.... Don't stop teaching ❤❤
Thank you so much for these materials, Kevin! I was able to grasp the basics from this tutorial of yours. 😊
That was the most lucid power BI tutorial on the internet. Thank You Kevin!
Thank you so much Kevin for this tutorial. Through this video I got familiar with the most powerful tool for Data Analysis: Power BI. Thanks once again!!
This was beautiful!!! I would love to see more videos on Power Bi. I’m not proficient in it but whatever you can add to this I will definitely watch. Thank you!