Power BI Full Course Tutorial (8+ Hours)

Power BI Full Course Tutorial (8+ Hours)

Get Ad-Free Training by becoming a member today!

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:

Enroll in our live, instructor-led Power BI class:

For Private Group Trainings please visit:

Start 0:00
Introduction 0:03
Introduction to Data Analytics and Power BI 5:16
Data Shaping 1:35:53
Enhancing Data Structure 1:49:49
Designing Data Model 2:02:01
DAX 2:38:38
Optimizing Model Performance 3:33:18
Reports and Accessibility 4:01:14
Dashboards 5:15:49
Paginated Reports 6:20:21
Performing Advanced Analytics 6:54:54
Managing Workspaces 7:44:48
Managing Datasets 8:03:06
Conclusion 8:18:20

Username: manuals
Password: password

#powerbi #powerbitutorial

(C) 2023 Learnit, Inc.

Any illegal reproduction of this content will result in immediate legal action.

[an_piya]

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

[Sylarleft]

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.

[ByteChunx]

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 👌🙏

[Soumayajitu]

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.

[socksylovely]

Awesome course. I am currently pursuing my diploma in Data Analytics in a school here in Canada. I don't feel like I was gaining so much from the program so I went in search of a course to compliment my learning. I found this course and it is the best course I have ever taken. The instructor explains and breaks it down so well that even if you have never touched a computer before in your life, you definitely will be able to follow this course. Awesome job. Not everyone can teach, but you do it perfectly.
I have taken courses that are supposed to be for beginners, but the instructors don't explain in detail and they just assume everyone will understand the steps or their jargon. You don't assume anything. You explain everything. One million stars for you

[nanditajaiswal]

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

[alfredbills]

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

[zahidhakim]

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.

[sdotlondonkid]

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

[mohamedel-shamy]

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

[isabellsamaluk]

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

[pon]

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

[vandpherdd]

Just at 5:35 and I already like the tutor's pace, tone, style and approach. This is real training. 5 stars not even enough.... ⭐⭐⭐ ⭐ ⭐ ⭐ ⭐

[GG-yqrr]

Let me start by saying this: I've devoured online courses, but this free Power BI course is the first to compel a YouTube 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.

[shankar]

Thank you Trish and learnit for publishing the whole video in Youtube. 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!! ...

[myafricaculture]

I have started my Lessons today and for sure you are the best. You move step by step and there is a good connection I promise to look for you and enjoy my first pay. Thanks and may the Lord give you good health.

[nikhithaeluri]

This video is enough for mention power bi in my resume

[Superman]

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?

[ysfhad]

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

[fredeata]

This is so far the best Power BI tutorial I've ever tried on Youtube because the teacher is so good at explaining the concepts. Just have this error though when trying to load data from the web and it goes like this: "We timed out waiting for the web page to load". Has anyone encountered this please and what has been done to fix it? Hope you can share it here... Thank you!