How to use Microsoft Power BI - Tutorial for Beginners

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 KZbin
kzbin.info?...
#stratvert

[@KevinStratvert]

🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com ⏭ Watch next: How to use DAX Formulas in Power BI: kzbin.info/www/bejne/rZKqkH2ed8yIpq8 📩 Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter/

[@kakkar88]

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?

[@jagatkrishna1543]

🙏 Thanks Sir God Bless You 🙏💕🙏❤️

[@jahviskeyonyi6137]

Hey Kevin, do u do training on power bi? 🙏

[@nierazapanta9756]

Hi Kevin, I'm your new subscriber here. Power bi is not available in mac ☹😥

[@mireillee.5571]

The video is really great! Thank you for sharing

[@len5142]

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

[@nicrome]

It’ll make a good portfolio!

[@galariajaved]

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!

[@uzairshaikh6545]

​@@galariajaved 😂😂😂

[@michaelajayi2117]

😆😆😆😆

[@pokeplush66]

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.

[@Tallnashguy83]

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!

[@colady3194]

same for me

[@antonioa.g.sanchez5442]

same here, the boring 8-min read on the Microsoft website... this video is pure gold. helping the algorithm here

[@dylanbingham1776]

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.

[@DataRich2525]

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

[@sethnanakwameappiah-kubi5035]

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.

[@arnabmit]

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.

[@SS-cd1dl]

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.

[@takeshiasahi5494]

Funny how 20 mins ago i didn't knew a thing about power BI

[@samreenkausar5428]

+1

[@iryna2087]

Same here, I think I love it and want to know more! It’s like Kaggle but easier, like Tableu but not concentrating mainly on visuals , like Excel but more powerful , can’t wait to start learning more ❤

[@jimekrut]

Kevin, you do an amazing job providing resources for practice and making instruction very clear. I frequently recommend your online training to educators.

[@explore_the_world_bfr_its2752]

I didn’t think one session would be more than enough to learn an application.. Just brilliant and thanks.. 👍🏼

[@mram4u]

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.

[@AljIsHere128]

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

[@adewaleadewale4391]

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.

[@familylaracuente7417]

Come on Kevin, you know we would like a Power BI pt 2!! Thanks for this one!

[@sawdameher4770]

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 ❤️

[@cycleSCUBA]

Excellent introduction and first steps at setting up a report. Thanks, Kevin. 10/10 👍

[@coalblacksmith]

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.

[@alankrzesinski8809]

The way you segmented the different sections of this video is very helpful. More youtubers should do that.

[@jannatulf6415]

You made everything pretty clear in less than half an hour of video. Amazing! Thank you so much for your help

[@marisellopez3412]

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.

[@derranstokes8760]

Wow Kevin you make the complex easy to understand. I would like to see a lot more of BI features please.

[@michaelmcgowan4969]

Same here

[@ishtiaqahmed7666]

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.

[@edwardcansara3286]

Thanks Kevin. Will you be able to share a video on sales comparison's for last 3 years month wise?

[@d56273]

Please does anyone know where to find data to practice and use Power BI features?

[@gelcamacho]

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.

[@Sohrawardy]

That was a great Power BI tutorial. Everything was crystal clear and easy to understand. Thanks Kevin! 🖤

[@kamakshibai5396]

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

[@nikolamilanovic95]

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

[@kollosal786]

love this highlevel overview. can't wait for more

[@1989sherif]

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

[@bukakhuderchuluun7264]

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

[@stanpriebe7672]

This is one of the best KZbin presentations I have seen. Thanks, Kevin. Amazing job!

[@maheshkumarsomalinga1455]

I completely agree with you...Starting from the sound all the way to the explanation..Great job, Kevin. Thanks.

[@BarbaraWothaya]

Agreed

[@hareshchallaboyana3496]

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.

[@leslietyks]

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

[@babarbaig8983]

Thanks for a very helpful, high-level introduction to Power BI

[@meshell7987]

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

[@SolutionsAbroad]

This is a great primer for Power BI Kevin, also love the polish in this video!

[@johnpaulnnamdi1461]

After months of watching many tutorials, I can say this is that first tutorial video that I have practically gained some insights from. Thanks

[@imwalkworse6298]

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.

[@HarmlessComment]

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!

[@d56273]

Please does anyone know where to find data to practice and use Power BI features?

[@gareth4106]

@@d56273 Did you find somewhere yet?

[@d56273]

@@gareth4106 not yet

[@Vinodkumar-lr2fs]

@@d56273 You can find sample dataset in Power BI tool it self. Under Help > Examples.

[@anaybarua5839]

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.

[@andreastan9939]

This is definitely a good and clear cut video for beginner! Nice work and effort, Kevin!

[@markusher1621]

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.

[@TylerStanczak]

This is awesome Kevin. I definitely need to explore this tool some more now. Thanks for the tutorial :)

[@shorelinerach01]

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

[@d56273]

Please does anyone know where to find data to practice and use Power BI features?

[@aphexHQ]

We've just launched our Power BI integration, and can't get over how great an intro to BI this is Kevin!

[@mohamedmohamudyusuf7883]

Hi Kevin. Thanks for the amazing work you did. This is was very usefull. Thanks alot.

[@anetab1424]

our teacher recommended us this video so I greet all students from VŠE in Prague

[@pilardevesa4474]

Thanks Kevin for this excellent material. I definitely want to know more about Power BI. I would appreciate if you go deeper on it

[@topeayanda]

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

[@zachsawyer3898]

Power BI in a nutshell. Thank you for the simplest yet detailed explanatory video ❤

[@gvinodnair]

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.

[@ArmanAlaverdyan]

Thank you for your efforts and the video, Kevin! Would love to see more about Power BI!

[@SleazyRat]

Straightforward and crisp. Really easy for a beginner to understand on what power bi is about. You just earned a subscriber here.

[@falkc11]

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

[@Guiletur]

Muito bom! Mais Power BI no canal, por favor!

[@pwintphyuaung2784]

Thank you so much .. i’ve been waiting this so long !!

[@anjumnisarahmed]

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.

[@trangkieu9992]

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!

[@livetableautraining]

I agree

[@remarks7607]

This is What I was looking for a long time. Thanks Dear💕. Looking for more

[@nonoobott8602]

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🙏

[@KevinStratvert]

Here's an intro to DAX: kzbin.info/www/bejne/rZKqkH2ed8yIpq8

[@patrickmeehan6856]

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.

[@RustyEdutainmentVlogs]

You are a great tutor! More of this so that I can appreciate data analysis without spending too much. Thank you!

[@Kmsbi]

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.

[@andresdiaz6960]

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!

[@jamesperry3837]

I built my first Power BI Report and I felt nice abt it. Thanks to Kevin ..........💗

[@indi8745]

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

[@Exceltrainingvideos]

That was awesome!

[@Sakhilemtimande]

Twas great, I follow you as well. You are also great

[@keyboardwarrior2418]

@@Sakhilemtimande You are also great.

[@ColinPowell_AMultitudeofOne]

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.

[@hollymolly2573]

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.

[@nowfalmedia]

I am actually new to Power BI and now confident with the services. Great video. Thanks

[@ayoayo6081]

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 👍🔔

[@chillisolutions]

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

[@OlalekanAdeeko]

Thank you so much. I am getting addicted to your tutorials.

[@fernandesdes]

Excellent work…great video. I had no clue what POWER BI was until I saw your video. I have been selected by my organization to attend a 4 day Power BI Workshop in the coming days and boy I’m so thrilled to know what I will be learning after watching your P BI tutorial. Thanks for sharing and keep up the great work!

[@anneknapp6457]

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

[@aleksanderstrommer7677]

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.

[@gislijonkristjansson5547]

Good point. If it is free then what is the logic ?

[@martinbourbeau7091]

That is a good intro! Thanks for sharing!

[@lealjaja]

Thanks Kevin por making our life easier, also get new learning and using real examples. God bless you always

[@timorousmwita445]

Thanks Kevin,You have added me a skill that will change my life.Good Job

[@muhammadjamalahmed8664]

Please do some more videos on PowerBI. Make a playlist on this. Go deeper.

[@joshc7865]

That’s what she said

[@curty85]

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

[@jennifermew8386]

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

[@rukminiharan6046]

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.

[@lcmin]

This was so great I watched from start to finish without leaving my desk. Thank you Kevin, you just got a new subscriber.

[@FrancoisvanJaarsveldd]

Like always absolutely great content, Thanks Kevin !

[@AlvinRyellPrada]

Omg finally been waiting for this

[@sikeleladalane262]

This is by far the best Power BI Tutorial I've ever come across, well done Kevin.

[@sridharkota4841]

Clear, concise and to the point. Thank you!

[@mrCetus]

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?

[@VanshdeepMadan]

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.

[@KevinStratvert]

Will add to my list. Thanks for the suggestion, Vanshdeep!

[@travisfubu9053]

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

[@darwintejerero2293]

I learned a lot by just watching this video. So easy to follow and understand

[@Resurection88]

Unfortunately it seems like share is only available when you have a corporate account...

[@raymondcwkoh7458]

Yup, I get to try this out as my corporate account is on MS. Cant use private dot hotmail or live account.

[@sarahyates1717]

I am a graphic designer that often works with engineers... I would love to see more of the design elements that are available in Power BI.

[@user-el4id2vi8x]

Very helpful for the new comer, it helps me to have an overview of the power BI benefit and function. Will try by myself and leave the comments .

[@annrosejessicamartillano5952]

Thank you so much for these materials, Kevin! I was able to grasp the basics from this tutorial of yours. 😊

[@DoubleD97]

Usually I only comment to roast peoples stupid hot takes. This tutorial has been super comprehensive and beneficial. Thank you

[@KevinStratvert]

Thanks for the note!

[@jackfrost89990]

Thank you so much for this intro! Your're an amazing tutor! Truly helps me as a beginner who have never used this before.

[@nadsb6170]

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

[@josephkondody2044]

Absolutely phenomenal! Thank you so much for the introduction. It was a great help!

[@riyazahmed3398]

Preparing for an interview, this video helped me understanding the basics Thanks a bunch

[@srikanthmalore]

Hi Kevin, I made a resoluion to learn Power BI this year and I am glad I followed your video first, great explanation and an amazing starting point. I have 2 questions - (1) For example, you have the list of 15 countries in your excel data and when you import a wiki page and merge it with the excel sheet, does he tool have a capability to merge only those 15 countries and not all ? or do we have to manually remove the unwanted ones? Q2) Can the tool auto-arrange the country names by itself when a new data is merged with the existing data?. Kindly clarify, thank you very much.

[@aliciahartwig8196]

This was great now it all makes sense how my manager was looking as if he has a mouse in his pocket and did not want the group to know. Thank you and yes, I like to dive deep into BI it simplifies the processes of analysis

[@PaulAcito-ce2ex]

Kevin, thanks so much for your excellent introduction!