Power BI Beginner Tutorial
ฝัง
- เผยแพร่เมื่อ 20 ก.ค. 2024
- 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.
![The Wall Song ร้องข้ามกำแพง | EP.202 | ตั้ม วราวุธ / เบสท์ คำสิงห์ | 18 ก.ค. 67 [1/5]](http://i.ytimg.com/vi/cwIoA7XHqnE/mqdefault.jpg)
Thank you for making these series publicly available. This is a huge amount of work for free.
Our pleasure!
Amazing training!! Beginner+Intermediate+Advanced PowerBI is the perfect package to make you a Pro! Great job Learnit : )
Thanks! 😃
Thought about learning Power BI. This is my 1st tutorial. Very good for the beginner like me. Thank you Learnit!
You are welcome!
Clear accent, reasonable speed, comprehensive approach and full of knowledge 🌸 love it
Thank you for watching Ali Naqvi!
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.
You are very welcome! Thank you for the kind words!
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.
Love to hear that! Good look at your new job!
Excellent training. The tutor walks you through every single step, much appreciated!
You're very welcome!
A true “beginners” class, as I am able to follow along and digest the material. Thank you.
You're very welcome!
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.
I really love the instructor's technique by making the tutorial session into perfectly match for beginner! thanks a lot for the modules ^^
You're very welcome!
You are just amazing. I've watched video of Power BI, yours is what I needed to start with. Very much appreciated 🙏
You're so welcome!
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!
Thank you so much for the kind words Janice!
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.
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.
Thank you for watching!
How can one extract and group similar strings out of other strings type in a spreadsheet column?
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.
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!"
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!
are you using powerbi desktop?
Hi from Perth Western Australia, thanks a lot for this amazing & comprehensive course, I learn a lot. Thanks again.
Thanks for watching!
it's AMAZING for a Beginners thank you
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.
Glad you enjoyed it!
you can slow down the video in youtube setting. this might help with the speech speed
Just finished this step by step. Thank you so much Trish for the great work.
You're so welcome!
Is it possible to create Power BI dashboard using Pivot tables or a raw excel data is better.
Always waiting for PowerBI
Thanks for making these resources available. It's worth every time invested. Bless you!
You are very welcome!
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 )
Glad it was helpful!
Hey, are a data analyst?
thank you so much for this amazing course, it truly means a lot for everyone watching! I can't show enough gratitude for this!
You're very welcome!
Hello from Myanmar. Yr channel help me a lot to enhance my Office skills thanks. Yr free courses are worth learning ❤
Happy to hear that!
The channel you need on your daily basis : Learnit Training
Thank you so much Taha-Amine Medaghri for the kind words!
This is truly such an amazing step-by-step tour of Power BI for a beginner. Thank you!
You are very welcome!
Thanks a lot for such an amazing tutorial. How many videos are in this new Power BI series?
Hi Mohit! There are 6 total videos for this series
As someone who is new to all this. Thank you so much for making this free and very easy to understand. Much appreciated
You are very welcome!
This is a very detailed and well organized training provided by your training institute. I have shared the link with my friends
Thank so much! Sharing helps us tremendously!
Worthy educational course. Thank you so much.
You're very welcome!
Just started to watch this, i have already subscribed, cuz this is great. Thank you for this
Awesome, thank you!
Thank you !! Your course is very clear and precise, very well designed and organized, progressive and useful. God bless you.
Thank you so much!
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
Hi Eugene - this article by Microsoft should help - docs.microsoft.com/en-us/power-bi/create-reports/desktop-evaluation-configuration
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?
Hello Hamzeh! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
Does Power BI support JDBC connectivity?
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.
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.
Your Style of Teaching is very Excellent and Soft . No doubt. God bless you for al your efforts. Surely will enrol for a Course.
Thank you for the kind words!
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?
a better tutorial than MS offered. thank you!
Glad it was helpful!
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
You are so welcome!
Thank you so much for this wonderful series
Our pleasure!
really wonderful. But we want you to attend a training course in the Etape
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
Hi Akil! Thank you for watching! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
DAY 1 Thanks a lot done with beginner now will move onto intermedaite
You got this!
I rarely comment on anything but this was so well explained and prepared that I just have to say THANK YOU!
You are very welcome!
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?
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?
We have new Power BI video series coming later this year!
we are waiting for the next videos, we really appreciate your efforts
Thank you for your continued support!
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.
Thank you so much for this videos
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.
Thank you so much, it s great for me. I have learnt a lot from this video.
You are very welcome! Thank you for watching!
thank you to share this valuable course, while I'm importing IT spend analysis sample in power BI. I got this error(input string was not in a correct format) and cant fix it. can you help me?
Hello P Pegah! You can get help directly from our instructors at Offsite. Our online community - www.offsitebylearnit.com/
awesome class, learning many things i didnt know, thx
Glad it was helpful!
tables are not working in median household income file in power bi
Thank you sooo much. Appreciate all your efforts.
You are very welcome!
Thank you for your work!
You are welcome!
Thank you for the helpful video.your content is clear and easy to follow.
You are welcome!
thanks a lot. The video series are so amazing
You are very welcome!
What is the second module in this Playlist? The Intermediate say it is the 3rd module?
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!
Hello guys, thank you very much for this course. I've learnt a lot already and plan to keep learning here.
I have a question: For the option to import files from the onedrive, does it only work with onedrive for business account holders? Because I couldn't find the "copy path" option to paste the link after opening the Sample superstore file as instructed (1:25:10 thereabouts).
Thank you!
Hello Jude Chidozie Ezenyi! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
@@LearnitTraining When attempting to get data from the web, table 2 and 3 will not appear. I attempted this step several times. Please help.
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?
Hi lvs! You can get your question answered at Offsite, our online community - www.offsitebylearnit.com
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"
thank you so much, this is really really helpful! Looking forward to the next video!
You are very welcome!
The way you imported the data from sharepoint it seems strange for me. Let’s assume we have some data on one drive, can we just use the normal way to import the excel just going to the location and not via an url link? Or is there a difference?
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.
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
Best of luck!
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!
Thank you for watching! We do encourage using the playspeed button as everyone learns at different speeds
Did you have trouble importing from the web? I keep trying and only Table 1 will show up for me.
Amazing training! Thanks! Question. I dont see to see the color saturation in the list where values tooltip and other things are. How do I see it?
It has being modified I guess with conditional formatting
Do you have a playlist of power query ?
Thanks video has lot of information and easy to follow approach
You are welcome!
Amazing content!!!! Bravo!!! I have a question about the difference between "Get data" and "import". When do we use each of them?
Hello Ioannis! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
Great content although the Medium Houshold income website is only bringing one table - any suggestions?
Hello Sandy! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
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?
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!
Glad it was helpful!
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.
Hi @Lex-ep1cp did you get a solution for this problem because I'm having the same. Thanks
@@derrickkassen897same here, don't know what to do..
@@shubratpatel5443 this is frustrating!! I went onto the Offline community platform and NO Reply for the past 2 hrs.🤐
@@derrickkassen897 I know ,saw ur post . Waiting for them to reply 🥲
Great job , i appreciate this training
Glad you enjoyed it!
Hi, will i need a paid PowerBI subscription at any point during this series?
I can’t access the northwind database, it says I have the wrong path. Are those old files you are sharing?
I don't see any excel or word document attached to the video. Kindly guide where to find the excels and word file as mentioned in the video.
Exercise Files: bit.ly/2W9iMvZ
Hi, i'm stuck on the "Exploring Web Data Inconsistencies". I'm getting 6 tables instead of 1, what do I do?
Thank you, great tutorial. Is there any way to obtain evidence that I watched it?
If you watch this version you will earn a TH-cam badge for completing the whole course - th-cam.com/play/PLoyECfvEFOjaMKFbBSKSmnOpEcXqqRegW.html&si=-e1HyCsAi1i8Tc1Z
Excellent, thanking you so much
You are most welcome!
Thank you, the video was very helpful👍
Glad it was helpful!
From 1:24:48 where you show how to get data from cloud-based Excel file, I get the following error when I try to get data from the web URL that I copied after opening the file in the excel app, "The downloaded data is HTML, which isn't the expected type. The URL may be wrong or you might not have provided the right credentials to the server." How do I resolve it?
Hello Shaka! You can get help directly from our instructors at Offsite, our online community! www.offsitebylearnit.com/spaces/9299204/events
I do not get Table 3 at 53:18. In fact, I get different table data 1, 2. Can anyone hep?
Thank Uvery much for the class. Greetings from Brazil.
You are welcome!
Thank you so much for the course 😊
You are so welcome!
1:18:00 Input string was not in a correct format
Why I have this error
cam on chi rat nhieu a minh rat quan tam den video nay
Không có chi! Cảm ơn vì đã xem
HI, I am having issues accessing the "northwind" file. I have googled the solutions but I have had no luck
Hi SkimpyLemon - the link to the exercise files is in the video description!
Hi, please I need a guide as I'm having a challenge with finding the Northwind file. Please can you help with a good data file just like the super store sample used In this tutorial. Thank you
Hello Christopher! The file is named Northwind.accdb
Really Thanks a lot for Power BI courses
You are welcome!
Thanks for all.
Please direct me on how to get the files to practice with
Thanks
Hi Sulaimon! The link to the exercise files is in the video description!
Video has Good WORTH Thank you ..
You are very welcome Ajay Singh!
50:05 why was the wikipedia link copied when another link from the word file was pasted? Can you please clarify
Hello Safwah! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
I just checked ms says it doesn’t support 2013 excel power query add in and suggest updating to 2016. How do we get it when we can’t force our employer to upgrade?
Unfortunately chookfeather there is no other way but to upgrade. 2013 is nearly a decade old and is missing numerous advanced features.
Hi amazing. This my first tutorial on Power BI. Where are the resources? I couldn't find the excel file you are using for my practice.
Exercise Files: bit.ly/2W9iMvZ