Power BI Beginner Tutorial

No video

Power BI Beginner Tutorial

Рет қаралды 647,639

Күн бұрын

Power BI Beginner Tutorial
Get Ad-Free Training by becoming a member today!
/ @learnittraining
Exercise Files: bit.ly/2W9iMvZ
Who it's for: Business Analysts, Data Analysts, and everyone in between looking to take the next step in data processing and visualization.
What it is: Power BI is Microsoft’s business analytics platform. It’s designed from the ground up to take mass sets of data and organize, analyze, and visualize it using live dashboards and interactive reports.
What you'll learn: In this series, users will be introduced to the foundational concepts of building queries and prepping data for analysis. Users will learn to build relationships across multiple databases using Power Pivot, all the while learning useful functions to help take data to the next level. Become familiar with building and navigating live dashboards and interactive reports, and much more.
Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
www.learnitanytime.com
Enroll in our live, instructor-led Power BI class:
bit.ly/3I4voXJ
For Private Group Trainings please visit:
www.learnit.com/private-group...
Manuals: bit.ly/30xZb59
Username: manuals
Password: password
Start 0:00
Introduction 0:03
Data Analytics 5:44
Licensing Options 8:03
Products and Services 10:09
Accessing Course Exercise Files 12:46
Reviewing Exercise File Data 13:01
Getting Data from Multiple Sources 14:17
Getting Data from Excel 16:14
Saving 18:21
Touring Report View 20:55
Touring Data View 25:49
Touring Model View 28:04
Starting New Instances of Power BI Desktop 30:28
Splash Screen 32:28
Getting Data from Access Database 35:32
Selecting Related Tables 40:05
Viewing Table Relationships and Settings 42:42
Accessing a Web URL 47:11
Getting Data from the Web 49:13
Web Authentication and Loading Tables 51:41
Exploring Web Data Inconsistencies 54:59
Optimizing Performance with Excel Files 57:06
Optimizing Performance with Power Pivot Data Model 59:25
Connecting to Underlying PivotTable Data 1:01:04
Importing from Power Pivot Data Model 1:03:15
Resolving Data Load Error 1:06:45
Resolving Data Path Error 1:09:51
Resolving Refresh Error 1:13:18
Exploring Power View Visualization Error 1:16:01
Implications of Locally Stored vs Cloud Based Excel Files 1:19:24
Locally Stored Excel Files 1:19:53
Refreshing In-Desktop and In-Service 1:22:02
Cloud-Based Excel Files 1:24:48
Publishing Cloud-Based Files to the Service and Refreshing 1:30:44
Conclusion 1:35:31
#PowerBI
(C) 2021 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.

Пікірлер: 481

@chad_the_stud 2 жыл бұрын

Thank you for making these series publicly available. This is a huge amount of work for free.

@LearnitTraining 2 жыл бұрын

Our pleasure!

@mohammadsafi583 2 жыл бұрын

Amazing training!! Beginner+Intermediate+Advanced PowerBI is the perfect package to make you a Pro! Great job Learnit : )

@LearnitTraining 2 жыл бұрын

Thanks! 😃

@alinaqvi6203 2 жыл бұрын

Clear accent, reasonable speed, comprehensive approach and full of knowledge 🌸 love it

@LearnitTraining 2 жыл бұрын

Thank you for watching Ali Naqvi!

@PO-yj8dw 3 ай бұрын

Trish, you are a legend. What a teacher? You have taught me a lot of things in power bi in this single module. You are a superstar. Thank you.

@LearnitTraining 3 ай бұрын

You are very welcome! Thank you for the kind words!

@TheAquarian214 2 жыл бұрын

A true “beginners” class, as I am able to follow along and digest the material. Thank you.

@LearnitTraining 2 жыл бұрын

You're very welcome!

@CarlosFlores-kd6rn 6 ай бұрын

As someone who has taken over 10 MOOCS , and now teach intro to computer studies at tertiary level I can tell you this is a very straightforward course. I will definitely be applying the teaching style I am learning in this series.

@unpatel1 2 жыл бұрын

Thought about learning Power BI. This is my 1st tutorial. Very good for the beginner like me. Thank you Learnit!

@LearnitTraining 2 жыл бұрын

You are welcome!

@madnessreigns1987 Жыл бұрын

Excellent training. The tutor walks you through every single step, much appreciated!

@LearnitTraining Жыл бұрын

You're very welcome!

@shonyamarpaung1842 Жыл бұрын

I really love the instructor's technique by making the tutorial session into perfectly match for beginner! thanks a lot for the modules ^^

@LearnitTraining Жыл бұрын

You're very welcome!

@joycej6558 4 ай бұрын

Thank you Learnit!From Power Apps to Power BI, you don't know how nervous I was about getting a data analytical reporting job. I followed your classes which gave me a lot of confidence in building my own tool. Really appreciate that.

@LearnitTraining 4 ай бұрын

Love to hear that! Good look at your new job!

@marcelinekasongo2880 2 жыл бұрын

You are just amazing. I've watched video of Power BI, yours is what I needed to start with. Very much appreciated 🙏

@LearnitTraining 2 жыл бұрын

You're so welcome!

@The_Iron_Yuppie Жыл бұрын

1:12:04 this is why it's great you included the source files. Other channels who have provided courses, haven't included the source files and I have run into problems because of it.

@LearnitTraining Жыл бұрын

Thank you for watching!

@janicesmyth2183 Жыл бұрын

This is a wonderful video and you presented it so beautifully that even I can follow :). My grand kids wonder what I'm always doing next. This is so interesting and what I wanted to do when I was much younger and I'm glad I have a chance to learn and try. Thank you Trish for all of your hard work. You're a wonderful teacher!

@LearnitTraining Жыл бұрын

Thank you so much for the kind words Janice!

@dmstrong1208 2 жыл бұрын

I was following an earlier version of the PBI training from Learnit (circa Mar-Apr 21) and due to work demands, postponed studies until recently. During that time frame, I lost my files and started over recently, having gone through 2/3rds of the training. Started over, but the web links for data have since expired. Did make some beautiful reports, alas lost to the data dump in the sky. Going to get through this training and then retake for certification.

@mohammedaymen8542 2 жыл бұрын

it's AMAZING for a Beginners thank you

@user-de1mx8jq5i Жыл бұрын

Wow, this is exactly what we needed - a comprehensive tutorial for beginners! Thank you so much, Ma'am, for going above and beyond to provide us with such valuable learning resources. Your dedication and effort in creating this tutorial are truly appreciated. As beginners, it can often feel overwhelming to dive into a new subject, but with your guidance, we feel more confident and motivated to learn. The step-by-step approach and clear explanations make it easy for us to grasp the concepts and progress in our learning journey. We are grateful for the time and expertise you have invested in making this tutorial accessible and beneficial to learners like us. Your passion for teaching shines through, and it inspires us to explore and master this subject further. We look forward to continuing this learning adventure with your guidance and support. Once again, thank you so much for empowering us with knowledge and helping us grow. You are making a significant impact, and we are truly grateful for everything you do!"

@LearnitTraining Жыл бұрын

Thank you so much for the kind words! We are glad you were able to learn so much and hope you learn more from all our videos!

@JohnPauloFigueroa 11 ай бұрын

are you using powerbi desktop?

@annapecora8019 Жыл бұрын

This is truly such an amazing step-by-step tour of Power BI for a beginner. Thank you!

@LearnitTraining Жыл бұрын

You are very welcome!

@alinaqvi6203 2 жыл бұрын

Hi from Perth Western Australia, thanks a lot for this amazing & comprehensive course, I learn a lot. Thanks again.

@LearnitTraining 2 жыл бұрын

Thanks for watching!

@justiceagbodjan6432 Жыл бұрын

Thanks for making these resources available. It's worth every time invested. Bless you!

@LearnitTraining Жыл бұрын

You are very welcome!

@Okaejobson 3 ай бұрын

Just finished this step by step. Thank you so much Trish for the great work.

@LearnitTraining 3 ай бұрын

You're so welcome!

@Cake-wh4pm 3 ай бұрын

thank you so much for this amazing course, it truly means a lot for everyone watching! I can't show enough gratitude for this!

@LearnitTraining 3 ай бұрын

You're very welcome!

@tahamedaghri 2 жыл бұрын

The channel you need on your daily basis : Learnit Training

@LearnitTraining 2 жыл бұрын

Thank you so much Taha-Amine Medaghri for the kind words!

@hasandewanjee7441 4 ай бұрын

As someone who is new to all this. Thank you so much for making this free and very easy to understand. Much appreciated

@LearnitTraining 4 ай бұрын

You are very welcome!

@jagatkrishna1543 3 жыл бұрын

Always waiting for PowerBI

@Asif_Shaik_ 5 ай бұрын

I am glad I found this video. As a non native of English I often find it difficult to follow the speaker.. but this is a great tutorial I could totally follow. Thank you for making this video.

@LearnitTraining 5 ай бұрын

Glad you enjoyed it!

@grzegorzkochanowicz6650 5 ай бұрын

you can slow down the video in youtube setting. this might help with the speech speed

@aungzinmyint9609 3 жыл бұрын

Hello from Myanmar. Yr channel help me a lot to enhance my Office skills thanks. Yr free courses are worth learning ❤

@LearnitTraining 3 жыл бұрын

Happy to hear that!

@srmchinni3 Жыл бұрын

Worthy educational course. Thank you so much.

@LearnitTraining Жыл бұрын

You're very welcome!

@michaeldukuamoako5244 Жыл бұрын

Just started to watch this, i have already subscribed, cuz this is great. Thank you for this

@LearnitTraining Жыл бұрын

Awesome, thank you!

@nicolasdekonn1503 8 ай бұрын

Thank you !! Your course is very clear and precise, very well designed and organized, progressive and useful. God bless you.

@LearnitTraining 8 ай бұрын

Thank you so much!

@KanasProject Жыл бұрын

a better tutorial than MS offered. thank you!

@LearnitTraining Жыл бұрын

Glad it was helpful!

@padmanabhakarkhanis6630 Жыл бұрын

This is a very detailed and well organized training provided by your training institute. I have shared the link with my friends

@LearnitTraining Жыл бұрын

Thank so much! Sharing helps us tremendously!

@Diyanibeats 2 ай бұрын

Trish you are so helpful and articulated extremely well. Truly a gem and a blessing ! I am transitioning my career and can’t afford a masters program, but these tutorials allow me to upskill myself! My mentor has the same name as you !!! Thanks again for sacrificing your time and uploading in depth tutorials. You are a true success when you help others become successful

@LearnitTraining 2 ай бұрын

You are so welcome!

@mej3758 2 жыл бұрын

hi thanks for creating this tutorial video...however, the power pivot import didnt work on my end, i got an Upgrade report error and if i proceed, its saying i cant connect to your's and Shannon's local drive. please help. thank you.

@nileshnacharya 2 жыл бұрын

Is it possible to create Power BI dashboard using Pivot tables or a raw excel data is better.

@andresaponte183 Жыл бұрын

Thank you so much for this videos

@RAJUBHAI-ww7em 2 жыл бұрын

DAY 1 Thanks a lot done with beginner now will move onto intermedaite

@LearnitTraining 2 жыл бұрын

You got this!

@user-pp1gc1qj7h 2 жыл бұрын

really wonderful. But we want you to attend a training course in the Etape

@GhayasudinGhayas 4 ай бұрын

I attended almost all the modules in your course, and I found them to be highly understandable, explicit, and thoroughly explained. Each topic was covered in detail, and I truly appreciate the generous service you provide, i expect to have the same course in Data Analysis other tools such as (SQL , Python, Azur ,Tableau and others )

@LearnitTraining 4 ай бұрын

Glad it was helpful!

@vazahathussain7893 4 ай бұрын

Hey, are a data analyst?

@ahmadaltaweel4981 2 жыл бұрын

we are waiting for the next videos, we really appreciate your efforts

@LearnitTraining 2 жыл бұрын

Thank you for your continued support!

@resilientprogrammer8466 2 жыл бұрын

How can one extract and group similar strings out of other strings type in a spreadsheet column?

@ramnareshjharamya 13 күн бұрын

"Great tutorial! The step-by-step explanations were easy to follow. I'm excited to start creating my own Power BI dashboards."

@LearnitTraining 12 күн бұрын

Glad it was helpful!

@kavyabhat6699 Жыл бұрын

Thank you so much for this wonderful series

@LearnitTraining Жыл бұрын

Our pleasure!

@HuongNguyen-ut5gt 2 жыл бұрын

Thank you so much, it s great for me. I have learnt a lot from this video.

@LearnitTraining 2 жыл бұрын

You are very welcome! Thank you for watching!

@user-tn3iy6qw6n 9 ай бұрын

Your Style of Teaching is very Excellent and Soft . No doubt. God bless you for al your efforts. Surely will enrol for a Course.

@LearnitTraining 9 ай бұрын

Thank you for the kind words!

@vinoddsingh52 16 күн бұрын

Thank you for making these series publicly available.......From India.

@LearnitTraining 16 күн бұрын

You are very welcome!

@beckienantongo2424 Жыл бұрын

Thank you sooo much. Appreciate all your efforts.

@LearnitTraining Жыл бұрын

You are very welcome!

@mohitseventeen 3 жыл бұрын

Thanks a lot for such an amazing tutorial. How many videos are in this new Power BI series?

@LearnitTraining 3 жыл бұрын

Hi Mohit! There are 6 total videos for this series

@newmbz9585 Жыл бұрын

awesome class, learning many things i didnt know, thx

@LearnitTraining Жыл бұрын

Glad it was helpful!

@cathyzhou8898 Ай бұрын

thank you so much, this is really really helpful! Looking forward to the next video!

@LearnitTraining Ай бұрын

You are very welcome!

@luzangellarestrepocastella7014 20 күн бұрын

I rarely comment on anything but this was so well explained and prepared that I just have to say THANK YOU!

@LearnitTraining 20 күн бұрын

You are very welcome!

@Oifilipemeia Жыл бұрын

thanks a lot. The video series are so amazing

@LearnitTraining Жыл бұрын

You are very welcome!

@SabujBanik-zz6ek 12 күн бұрын

Thank you Trish

@danieleugene2924 2 жыл бұрын

Hello, thanks for this tutorial. I'm current stuck because for some unknown reason I've been unable to import the "northwind" file into my power BI, it keeps saying wrong configuration. I'd really appreciate your help. Thanks

@LearnitTraining 2 жыл бұрын

Hi Eugene - this article by Microsoft should help - docs.microsoft.com/en-us/power-bi/create-reports/desktop-evaluation-configuration

@tomjun8945 Жыл бұрын

Thank you for the helpful video.your content is clear and easy to follow.

@LearnitTraining Жыл бұрын

You are welcome!

@akil3293 Жыл бұрын

Thank you for making these series publicly available. This is a huge amount of work for free I just wanted to report an error. When I'm trying to import the "IT Spend Analysis Sample" the same way as you do, I get an error during migration. It says "Input string was not in a correct format" and does not allow me to import the file

@LearnitTraining Жыл бұрын

Hi Akil! Thank you for watching! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com

@giaothuy5589 Жыл бұрын

cam on chi rat nhieu a minh rat quan tam den video nay

@LearnitTraining Жыл бұрын

Không có chi! Cảm ơn vì đã xem

@RazzPlay Жыл бұрын

This is an awesome tutorial. But I had to increase the speed to 1.25x because I feel like the pacing could be better. Overall this is AWESOME!

@LearnitTraining Жыл бұрын

Thank you for watching! We do encourage using the playspeed button as everyone learns at different speeds

@Dog21273 Жыл бұрын

Did you have trouble importing from the web? I keep trying and only Table 1 will show up for me.

@ashokkumarnayak5139 17 күн бұрын

Its just wow content for a Beginner and very well explained as well... Thanks for uploading this content... I am sure a lot of people are going to get great benefits out of it...👏

@LearnitTraining 17 күн бұрын

It's our pleasure!

@ranvirsingh275 2 жыл бұрын

Thanks video has lot of information and easy to follow approach

@LearnitTraining 2 жыл бұрын

You are welcome!

@dhjsgsjajh 6 ай бұрын

Fantastic Training and Resource. I echo the comments below, thanks for making this available. I'm starting a new role and this is ideal material

@LearnitTraining 6 ай бұрын

Best of luck!

@cheufdphil2487 Жыл бұрын

Thank you for your work!

@LearnitTraining Жыл бұрын

You are welcome!

@chorchayng300 2 жыл бұрын

Does Power BI support JDBC connectivity?

@happysharma5485 3 күн бұрын

thankyou so much for given class free and material also

@LearnitTraining 3 күн бұрын

It's our pleasure

@tsadmb 11 ай бұрын

Thank Uvery much for the class. Greetings from Brazil.

@LearnitTraining 11 ай бұрын

You are welcome!

@malvikamalhotra6001 Жыл бұрын

I get the message that Microsoft access is not registered on the local machine so the NORTHEAD file at 38.14 does not open on my system.

@anil-kumar 2 жыл бұрын

Which Video I see this one or Another with the same name. Because their are 2 Playlist 1 has 6 video and Another has only 3 videos. plz give suggestions so I can start learning.

@MrSingha2009 Жыл бұрын

ยอดเยี่ยมขอบคุณมาก

@LearnitTraining Жыл бұрын

ด้วยความยินดี

@user-lm6qm6rc3i Жыл бұрын

Thank you, the video was very helpful👍

@LearnitTraining Жыл бұрын

Glad it was helpful!

@veetchand4894 2 жыл бұрын

Excellent, thanking you so much

@LearnitTraining 2 жыл бұрын

You are most welcome!

@amrouchemahdia2551 4 ай бұрын

Thank you so much for the course 😊

@LearnitTraining 4 ай бұрын

You are so welcome!

@user-wt9wj4js2q Ай бұрын

Thank you very much for simple way to explain and detail containt.

@LearnitTraining Ай бұрын

You are welcome!

@nayem7657 Ай бұрын

Really Thanks a lot for Power BI courses

@LearnitTraining Ай бұрын

You are welcome!

@Madhuri8428 Ай бұрын

In one word "Awesome", Amazing explanation, Thanks so much!!

@LearnitTraining Ай бұрын

You're very welcome!

@BenjaminRojas-kf6ep 6 ай бұрын

Excelente la forma de mostrar tus capacidades pedagógicas. Great videos

@LearnitTraining 5 ай бұрын

Thank you!

@ajaysingh6140 2 жыл бұрын

Video has Good WORTH Thank you ..

@LearnitTraining 2 жыл бұрын

You are very welcome Ajay Singh!

@roamzi Жыл бұрын

Great job , i appreciate this training

@LearnitTraining Жыл бұрын

Glad you enjoyed it!

@akosasuke5128 Жыл бұрын

Hi, will i need a paid PowerBI subscription at any point during this series?

@Ricky-ri4kq Жыл бұрын

Do you have a playlist of power query ?

@sanshichauhan7885 2 ай бұрын

HI, Actually i'm not being able to upload the web data and the files are also not same as shown in video, what should i do can someone help.

@n_utd 11 ай бұрын

tables are not working in median household income file in power bi

@temiloluwaadegbemile1401 Жыл бұрын

I am having issues with getting data from the web using the same link. it is displaying "we cant find any table on this web page"

@jose-ob4mi 6 ай бұрын

Sample superstore - OD did not update as in the example and the type of document I have is "Semantic Model and your is "dataset", do you thin this could be the issue?

@hamzehmahmod9706 Жыл бұрын

Hey Trish, great video.. I have a technical question if you don't mind me annoying you... is there a way to connect the video's progression (Frame or which second it is at) with my data? For example.. lets say the report is about a building being constructed from start till finish, and in power bi I have a chart of dates (X) and completion % (Y) that mirrors that... then I have a video simulation of the building being built, and I want to connect the progression of the video with the progression of the chart somehow.. Can you advise me on that?

@LearnitTraining Жыл бұрын

Hello Hamzeh! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com

@moniquereneemanners4629 Жыл бұрын

Instructor Trisha Conner-Cato ROCKS!

@LearnitTraining Жыл бұрын

We think so too Monique!

@ifrahabdirahman1315 Жыл бұрын

Thank u very much From Somalia

@LearnitTraining Жыл бұрын

You are welcome!

@naturalsounds3160 8 ай бұрын

Brilliant course thank you

@LearnitTraining 8 ай бұрын

You are very welcome!

@CaribouDataScience 2 жыл бұрын

What is the second module in this Playlist? The Intermediate say it is the 3rd module?

@LearnitTraining 2 жыл бұрын

HI Caribou! Modules 1 and 2 are covered here in the beginner video and module 3 begins on the intermediate video - also thank you all your support!

@ioannisk.1748 Жыл бұрын

Amazing content!!!! Bravo!!! I have a question about the difference between "Get data" and "import". When do we use each of them?

@LearnitTraining Жыл бұрын

Hello Ioannis! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com

@JoW-x6m Ай бұрын

Thank you, great tutorial. Is there any way to obtain evidence that I watched it?

@LearnitTraining Ай бұрын

If you watch this version you will earn a KZfaq badge for completing the whole course - kzfaq.info/sun/PLoyECfvEFOjaMKFbBSKSmnOpEcXqqRegW&si=-e1HyCsAi1i8Tc1Z

@akujobinjokuobikara3820 3 ай бұрын

I am able to follow the step by step training

@LearnitTraining 3 ай бұрын

Great!

@gustavorojas6408 11 ай бұрын

Does anyone know why the 'Ok' button from the settings gets greyed out after changing a setting?? And do you know how you can fix it?

@lex494 2 жыл бұрын

Hey I just wanted to report an error. When I'm trying to import the "IT Spend Analysis Sample" the same way as you do, I get an error during migration. It says "Input string was not in a correct format" and does not allow me to import the file.

@derrickkassen897 Жыл бұрын

Hi @Lex-ep1cp did you get a solution for this problem because I'm having the same. Thanks

@shubratpatel5443 Жыл бұрын

@@derrickkassen897same here, don't know what to do..

@derrickkassen897 Жыл бұрын

@@shubratpatel5443 this is frustrating!! I went onto the Offline community platform and NO Reply for the past 2 hrs.🤐

@shubratpatel5443 Жыл бұрын

@@derrickkassen897 I know ,saw ur post . Waiting for them to reply 🥲

@englishwitharash 5 ай бұрын

Great Video! Thanks.

@LearnitTraining 5 ай бұрын

You're welcome!

@lvsk2305 2 жыл бұрын

Hi, I was done as you do like I was selected customers, employees, order details, products, shippers, suppliers without orders table but the issue is after clicking on the load button the orders table is not created on the right side, only what the tables I was selected those only created. Any suggestion?

@LearnitTraining 2 жыл бұрын

Hi lvs! You can get your question answered at Offsite, our online community - www.offsitebylearnit.com

@aartiojha9854 10 ай бұрын

Hello Ma’am, I would like to thank you for this course. It has been of a tremendous help in understanding the tool better. I am unable to track the path to the Powerpoint presentatioon in the video description. I would appreciate if you guide me to the same. Thanks!

@LearnitTraining 10 ай бұрын

Glad it was helpful!

@tinalalonde1438 4 ай бұрын

i really appreciate your instructions, but curious. is there an updated version s the Power BI that I have Data as heading whereas you have Fields?

@LearnitTraining 4 ай бұрын

We have new Power BI video series coming later this year!

@emadfawzy6054 2 жыл бұрын

Great job, thank you

@LearnitTraining 2 жыл бұрын

Thanks for watching!

@akosasuke5128 Жыл бұрын

Hi, Will i be needing a paid PowerBI subscription at any point during this series?

@TheFrancisChowdhury 2 жыл бұрын

Thank you so much

@LearnitTraining 2 жыл бұрын

You're most welcome!

@fideleananivi4102 7 ай бұрын

Hello, I really like your course and I am learning a lot from you. I am currently having an issue with the Date expression in the 2010 Total Corporate Sales formula. VAR IncludedDates = FILTER(ALL(Dates[Year],Dates[Year] = 2010)) the second Dates[Year] is highlighted as error. please Help.

@francisesther9416 3 ай бұрын

Am enjoying the tutorial but I tried clicking on the webpage to be used for the lesson but not opening on my system hence can't import into powerbi. Please how do I go about it?

@JoW-x6m Ай бұрын

Thank you fantastic course

@LearnitTraining Ай бұрын

You are very welcome

@vernongsnyder Жыл бұрын

My url does not need to be edited when I try to link to Superstores from my Onedrive, but every time I try to link to it I get an error message about HTML.