Power BI Full Course Tutorial (8+ Hours) 

16:00 - Module 1 --> Getting Data from different sources 56:05 - Module 2 --> Optimizing performance (import data from power view, pivot etc + local vs OneDrive) 1:35:48 - Module 3 --> Cleaning and Transforming data (1:49:58 -- Merging info from one table to another 1:52:30 - Join types 1:58:12 - data profiling) 2:02:03 -- Module 4 --> Designing a data Model (2:03:08 - working with tables 2:09:06 - dimensions & hierarchies 2:19:25 - create model r/n 2:27:24 - review model interface 2:31:35 - enforce row-level security) 2:38:47 - Module 5 --> Model calculation using DAX ( 2:41:05 - Create calculated tables 2:44:46 - Create calculated columns 2:59:48 - Create quick measures (size constraint + pre defined) 3:05:39 - Create measures (curated) 3:10:21 - Time intelligence fn 3:25:52 - Key perf indicators) 3:33:20 - Module 6 --> Optimize Model performance ( 3:34:38 - DirectQuery vs import 3:43:49 - Importance of Variable 3:58:38 - Other Optimization Techniques) 4:01:14 - Module 7 --> Reports and Accessibility ( 4:02:31 - Design & Create Report + Enhance Report + Configure visual fields and format properties 4:21:28 - Sync slicers 4:26:36 - Drill - through page 4:44:05 - Conditional formatting 4:49:09 - Bookmarks 4:52:33 - Accessibility ~ alt text + data table + tab order + theme 5:02:35 - Histogram) 5:15:49 - Module 8 --> Dashboards ( 5:16:49- Create Dashboard 5:25:55 - Real-Time Dashboard + 5:58:18 - Enhance Dashboard 6:03:54 - Configure Dashboard tile alert 6:07:25 - Use Q&A for analysis + 6:10:08 - Quick Insights misc - 6:13:09 - featured dashboard + 6:15:16 - usage metrics report + 6:16:30 - Configure for mobile view ) 6:20:21 - Module 9 --> Paginated Reports ( 6:28:14 - Power BI report builder + Design multi-page report layout + Export report to PDF) 6:54:54 - Module 10 --> [Power BI Master] Performing Advanced Analytics ( Advanced analytics = grouping on data fields - 7:02:10, binning on numerical fields- 7:03:20, drill down/up - 7:07:46 , analyze - 7:16:44 7:20:25 - Data insights through AI visuals ( key influencers) 7:26:32 - Animated scatter chart 7:29:57 - Use visual to forecast value 7:37:23 - Create custom advanced analytics visual) 7:44:48 - Module 11 --> [Power BI Professional] Managing Workspaces ( 7:45:38 - Sharing and managing assets 7:53:24 - Map security principles to Data-Set roles 7:56:30 - Publish app) 8:03:06 - Module 12 --> Managing Datasets ( Parameters using Power Query editor + Datesets + Configure dataset refresh) 8:18:20 - Conclusion

I was looking for a compact and clear Power BI tutorial for long time. Till now this is the best one I found , the explanation starts from very beginning level and gradually moving towards advanced with right mix of theoretical and practical knowledge. Thank you very much for this video.

PowerBI Cheatsheet --- Data Cleaning & Organizing --- 1:38:57 Using PowerQuery to edit & filter tables/cols/rows 1:50:50 Using PowerQuery to join tables (queries) 1:58:28 Using PowerQuery to visualize data for inspection (somewhat like pd.describe) 2:04:47 Assigning types to column (%, currency, dates, regions, etc) 2:09:00 Slicing tables to boost performance (separating 'facts' from 'descriptive' columns from each other) --- Database Modeling & Management --- 2:19:35 Relationships/Cardinality between tables [1:1, 1:*, *:1, *:*] 2:31:39 Row-Level Security (RLS), for limiting user-access to their given role --- Calculations (DAX) --- 2:40:48 Create Calculated Table 2:44:49 Create Calculated Columns 2:59:50 Create Quick Measures The difference between measures and quick measures is that QM has pre-built commonly used aggregations, without requiring the use of formulas. Thus, it's easier, but also less flexible. 3:05:33 Create Measures Measures are calculations that don't get stored in the table. It can only be actually used in the report tab. 3:10:17 Time Intelligence Functions (date formats/filling shenanigans) 3:26:00 KPI's --- Optimizing Performance --- 3:33:00 DirectQuery (in a nutshell, don't refresh/download data all the time. Do queries directly on the server) 3:43:55 Importance of Variables [AKA named expressions] 3:51:30 Actually using variables with a measure 3:58:38 Other Optimizations Techniques --- Reports --- 4:03:46 Basic Report Creation 4:14:29 Filters 4:26:47 Drill-Through Page (when you can right-click to access a pre-built page with aggregation data, filtered with what you right-clicked with) 4:49:05 Bookmarks (for storing report filter selections) 4:52:33 Accessibility Options 5:02:54 Histogram viz --- Dashboards --- 5:19:34 Cloud Simple Dashboard 5:26:00 Dashboard with streaming-data 5:47:15 Using Power Automate's flow to push data into the Dashboard --- Advanced Analytics --- 6:55:02 Grouping data (similar to groupBy, but done directly in the report Tab) 7:03:30 Binning numerical data 7:07:45 Drilling Down and up & hierarchies (o tal do grão maior/menor que o ratão fala) 7:16:45 Automatic Analytics by Power BI 7:20:25 AI visuals (semi-automatic analytics. This time, we input what we want to check) 7:26:49 Animated Scatter Chart 7:30:06 Forecasting 7:37:27 Custom visualizations --- Managing Datasets --- 8:05:00 Setting parameters (it's a way to let the data manager easily filter data [in multiple fields at once, if that's the case] after it's published) Example of usefulness: imagine a manager wants the team to focus on X aspect of a KPI, but after some time, decides that they need to focus on Y aspect. Now imagine this with multiple aspects/parameters, specially if it's cyclical in some way. We'd be able to quickly make such changes, without redesigning dashboards/reports/apps all the time.

This is the BEST PBI course on the net ever; very calm, clear and nice voice; all reference files and links are functional; no reference to "my previous videos in the links"; no blips and blunders and very detailed to the last dots. Thank you Trish 👌🙏

This tutorial is fabulous! I have only gotten half-way through, and I already can pull data & create report pages for work. I am so excited to continue this tutorial!!!

pause at 2:13:00 -> Facts vs Dimensions tables and how to model table by separating both pause at 2:38:00 after learning how to deal with relationships and also security

Miss Trish, thank you so much for sharing your knowledge in this excellent and very informative course. You're an excellent instructor!

Thank you Trish and learnit for publishing the whole video in RU-vid. I just completed it, and I started as almost a complete noob in PowerBI. Your video made me comfortable with the different options in PowerBi, and also shared the variety of the features of the tool. My mind was blown as I was learning module by module, the last few modules showed how advanced PowerBI is and how much thought Microsoft has put into while making the product. Now I will be practicing on my own, deep diving into data modelling using my own organization data, and trying to buiild new visualizations which were earlier made in SSRS. Thank you once again!! ...

Best power Bi tutotrial ever, been looking for it for long time. Appreciate the work you've done. Thank you very much :)

What a timing! What a great time to be alive! Thank you!

it's a pleasure to take your classes. They are clear and at a good pace. Thank you!

Thanks for all of your hard work on this. You are very easy to follow and I appreciate that you don't fly through the material.

Awesome tutorial. Excellent step-by-step walkthrough with very useful examples and coveres a great range of tools and use cases! Thank you Trish!!

Thank you so much. The classes are clear and at a good pace.

This video is enough for mention power bi in my resume

Great tutorial video on Power BI. It covers all aspects. Trish has explained it very well. Thank you!

Finally a video that make sense. A bit slow at times but slow for a good reason. Thank you for the effort and the detailed information.

Hello Fam, thanks so much for the video. Its very detailed and insightful. I have a simple question on how to get the dataset. Thanks.

Great tutorial! it helped give me a better understanding of the program's functionality, Thank you for your works.

Trish. You are such an amazing instructor. Thank you for your course

Such an amazing course I feel like I learn something from every sentence she speaks, also the speed do ratio is perfect for me to keep up with what she is doing without dailing back the video. Thank you from my Heart great Job

Thank you mam... For sharing your valuable knowledge to viewers... Thanking you to organization .... ....Also try to make a video about DAX briefly...

Trish, thanks for this full course in Power BI. Very detailed and step by step training.

Thank you so much for upskilling thousands of people around the world, you are a wonderful teacher. Video was really very informative.

I have so much fear of Data Analysis, especially the Power BI tool. I even tried Microsoft Learning Center but everyone there talks fast and expects you to follow suit. The instructor is the best I have ever come across. She knows her stuff inside out. If I made it as a Data Analyst, Ill look for this lady and give her part of my first pay. What a talent

Thank you so much for your great work! I'm really thankful learning from your video. It helped me a lot.😇

1:44:51 Removing columns 1:46:19 Filter for rows 1:47:52 Rename Colums Rename tables 1:48:07 Sorting data by alphabetical 1:48:35 Saving power Q edits and apply it to power bi 1:50:04 Merging tables/sheets 1:53:32 join kind left right outer etc 1:58:38 valid error empty 2:08:12 categorising locations as city or long latitude Abu Dhabi , Dubai as states or province 2:10:08 fact vs dimensions 2:17:40 creating hierarchy for locations

Very well follow along with the supplied files for follow along. One note that I need to state, if you don't have a work email to use the service parts of this training just pay close attention to the course to understand whats going on.

1:53:13 - Join types 2:09:33 - Dimension vs Fact 2:17:13 - Creating a hierarchy 2:19:57 - Creating model relationships 2:31:41 - Row-Level Security

Miss Trish, you are a wonderful teacher with great voice and easy to follow instruction. Thank you for uploading this excellent instructional video on Power BI. Many, many people will benefit from your great knowledge. Thank you.

Trish, this is just the type of course I was looking for. Your instruction is perfectly paced, clear, and your instruction is easy to follow. Do you also offer one-on-one instruction? Also, I am looking for a similar course to learn Power query. Do you teach that as well?

People paying so much for learning powerBi and finally i found this video.... I have zero knowledge about this but i think after watching your videos and practically incorporaring them on PowerBi .. I think i am eventually getting better... Thankyou so much

ThIs is the Best Power BI Course Tutorial i have ever come across. Thumbs up to the instructor @ Trish Conner - Cata. Thank you🙏. You are Amazing. What a great time to be alive.

I am really grateful for your wonderful video and resources. It really helps me with my interview preparation a lot! Thank you so much for your help!

Amazing Trish .. Your training has really boosted my knowledge and proficiency on MS PBI .. Beautifully structured course and probably the BEST I have come across with step by step instructions including intricate details and the sample files ..! Thank You very much for your effort in putting this all together .. 😄

Hi Trish, thank you very much for the course! it is very easy to follow. However I do encounter a question. In model 9 and 10, the course require to get some sample reports from Microsoft through click an arrow button at the bottom left cornor of the page. But I don't find that arrow. Where exactly do I go? Thanks!

Thanks so much. I can say this is the best tutorial I have seen. Was able to understand every sentence. Miss Trish you are the best tutor. You created desire to finish the course. I like your style and I have learnt something about it. You are a treasure. Thanks and God bless.

Thanks very much Trish for sharing this brilliant tutorial with us! This is so easy to follow and I have learnt so much after being in 'IT hibernation' for over a decade. Apart from Power BI, I also got to learn about Form and Power Automate which I have never used/heard before (no thanks to the 'IT hibernation'). I feel that this is so much better than learning in class (ie. face to face) as I am able to control the speed of the video based on my pace and understanding. I guess it is harder to catch up if I got lost during face to face lessons. Looking forward to check out your other tutorials once I finish the Master section (2 more hours to go!) of your tutorial :-)

Me gustó mucho, GRACIAS.

Miss Trish, thank you so much for sharing your knowledge in this excellent and very informative course. You're an excellent instructor! God bless!

I am so so so so impressed with this course. i have completed all the levels. this is the best so far. Thank you Learnit and Trish. How do i get certified from your end before the PL-300?

Let me start by saying this: I've devoured online courses, but this free Power BI course is the first to compel a RU-vid review! Here's why it's fantastic: The Star of the Show: The Instructor! This course is a 5-star experience thanks entirely to the instructor. Her teaching style is phenomenal. Follow Along by Ear: Here's what truly sets her apart. She meticulously explains where to look on the screen, the exact wording you'll see, and the steps to take. This incredible level of detail allows me to follow along entirely by audio! No constantly switching between the instructor and the screen. Beyond the How, the Why: This course goes beyond just teaching Power Query or creating visualizations. The instructor dives deep into data analysis, explaining the "why" behind every step. You'll understand not just the mechanics, but the purpose and reasoning. Unfortunately I'm unable to find any recent courses by Ms. Trish, but I'll be looking to take any course where she is the instructor.

At 2:26, how is the relationship between Orders and Managers table Many: Many when only the region in the Managers table matches the region in orders ? In my PowerBI set up the relationship detected was Many:1.

Wow, what an amazing course and presentation. Thank you so much!

Thank you for your contribution! Nice video and explanation

Hi Trish! Hope you're well! :) Quick Question: Do you feel that this video is enough to begin preparing for the Microsoft PL-300 Power BI Data Analyst Associate Certification?

what a wonderful teacher with so much concept clarity ,,thanks a ton maam

Excellent training ! Many thanks for sharing your expertise.

Great course! Helpful contents! I would rather have some minutes dedicated to Gateway connection. Perhaps, it was beyond the scope. Aside from that, I love it. This gonna help me in my Data Analyst journey. Thanks a mil!

The path to the file can also be found in de info pane of OD. In the menu click on Info and a pane opens. Here you can get the path to the file without a tricky part. But perhaps you knew this already and was't it suitable for the course.

The Best Tutorial on Power BI. You get to know about a lot of underlying stuff. Thanks for the upload

This tutorial covered almost all Power BI topics. Thank you Trish for the Excellent course .

Thank you very much for this Course. Just a comment at 1:25, it is easier to have the path copied within OD by clicking on the 3-Dot, then Details. At the bottom there is the path.

Hi, When I try to import IT spend Analysis Sample I get an error saying "Input string was not in a correct format". What should I do?

It was great learning and i have learnt a lot specially live streaming data!! Thank you so much

Thanks again. I am gonna comment everytime I learn something. The tutorial is precise and useful. I wish your channel good luck. Before this I quit 3 videos in the middle due to improper pronunciation and tedious style.

I am checking this course as part of the path that I am taking to get a power bi certification and I can say that how you speak and explain is by far the best. You have no word crutches or clicks and you have a rich vocabulary. Believe me, those things start to be noticeable after 2 hours. I also appreciate a lot the order and structure of your course. Is this course enough to prepare me for a Microsoft test?

so nice what a great motivation to start my 1st PBI practicing thank you so much from Egypt

Just finished watching full video and I can say, it's amazing 😊

Good content and I was interested to learn with you. Learned a lot from you and Thank for a lot. ☺

Very informative video . Thank you so much.

This is Gold❤❤ Thank You!

When it came to managing security roles in RLS, when you typed region in that enclosed bracket, is it case sensitive??

Great training! Thank you so much Trish!

Thanks! Very helpful tutorial. I feel indebted.

Great work you put into this. Thanks a lot.

i have never seen a nice video course about PBI like this , i think i found my PBI course i was looking for since .

Thank you Will be great if you can upload similarly long videos wrt tableu,excel,data analysis etc

Hi, thank you for this video. I'm unable to load data (median household income) from web. It's taking alot of time to evaluate the data. After some time, it says, "We timed out waiting for the web page to load"

I haven't seen this but the comments are encouraging. I have issues with reporting and dashboard in Power Bi. I will give this a try and give my feedback.

So wonderful. Thank you so much

Amazing and very informative course. Thank you so much for sharing such a great content.

Hello, I am enjoying this so far thank you. Just wondering if you have a manual that can be downloaded for Power BI?

Can we get the presentation of this ? Its superb for revising back !!

I saved the vedio to watch it and finish it during that week Thank you ♥️♥️

is it the combine form of previous videos? or is it the absouletly different?

Amazing video that's really easy to understand and follow! Will this be enough to pass the PL-300 Exam? Many thanks!

thank u so much but the video is clear at my end

Hi Trish, just curious at 2:47:25, is there a reason for selecting .date after the order date column is selected? Because what if the month changes? I am assuming that might break the logic? Thanks for the wonderful tutorial - this was so awesome!

for this tutorial, the ending of develop the retail analysis sample, is it use all the sample file or just only sample superstore, because mine cannot read the access file, not finish watching yet.

Hello, in the word document there is no such link as shown in the video. My Word file consist of Median Household Income; Pricing & Product Comparison; Row-level security. Could you advice on where to go to get the file you are working with?

Thank you so much... Far Better than what I learned at School.

preparing for PL300 exam with this excellent tutorial :) wish me good luck!

This has been absolutely helpful as a PBI beginner. Thanks a lot for your guidance

Thanks a lot for your work!

one of the link is not in the word document and i happen to see more tables when I use the link to connect to the data ... ... course seems quite good though

Pls do a video on data flows in power bi and incremental refresh .

1:57:36 how do you merge returned and order queries? Please help

A true master class presentation. Clear and precise content, organized script, clear and confident speech....a very valued video for learners indeed. thank you for you efforts for the wellbeing of others. God bless!!

Thank you, the video was very helpful👍

The video is somewhat confusing for working with multiple projects, which I'd prefer to just stick with one. But the knowledge is vast!

Hey! Thank You for this awesome course but I'm having an issue with loading Median income by state data. You got 3 tables to load and I can see and load only 2 tables.

status is not common in orders and return what should i do plz guide

Trish! You are great. do you have a Power BI Business tutorial?

2:43:55 could we create the table using DAX from the Data View, instead of Report view? I see the create table option is there also..

at 6:23:36 when you click on the arrow to get data, is there another way to do that? I do not have that arrow on my screen.

Hi Trish great video but am stuck at the merging if the returns and order...how were you able to filter the null values from Retrun.status. thank you

Great learning place. Thank you!

Hello ma. I tried loading the web files into power Bi but keep getting message "we timed out waiting for the web page to load". Again, from your video, it looks like your no of tables is different from mine. I only have table 1 and 2 then one text and one html files. I loaded Excel and database files without issues. Thanks

Greate session. I have learnt lot. Thanks for sharing valuable information